コード例 #1
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         KFB_BSYS o_KFB_BSYS = new KFB_BSYS();
         if (objGameOtherDefaultDB.Exists(ms_TYPE))
         {
             objGameOtherDefaultDB.UpdateBQ(getKFB_BSYS());
             this.ShowMsg("修改成功");
         }
         else
         {
             objGameOtherDefaultDB.AddBQ(getKFB_BSYS());
             this.ShowMsg("新增成功");
         }
     }
     catch (Exception ex)
     {
         this.WriteLog("用户名=" + this.mUserID + ex.ToString());
         this.ShowMsg("保存失敗");
     }
 }
コード例 #2
0
    private void InitInsertPage()
    {
        #region 新增狀態下帶出默認值
        DateTime dt = this.objGame.GetZWDate();
        this.drpZWYear.Value   = dt.Year.ToString();
        this.drpZWMonth.Value  = dt.Month.ToString().PadLeft(2, '0');
        this.drpZWDay.Value    = dt.Day.ToString().PadLeft(2, '0');
        this.drpBSYear.Value   = DateTime.Now.Year.ToString();
        this.drpBSMonth.Value  = DateTime.Now.Month.ToString().PadLeft(2, '0');
        this.drpBSDay.Value    = DateTime.Now.Day.ToString().PadLeft(2, '0');
        this.drpBSHour.Value   = DateTime.Now.Hour.ToString().PadLeft(2, '0');
        this.drpBSMinute.Value = DateTime.Now.Minute.ToString().PadLeft(2, '0');
        this.chkLet.Value      = "0";

        KFB_BSYS o_KFB_BSYS = this.objGame.GetModel(ms_TYPE);
        if (o_KFB_BSYS != null)
        {
            if ((o_KFB_BSYS.N_CBXH.Value & 1) == 1)
            {
                this.chkCB.Items[0].Selected = true;
            }
            if ((o_KFB_BSYS.N_CBXH.Value & 2) == 2)
            {
                this.chkCB.Items[1].Selected = true;
            }
            if ((o_KFB_BSYS.N_CBXH.Value & 4) == 4)
            {
                this.chkCB.Items[2].Selected = true;
            }

            this.chkDSClose.Checked = true;
            this.chkDXClose.Checked = true;
            this.chkDYClose.Checked = true;
            this.chkRFClose.Checked = true;
            //this.chkSYClose.Checked = true;
            this.txtDZSX.Text    = o_KFB_BSYS.N_HYDZSX.ToString();
            this.txtDCSX.Text    = o_KFB_BSYS.N_HYDCSX.ToString();
            this.drpRFFS.Value   = o_KFB_BSYS.N_RFFS.ToString();
            this.drpRFLX.Value   = o_KFB_BSYS.N_RFLX.ToString();
            this.txtRFBL.Value   = o_KFB_BSYS.N_RFBL.ToString();
            this.txtLRFPL.Value  = o_KFB_BSYS.N_LRFPL.ToString();
            this.txtRRFPL.Value  = o_KFB_BSYS.N_RRFPL.ToString();
            this.drpLRFCJ.Value  = o_KFB_BSYS.N_LRFCJ.ToString();
            this.drpRRFCJ.Value  = o_KFB_BSYS.N_RRFCJ.ToString();
            this.txtLRFSX.Value  = o_KFB_BSYS.N_LRFSX.ToString();
            this.txtRRFSX.Value  = o_KFB_BSYS.N_RRFSX.ToString();
            this.txtRFCJJE.Value = o_KFB_BSYS.N_RFCJJE.ToString();
            this.drpRFCJFS.Value = o_KFB_BSYS.N_RFCJFS.ToString();
            if (o_KFB_BSYS.N_RFCJFS.Value.Equals(0))
            {
                this.drpRFCJPL.Value = o_KFB_BSYS.N_RFCJPL.ToString();
            }
            else
            {
                this.drpRFCJPL1.Value = o_KFB_BSYS.N_RFCJPL.ToString();
            }
            this.drpDXFS.Value   = o_KFB_BSYS.N_DXFS.ToString();
            this.drpDXLX.Value   = o_KFB_BSYS.N_DXLX.ToString();
            this.txtDXBL.Value   = o_KFB_BSYS.N_DXBL.ToString();
            this.txtDXDPL.Value  = o_KFB_BSYS.N_DXDPL.ToString();
            this.txtDXXPL.Value  = o_KFB_BSYS.N_DXXPL.ToString();
            this.drpDXDCJ.Value  = o_KFB_BSYS.N_DXDCJ.ToString();
            this.drpDXXCJ.Value  = o_KFB_BSYS.N_DXXCJ.ToString();
            this.txtLDXSX.Value  = o_KFB_BSYS.N_LDXSX.ToString();
            this.txtRDXSX.Value  = o_KFB_BSYS.N_RDXSX.ToString();
            this.txtDXCJ.Value   = o_KFB_BSYS.N_DXCJ.ToString();
            this.drpDXCJPL.Value = o_KFB_BSYS.N_DXCJPL.ToString();
            this.txtLDYPL.Value  = o_KFB_BSYS.N_LDYPL.ToString();
            this.txtRDYPL.Value  = o_KFB_BSYS.N_RDYPL.ToString();
            this.drpLDYCJ.Value  = o_KFB_BSYS.N_LDYCJ.ToString();
            this.drpRDYCJ.Value  = o_KFB_BSYS.N_RDYCJ.ToString();
            this.txtLDYSX.Value  = o_KFB_BSYS.N_LDYSX.ToString();
            this.txtRDYSX.Value  = o_KFB_BSYS.N_RDYSX.ToString();
            this.txtDYCJ.Value   = o_KFB_BSYS.N_DYCJ.ToString();
            this.drpDYCJPL.Value = o_KFB_BSYS.N_DYCJPL.ToString();
            //this.txtLSYPL.Value = o_KFB_BSYS.N_LSYPL.ToString();
            //this.txtRSYPL.Value = o_KFB_BSYS.N_RSYPL.ToString();
            //this.drpLSYCJ.Value = o_KFB_BSYS.N_LSYCJ.ToString();
            //this.drpRSYCJ.Value = o_KFB_BSYS.N_RSYCJ.ToString();
            //this.txtLSYSX.Value = o_KFB_BSYS.N_LSYSX.ToString();
            //this.txtRSYSX.Value = o_KFB_BSYS.N_RSYSX.ToString();
            //this.txtSYCJ.Value = o_KFB_BSYS.N_SYCJ.ToString();
            //this.drpSYCJPL.Value = o_KFB_BSYS.N_SYCJPL.ToString();
            this.txtDSDPL.Value  = o_KFB_BSYS.N_DSDPL.ToString();
            this.txtDSSPL.Value  = o_KFB_BSYS.N_DSSPL.ToString();
            this.drpDSDCJ.Value  = o_KFB_BSYS.N_DSDCJ.ToString();
            this.drpDSSCJ.Value  = o_KFB_BSYS.N_DSSCJ.ToString();
            this.txtLDSSX.Value  = o_KFB_BSYS.N_LDSSX.ToString();
            this.txtRDSSX.Value  = o_KFB_BSYS.N_RDSSX.ToString();
            this.txtDSCJ.Value   = o_KFB_BSYS.N_DSCJ.ToString();
            this.drpDSCJPL.Value = o_KFB_BSYS.N_DSCJPL.ToString();

            this.chkRFGGClose.Checked = true;
            this.chkDXGGClose.Checked = true;
            this.chkDYGGClose.Checked = true;
            //this.chkSYGGClose.Checked = true;
            this.chkDSGGClose.Checked = true;

            this.txt00.Text   = o_KFB_BSYS.N_BDGPL00.ToString();
            this.txt11.Text   = o_KFB_BSYS.N_BDGPL11.ToString();
            this.txt22.Text   = o_KFB_BSYS.N_BDGPL22.ToString();
            this.txt33.Text   = o_KFB_BSYS.N_BDGPL33.ToString();
            this.txt44.Text   = o_KFB_BSYS.N_BDGPL44.ToString();
            this.txtkc10.Text = o_KFB_BSYS.N_BDKPL10.ToString();
            this.txtkc20.Text = o_KFB_BSYS.N_BDKPL20.ToString();
            this.txtkc21.Text = o_KFB_BSYS.N_BDKPL21.ToString();
            this.txtkc30.Text = o_KFB_BSYS.N_BDKPL30.ToString();
            this.txtkc31.Text = o_KFB_BSYS.N_BDKPL31.ToString();
            this.txtkc32.Text = o_KFB_BSYS.N_BDKPL32.ToString();
            this.txtkc40.Text = o_KFB_BSYS.N_BDKPL40.ToString();
            this.txtkc41.Text = o_KFB_BSYS.N_BDKPL41.ToString();
            this.txtkc42.Text = o_KFB_BSYS.N_BDKPL42.ToString();
            this.txtkc43.Text = o_KFB_BSYS.N_BDKPL43.ToString();
            this.txtkc5.Text  = o_KFB_BSYS.N_BDKPL5.ToString();
            this.txtbdsx.Text = o_KFB_BSYS.N_BDSX.ToString();
            this.txtzc10.Text = o_KFB_BSYS.N_BDZPL10.ToString();
            this.txtzc20.Text = o_KFB_BSYS.N_BDZPL20.ToString();
            this.txtzc21.Text = o_KFB_BSYS.N_BDZPL21.ToString();
            this.txtzc30.Text = o_KFB_BSYS.N_BDZPL30.ToString();
            this.txtzc31.Text = o_KFB_BSYS.N_BDZPL31.ToString();
            this.txtzc32.Text = o_KFB_BSYS.N_BDZPL32.ToString();
            this.txtzc40.Text = o_KFB_BSYS.N_BDZPL40.ToString();
            this.txtzc41.Text = o_KFB_BSYS.N_BDZPL41.ToString();
            this.txtzc42.Text = o_KFB_BSYS.N_BDZPL42.ToString();
            this.txtzc43.Text = o_KFB_BSYS.N_BDZPL43.ToString();
            this.txtzc5.Text  = o_KFB_BSYS.N_BDZPL5.ToString();

            this.txtbqchh.Text = o_KFB_BSYS.N_BQCHH.ToString();
            this.txtbqchk.Text = o_KFB_BSYS.N_BQCHK.ToString();
            this.txtbqchz.Text = o_KFB_BSYS.N_BQCHZ.ToString();
            this.txtbqckh.Text = o_KFB_BSYS.N_BQCKH.ToString();
            this.txtbqckk.Text = o_KFB_BSYS.N_BQCKK.ToString();

            this.txtbqckz.Text     = o_KFB_BSYS.N_BQCKZ.ToString();
            this.txtbqcsx.Text     = o_KFB_BSYS.N_BQCSX.ToString();
            this.txtbqczh.Text     = o_KFB_BSYS.N_BQCZH.ToString();
            this.txtbqczk.Text     = o_KFB_BSYS.N_BQCZK.ToString();
            this.txtbqczz.Text     = o_KFB_BSYS.N_BQCZZ.ToString();
            this.txtrqs01.Text     = o_KFB_BSYS.N_RQSPL01.ToString();
            this.txtrqs23.Text     = o_KFB_BSYS.N_RQSPL23.ToString();
            this.txtrqs46.Text     = o_KFB_BSYS.N_RQSPL46.ToString();
            this.txtrqs7.Text      = o_KFB_BSYS.N_RQSPL7.ToString();
            this.txtrqssx.Text     = o_KFB_BSYS.N_RQSSX.ToString();
            this.txtN_HJPL.Value   = o_KFB_BSYS.N_HJPL.ToString();
            this.drpN_HJGGCJ.Value = o_KFB_BSYS.N_HJGGCJ.ToString();
            this.txtN_HJSX.Value   = o_KFB_BSYS.N_HJSX.ToString();
        }
        #endregion
    }
コード例 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["bt"] != null)
        {
            ms_TYPE = Request.QueryString["bt"];
            switch (Request.QueryString["bt"])
            {
            case "b_by":
                this.lblball.Text = "网球";
                break;

            case "b_bj":
                this.lblball.Text = "棒球";
                break;

            case "b_bk":
                this.lblball.Text = "籃球";
                break;

            case "b_bb":
                this.lblball.Text = "排球";
                break;

            case "b_bq":
                this.lblball.Text = "冰球";
                break;
            }
        }
        if (!IsPostBack)
        {
            KFB_BSYS o_KFB_BSYS = objGamesDB.GetModel(ms_TYPE);
            if (o_KFB_BSYS != null)
            {
                if ((o_KFB_BSYS.N_CBXH.Value & 1) == 1)
                {
                    this.chkCB.Items[0].Selected = true;
                }
                if ((o_KFB_BSYS.N_CBXH.Value & 2) == 2)
                {
                    this.chkCB.Items[1].Selected = true;
                }
                if ((o_KFB_BSYS.N_CBXH.Value & 4) == 4)
                {
                    this.chkCB.Items[2].Selected = true;
                }
                this.txtDZSX.Value   = o_KFB_BSYS.N_HYDZSX.ToString();
                this.txtDCSX.Value   = o_KFB_BSYS.N_HYDCSX.ToString();
                this.drpRFFS.Value   = o_KFB_BSYS.N_RFFS.ToString();
                this.drpRFLX.Value   = o_KFB_BSYS.N_RFLX.ToString();
                this.txtRFBL.Value   = o_KFB_BSYS.N_RFBL.ToString();
                this.txtLRFPL.Value  = o_KFB_BSYS.N_LRFPL.ToString();
                this.txtRRFPL.Value  = o_KFB_BSYS.N_RRFPL.ToString();
                this.drpLRFCJ.Value  = o_KFB_BSYS.N_LRFCJ.ToString();
                this.drpRRFCJ.Value  = o_KFB_BSYS.N_RRFCJ.ToString();
                this.txtLRFSX.Value  = o_KFB_BSYS.N_LRFSX.ToString();
                this.txtRRFSX.Value  = o_KFB_BSYS.N_RRFSX.ToString();
                this.txtRFCJJE.Value = o_KFB_BSYS.N_RFCJJE.ToString();
                this.drpRFCJFS.Value = o_KFB_BSYS.N_RFCJFS.ToString();
                if (o_KFB_BSYS.N_RFCJFS.Value.Equals(0))
                {
                    this.drpRFCJPL.Value = o_KFB_BSYS.N_RFCJPL.ToString();
                }
                else
                {
                    this.drpRFCJPL1.Value = o_KFB_BSYS.N_RFCJPL.ToString();
                }
                this.txtDXFS.Value   = o_KFB_BSYS.N_DXFS.ToString();
                this.drpDXLX.Value   = o_KFB_BSYS.N_DXLX.ToString();
                this.txtDXBL.Value   = o_KFB_BSYS.N_DXBL.ToString();
                this.txtDXDPL.Value  = o_KFB_BSYS.N_DXDPL.ToString();
                this.txtDXXPL.Value  = o_KFB_BSYS.N_DXXPL.ToString();
                this.drpDXDCJ.Value  = o_KFB_BSYS.N_DXDCJ.ToString();
                this.drpDXXCJ.Value  = o_KFB_BSYS.N_DXXCJ.ToString();
                this.txtLDXSX.Value  = o_KFB_BSYS.N_LDXSX.ToString();
                this.txtRDXSX.Value  = o_KFB_BSYS.N_RDXSX.ToString();
                this.txtDXCJ.Value   = o_KFB_BSYS.N_DXCJ.ToString();
                this.drpDXCJPL.Value = o_KFB_BSYS.N_DXCJPL.ToString();


                this.txtLSYPL.Value  = o_KFB_BSYS.N_LSYPL.ToString();
                this.txtRSYPL.Value  = o_KFB_BSYS.N_RSYPL.ToString();
                this.drpLSYCJ.Value  = o_KFB_BSYS.N_LSYCJ.ToString();
                this.drpRSYCJ.Value  = o_KFB_BSYS.N_RSYCJ.ToString();
                this.txtLSYSX.Value  = o_KFB_BSYS.N_LSYSX.ToString();
                this.txtRSYSX.Value  = o_KFB_BSYS.N_RSYSX.ToString();
                this.txtSYCJ.Value   = o_KFB_BSYS.N_SYCJ.ToString();
                this.drpSYCJPL.Value = o_KFB_BSYS.N_SYCJPL.ToString();

                this.txtLDYPL.Value  = o_KFB_BSYS.N_LDYPL.ToString();
                this.txtRDYPL.Value  = o_KFB_BSYS.N_RDYPL.ToString();
                this.drpLDYCJ.Value  = o_KFB_BSYS.N_LDYCJ.ToString();
                this.drpRDYCJ.Value  = o_KFB_BSYS.N_RDYCJ.ToString();
                this.txtLDYSX.Value  = o_KFB_BSYS.N_LDYSX.ToString();
                this.txtRDYSX.Value  = o_KFB_BSYS.N_RDYSX.ToString();
                this.txtDYCJ.Value   = o_KFB_BSYS.N_DYCJ.ToString();
                this.drpDYCJPL.Value = o_KFB_BSYS.N_DYCJPL.ToString();
                this.txtDSDPL.Value  = o_KFB_BSYS.N_DSDPL.ToString();
                this.txtDSSPL.Value  = o_KFB_BSYS.N_DSSPL.ToString();
                this.drpDSDCJ.Value  = o_KFB_BSYS.N_DSDCJ.ToString();
                this.drpDSSCJ.Value  = o_KFB_BSYS.N_DSSCJ.ToString();
                this.txtLDSSX.Value  = o_KFB_BSYS.N_LDSSX.ToString();
                this.txtRDSSX.Value  = o_KFB_BSYS.N_RDSSX.ToString();
                this.txtDSCJ.Value   = o_KFB_BSYS.N_DSCJ.ToString();
                this.drpDSCJPL.Value = o_KFB_BSYS.N_DSCJPL.ToString();
            }
        }
        this.Page.ClientScript.RegisterStartupScript(this.GetType(), "Keys", "changefenshu(document.getElementById('ContentPlaceHolder11_drpRFCJFS'));", true);
    }
コード例 #4
0
    private KFB_BSYS getKFB_BSYS()
    {
        KFB_BSYS o_KFB_BSYS = new KFB_BSYS();

        o_KFB_BSYS.N_LX = ms_TYPE;
        //是否延遲下注
        int i_Count = 0;

        for (int i = 0; i < this.chkCB.Items.Count; i++)
        {
            if (chkCB.Items[i].Selected)
            {
                i_Count += Convert.ToInt32(chkCB.Items[i].Value);
            }
        }
        o_KFB_BSYS.N_CBXH   = i_Count;
        o_KFB_BSYS.N_HYDZSX = Convert.ToSingle(this.txtDZSX.Value);
        o_KFB_BSYS.N_HYDCSX = Convert.ToSingle(this.txtDCSX.Value);
        o_KFB_BSYS.N_RFFS   = Convert.ToSingle(this.drpRFFS.Value);
        o_KFB_BSYS.N_RFLX   = Convert.ToInt32(this.drpRFLX.Value);
        o_KFB_BSYS.N_RFBL   = Convert.ToInt32(this.txtRFBL.Value);
        o_KFB_BSYS.N_LRFPL  = Convert.ToSingle(this.txtLRFPL.Value);
        o_KFB_BSYS.N_RRFPL  = Convert.ToSingle(this.txtRRFPL.Value);
        o_KFB_BSYS.N_LRFCJ  = Convert.ToSingle(this.drpLRFCJ.Value);
        o_KFB_BSYS.N_RRFCJ  = Convert.ToSingle(this.drpRRFCJ.Value);
        o_KFB_BSYS.N_LRFSX  = Convert.ToSingle(this.txtLRFSX.Value);
        o_KFB_BSYS.N_RRFSX  = Convert.ToSingle(this.txtRRFSX.Value);
        o_KFB_BSYS.N_RFCJJE = Convert.ToSingle(this.txtRFCJJE.Value);
        o_KFB_BSYS.N_RFCJFS = Convert.ToInt32(this.drpRFCJFS.Value);
        if (this.drpRFCJFS.Value.Equals("0"))
        {
            o_KFB_BSYS.N_RFCJPL = Convert.ToSingle(this.drpRFCJPL.Value);
        }
        else
        {
            o_KFB_BSYS.N_RFCJPL = Convert.ToSingle(this.drpRFCJPL1.Value);
        }
        o_KFB_BSYS.N_DXFS   = Convert.ToSingle(this.txtDXFS.Value);
        o_KFB_BSYS.N_DXLX   = Convert.ToInt32(this.drpDXLX.Value);
        o_KFB_BSYS.N_DXBL   = Convert.ToInt32(this.txtDXBL.Value);
        o_KFB_BSYS.N_DXDPL  = Convert.ToSingle(this.txtDXDPL.Value);
        o_KFB_BSYS.N_DXXPL  = Convert.ToSingle(this.txtDXXPL.Value);
        o_KFB_BSYS.N_DXDCJ  = Convert.ToSingle(this.drpDXDCJ.Value);
        o_KFB_BSYS.N_DXXCJ  = Convert.ToSingle(this.drpDXXCJ.Value);
        o_KFB_BSYS.N_DXDCSX = 0;
        o_KFB_BSYS.N_LDXSX  = Convert.ToSingle(this.txtLDXSX.Value);
        o_KFB_BSYS.N_RDXSX  = Convert.ToSingle(this.txtRDXSX.Value);
        o_KFB_BSYS.N_DXCJ   = Convert.ToSingle(this.txtDXCJ.Value);
        o_KFB_BSYS.N_DXCJPL = Convert.ToSingle(this.drpDXCJPL.Value);
        o_KFB_BSYS.N_LDYPL  = Convert.ToSingle(this.txtLDYPL.Value);
        o_KFB_BSYS.N_RDYPL  = Convert.ToSingle(this.txtRDYPL.Value);
        o_KFB_BSYS.N_LDYCJ  = Convert.ToSingle(this.drpLDYCJ.Value);
        o_KFB_BSYS.N_RDYCJ  = Convert.ToSingle(this.drpRDYCJ.Value);
        o_KFB_BSYS.N_LDYSX  = Convert.ToSingle(this.txtLDYSX.Value);
        o_KFB_BSYS.N_RDYSX  = Convert.ToSingle(this.txtRDYSX.Value);
        o_KFB_BSYS.N_DYCJ   = Convert.ToSingle(this.txtDYCJ.Value);
        o_KFB_BSYS.N_DYCJPL = Convert.ToSingle(this.drpDYCJPL.Value);

        o_KFB_BSYS.N_LSYPL  = Convert.ToSingle(this.txtLSYPL.Value);
        o_KFB_BSYS.N_RSYPL  = Convert.ToSingle(this.txtRSYPL.Value);
        o_KFB_BSYS.N_LSYCJ  = Convert.ToSingle(this.drpLSYCJ.Value);
        o_KFB_BSYS.N_RSYCJ  = Convert.ToSingle(this.drpRSYCJ.Value);
        o_KFB_BSYS.N_LSYSX  = Convert.ToSingle(this.txtLSYSX.Value);
        o_KFB_BSYS.N_RSYSX  = Convert.ToSingle(this.txtRSYSX.Value);
        o_KFB_BSYS.N_SYCJ   = Convert.ToSingle(this.txtSYCJ.Value);
        o_KFB_BSYS.N_SYCJPL = Convert.ToSingle(this.drpSYCJPL.Value);

        o_KFB_BSYS.N_DSDPL  = Convert.ToSingle(this.txtDSDPL.Value);
        o_KFB_BSYS.N_DSSPL  = Convert.ToSingle(this.txtDSSPL.Value);
        o_KFB_BSYS.N_DSDCJ  = Convert.ToSingle(this.drpDSDCJ.Value);
        o_KFB_BSYS.N_DSSCJ  = Convert.ToSingle(this.drpDSSCJ.Value);
        o_KFB_BSYS.N_DSDCSX = 0;
        o_KFB_BSYS.N_LDSSX  = Convert.ToSingle(this.txtLDSSX.Value);
        o_KFB_BSYS.N_RDSSX  = Convert.ToSingle(this.txtRDSSX.Value);
        o_KFB_BSYS.N_DSCJ   = Convert.ToSingle(this.txtDSCJ.Value);
        o_KFB_BSYS.N_DSCJPL = Convert.ToSingle(this.drpDSCJPL.Value);
        return(o_KFB_BSYS);
    }
コード例 #5
0
    /// <summary>
    /// 更新一条数据
    /// </summary>
    public void UpdateBQ(KFB_BSYS model)
    {
        StringBuilder strSql = new StringBuilder();

        strSql.Append("update KFB_BSYS set ");
        strSql.Append("N_LX=:N_LX,");
        strSql.Append("N_HYDZSX=:N_HYDZSX,");
        strSql.Append("N_HYDCSX=:N_HYDCSX,");
        strSql.Append("N_CBXH=:N_CBXH,");
        strSql.Append("N_RFFS=:N_RFFS,");
        strSql.Append("N_RFLX=:N_RFLX,");
        strSql.Append("N_RFBL=:N_RFBL,");
        strSql.Append("N_LRFPL=:N_LRFPL,");
        strSql.Append("N_RRFPL=:N_RRFPL,");
        strSql.Append("N_LRFCJ=:N_LRFCJ,");
        strSql.Append("N_RRFCJ=:N_RRFCJ,");
        strSql.Append("N_LRFSX=:N_LRFSX,");
        strSql.Append("N_RRFSX=:N_RRFSX,");
        strSql.Append("N_RFCJJE=:N_RFCJJE,");
        strSql.Append("N_RFCJFS=:N_RFCJFS,");
        strSql.Append("N_RFCJPL=:N_RFCJPL,");
        strSql.Append("N_DXFS=:N_DXFS,");
        strSql.Append("N_DXLX=:N_DXLX,");
        strSql.Append("N_DXBL=:N_DXBL,");
        strSql.Append("N_DXDPL=:N_DXDPL,");
        strSql.Append("N_DXXPL=:N_DXXPL,");
        strSql.Append("N_DXDCJ=:N_DXDCJ,");
        strSql.Append("N_DXXCJ=:N_DXXCJ,");
        strSql.Append("N_DXDCSX=:N_DXDCSX,");
        strSql.Append("N_DXCJ=:N_DXCJ,");
        strSql.Append("N_DXCJPL=:N_DXCJPL,");
        strSql.Append("N_LDYPL=:N_LDYPL,");
        strSql.Append("N_RDYPL=:N_RDYPL,");
        strSql.Append("N_LDYCJ=:N_LDYCJ,");
        strSql.Append("N_RDYCJ=:N_RDYCJ,");
        strSql.Append("N_LDYSX=:N_LDYSX,");
        strSql.Append("N_RDYSX=:N_RDYSX,");
        strSql.Append("N_DYCJ=:N_DYCJ,");
        strSql.Append("N_DYCJPL=:N_DYCJPL,");
        strSql.Append("N_LSYPL=:N_LSYPL,");
        strSql.Append("N_RSYPL=:N_RSYPL,");
        strSql.Append("N_LSYCJ=:N_LSYCJ,");
        strSql.Append("N_RSYCJ=:N_RSYCJ,");
        strSql.Append("N_LSYSX=:N_LSYSX,");
        strSql.Append("N_RSYSX=:N_RSYSX,");
        strSql.Append("N_SYCJ=:N_SYCJ,");
        strSql.Append("N_SYCJPL=:N_SYCJPL,");
        strSql.Append("N_DSDPL=:N_DSDPL,");
        strSql.Append("N_DSSPL=:N_DSSPL,");
        strSql.Append("N_DSDCJ=:N_DSDCJ,");
        strSql.Append("N_DSSCJ=:N_DSSCJ,");
        strSql.Append("N_DSDCSX=:N_DSDCSX,");
        strSql.Append("N_DSCJ=:N_DSCJ,");
        strSql.Append("N_DSCJPL=:N_DSCJPL,");
        strSql.Append("N_LDXSX=:N_LDXSX,");
        strSql.Append("N_RDXSX=:N_RDXSX,");
        strSql.Append("N_LDSSX=:N_LDSSX,");
        strSql.Append("N_RDSSX=:N_RDSSX");
        strSql.Append(" where N_LX=:N_LX ");
        OracleParameter[] parameters =
        {
            new OracleParameter(":N_LX",     OracleType.VarChar, 50),
            new OracleParameter(":N_HYDZSX", OracleType.Float,   22),
            new OracleParameter(":N_HYDCSX", OracleType.Float,   22),
            new OracleParameter(":N_CBXH",   OracleType.Number,   4),
            new OracleParameter(":N_RFFS",   OracleType.Float,   22),
            new OracleParameter(":N_RFLX",   OracleType.Number,   4),
            new OracleParameter(":N_RFBL",   OracleType.Number,   4),
            new OracleParameter(":N_LRFPL",  OracleType.Float,   22),
            new OracleParameter(":N_RRFPL",  OracleType.Float,   22),
            new OracleParameter(":N_LRFCJ",  OracleType.Float,   22),
            new OracleParameter(":N_RRFCJ",  OracleType.Float,   22),
            new OracleParameter(":N_LRFSX",  OracleType.Float,   22),
            new OracleParameter(":N_RRFSX",  OracleType.Float,   22),
            new OracleParameter(":N_RFCJJE", OracleType.Float,   22),
            new OracleParameter(":N_RFCJFS", OracleType.Number,   4),
            new OracleParameter(":N_RFCJPL", OracleType.Float,   22),
            new OracleParameter(":N_DXFS",   OracleType.Float,   22),
            new OracleParameter(":N_DXLX",   OracleType.Number,   4),
            new OracleParameter(":N_DXBL",   OracleType.Number,   4),
            new OracleParameter(":N_DXDPL",  OracleType.Float,   22),
            new OracleParameter(":N_DXXPL",  OracleType.Float,   22),
            new OracleParameter(":N_DXDCJ",  OracleType.Float,   22),
            new OracleParameter(":N_DXXCJ",  OracleType.Float,   22),
            new OracleParameter(":N_DXDCSX", OracleType.Float,   22),
            new OracleParameter(":N_DXCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DXCJPL", OracleType.Float,   22),
            new OracleParameter(":N_LDYPL",  OracleType.Float,   22),
            new OracleParameter(":N_RDYPL",  OracleType.Float,   22),
            new OracleParameter(":N_LDYCJ",  OracleType.Float,   22),
            new OracleParameter(":N_RDYCJ",  OracleType.Float,   22),
            new OracleParameter(":N_LDYSX",  OracleType.Float,   22),
            new OracleParameter(":N_RDYSX",  OracleType.Float,   22),
            new OracleParameter(":N_DYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DYCJPL", OracleType.Float,   22),
            new OracleParameter(":N_LSYPL",  OracleType.Float,   22),
            new OracleParameter(":N_RSYPL",  OracleType.Float,   22),
            new OracleParameter(":N_LSYCJ",  OracleType.Float,   22),
            new OracleParameter(":N_RSYCJ",  OracleType.Float,   22),
            new OracleParameter(":N_LSYSX",  OracleType.Float,   22),
            new OracleParameter(":N_RSYSX",  OracleType.Float,   22),
            new OracleParameter(":N_SYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_SYCJPL", OracleType.Float,   22),
            new OracleParameter(":N_DSDPL",  OracleType.Float,   22),
            new OracleParameter(":N_DSSPL",  OracleType.Float,   22),
            new OracleParameter(":N_DSDCJ",  OracleType.Float,   22),
            new OracleParameter(":N_DSSCJ",  OracleType.Float,   22),
            new OracleParameter(":N_DSDCSX", OracleType.Float,   22),
            new OracleParameter(":N_DSCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DSCJPL", OracleType.Float,   22),
            new OracleParameter(":N_LDXSX",  OracleType.Number,   4),
            new OracleParameter(":N_RDXSX",  OracleType.Number,   4),
            new OracleParameter(":N_LDSSX",  OracleType.Number,   4),
            new OracleParameter(":N_RDSSX",  OracleType.Number, 4)
        };
        parameters[0].Value  = model.N_LX;
        parameters[1].Value  = model.N_HYDZSX;
        parameters[2].Value  = model.N_HYDCSX;
        parameters[3].Value  = model.N_CBXH;
        parameters[4].Value  = model.N_RFFS;
        parameters[5].Value  = model.N_RFLX;
        parameters[6].Value  = model.N_RFBL;
        parameters[7].Value  = model.N_LRFPL;
        parameters[8].Value  = model.N_RRFPL;
        parameters[9].Value  = model.N_LRFCJ;
        parameters[10].Value = model.N_RRFCJ;
        parameters[11].Value = model.N_LRFSX;
        parameters[12].Value = model.N_RRFSX;
        parameters[13].Value = model.N_RFCJJE;
        parameters[14].Value = model.N_RFCJFS;
        parameters[15].Value = model.N_RFCJPL;
        parameters[16].Value = model.N_DXFS;
        parameters[17].Value = model.N_DXLX;
        parameters[18].Value = model.N_DXBL;
        parameters[19].Value = model.N_DXDPL;
        parameters[20].Value = model.N_DXXPL;
        parameters[21].Value = model.N_DXDCJ;
        parameters[22].Value = model.N_DXXCJ;
        parameters[23].Value = model.N_DXDCSX;
        parameters[24].Value = model.N_DXCJ;
        parameters[25].Value = model.N_DXCJPL;
        parameters[26].Value = model.N_LDYPL;
        parameters[27].Value = model.N_RDYPL;
        parameters[28].Value = model.N_LDYCJ;
        parameters[29].Value = model.N_RDYCJ;
        parameters[30].Value = model.N_LDYSX;
        parameters[31].Value = model.N_RDYSX;
        parameters[32].Value = model.N_DYCJ;
        parameters[33].Value = model.N_DYCJPL;
        parameters[34].Value = model.N_LSYPL;
        parameters[35].Value = model.N_RSYPL;
        parameters[36].Value = model.N_LSYCJ;
        parameters[37].Value = model.N_RSYCJ;
        parameters[38].Value = model.N_LSYSX;
        parameters[39].Value = model.N_RSYSX;
        parameters[40].Value = model.N_SYCJ;
        parameters[41].Value = model.N_SYCJPL;
        parameters[42].Value = model.N_DSDPL;
        parameters[43].Value = model.N_DSSPL;
        parameters[44].Value = model.N_DSDCJ;
        parameters[45].Value = model.N_DSSCJ;
        parameters[46].Value = model.N_DSDCSX;
        parameters[47].Value = model.N_DSCJ;
        parameters[48].Value = model.N_DSCJPL;
        parameters[49].Value = model.N_LDXSX;
        parameters[50].Value = model.N_RDXSX;
        parameters[51].Value = model.N_LDSSX;
        parameters[52].Value = model.N_RDSSX;

        DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
    }
コード例 #6
0
    /// <summary>
    /// 增加一条数据
    /// </summary>
    public void AddZQ(KFB_BSYS model)
    {
        StringBuilder strSql = new StringBuilder();

        strSql.Append("insert into KFB_BSYS(");
        strSql.Append("N_LX,N_HYDZSX,N_HYDCSX,N_DYSX,N_WZSX,N_LYSX,N_WZQSX,N_CBXH,N_RFFS,N_RFLX,N_RFBL,N_LRFPL,N_RRFPL,N_LRFCJ,N_RRFCJ,N_LRFSX,N_RRFSX,N_RFCJJE,N_RFCJFS,N_RFCJPL,N_DXFS,N_DXLX,N_DXBL,N_DXDPL,N_DXXPL,N_DXDCJ,N_DXXCJ,N_DXDCSX,N_DXCJ,N_DXCJPL,N_LDYPL,N_RDYPL,N_LDYCJ,N_RDYCJ,N_LDYSX,N_RDYSX,N_DYCJ,N_DYCJPL,N_LSYPL,N_RSYPL,N_LSYCJ,N_RSYCJ,N_LSYSX,N_RSYSX,N_SYCJ,N_SYCJPL,N_DSDPL,N_DSSPL,N_DSDCJ,N_DSSCJ,N_DSDCSX,N_DSCJ,N_DSCJPL,N_RQSPL01,N_RQSPL23,N_RQSPL46,N_RQSPL7,N_RQSSX,N_BDGPL00,N_BDZPL10,N_BDGPL11,N_BDZPL20,N_BDZPL21,N_BDGPL22,N_BDZPL30,N_BDZPL31,N_BDZPL32,N_BDGPL33,N_BDZPL41,N_BDZPL40,N_BDZPL42,N_BDZPL43,N_BDKPL10,N_BDKPL20,N_BDKPL21,N_BDKPL30,N_BDKPL31,N_BDKPL32,N_BDKPL40,N_BDKPL41,N_BDKPL42,N_BDKPL43,N_BDGPL44,N_BDZPL5,N_BDKPL5,N_BDSX,N_BQCZZ,N_BQCZH,N_BQCZK,N_BQCHH,N_BQCHZ,N_BQCHK,N_BQCKK,N_BQCKZ,N_BQCKH,N_BQCSX,N_HJPL,N_HJGGCJ,N_HJSX,N_LDXSX,N_RDXSX,N_LDSSX,N_RDSSX)");
        strSql.Append(" values (");
        strSql.Append(":N_LX,:N_HYDZSX,:N_HYDCSX,:N_DYSX,:N_WZSX,:N_LYSX,:N_WZQSX,:N_CBXH,:N_RFFS,:N_RFLX,:N_RFBL,:N_LRFPL,:N_RRFPL,:N_LRFCJ,:N_RRFCJ,:N_LRFSX,:N_RRFSX,:N_RFCJJE,:N_RFCJFS,:N_RFCJPL,:N_DXFS,:N_DXLX,:N_DXBL,:N_DXDPL,:N_DXXPL,:N_DXDCJ,:N_DXXCJ,:N_DXDCSX,:N_DXCJ,:N_DXCJPL,:N_LDYPL,:N_RDYPL,:N_LDYCJ,:N_RDYCJ,:N_LDYSX,:N_RDYSX,:N_DYCJ,:N_DYCJPL,:N_LSYPL,:N_RSYPL,:N_LSYCJ,:N_RSYCJ,:N_LSYSX,:N_RSYSX,:N_SYCJ,:N_SYCJPL,:N_DSDPL,:N_DSSPL,:N_DSDCJ,:N_DSSCJ,:N_DSDCSX,:N_DSCJ,:N_DSCJPL,:N_RQSPL01,:N_RQSPL23,:N_RQSPL46,:N_RQSPL7,:N_RQSSX,:N_BDGPL00,:N_BDZPL10,:N_BDGPL11,:N_BDZPL20,:N_BDZPL21,:N_BDGPL22,:N_BDZPL30,:N_BDZPL31,:N_BDZPL32,:N_BDGPL33,:N_BDZPL41,:N_BDZPL40,:N_BDZPL42,:N_BDZPL43,:N_BDKPL10,:N_BDKPL20,:N_BDKPL21,:N_BDKPL30,:N_BDKPL31,:N_BDKPL32,:N_BDKPL40,:N_BDKPL41,:N_BDKPL42,:N_BDKPL43,:N_BDGPL44,:N_BDZPL5,:N_BDKPL5,:N_BDSX,:N_BQCZZ,:N_BQCZH,:N_BQCZK,:N_BQCHH,:N_BQCHZ,:N_BQCHK,:N_BQCKK,:N_BQCKZ,:N_BQCKH,:N_BQCSX,:N_HJPL,:N_HJGGCJ,:N_HJSX,:N_LDXSX,:N_RDXSX,:N_LDSSX,:N_RDSSX)");
        OracleParameter[] parameters =
        {
            new OracleParameter(":N_LX",      OracleType.VarChar, 50),
            new OracleParameter(":N_HYDZSX",  OracleType.Float,   22),
            new OracleParameter(":N_HYDCSX",  OracleType.Float,   22),
            new OracleParameter(":N_DYSX",    OracleType.Number,   4),
            new OracleParameter(":N_WZSX",    OracleType.Number,   4),
            new OracleParameter(":N_LYSX",    OracleType.Number,   4),
            new OracleParameter(":N_WZQSX",   OracleType.Number,   4),
            new OracleParameter(":N_CBXH",    OracleType.Number,   4),
            new OracleParameter(":N_RFFS",    OracleType.Float,   22),
            new OracleParameter(":N_RFLX",    OracleType.Number,   4),
            new OracleParameter(":N_RFBL",    OracleType.Number,   4),
            new OracleParameter(":N_LRFPL",   OracleType.Float,   22),
            new OracleParameter(":N_RRFPL",   OracleType.Float,   22),
            new OracleParameter(":N_LRFCJ",   OracleType.Float,   22),
            new OracleParameter(":N_RRFCJ",   OracleType.Float,   22),
            new OracleParameter(":N_LRFSX",   OracleType.Float,   22),
            new OracleParameter(":N_RRFSX",   OracleType.Float,   22),
            new OracleParameter(":N_RFCJJE",  OracleType.Float,   22),
            new OracleParameter(":N_RFCJFS",  OracleType.Number,   4),
            new OracleParameter(":N_RFCJPL",  OracleType.Float,   22),
            new OracleParameter(":N_DXFS",    OracleType.Float,   22),
            new OracleParameter(":N_DXLX",    OracleType.Number,   4),
            new OracleParameter(":N_DXBL",    OracleType.Number,   4),
            new OracleParameter(":N_DXDPL",   OracleType.Float,   22),
            new OracleParameter(":N_DXXPL",   OracleType.Float,   22),
            new OracleParameter(":N_DXDCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DXXCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DXDCSX",  OracleType.Float,   22),
            new OracleParameter(":N_DXCJ",    OracleType.Float,   22),
            new OracleParameter(":N_DXCJPL",  OracleType.Float,   22),
            new OracleParameter(":N_LDYPL",   OracleType.Float,   22),
            new OracleParameter(":N_RDYPL",   OracleType.Float,   22),
            new OracleParameter(":N_LDYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_RDYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_LDYSX",   OracleType.Float,   22),
            new OracleParameter(":N_RDYSX",   OracleType.Float,   22),
            new OracleParameter(":N_DYCJ",    OracleType.Float,   22),
            new OracleParameter(":N_DYCJPL",  OracleType.Float,   22),
            new OracleParameter(":N_LSYPL",   OracleType.Float,   22),
            new OracleParameter(":N_RSYPL",   OracleType.Float,   22),
            new OracleParameter(":N_LSYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_RSYCJ",   OracleType.Float,   22),
            new OracleParameter(":N_LSYSX",   OracleType.Float,   22),
            new OracleParameter(":N_RSYSX",   OracleType.Float,   22),
            new OracleParameter(":N_SYCJ",    OracleType.Float,   22),
            new OracleParameter(":N_SYCJPL",  OracleType.Float,   22),
            new OracleParameter(":N_DSDPL",   OracleType.Float,   22),
            new OracleParameter(":N_DSSPL",   OracleType.Float,   22),
            new OracleParameter(":N_DSDCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DSSCJ",   OracleType.Float,   22),
            new OracleParameter(":N_DSDCSX",  OracleType.Float,   22),
            new OracleParameter(":N_DSCJ",    OracleType.Float,   22),
            new OracleParameter(":N_DSCJPL",  OracleType.Float,   22),
            new OracleParameter(":N_RQSPL01", OracleType.Float,   22),
            new OracleParameter(":N_RQSPL23", OracleType.Float,   22),
            new OracleParameter(":N_RQSPL46", OracleType.Float,   22),
            new OracleParameter(":N_RQSPL7",  OracleType.Float,   22),
            new OracleParameter(":N_RQSSX",   OracleType.Float,   22),
            new OracleParameter(":N_BDGPL00", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL10", OracleType.Float,   22),
            new OracleParameter(":N_BDGPL11", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL20", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL21", OracleType.Float,   22),
            new OracleParameter(":N_BDGPL22", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL30", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL31", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL32", OracleType.Float,   22),
            new OracleParameter(":N_BDGPL33", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL41", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL40", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL42", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL43", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL10", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL20", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL21", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL30", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL31", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL32", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL40", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL41", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL42", OracleType.Float,   22),
            new OracleParameter(":N_BDKPL43", OracleType.Float,   22),
            new OracleParameter(":N_BDGPL44", OracleType.Float,   22),
            new OracleParameter(":N_BDZPL5",  OracleType.Float,   22),
            new OracleParameter(":N_BDKPL5",  OracleType.Float,   22),
            new OracleParameter(":N_BDSX",    OracleType.Float,   22),
            new OracleParameter(":N_BQCZZ",   OracleType.Float,   22),
            new OracleParameter(":N_BQCZH",   OracleType.Float,   22),
            new OracleParameter(":N_BQCZK",   OracleType.Float,   22),
            new OracleParameter(":N_BQCHH",   OracleType.Float,   22),
            new OracleParameter(":N_BQCHZ",   OracleType.Float,   22),
            new OracleParameter(":N_BQCHK",   OracleType.Float,   22),
            new OracleParameter(":N_BQCKK",   OracleType.Float,   22),
            new OracleParameter(":N_BQCKZ",   OracleType.Float,   22),
            new OracleParameter(":N_BQCKH",   OracleType.Float,   22),
            new OracleParameter(":N_BQCSX",   OracleType.Float,   22),
            new OracleParameter(":N_HJPL",    OracleType.Float,   22),
            new OracleParameter(":N_HJGGCJ",  OracleType.Float,   22),
            new OracleParameter(":N_HJSX",    OracleType.Float,   22),
            new OracleParameter(":N_LDXSX",   OracleType.Number,   4),
            new OracleParameter(":N_RDXSX",   OracleType.Number,   4),
            new OracleParameter(":N_LDSSX",   OracleType.Number,   4),
            new OracleParameter(":N_RDSSX",   OracleType.Number, 4)
        };
        parameters[0].Value   = model.N_LX;
        parameters[1].Value   = model.N_HYDZSX;
        parameters[2].Value   = model.N_HYDCSX;
        parameters[3].Value   = model.N_DYSX;
        parameters[4].Value   = model.N_WZSX;
        parameters[5].Value   = model.N_LYSX;
        parameters[6].Value   = model.N_WZQSX;
        parameters[7].Value   = model.N_CBXH;
        parameters[8].Value   = model.N_RFFS;
        parameters[9].Value   = model.N_RFLX;
        parameters[10].Value  = model.N_RFBL;
        parameters[11].Value  = model.N_LRFPL;
        parameters[12].Value  = model.N_RRFPL;
        parameters[13].Value  = model.N_LRFCJ;
        parameters[14].Value  = model.N_RRFCJ;
        parameters[15].Value  = model.N_LRFSX;
        parameters[16].Value  = model.N_RRFSX;
        parameters[17].Value  = model.N_RFCJJE;
        parameters[18].Value  = model.N_RFCJFS;
        parameters[19].Value  = model.N_RFCJPL;
        parameters[20].Value  = model.N_DXFS;
        parameters[21].Value  = model.N_DXLX;
        parameters[22].Value  = model.N_DXBL;
        parameters[23].Value  = model.N_DXDPL;
        parameters[24].Value  = model.N_DXXPL;
        parameters[25].Value  = model.N_DXDCJ;
        parameters[26].Value  = model.N_DXXCJ;
        parameters[27].Value  = model.N_DXDCSX;
        parameters[28].Value  = model.N_DXCJ;
        parameters[29].Value  = model.N_DXCJPL;
        parameters[30].Value  = model.N_LDYPL;
        parameters[31].Value  = model.N_RDYPL;
        parameters[32].Value  = model.N_LDYCJ;
        parameters[33].Value  = model.N_RDYCJ;
        parameters[34].Value  = model.N_LDYSX;
        parameters[35].Value  = model.N_RDYSX;
        parameters[36].Value  = model.N_DYCJ;
        parameters[37].Value  = model.N_DYCJPL;
        parameters[38].Value  = model.N_LSYPL;
        parameters[39].Value  = model.N_RSYPL;
        parameters[40].Value  = model.N_LSYCJ;
        parameters[41].Value  = model.N_RSYCJ;
        parameters[42].Value  = model.N_LSYSX;
        parameters[43].Value  = model.N_RSYSX;
        parameters[44].Value  = model.N_SYCJ;
        parameters[45].Value  = model.N_SYCJPL;
        parameters[46].Value  = model.N_DSDPL;
        parameters[47].Value  = model.N_DSSPL;
        parameters[48].Value  = model.N_DSDCJ;
        parameters[49].Value  = model.N_DSSCJ;
        parameters[50].Value  = model.N_DSDCSX;
        parameters[51].Value  = model.N_DSCJ;
        parameters[52].Value  = model.N_DSCJPL;
        parameters[53].Value  = model.N_RQSPL01;
        parameters[54].Value  = model.N_RQSPL23;
        parameters[55].Value  = model.N_RQSPL46;
        parameters[56].Value  = model.N_RQSPL7;
        parameters[57].Value  = model.N_RQSSX;
        parameters[58].Value  = model.N_BDGPL00;
        parameters[59].Value  = model.N_BDZPL10;
        parameters[60].Value  = model.N_BDGPL11;
        parameters[61].Value  = model.N_BDZPL20;
        parameters[62].Value  = model.N_BDZPL21;
        parameters[63].Value  = model.N_BDGPL22;
        parameters[64].Value  = model.N_BDZPL30;
        parameters[65].Value  = model.N_BDZPL31;
        parameters[66].Value  = model.N_BDZPL32;
        parameters[67].Value  = model.N_BDGPL33;
        parameters[68].Value  = model.N_BDZPL41;
        parameters[69].Value  = model.N_BDZPL40;
        parameters[70].Value  = model.N_BDZPL42;
        parameters[71].Value  = model.N_BDZPL43;
        parameters[72].Value  = model.N_BDKPL10;
        parameters[73].Value  = model.N_BDKPL20;
        parameters[74].Value  = model.N_BDKPL21;
        parameters[75].Value  = model.N_BDKPL30;
        parameters[76].Value  = model.N_BDKPL31;
        parameters[77].Value  = model.N_BDKPL32;
        parameters[78].Value  = model.N_BDKPL40;
        parameters[79].Value  = model.N_BDKPL41;
        parameters[80].Value  = model.N_BDKPL42;
        parameters[81].Value  = model.N_BDKPL43;
        parameters[82].Value  = model.N_BDGPL44;
        parameters[83].Value  = model.N_BDZPL5;
        parameters[84].Value  = model.N_BDKPL5;
        parameters[85].Value  = model.N_BDSX;
        parameters[86].Value  = model.N_BQCZZ;
        parameters[87].Value  = model.N_BQCZH;
        parameters[88].Value  = model.N_BQCZK;
        parameters[89].Value  = model.N_BQCHH;
        parameters[90].Value  = model.N_BQCHZ;
        parameters[91].Value  = model.N_BQCHK;
        parameters[92].Value  = model.N_BQCKK;
        parameters[93].Value  = model.N_BQCKZ;
        parameters[94].Value  = model.N_BQCKH;
        parameters[95].Value  = model.N_BQCSX;
        parameters[96].Value  = model.N_HJPL;
        parameters[97].Value  = model.N_HJGGCJ;
        parameters[98].Value  = model.N_HJSX;
        parameters[99].Value  = model.N_LDXSX;
        parameters[100].Value = model.N_RDXSX;
        parameters[101].Value = model.N_LDSSX;
        parameters[102].Value = model.N_RDSSX;

        DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
    }
コード例 #7
0
    private void InitInsertPage()
    {
        #region 新增狀態下帶出默認值
        DateTime dt = this.objGame.GetZWDate();
        this.drpZWYear.Value   = dt.Year.ToString();
        this.drpZWMonth.Value  = dt.Month.ToString().PadLeft(2, '0');
        this.drpZWDay.Value    = dt.Day.ToString().PadLeft(2, '0');
        this.drpBSYear.Value   = DateTime.Now.Year.ToString();
        this.drpBSMonth.Value  = DateTime.Now.Month.ToString().PadLeft(2, '0');
        this.drpBSDay.Value    = DateTime.Now.Day.ToString().PadLeft(2, '0');
        this.drpBSHour.Value   = DateTime.Now.Hour.ToString().PadLeft(2, '0');
        this.drpBSMinute.Value = DateTime.Now.Minute.ToString().PadLeft(2, '0');
        this.chkLet.Value      = "0";

        KFB_BSYS o_KFB_BSYS = objGame.GetModel(ms_TYPE);
        if (o_KFB_BSYS != null)
        {
            if ((o_KFB_BSYS.N_CBXH.Value & 1) == 1)
            {
                this.chkCB.Items[0].Selected = true;
            }
            if ((o_KFB_BSYS.N_CBXH.Value & 2) == 2)
            {
                this.chkCB.Items[1].Selected = true;
            }
            if ((o_KFB_BSYS.N_CBXH.Value & 4) == 4)
            {
                this.chkCB.Items[2].Selected = true;
            }

            this.chkDSClose.Checked = true;
            this.chkDXClose.Checked = true;
            this.chkDYClose.Checked = true;
            this.chkRFClose.Checked = true;
            this.chkSYClose.Checked = true;
            this.txtDZSX.Text       = o_KFB_BSYS.N_HYDZSX.ToString();
            this.txtDCSX.Text       = o_KFB_BSYS.N_HYDCSX.ToString();
            this.drpRFFS.Value      = o_KFB_BSYS.N_RFFS.ToString();
            this.drpRFLX.Value      = o_KFB_BSYS.N_RFLX.ToString();
            this.txtRFBL.Value      = o_KFB_BSYS.N_RFBL.ToString();
            this.txtLRFPL.Value     = o_KFB_BSYS.N_LRFPL.ToString();
            this.txtRRFPL.Value     = o_KFB_BSYS.N_RRFPL.ToString();
            this.drpLRFCJ.Value     = o_KFB_BSYS.N_LRFCJ.ToString();
            this.drpRRFCJ.Value     = o_KFB_BSYS.N_RRFCJ.ToString();
            this.txtLRFSX.Value     = o_KFB_BSYS.N_LRFSX.ToString();
            this.txtRRFSX.Value     = o_KFB_BSYS.N_RRFSX.ToString();
            this.txtRFCJJE.Value    = o_KFB_BSYS.N_RFCJJE.ToString();
            this.drpRFCJFS.Value    = o_KFB_BSYS.N_RFCJFS.ToString();
            if (o_KFB_BSYS.N_RFCJFS.Value.Equals(0))
            {
                this.drpRFCJPL.Value = o_KFB_BSYS.N_RFCJPL.ToString();
            }
            else
            {
                this.drpRFCJPL1.Value = o_KFB_BSYS.N_RFCJPL.ToString();
            }
            this.txtDXFS.Value   = o_KFB_BSYS.N_DXFS.ToString();
            this.drpDXLX.Value   = o_KFB_BSYS.N_DXLX.ToString();
            this.txtDXBL.Value   = o_KFB_BSYS.N_DXBL.ToString();
            this.txtDXDPL.Value  = o_KFB_BSYS.N_DXDPL.ToString();
            this.txtDXXPL.Value  = o_KFB_BSYS.N_DXXPL.ToString();
            this.drpDXDCJ.Value  = o_KFB_BSYS.N_DXDCJ.ToString();
            this.drpDXXCJ.Value  = o_KFB_BSYS.N_DXXCJ.ToString();
            this.txtLDXSX.Value  = o_KFB_BSYS.N_LDXSX.ToString();
            this.txtRDXSX.Value  = o_KFB_BSYS.N_RDXSX.ToString();
            this.txtDXCJ.Value   = o_KFB_BSYS.N_DXCJ.ToString();
            this.drpDXCJPL.Value = o_KFB_BSYS.N_DXCJPL.ToString();
            this.txtLDYPL.Value  = o_KFB_BSYS.N_LDYPL.ToString();
            this.txtRDYPL.Value  = o_KFB_BSYS.N_RDYPL.ToString();
            this.drpLDYCJ.Value  = o_KFB_BSYS.N_LDYCJ.ToString();
            this.drpRDYCJ.Value  = o_KFB_BSYS.N_RDYCJ.ToString();
            this.txtLDYSX.Value  = o_KFB_BSYS.N_LDYSX.ToString();
            this.txtRDYSX.Value  = o_KFB_BSYS.N_RDYSX.ToString();
            this.txtDYCJ.Value   = o_KFB_BSYS.N_DYCJ.ToString();
            this.drpDYCJPL.Value = o_KFB_BSYS.N_DYCJPL.ToString();
            this.txtLSYPL.Value  = o_KFB_BSYS.N_LSYPL.ToString();
            this.txtRSYPL.Value  = o_KFB_BSYS.N_RSYPL.ToString();
            this.drpLSYCJ.Value  = o_KFB_BSYS.N_LSYCJ.ToString();
            this.drpRSYCJ.Value  = o_KFB_BSYS.N_RSYCJ.ToString();
            this.txtLSYSX.Value  = o_KFB_BSYS.N_LSYSX.ToString();
            this.txtRSYSX.Value  = o_KFB_BSYS.N_RSYSX.ToString();
            this.txtSYCJ.Value   = o_KFB_BSYS.N_SYCJ.ToString();
            this.drpSYCJPL.Value = o_KFB_BSYS.N_SYCJPL.ToString();
            this.txtDSDPL.Value  = o_KFB_BSYS.N_DSDPL.ToString();
            this.txtDSSPL.Value  = o_KFB_BSYS.N_DSSPL.ToString();
            this.drpDSDCJ.Value  = o_KFB_BSYS.N_DSDCJ.ToString();
            this.drpDSSCJ.Value  = o_KFB_BSYS.N_DSSCJ.ToString();
            this.txtLDSSX.Value  = o_KFB_BSYS.N_LDSSX.ToString();
            this.txtRDSSX.Value  = o_KFB_BSYS.N_RDSSX.ToString();
            this.txtDSCJ.Value   = o_KFB_BSYS.N_DSCJ.ToString();
            this.drpDSCJPL.Value = o_KFB_BSYS.N_DSCJPL.ToString();

            this.chkRFGGClose.Checked = true;
            this.chkDXGGClose.Checked = true;
            this.chkDYGGClose.Checked = true;
            this.chkSYGGClose.Checked = true;
            this.chkDSGGClose.Checked = true;
        }
        #endregion
    }
コード例 #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["bt"] != null)
        {
            ms_TYPE = Request.QueryString["bt"];
            switch (Request.QueryString["bt"])
            {
            case "b_zq":
                this.lblball.Text = "足球";
                break;
            }
        }
        if (!IsPostBack)
        {
            KFB_BSYS o_KFB_BSYS = objGamesDB.GetModel(ms_TYPE);
            if (o_KFB_BSYS != null)
            {
                if ((o_KFB_BSYS.N_CBXH.Value & 1) == 1)
                {
                    this.chkCB.Items[0].Selected = true;
                }
                if ((o_KFB_BSYS.N_CBXH.Value & 2) == 2)
                {
                    this.chkCB.Items[1].Selected = true;
                }
                if ((o_KFB_BSYS.N_CBXH.Value & 4) == 4)
                {
                    this.chkCB.Items[2].Selected = true;
                }
                this.txtDZSX.Value   = o_KFB_BSYS.N_HYDZSX.ToString();
                this.txtDCSX.Value   = o_KFB_BSYS.N_HYDCSX.ToString();
                this.drpRFFS.Value   = o_KFB_BSYS.N_RFFS.ToString();
                this.drpRFLX.Value   = o_KFB_BSYS.N_RFLX.ToString();
                this.txtRFBL.Value   = o_KFB_BSYS.N_RFBL.ToString();
                this.txtLRFPL.Value  = o_KFB_BSYS.N_LRFPL.ToString();
                this.txtRRFPL.Value  = o_KFB_BSYS.N_RRFPL.ToString();
                this.drpLRFCJ.Value  = o_KFB_BSYS.N_LRFCJ.ToString();
                this.drpRRFCJ.Value  = o_KFB_BSYS.N_RRFCJ.ToString();
                this.txtLRFSX.Value  = o_KFB_BSYS.N_LRFSX.ToString();
                this.txtRRFSX.Value  = o_KFB_BSYS.N_RRFSX.ToString();
                this.txtRFCJJE.Value = o_KFB_BSYS.N_RFCJJE.ToString();
                this.drpRFCJFS.Value = o_KFB_BSYS.N_RFCJFS.ToString();
                if (o_KFB_BSYS.N_RFCJFS.Value.Equals(0))
                {
                    this.drpRFCJPL.Value = o_KFB_BSYS.N_RFCJPL.ToString();
                }
                else
                {
                    this.drpRFCJPL1.Value = o_KFB_BSYS.N_RFCJPL.ToString();
                }
                this.drpDXFS.Value   = o_KFB_BSYS.N_DXFS.ToString();
                this.drpDXLX.Value   = o_KFB_BSYS.N_DXLX.ToString();
                this.txtDXBL.Value   = o_KFB_BSYS.N_DXBL.ToString();
                this.txtDXDPL.Value  = o_KFB_BSYS.N_DXDPL.ToString();
                this.txtDXXPL.Value  = o_KFB_BSYS.N_DXXPL.ToString();
                this.drpDXDCJ.Value  = o_KFB_BSYS.N_DXDCJ.ToString();
                this.drpDXXCJ.Value  = o_KFB_BSYS.N_DXXCJ.ToString();
                this.txtLDXSX.Value  = o_KFB_BSYS.N_LDXSX.ToString();
                this.txtRDXSX.Value  = o_KFB_BSYS.N_RDXSX.ToString();
                this.txtDXCJ.Value   = o_KFB_BSYS.N_DXCJ.ToString();
                this.drpDXCJPL.Value = o_KFB_BSYS.N_DXCJPL.ToString();
                this.txtLDYPL.Value  = o_KFB_BSYS.N_LDYPL.ToString();
                this.txtRDYPL.Value  = o_KFB_BSYS.N_RDYPL.ToString();
                this.drpLDYCJ.Value  = o_KFB_BSYS.N_LDYCJ.ToString();
                this.drpRDYCJ.Value  = o_KFB_BSYS.N_RDYCJ.ToString();
                this.txtLDYSX.Value  = o_KFB_BSYS.N_LDYSX.ToString();
                this.txtRDYSX.Value  = o_KFB_BSYS.N_RDYSX.ToString();
                this.txtDYCJ.Value   = o_KFB_BSYS.N_DYCJ.ToString();
                this.drpDYCJPL.Value = o_KFB_BSYS.N_DYCJPL.ToString();
                //this.txtLSYPL.Value = o_KFB_BSYS.N_LSYPL.ToString();
                //this.txtRSYPL.Value = o_KFB_BSYS.N_RSYPL.ToString();
                //this.drpLSYCJ.Value = o_KFB_BSYS.N_LSYCJ.ToString();
                //this.drpRSYCJ.Value = o_KFB_BSYS.N_RSYCJ.ToString();
                //this.txtLSYSX.Value = o_KFB_BSYS.N_LSYSX.ToString();
                //this.txtRSYSX.Value = o_KFB_BSYS.N_RSYSX.ToString();
                //this.txtSYCJ.Value = o_KFB_BSYS.N_SYCJ.ToString();
                //this.drpSYCJPL.Value = o_KFB_BSYS.N_SYCJPL.ToString();
                this.txtDSDPL.Value  = o_KFB_BSYS.N_DSDPL.ToString();
                this.txtDSSPL.Value  = o_KFB_BSYS.N_DSSPL.ToString();
                this.drpDSDCJ.Value  = o_KFB_BSYS.N_DSDCJ.ToString();
                this.drpDSSCJ.Value  = o_KFB_BSYS.N_DSSCJ.ToString();
                this.txtLDSSX.Value  = o_KFB_BSYS.N_LDSSX.ToString();
                this.txtRDSSX.Value  = o_KFB_BSYS.N_RDSSX.ToString();
                this.txtDSCJ.Value   = o_KFB_BSYS.N_DSCJ.ToString();
                this.drpDSCJPL.Value = o_KFB_BSYS.N_DSCJPL.ToString();

                this.txt00.Text   = o_KFB_BSYS.N_BDGPL00.ToString();
                this.txt11.Text   = o_KFB_BSYS.N_BDGPL11.ToString();
                this.txt22.Text   = o_KFB_BSYS.N_BDGPL22.ToString();
                this.txt33.Text   = o_KFB_BSYS.N_BDGPL33.ToString();
                this.txt44.Text   = o_KFB_BSYS.N_BDGPL44.ToString();
                this.txtkc10.Text = o_KFB_BSYS.N_BDKPL10.ToString();
                this.txtkc20.Text = o_KFB_BSYS.N_BDKPL20.ToString();
                this.txtkc21.Text = o_KFB_BSYS.N_BDKPL21.ToString();
                this.txtkc30.Text = o_KFB_BSYS.N_BDKPL30.ToString();
                this.txtkc31.Text = o_KFB_BSYS.N_BDKPL31.ToString();
                this.txtkc32.Text = o_KFB_BSYS.N_BDKPL32.ToString();
                this.txtkc40.Text = o_KFB_BSYS.N_BDKPL40.ToString();
                this.txtkc41.Text = o_KFB_BSYS.N_BDKPL41.ToString();
                this.txtkc42.Text = o_KFB_BSYS.N_BDKPL42.ToString();
                this.txtkc43.Text = o_KFB_BSYS.N_BDKPL43.ToString();
                this.txtkc5.Text  = o_KFB_BSYS.N_BDKPL5.ToString();
                this.txtbdsx.Text = o_KFB_BSYS.N_BDSX.ToString();
                this.txtzc10.Text = o_KFB_BSYS.N_BDZPL10.ToString();
                this.txtzc20.Text = o_KFB_BSYS.N_BDZPL20.ToString();
                this.txtzc21.Text = o_KFB_BSYS.N_BDZPL21.ToString();
                this.txtzc30.Text = o_KFB_BSYS.N_BDZPL30.ToString();
                this.txtzc31.Text = o_KFB_BSYS.N_BDZPL31.ToString();
                this.txtzc32.Text = o_KFB_BSYS.N_BDZPL32.ToString();
                this.txtzc40.Text = o_KFB_BSYS.N_BDZPL40.ToString();
                this.txtzc41.Text = o_KFB_BSYS.N_BDZPL41.ToString();
                this.txtzc42.Text = o_KFB_BSYS.N_BDZPL42.ToString();
                this.txtzc43.Text = o_KFB_BSYS.N_BDZPL43.ToString();
                this.txtzc5.Text  = o_KFB_BSYS.N_BDZPL5.ToString();

                this.txtbqchh.Text = o_KFB_BSYS.N_BQCHH.ToString();
                this.txtbqchk.Text = o_KFB_BSYS.N_BQCHK.ToString();
                this.txtbqchz.Text = o_KFB_BSYS.N_BQCHZ.ToString();
                this.txtbqckh.Text = o_KFB_BSYS.N_BQCKH.ToString();
                this.txtbqckk.Text = o_KFB_BSYS.N_BQCKK.ToString();

                this.txtbqckz.Text     = o_KFB_BSYS.N_BQCKZ.ToString();
                this.txtbqcsx.Text     = o_KFB_BSYS.N_BQCSX.ToString();
                this.txtbqczh.Text     = o_KFB_BSYS.N_BQCZH.ToString();
                this.txtbqczk.Text     = o_KFB_BSYS.N_BQCZK.ToString();
                this.txtbqczz.Text     = o_KFB_BSYS.N_BQCZZ.ToString();
                this.txtrqs01.Text     = o_KFB_BSYS.N_RQSPL01.ToString();
                this.txtrqs23.Text     = o_KFB_BSYS.N_RQSPL23.ToString();
                this.txtrqs46.Text     = o_KFB_BSYS.N_RQSPL46.ToString();
                this.txtrqs7.Text      = o_KFB_BSYS.N_RQSPL7.ToString();
                this.txtrqssx.Text     = o_KFB_BSYS.N_RQSSX.ToString();
                this.txtN_HJPL.Value   = o_KFB_BSYS.N_HJPL.ToString();
                this.txtN_HJGGCJ.Value = o_KFB_BSYS.N_HJGGCJ.ToString();
                this.txtN_HJSX.Value   = o_KFB_BSYS.N_HJSX.ToString();
            }
        }
        this.Page.ClientScript.RegisterStartupScript(this.GetType(), "Keys", "changefenshu(document.getElementById('ContentPlaceHolder11_drpRFCJFS'));", true);
    }
コード例 #9
0
    private KFB_BSYS getKFB_BSYS()
    {
        KFB_BSYS o_KFB_BSYS = new KFB_BSYS();

        o_KFB_BSYS.N_LX = ms_TYPE;
        //是否延遲下注
        int i_Count = 0;

        for (int i = 0; i < this.chkCB.Items.Count; i++)
        {
            if (chkCB.Items[i].Selected)
            {
                i_Count += Convert.ToInt32(chkCB.Items[i].Value);
            }
        }
        o_KFB_BSYS.N_CBXH   = i_Count;
        o_KFB_BSYS.N_HYDZSX = Convert.ToSingle(this.txtDZSX.Value);
        o_KFB_BSYS.N_HYDCSX = Convert.ToSingle(this.txtDCSX.Value);
        o_KFB_BSYS.N_RFFS   = Convert.ToSingle(this.drpRFFS.Value);
        o_KFB_BSYS.N_RFLX   = Convert.ToInt32(this.drpRFLX.Value);
        o_KFB_BSYS.N_RFBL   = Convert.ToInt32(this.txtRFBL.Value);
        o_KFB_BSYS.N_LRFPL  = Convert.ToSingle(this.txtLRFPL.Value);
        o_KFB_BSYS.N_RRFPL  = Convert.ToSingle(this.txtRRFPL.Value);
        o_KFB_BSYS.N_LRFCJ  = Convert.ToSingle(this.drpLRFCJ.Value);
        o_KFB_BSYS.N_RRFCJ  = Convert.ToSingle(this.drpRRFCJ.Value);
        o_KFB_BSYS.N_LRFSX  = Convert.ToSingle(this.txtLRFSX.Value);
        o_KFB_BSYS.N_RRFSX  = Convert.ToSingle(this.txtRRFSX.Value);
        o_KFB_BSYS.N_RFCJJE = Convert.ToSingle(this.txtRFCJJE.Value);
        o_KFB_BSYS.N_RFCJFS = Convert.ToInt32(this.drpRFCJFS.Value);
        if (this.drpRFCJFS.Value.Equals("0"))
        {
            o_KFB_BSYS.N_RFCJPL = Convert.ToSingle(this.drpRFCJPL.Value);
        }
        else
        {
            o_KFB_BSYS.N_RFCJPL = Convert.ToSingle(this.drpRFCJPL1.Value);
        }
        o_KFB_BSYS.N_DXFS   = Convert.ToSingle(this.drpDXFS.Value);
        o_KFB_BSYS.N_DXLX   = Convert.ToInt32(this.drpDXLX.Value);
        o_KFB_BSYS.N_DXBL   = Convert.ToInt32(this.txtDXBL.Value);
        o_KFB_BSYS.N_DXDPL  = Convert.ToSingle(this.txtDXDPL.Value);
        o_KFB_BSYS.N_DXXPL  = Convert.ToSingle(this.txtDXXPL.Value);
        o_KFB_BSYS.N_DXDCJ  = Convert.ToSingle(this.drpDXDCJ.Value);
        o_KFB_BSYS.N_DXXCJ  = Convert.ToSingle(this.drpDXXCJ.Value);
        o_KFB_BSYS.N_DXDCSX = 0;
        o_KFB_BSYS.N_LDXSX  = Convert.ToSingle(this.txtLDXSX.Value);
        o_KFB_BSYS.N_RDXSX  = Convert.ToSingle(this.txtRDXSX.Value);
        o_KFB_BSYS.N_DXCJ   = Convert.ToSingle(this.txtDXCJ.Value);
        o_KFB_BSYS.N_DXCJPL = Convert.ToSingle(this.drpDXCJPL.Value);
        o_KFB_BSYS.N_LDYPL  = Convert.ToSingle(this.txtLDYPL.Value);
        o_KFB_BSYS.N_RDYPL  = Convert.ToSingle(this.txtRDYPL.Value);
        o_KFB_BSYS.N_LDYCJ  = Convert.ToSingle(this.drpLDYCJ.Value);
        o_KFB_BSYS.N_RDYCJ  = Convert.ToSingle(this.drpRDYCJ.Value);
        o_KFB_BSYS.N_LDYSX  = Convert.ToSingle(this.txtLDYSX.Value);
        o_KFB_BSYS.N_RDYSX  = Convert.ToSingle(this.txtRDYSX.Value);
        o_KFB_BSYS.N_DYCJ   = Convert.ToSingle(this.txtDYCJ.Value);
        o_KFB_BSYS.N_DYCJPL = Convert.ToSingle(this.drpDYCJPL.Value);

        o_KFB_BSYS.N_LSYPL  = 0;
        o_KFB_BSYS.N_RSYPL  = 0;
        o_KFB_BSYS.N_LSYCJ  = 0;
        o_KFB_BSYS.N_RSYCJ  = 0;
        o_KFB_BSYS.N_LSYSX  = 0;
        o_KFB_BSYS.N_RSYSX  = 0;
        o_KFB_BSYS.N_SYCJ   = 0;
        o_KFB_BSYS.N_SYCJPL = 0;

        o_KFB_BSYS.N_DSDPL  = Convert.ToSingle(this.txtDSDPL.Value);
        o_KFB_BSYS.N_DSSPL  = Convert.ToSingle(this.txtDSSPL.Value);
        o_KFB_BSYS.N_DSDCJ  = Convert.ToSingle(this.drpDSDCJ.Value);
        o_KFB_BSYS.N_DSSCJ  = Convert.ToSingle(this.drpDSSCJ.Value);
        o_KFB_BSYS.N_DSDCSX = 0;
        o_KFB_BSYS.N_LDSSX  = Convert.ToSingle(this.txtLDSSX.Value);
        o_KFB_BSYS.N_RDSSX  = Convert.ToSingle(this.txtRDSSX.Value);
        o_KFB_BSYS.N_DSCJ   = Convert.ToSingle(this.txtDSCJ.Value);
        o_KFB_BSYS.N_DSCJPL = Convert.ToSingle(this.drpDSCJPL.Value);

        o_KFB_BSYS.N_BDGPL00 = Convert.ToSingle(this.txt00.Text);
        o_KFB_BSYS.N_BDGPL11 = Convert.ToSingle(this.txt11.Text);
        o_KFB_BSYS.N_BDGPL22 = Convert.ToSingle(this.txt22.Text);
        o_KFB_BSYS.N_BDGPL33 = Convert.ToSingle(this.txt33.Text);
        o_KFB_BSYS.N_BDGPL44 = Convert.ToSingle(this.txt44.Text);
        o_KFB_BSYS.N_BDKPL10 = Convert.ToSingle(this.txtkc10.Text);
        o_KFB_BSYS.N_BDKPL20 = Convert.ToSingle(this.txtkc20.Text);
        o_KFB_BSYS.N_BDKPL21 = Convert.ToSingle(this.txtkc21.Text);
        o_KFB_BSYS.N_BDKPL30 = Convert.ToSingle(this.txtkc30.Text);
        o_KFB_BSYS.N_BDKPL31 = Convert.ToSingle(this.txtkc31.Text);
        o_KFB_BSYS.N_BDKPL32 = Convert.ToSingle(this.txtkc32.Text);
        o_KFB_BSYS.N_BDKPL40 = Convert.ToSingle(this.txtkc40.Text);
        o_KFB_BSYS.N_BDKPL41 = Convert.ToSingle(this.txtkc41.Text);
        o_KFB_BSYS.N_BDKPL42 = Convert.ToSingle(this.txtkc42.Text);
        o_KFB_BSYS.N_BDKPL43 = Convert.ToSingle(this.txtkc43.Text);
        o_KFB_BSYS.N_BDKPL5  = Convert.ToSingle(this.txtkc5.Text);
        o_KFB_BSYS.N_BDSX    = Convert.ToSingle(this.txtbdsx.Text);
        o_KFB_BSYS.N_BDZPL10 = Convert.ToSingle(this.txtzc10.Text);
        o_KFB_BSYS.N_BDZPL20 = Convert.ToSingle(this.txtzc20.Text);
        o_KFB_BSYS.N_BDZPL21 = Convert.ToSingle(this.txtzc21.Text);
        o_KFB_BSYS.N_BDZPL30 = Convert.ToSingle(this.txtzc30.Text);
        o_KFB_BSYS.N_BDZPL31 = Convert.ToSingle(this.txtzc31.Text);
        o_KFB_BSYS.N_BDZPL32 = Convert.ToSingle(this.txtzc32.Text);
        o_KFB_BSYS.N_BDZPL40 = Convert.ToSingle(this.txtzc40.Text);
        o_KFB_BSYS.N_BDZPL41 = Convert.ToSingle(this.txtzc41.Text);
        o_KFB_BSYS.N_BDZPL42 = Convert.ToSingle(this.txtzc42.Text);
        o_KFB_BSYS.N_BDZPL43 = Convert.ToSingle(this.txtzc43.Text);
        o_KFB_BSYS.N_BDZPL5  = Convert.ToSingle(this.txtzc5.Text);

        o_KFB_BSYS.N_BQCHH = Convert.ToSingle(this.txtbqchh.Text);
        o_KFB_BSYS.N_BQCHK = Convert.ToSingle(this.txtbqchk.Text);
        o_KFB_BSYS.N_BQCHZ = Convert.ToSingle(this.txtbqchz.Text);
        o_KFB_BSYS.N_BQCKH = Convert.ToSingle(this.txtbqckh.Text);
        o_KFB_BSYS.N_BQCKK = Convert.ToSingle(this.txtbqckk.Text);

        o_KFB_BSYS.N_BQCKZ   = Convert.ToSingle(this.txtbqckz.Text);
        o_KFB_BSYS.N_BQCSX   = Convert.ToSingle(this.txtbqcsx.Text);
        o_KFB_BSYS.N_BQCZH   = Convert.ToSingle(this.txtbqczh.Text);
        o_KFB_BSYS.N_BQCZK   = Convert.ToSingle(this.txtbqczk.Text);
        o_KFB_BSYS.N_BQCZZ   = Convert.ToSingle(this.txtbqczz.Text);
        o_KFB_BSYS.N_RQSPL01 = Convert.ToSingle(this.txtrqs01.Text);
        o_KFB_BSYS.N_RQSPL23 = Convert.ToSingle(this.txtrqs23.Text);
        o_KFB_BSYS.N_RQSPL46 = Convert.ToSingle(this.txtrqs46.Text);
        o_KFB_BSYS.N_RQSPL7  = Convert.ToSingle(this.txtrqs7.Text);
        o_KFB_BSYS.N_RQSSX   = Convert.ToSingle(this.txtrqssx.Text);

        o_KFB_BSYS.N_DYSX  = 0;
        o_KFB_BSYS.N_WZSX  = 0;
        o_KFB_BSYS.N_LYSX  = 0;
        o_KFB_BSYS.N_WZQSX = 0;

        o_KFB_BSYS.N_HJPL   = Convert.ToSingle(this.txtN_HJPL.Value);
        o_KFB_BSYS.N_HJGGCJ = Convert.ToSingle(this.txtN_HJGGCJ.Value);
        o_KFB_BSYS.N_HJSX   = Convert.ToSingle(this.txtN_HJSX.Value);

        return(o_KFB_BSYS);
    }