C# Handler类代码示例

        private void OnConsolidatedOrderBookUpdated(Handler.OrderBookUpdatedEventArgs e)
        {
            try
            {
                if (double.NaN == e.Book.LastTradePrice)
                {
                    Trace.WriteLine("Book " + e.Book.SecurityId + " : LastTradePrice: " + e.Book.LastTradePrice);
                }

                this.securityId2book_[e.Book.SecurityId] = e.Book;

                if (null != this.securityIdComboBox.SelectedItem && this.securityIdComboBox.SelectedItem.ToString() == e.Book.SecurityId)
                {
                    UpdateOrderBookView();
                }
                else
                {
                    if (!this.securityIdComboBox.Items.Contains(e.Book.SecurityId))
                    {
                        this.securityIdComboBox.Items.Add(e.Book.SecurityId);

                        if (!this.selectedIndexWasChanged_)
                        {
                            this.securityIdComboBox.SelectedIndex = 0;
                            securityIDsComboBox_SelectedIndexChanged(this, null);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Trace.WriteLine("Unhandled Exception in BookVkewControl.OnConsolidatedOrderBookUpdated: " + ex);
            }
        }

 public static void registerHandler(short header,Handler h)
 {
     if (!handlers.ContainsValue(h))
     {
         handlers.Add(header, h);
     }
 }

 private void FillCompany()
 {
     if (Session["userid"] != null && Session["userid"].ToString() != string.Empty)
     {
         Handler company = new Handler();
         string sqlcmp = "SELECT CM.CMPID,CM.CMPNAME FROM PERMISSIONMASTER PM INNER JOIN COMPANYMASTER CM ON CM.CMPID=PM.CMPID"+
                         " WHERE CM.STATUS=0 AND PM.STATUS=0 AND PM.USERID="+ Session["userid"].ToString()+" GROUP BY CM.CMPID,CM.CMPNAME";
         DataTable dtcompany = company.GetTable(sqlcmp);
         if (dtcompany.Rows.Count > 0)
         {
             ddlcompany.DataSource = dtcompany;
             ddlcompany.DataTextField = "CMPNAME";
             ddlcompany.DataValueField = "CMPID";
             ddlcompany.DataBind();
            
             ddlcompany.Enabled = true;
         }
     }
     else
     {
         ddlcompany.DataSource = null;
         ddlcompany.DataBind();
         ddlcompany.Items.Insert(0, new ListItem("--Select Company--", "--Select Company--"));
         ddlcompany.Enabled = false;
     }
 }

 protected void btnaccount_Click(object sender, EventArgs e)
 {
     string sponsorid = string.Empty;
     Handler hdn = new Handler();
     DataTable dt = hdn.GetTable("SELECT SRNO,NAME FROM REGISTRATIONTABLE RT WHERE SPONSORSEMICODE='" + txtsponsorid.Text.Trim() + "'");
     if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
     {
         registrationtable obj = new registrationtable(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
         obj.registrationtable_SRNO = -1;
         obj.registrationtable_NAME = txtname.Text.Trim();
         obj.registrationtable_SEMICODE = txtsemid.Text.Trim();
         obj.registrationtable_PHONENO = txtmobileno.Text.Trim();
         obj.registrationtable_EMAILID = txtemail.Text.Trim();
         if (dt.Rows.Count > 0 && dt.Rows[0]["SRNO"].ToString() != string.Empty)
         {
             obj.registrationtable_SPONSORID = General.Parse<int>(dt.Rows[0]["SRNO"].ToString());
             obj.registrationtable_SPONSORNAME = dt.Rows[0]["NAME"].ToString();
             obj.registrationtable_SPONSORSEMICODE = txtsponsorid.Text.Trim();
         }
         else
         {
             obj.registrationtable_SPONSORID = -1;
         }
         
         obj.registrationtable_STATUS = -1;
         string condition = "SRNO=" + Session["userid"].ToString();
         if (obj.Insert(false, "registrationtable", condition))
         {
             MessageBox("Profile Updated Successfully");
         }
     }
 }

 private DataTable FillData(string id)
 {
     string sql = "SELECT DATE,NAME,CONTACTNO,ACTIVITY,RESULT,REMARK FROM REPORTINGMASTER RM WHERE STATUS=0 AND RELATIONSHIPID=" + id.ToString();
     Handler hdn = new Handler();
     DataTable dt = hdn.GetTable(sql);
     return dt;
 }

    protected void FillData(string vehicleid)
    {
        Handler hd = new Handler();
        DataTable dtcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION CATEGORY' and lm.headid=hm.srno ");
      
        ddleditcategory.DataSource = dtcategory;
        ddleditcategory.DataTextField = "NAME";
        ddleditcategory.DataValueField = "VALUE";
        ddleditcategory.DataBind();


        DataTable dtsubcategory = hd.GetTable("select RTRIM(name) AS NAME , RTRIM(value) AS VALUE from lookupmaster lm , lookupheadingmaster hm where head='TERMS AND CONDITION SUBCATEGORY' and lm.headid=hm.srno ");
        ddleditsubcategory.DataSource = dtsubcategory;
        ddleditsubcategory.DataTextField = "NAME";
        ddleditsubcategory.DataValueField = "VALUE";
        ddleditsubcategory.DataBind();
        ddleditsubcategory.Items.Insert(0, "--Select--");

        string sql = "SELECT * FROM TERMSCONDITION TM WHERE TM.SRNO=" + ViewState["termid"].ToString().Trim().ToString();
        Handler hdnstate = new Handler();
        DataTable dtstate = hdnstate.GetTable(sql);
        txteditterms.Text = dtstate.Rows[0]["TERMS"].ToString().Trim();
        txteditdescription.Text = dtstate.Rows[0]["DESCRIPTION"].ToString().Trim();
        ddleditcategory.Items.FindByText(dtstate.Rows[0]["CATEGORY"].ToString().Trim()).Selected = true;
        if (dtstate.Rows[0]["STATUS"].ToString().Trim() == "True")
        {
            ddlstatus.SelectedValue = "1";
        }
        else
        {
            ddlstatus.SelectedValue = "0";
        }
    }

    protected void btnsubmit_Click(object sender, EventArgs e)
    {
         Handler hdnpartycode=new Handler();
         DataTable dtpartycode = hdnpartycode.GetTable("SELECT VEHICLEID FROM VEHICLEMASTER VM WHERE TRANSPORTERID=" + ddltransporter.SelectedValue.ToString().Trim() + " AND VEHICLENO='" + txtvehicleno.Text.Trim().ToString() + "'");
         if (dtpartycode.Rows.Count == 0)
         {
             vehiclemaster objvehiclemaster = new vehiclemaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
             objvehiclemaster.vehiclemaster_VEHICLEID = -1;
             objvehiclemaster.vehiclemaster_TRANSPORTERID = General.Parse<int>(ddltransporter.SelectedValue.ToString().Trim());
             objvehiclemaster.vehiclemaster_STATUS = 0;
             objvehiclemaster.vehiclemaster_CAPACITY = ddlcapacity.SelectedItem.Text.Trim();
             objvehiclemaster.vehiclemaster_VEHICLENO = txtvehicleno.Text.Trim().ToString();
             objvehiclemaster.vehiclemaster_VEHICLENAME = txtvehiclename.Text.Trim().ToString();
             if (objvehiclemaster.Insert(true, "vehiclemaster"))
             {
                 MessageBox("Vehicle Added Successfully");
                 ddltransporter.SelectedIndex = 0;
                 ddlcapacity.SelectedIndex = 0;
                 txtvehicleno.Text = string.Empty;
                 txtvehiclename.Text = string.Empty;
                 FillVehicle();

             }
         }
         else
         {
             MessageBox("Vehicle Already Present");
         }
    }

 private DataTable FillCoolieryList()
 {
     string sqlpartylist = "SELECT CM.SRNO AS COLLIERYID,CM.COLLIERYNAME,CM.COLLIERYCODE,CM.COLLIERYREGION,CASE WHEN STATUS=0 THEN 'ACTIVE' ELSE 'DE-ACTIVE' END AS STATUS FROM collierymaster CM";
     Handler hdnpartylist = new Handler();
     DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
     return dtpartylist;
 }

			public Map(string name, string description, Events[] events, CSDK.Game.Location[] locations, Handler[] data) {
				this.name = name;
				this.description = description;
				this.events = events;
				this.locations = locations;
				this.data = data;
			}

            public HandlerDIR(Handler handler)
            {
                this.handler = handler;
                gchandles = new List<GCHandle>();
                if (handler != null)
                {
                    HandlerSet handlerSet = new HandlerSet();

                    if (handler.onCreateDevice != null)
                    {
                        OnCreateDeviceDIRDelegate dir = new OnCreateDeviceDIRDelegate(OnCreateDevice);
                        gchandles.Add(GCHandle.Alloc(dir));
                        handlerSet.onCreateDevice = Marshal.GetFunctionPointerForDelegate(dir);
                    }
                    if (handler.onSetupStreams != null)
                    {
                        OnSetupStreamsDIRDelegate dir = new OnSetupStreamsDIRDelegate(OnSetupStreams);
                        gchandles.Add(GCHandle.Alloc(dir));
                        handlerSet.onSetupStreams = Marshal.GetFunctionPointerForDelegate(dir);
                    }
                    if (handler.onNextDevice != null)
                    {
                        OnNextDeviceDIRDelegate dir = new OnNextDeviceDIRDelegate(OnNextDevice);
                        gchandles.Add(GCHandle.Alloc(dir));
                        handlerSet.onNextDevice = Marshal.GetFunctionPointerForDelegate(dir);
                    }

                    dirUnmanaged = PXCMCaptureManager_AllocHandlerDIR(handlerSet);
                }
            }

			public async Task ModifyHandler(Command cmd, string name, Handler data = null) {
				var list = CSDK.Game.Converter.ConvertMemory (memory);
				await Task.Delay (1);
				for (int i = 0; i < list.Count; ++i) {
					if (cmd != Command.Retrieve && data == null)
						break;
					if (list [i].Value.Key != name)
						continue;
					Guid guid = list [i].Key;
					Memory _memory = list [i].Value.Value;
					int index = _memory.Search (guid, out result);
					switch (cmd) {
					case Command.Add:
						_memory.Add (data.Mem);
						break;
					case Command.Remove:
						if (index >= 0 && result)
							_memory.Remove (index);
						break;
					case Command.Replace:
						_memory.Replace (data.Mem, out result);
						break;
					case Command.Retrieve:
						data = _memory [index];
						break;
					default:
						break;
					}
				}
			}

        static void Main( string[] args )
        {
            if( args.Length < 1 )
            {
                Console.WriteLine( "Usage: DsTrack.exe pathtofolder\n" );
                return;
            }

            const string path = "templatedata.txt";
            if( File.Exists( path ) )
            {
                Result.Lines = File
                    .ReadAllLines( path )
                    .Select( s => new Line( s ) )
                    .ToArray();
            }

            var handler = new Handler();
            handler.AddFolder( args[0] );

            foreach( var r in handler.Make() )
            {
                Console.WriteLine( r.ToString() );
            }
        }

 private DataTable FillMemberList(string fromdate,string todate)
 {
     string sqlpartylist = "SELECT * FROM REPORTINGMASTER RM WHERE STATUS=0 AND RELATIONSHIPID=" + Session["userid"].ToString() + " AND DATE BETWEEN '" + fromdate + "' AND '" + todate + "'";
     Handler hdnpartylist = new Handler();
     DataTable dtpartylist = hdnpartylist.GetTable(sqlpartylist);
     return dtpartylist;
 }

 private DataTable FillSubgroup(string groupid)
 {
     string sql = "SELECT GROUPNAME,GROUPID FROM accountgroup AG WHERE ASSOGROUPID=" + groupid + " AND BRANCHID=0";
     Handler hdn = new Handler();
     DataTable dt = hdn.GetTable(sql);
     return dt;
 }

    private void FillData(string fromdate,string todate)
    {
        string sql = "SELECT PT.FIRSTNAME+' '+CASE WHEN PT.MIDDLENAME IS NULL THEN '' ELSE PT.MIDDLENAME END +' '+CASE WHEN PT.LASTNAME IS NULL THEN '' ELSE PT.LASTNAME END +'('+PR.ASSOSIATEDFEILD+')' AS LEDGER," +
                   " TT.AMOUNT,TT.VOUCHERTYPE,TT.TRANSDATE,TT.NARRATION,TT.LTRNTYPE2 AS LTRNTYPE FROM TRANSACTIONTABLE TT INNER JOIN PERSONALRELATION PR ON PR.SRNO=TT.LEDGER2" +
                   " INNER JOIN PERSONALTABLE PT ON PT.RELATIONSHIPID=PR.RELATIONSHIPID WHERE TT.BRANCHID =" + Session["branchid"].ToString() + " AND TT.STATUS=0 " +
                   " AND (convert(datetime, TT.TRANSDATE, 103) BETWEEN  convert(datetime, '" + fromdate.Trim().ToString() + "', 103) AND convert(datetime, '" + todate.Trim().ToString() + "', 103)) AND" +
                   " TT.LEDGER1=(SELECT SRNO FROM PERSONALRELATION PR1 INNER JOIN PERSONALTABLE PT1 ON PT1.RELATIONSHIPID=PR1.RELATIONSHIPID WHERE PT1.FIRSTNAME='CASH ACCOUNT' AND" +
                   " PT1.BRANCHID=" + Session["branchid"].ToString() + ") AND (TT.TRANSACTIONTYPE=1 OR TT.TRANSACTIONTYPE=2)";
        Handler hdn = new Handler();
        DataTable dt = hdn.GetTable(sql);
        string value = GetOpeningAmount(fromdate);
        DataRow newrow = dt.NewRow();

        string[] columnarr = value.Split('~');
        dt.Rows.InsertAt(newrow, 0);
        dt.Rows[0]["LEDGER"] = "OPENING AMOUNT";
        dt.Rows[0]["AMOUNT"] = columnarr[0].ToString();
        dt.Rows[0]["LTRNTYPE"] = columnarr[1].ToString();
     
        DataTable dtcash = GetBalance(dt, "AMOUNT", "LTRNTYPE");
        ViewState["cashbook"] = dtcash;

        if (dt.Rows.Count > 0)
        {
            gvcashbook.DataSource = (DataTable)ViewState["cashbook"];
            gvcashbook.DataBind();
        }
        else
        {
            gvcashbook.DataSource = null;
            gvcashbook.DataBind();
        }
    }