/// <summary> /// 取得下級的設置 /// </summary> /// <param name="strlvl"></param> /// <param name="strparid"></param> public void GetSUB(string strlvl, string strparid) { KFB_SETUPZQ mo_ZQ = this.objAgentManageAddDB.GetModelZQ(strlvl, strparid); string strSpName = "(" + Comm.GetLvSName(Convert.ToString(Convert.ToDecimal(strlvl) + 1)) + ")"; this.lbtyarft.Text = strSpName + mo_ZQ.N_ARFTY.ToString(); this.lbtybrft.Text = strSpName + mo_ZQ.N_BRFTY.ToString(); this.lbtycrft.Text = strSpName + mo_ZQ.N_CRFTY.ToString(); this.lbdzrft.Text = strSpName + mo_ZQ.N_RFDZ.ToString(); this.lbdcrft.Text = strSpName + mo_ZQ.N_RFDC.ToString(); this.lbtyadxt.Text = strSpName + mo_ZQ.N_ADXTY.ToString(); this.lbtybdxt.Text = strSpName + mo_ZQ.N_BDXTY.ToString(); this.lbtycdxt.Text = strSpName + mo_ZQ.N_CDXTY.ToString(); this.lbdzdxt.Text = strSpName + mo_ZQ.N_DXDZ.ToString(); this.lbdcdxt.Text = strSpName + mo_ZQ.N_DXDC.ToString(); this.lbtyadyt.Text = strSpName + mo_ZQ.N_ADYTY.ToString(); this.lbtybdyt.Text = strSpName + mo_ZQ.N_BDYTY.ToString(); this.lbtycdyt.Text = strSpName + mo_ZQ.N_CDYTY.ToString(); this.lbdzdyt.Text = strSpName + mo_ZQ.N_DYDZ.ToString(); this.lbdcdyt.Text = strSpName + mo_ZQ.N_DYDC.ToString(); this.lbtyadst.Text = strSpName + mo_ZQ.N_ADSTY.ToString(); this.lbtybdst.Text = strSpName + mo_ZQ.N_BDSTY.ToString(); this.lbtycdst.Text = strSpName + mo_ZQ.N_CDSTY.ToString(); this.lbdzdst.Text = strSpName + mo_ZQ.N_DSDZ.ToString(); this.lbdcdst.Text = strSpName + mo_ZQ.N_DSDC.ToString(); this.lbtyazdrft.Text = strSpName + mo_ZQ.N_AZDRFTY.ToString(); this.lbtybzdrft.Text = strSpName + mo_ZQ.N_BZDRFTY.ToString(); this.lbtyczdrft.Text = strSpName + mo_ZQ.N_CZDRFTY.ToString(); this.lbdzzdrft.Text = strSpName + mo_ZQ.N_ZDRFDZ.ToString(); this.lbdczdrft.Text = strSpName + mo_ZQ.N_ZDRFDC.ToString(); this.lbtyazddxt.Text = strSpName + mo_ZQ.N_AZDDXTY.ToString(); this.lbtybzddxt.Text = strSpName + mo_ZQ.N_BZDDXTY.ToString(); this.lbtyczddxt.Text = strSpName + mo_ZQ.N_CZDDXTY.ToString(); this.lbdzzddxt.Text = strSpName + mo_ZQ.N_ZDDXDZ.ToString(); this.lbdczddxt.Text = strSpName + mo_ZQ.N_ZDDXDC.ToString(); this.lbtyabcrft.Text = strSpName + mo_ZQ.N_ABCRFTY.ToString(); this.lbtybbcrft.Text = strSpName + mo_ZQ.N_BBCRFTY.ToString(); this.lbtycbcrft.Text = strSpName + mo_ZQ.N_CBCRFTY.ToString(); this.lbdzbcrft.Text = strSpName + mo_ZQ.N_BCRFDZ.ToString(); this.lbdcbcrft.Text = strSpName + mo_ZQ.N_BCRFDC.ToString(); this.lbtyabcdxt.Text = strSpName + mo_ZQ.N_ABCDXTY.ToString(); this.lbtybbcdxt.Text = strSpName + mo_ZQ.N_BBCDXTY.ToString(); this.lbtycbcdxt.Text = strSpName + mo_ZQ.N_CBCDXTY.ToString(); this.lbdzbcdxt.Text = strSpName + mo_ZQ.N_BCDXDZ.ToString(); this.lbdcbcdxt.Text = strSpName + mo_ZQ.N_BCDXDC.ToString(); this.lbtyabcdyt.Text = strSpName + mo_ZQ.N_ABCDYTY.ToString(); this.lbtybbcdyt.Text = strSpName + mo_ZQ.N_BBCDYTY.ToString(); this.lbtycbcdyt.Text = strSpName + mo_ZQ.N_CBCDYTY.ToString(); this.lbdzbcdyt.Text = strSpName + mo_ZQ.N_BCDYDZ.ToString(); this.lbdcbcdyt.Text = strSpName + mo_ZQ.N_BCDYDC.ToString(); this.lbtyarqst.Text = strSpName + mo_ZQ.N_ARQSTY.ToString(); this.lbtybrqst.Text = strSpName + mo_ZQ.N_BRQSTY.ToString(); this.lbtycrqst.Text = strSpName + mo_ZQ.N_CRQSTY.ToString(); this.lbdzrqst.Text = strSpName + mo_ZQ.N_RQSDZ.ToString(); this.lbdcrqst.Text = strSpName + mo_ZQ.N_RQSDC.ToString(); this.lbtyabdt.Text = strSpName + mo_ZQ.N_ABDTY.ToString(); this.lbtybbdt.Text = strSpName + mo_ZQ.N_BBDTY.ToString(); this.lbtycbdt.Text = strSpName + mo_ZQ.N_CBDTY.ToString(); this.lbdzbdt.Text = strSpName + mo_ZQ.N_BDDZ.ToString(); this.lbdcbdt.Text = strSpName + mo_ZQ.N_BDDC.ToString(); this.lbtyabqct.Text = strSpName + mo_ZQ.N_ABQCTY.ToString(); this.lbtybbqct.Text = strSpName + mo_ZQ.N_BBQCTY.ToString(); this.lbtycbqct.Text = strSpName + mo_ZQ.N_CBQCTY.ToString(); this.lbdzbqct.Text = strSpName + mo_ZQ.N_BQCDZ.ToString(); this.lbdcbqct.Text = strSpName + mo_ZQ.N_BQCDC.ToString(); this.lbtyaggt.Text = strSpName + mo_ZQ.N_AGGTY.ToString(); this.lbtybggt.Text = strSpName + mo_ZQ.N_BGGTY.ToString(); this.lbtycggt.Text = strSpName + mo_ZQ.N_CGGTY.ToString(); this.lbdzggt.Text = strSpName + mo_ZQ.N_GGDZ.ToString(); this.lbdcggt.Text = strSpName + mo_ZQ.N_GGDC.ToString(); this.lbtyagjt.Text = strSpName + mo_ZQ.N_AGJTY.ToString(); this.lbtybgjt.Text = strSpName + mo_ZQ.N_BGJTY.ToString(); this.lbtycgjt.Text = strSpName + mo_ZQ.N_CGJTY.ToString(); this.lbdzgjt.Text = strSpName + mo_ZQ.N_GJDZ.ToString(); this.lbdcgjt.Text = strSpName + mo_ZQ.N_GJDC.ToString(); }
/// <summary> /// 上級帳號上層賦值 /// </summary> public void ZHFZ(string strparid, string strlvl) { string strzh = ""; if (strlvl == "10") { KFB_HYGL mo_hygl = this.objAgentManageDB.GetModelHYGL(strparid); strzh = mo_hygl.N_DLDH; } else { strzh = Comm.GetUPID(strparid, strlvl); } KFB_SETUPZQ mo_ZQ = this.objAgentManageAddDB.GetModelZQ(strzh); this.lbdzrf.Text = mo_ZQ.N_RFDZ.ToString(); this.lbdcrf.Text = mo_ZQ.N_RFDC.ToString(); this.lbdzdx.Text = mo_ZQ.N_DXDZ.ToString(); this.lbdcdx.Text = mo_ZQ.N_DXDC.ToString(); this.lbdzdy.Text = mo_ZQ.N_DYDZ.ToString(); this.lbdcdy.Text = mo_ZQ.N_DYDC.ToString(); this.lbdzds.Text = mo_ZQ.N_DSDZ.ToString(); this.lbdcds.Text = mo_ZQ.N_DSDC.ToString(); this.lbdzzdrf.Text = mo_ZQ.N_ZDRFDZ.ToString(); this.lbdczdrf.Text = mo_ZQ.N_ZDRFDC.ToString(); this.lbdzzddx.Text = mo_ZQ.N_ZDDXDZ.ToString(); this.lbdczddx.Text = mo_ZQ.N_ZDDXDC.ToString(); this.lbdzbcrf.Text = mo_ZQ.N_BCRFDZ.ToString(); this.lbdcbcrf.Text = mo_ZQ.N_BCRFDC.ToString(); this.lbdzbcdx.Text = mo_ZQ.N_BCDXDZ.ToString(); this.lbdcbcdx.Text = mo_ZQ.N_BCDXDC.ToString(); this.lbdzbcdy.Text = mo_ZQ.N_BCDYDZ.ToString(); this.lbdcbcdy.Text = mo_ZQ.N_BCDYDC.ToString(); this.lbdzrqs.Text = mo_ZQ.N_RQSDZ.ToString(); this.lbdcrqs.Text = mo_ZQ.N_RQSDC.ToString(); this.lbdzbd.Text = mo_ZQ.N_BDDZ.ToString(); this.lbdcbd.Text = mo_ZQ.N_BDDC.ToString(); this.lbdzbqc.Text = mo_ZQ.N_BQCDZ.ToString(); this.lbdcbqc.Text = mo_ZQ.N_BQCDC.ToString(); this.lbdzgg.Text = mo_ZQ.N_GGDZ.ToString(); this.lbdcgg.Text = mo_ZQ.N_GGDC.ToString(); this.lbdzgj.Text = mo_ZQ.N_GJDZ.ToString(); this.lbdcgj.Text = mo_ZQ.N_GJDC.ToString(); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ABCDXTY.Value / 100), this.drptyabcdx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ABCDYTY.Value / 100), this.drptyabcdy); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ABCRFTY.Value / 100), this.drptyabcrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ABDTY.Value / 100), this.drptyabd); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ABQCTY.Value / 100), this.drptyabqc); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ADSTY.Value / 100), this.drptyads); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ADXTY.Value / 100), this.drptyadx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ADYTY.Value / 100), this.drptyady); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_AGGTY.Value / 100), this.drptyagg); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_AGJTY.Value / 100), this.drptyagj); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ARFTY.Value / 100), this.drptyarf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_ARQSTY.Value / 100), this.drptyarqs); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_AZDDXTY.Value / 100), this.drptyazddx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_AZDRFTY.Value / 100), this.drptyazdrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BBCDXTY.Value / 100), this.drptybbcdx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BBCDYTY.Value / 100), this.drptybbcdy); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BBCRFTY.Value / 100), this.drptybbcrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BBDTY.Value / 100), this.drptybbd); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BBQCTY.Value / 100), this.drptybbqc); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BDSTY.Value / 100), this.drptybds); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BDXTY.Value / 100), this.drptybdx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BDYTY.Value / 100), this.drptybdy); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BGGTY.Value / 100), this.drptybgg); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BGJTY.Value / 100), this.drptybgj); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BRFTY.Value / 100), this.drptybrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BRQSTY.Value / 100), this.drptybrqs); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BZDDXTY.Value / 100), this.drptybzddx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_BZDRFTY.Value / 100), this.drptybzdrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CBCDXTY.Value / 100), this.drptycbcdx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CBCDYTY.Value / 100), this.drptycbcdy); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CBCRFTY.Value / 100), this.drptycbcrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CBDTY.Value / 100), this.drptycbd); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CBQCTY.Value / 100), this.drptycbqc); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CDSTY.Value / 100), this.drptycds); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CDXTY.Value / 100), this.drptycdx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CDYTY.Value / 100), this.drptycdy); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CGGTY.Value / 100), this.drptycgg); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CGJTY.Value / 100), this.drptycgj); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CRFTY.Value / 100), this.drptycrf); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CRQSTY.Value / 100), this.drptycrqs); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CZDDXTY.Value / 100), this.drptyczddx); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_ZQ.N_CZDRFTY.Value / 100), this.drptyczdrf); string s_TYA = "N_ABCDXTY,N_ABCDYTY,N_ABCRFTY,N_ABDTY,N_ABQCTY,N_ADSTY,N_ADXTY,N_ADYTY,N_AGGTY,N_ARFTY,N_ARQSTY,N_AZDDXTY,N_AZDRFTY"; string s_LeastA = this.objAgentManageAddDB.GetLeast("kfb_setupzq", "least", s_TYA, " where n_hyzh='" + GetUser + "'"); string s_TYB = "N_BBCDXTY,N_BBCDYTY,N_BBCRFTY,N_BBDTY,N_BBQCTY,N_BDSTY,N_BDXTY,N_BDYTY,N_BGGTY,N_BRFTY,N_BRQSTY,N_BZDDXTY,N_BZDRFTY"; string s_LeastB = objAgentManageAddDB.GetLeast("kfb_setupzq", "least", s_TYB, " where n_hyzh='" + GetUser + "'"); string s_TYC = "N_CBCDXTY,N_CBCDYTY,N_CBCRFTY,N_CBDTY,N_CBQCTY,N_CDSTY,N_CDXTY,N_CDYTY,N_CGGTY,N_CRFTY,N_CRQSTY,N_CZDDXTY,N_CZDRFTY"; string s_LeastC = objAgentManageAddDB.GetLeast("kfb_setupzq", "least", s_TYC, " where n_hyzh='" + GetUser + "'"); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(s_LeastA) / 100, this.drptyaall); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(s_LeastB) / 100, this.drptyball); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(s_LeastC) / 100, this.drptycall); }
/// <summary> /// 保存按鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { #region "修改足球設定檔" KFB_SETUPZQ mo_zq = new KFB_SETUPZQ(); Hashtable GetSql = new Hashtable(); KFB_ZHGL mo_zhgl = new KFB_ZHGL(); mo_zhgl = objAgentManageDB.GetModel(this.lblName.Text.ToString().Trim()); mo_zq.N_HYZH = this.lblName.Text.ToString().Trim(); mo_zq.N_ARFTY = Convert.ToDecimal(this.drptyarf.Text); mo_zq.N_ADXTY = Convert.ToDecimal(this.drptyadx.Text); mo_zq.N_ADYTY = Convert.ToDecimal(this.drptyady.Text); mo_zq.N_ADSTY = Convert.ToDecimal(this.drptyads.Text); mo_zq.N_AZDRFTY = Convert.ToDecimal(this.drptyazdrf.Text); mo_zq.N_AZDDXTY = Convert.ToDecimal(this.drptyazddx.Text); mo_zq.N_ABCRFTY = Convert.ToDecimal(this.drptyabcrf.Text); mo_zq.N_ABCDXTY = Convert.ToDecimal(this.drptyabcdx.Text); mo_zq.N_ABCDYTY = Convert.ToDecimal(this.drptyabcdy.Text); mo_zq.N_ARQSTY = Convert.ToDecimal(this.drptyarqs.Text); mo_zq.N_ABDTY = Convert.ToDecimal(this.drptyabd.Text); mo_zq.N_ABQCTY = Convert.ToDecimal(this.drptyabqc.Text); mo_zq.N_AGGTY = Convert.ToDecimal(this.drptyagg.Text); mo_zq.N_AGJTY = Convert.ToDecimal(this.drptyagj.Text); mo_zq.N_BRFTY = Convert.ToDecimal(this.drptybrf.Text); mo_zq.N_BDXTY = Convert.ToDecimal(this.drptybdx.Text); mo_zq.N_BDYTY = Convert.ToDecimal(this.drptybdy.Text); mo_zq.N_BDSTY = Convert.ToDecimal(this.drptybds.Text); mo_zq.N_BZDRFTY = Convert.ToDecimal(this.drptybzdrf.Text); mo_zq.N_BZDDXTY = Convert.ToDecimal(this.drptybzddx.Text); mo_zq.N_BBCRFTY = Convert.ToDecimal(this.drptybbcrf.Text); mo_zq.N_BBCDXTY = Convert.ToDecimal(this.drptybbcdx.Text); mo_zq.N_BBCDYTY = Convert.ToDecimal(this.drptybbcdy.Text); mo_zq.N_BRQSTY = Convert.ToDecimal(this.drptybrqs.Text); mo_zq.N_BBDTY = Convert.ToDecimal(this.drptybbd.Text); mo_zq.N_BBQCTY = Convert.ToDecimal(this.drptybbqc.Text); mo_zq.N_BGGTY = Convert.ToDecimal(this.drptybgg.Text); mo_zq.N_BGJTY = Convert.ToDecimal(this.drptybgj.Text); mo_zq.N_CRFTY = Convert.ToDecimal(this.drptycrf.Text); mo_zq.N_CDXTY = Convert.ToDecimal(this.drptycdx.Text); mo_zq.N_CDYTY = Convert.ToDecimal(this.drptycdy.Text); mo_zq.N_CDSTY = Convert.ToDecimal(this.drptycds.Text); mo_zq.N_CZDRFTY = Convert.ToDecimal(this.drptyczdrf.Text); mo_zq.N_CZDDXTY = Convert.ToDecimal(this.drptyczddx.Text); mo_zq.N_CBCRFTY = Convert.ToDecimal(this.drptycbcrf.Text); mo_zq.N_CBCDXTY = Convert.ToDecimal(this.drptycbcdx.Text); mo_zq.N_CBCDYTY = Convert.ToDecimal(this.drptycbcdy.Text); mo_zq.N_CRQSTY = Convert.ToDecimal(this.drptycrqs.Text); mo_zq.N_CBDTY = Convert.ToDecimal(this.drptycbd.Text); mo_zq.N_CBQCTY = Convert.ToDecimal(this.drptycbqc.Text); mo_zq.N_CGGTY = Convert.ToDecimal(this.drptycgg.Text); mo_zq.N_CGJTY = Convert.ToDecimal(this.drptycgj.Text); mo_zq.N_RFDZ = Convert.ToDecimal(this.txtdzrf.Text); mo_zq.N_RFDC = Convert.ToDecimal(this.txtdcrf.Text); mo_zq.N_DXDZ = Convert.ToDecimal(this.txtdzdx.Text); mo_zq.N_DXDC = Convert.ToDecimal(this.txtdcdx.Text); mo_zq.N_DYDZ = Convert.ToDecimal(this.txtdzdy.Text); mo_zq.N_DYDC = Convert.ToDecimal(this.txtdcdy.Text); mo_zq.N_DSDZ = Convert.ToDecimal(this.txtdzds.Text); mo_zq.N_DSDC = Convert.ToDecimal(this.txtdcds.Text); mo_zq.N_ZDRFDZ = Convert.ToDecimal(this.txtdzzdrf.Text); mo_zq.N_ZDRFDC = Convert.ToDecimal(this.txtdczdrf.Text); mo_zq.N_ZDDXDZ = Convert.ToDecimal(this.txtdzzddx.Text); mo_zq.N_ZDDXDC = Convert.ToDecimal(this.txtdczddx.Text); mo_zq.N_BCRFDZ = Convert.ToDecimal(this.txtdzbcrf.Text); mo_zq.N_BCRFDC = Convert.ToDecimal(this.txtdcbcrf.Text); mo_zq.N_BCDXDZ = Convert.ToDecimal(this.txtdzbcdx.Text); mo_zq.N_BCDXDC = Convert.ToDecimal(this.txtdcbcdx.Text); mo_zq.N_BCDYDZ = Convert.ToDecimal(this.txtdzbcdy.Text); mo_zq.N_BCDYDC = Convert.ToDecimal(this.txtdcbcdy.Text); mo_zq.N_RQSDZ = Convert.ToDecimal(this.txtdzrqs.Text); mo_zq.N_RQSDC = Convert.ToDecimal(this.txtdcrqs.Text); mo_zq.N_BDDZ = Convert.ToDecimal(this.txtdzbd.Text); mo_zq.N_BDDC = Convert.ToDecimal(this.txtdcbd.Text); mo_zq.N_BQCDZ = Convert.ToDecimal(this.txtdzbqc.Text); mo_zq.N_BQCDC = Convert.ToDecimal(this.txtdcbqc.Text); mo_zq.N_GGDZ = Convert.ToDecimal(this.txtdzgg.Text); mo_zq.N_GGDC = Convert.ToDecimal(this.txtdcgg.Text); mo_zq.N_GJDZ = Convert.ToDecimal(this.txtdzgj.Text); mo_zq.N_GJDC = Convert.ToDecimal(this.txtdcgj.Text); objAgentManageDB.UpdateZQ(mo_zq, GetSql); objAgentManageDB.Update(GetSql); #endregion #region "修改下綫" string strhidvalue = this.hidvalue.Value; string strZH = ""; string strFlag = ""; DataSet getds = new DataSet(); if (strhidvalue.IndexOf(":") > -1) { //取出所有會員 if (mo_zhgl.N_HYDJ.ToString() != "9") //取得下屬帳號 { getds = objAgentManageDB.GetZH(mo_zhgl.N_HYDJ.ToString(), this.lblName.Text); if (getds.Tables[0].Rows.Count > 0) { for (int i = 0; i < getds.Tables[0].Rows.Count; i++) { strZH = strZH + strFlag + "'" + getds.Tables[0].Rows[i]["n_hyzh"].ToString() + "'"; strFlag = ","; } } } getds = objAgentManageDB.GetHYZH(mo_zhgl.N_HYDJ.ToString(), this.lblName.Text); //取得下屬會員 if (getds.Tables[0].Rows.Count > 0) { for (int i = 0; i < getds.Tables[0].Rows.Count; i++) { strZH = strZH + strFlag + "'" + getds.Tables[0].Rows[i]["n_hyzh"].ToString() + "'"; strFlag = ","; } } if (!strZH.Equals("")) { string[] strarr = strhidvalue.Split(';'); for (int i = 0; i < strarr.Length - 1; i++) { string[] strElement = strarr[i].ToString().Split(':'); string strtable = strElement[0]; string[] strvalue = strElement[1].ToString().Split(','); objAgentManageDB.Update("zq", strvalue[0].ToString(), strvalue[1].ToString(), strZH); } } } #endregion ShowMsg("修改成功!"); } catch (Exception ex) { ShowMsg("修改失敗,請通知管理員!"); } }
/// <summary> /// 查詢帳號本身的設定 /// </summary> public void SetUI() { KFB_SETUPZQ mo_ZQ = this.objAgentManageAddDB.GetModelZQ(this.GetUser); this.txtdzrf.Text = mo_ZQ.N_RFDZ.ToString(); this.txtdcrf.Text = mo_ZQ.N_RFDC.ToString(); this.txtdzdx.Text = mo_ZQ.N_DXDZ.ToString(); this.txtdcdx.Text = mo_ZQ.N_DXDC.ToString(); this.txtdzdy.Text = mo_ZQ.N_DYDZ.ToString(); this.txtdcdy.Text = mo_ZQ.N_DYDC.ToString(); this.txtdzds.Text = mo_ZQ.N_DSDZ.ToString(); this.txtdcds.Text = mo_ZQ.N_DSDC.ToString(); this.txtdzzdrf.Text = mo_ZQ.N_ZDRFDZ.ToString(); this.txtdczdrf.Text = mo_ZQ.N_ZDRFDC.ToString(); this.txtdzzddx.Text = mo_ZQ.N_ZDDXDZ.ToString(); this.txtdczddx.Text = mo_ZQ.N_ZDDXDC.ToString(); this.txtdzbcrf.Text = mo_ZQ.N_BCRFDZ.ToString(); this.txtdcbcrf.Text = mo_ZQ.N_BCRFDC.ToString(); this.txtdzbcdx.Text = mo_ZQ.N_BCDXDZ.ToString(); this.txtdcbcdx.Text = mo_ZQ.N_BCDXDC.ToString(); this.txtdzbcdy.Text = mo_ZQ.N_BCDYDZ.ToString(); this.txtdcbcdy.Text = mo_ZQ.N_BCDYDC.ToString(); this.txtdzrqs.Text = mo_ZQ.N_RQSDZ.ToString(); this.txtdcrqs.Text = mo_ZQ.N_RQSDC.ToString(); this.txtdzbd.Text = mo_ZQ.N_BDDZ.ToString(); this.txtdcbd.Text = mo_ZQ.N_BDDC.ToString(); this.txtdzbqc.Text = mo_ZQ.N_BQCDZ.ToString(); this.txtdcbqc.Text = mo_ZQ.N_BQCDC.ToString(); this.txtdzgg.Text = mo_ZQ.N_GGDZ.ToString(); this.txtdcgg.Text = mo_ZQ.N_GGDC.ToString(); this.txtdzgj.Text = mo_ZQ.N_GJDZ.ToString(); this.txtdcgj.Text = mo_ZQ.N_GJDC.ToString(); KFB_ZHGL mo_zhgl = new KFB_ZHGL(); mo_zhgl = this.objAgentManageDB.GetModel(this.GetUser); if (mo_zhgl == null) { KFB_HYGL mo_hygl = objHYGL.GetModel(this.GetUser); this.ZHFZ(mo_hygl.N_HYZH.ToString(), "10"); this.lblName.Text = mo_hygl.N_HYZH.ToString(); this.lblRealName.Text = mo_hygl.N_HYMC.ToString(); this.lblDJ.Text = "會員"; } else { if (mo_zhgl.N_HYDJ.ToString() != "4") { this.ZHFZ(mo_zhgl.N_HYZH.ToString(), mo_zhgl.N_HYDJ.ToString()); } else { this.DZJFZ(); } this.lblName.Text = mo_zhgl.N_HYZH.ToString(); this.lblRealName.Text = mo_zhgl.N_HYMC.ToString(); this.lblDJ.Text = Comm.GetLvName(mo_zhgl.N_HYDJ.ToString()); GetSUB(mo_zhgl.N_HYDJ.ToString(), mo_zhgl.N_HYZH.ToString()); } this.drptyarf.SelectedValue = mo_ZQ.N_ARFTY.ToString(); this.drptybrf.SelectedValue = mo_ZQ.N_BRFTY.ToString(); this.drptycrf.SelectedValue = mo_ZQ.N_CRFTY.ToString(); this.drptyadx.SelectedValue = mo_ZQ.N_ADXTY.ToString(); this.drptybdx.SelectedValue = mo_ZQ.N_BDXTY.ToString(); this.drptycdx.SelectedValue = mo_ZQ.N_CDXTY.ToString(); this.drptyady.SelectedValue = mo_ZQ.N_ADYTY.ToString(); this.drptybdy.SelectedValue = mo_ZQ.N_BDYTY.ToString(); this.drptycdy.SelectedValue = mo_ZQ.N_CDYTY.ToString(); this.drptyads.SelectedValue = mo_ZQ.N_ADSTY.ToString(); this.drptybds.SelectedValue = mo_ZQ.N_BDSTY.ToString(); this.drptycds.SelectedValue = mo_ZQ.N_CDSTY.ToString(); this.drptyazdrf.SelectedValue = mo_ZQ.N_AZDRFTY.ToString(); this.drptybzdrf.SelectedValue = mo_ZQ.N_BZDRFTY.ToString(); this.drptyczdrf.SelectedValue = mo_ZQ.N_CZDRFTY.ToString(); this.drptyazddx.SelectedValue = mo_ZQ.N_AZDDXTY.ToString(); this.drptybzddx.SelectedValue = mo_ZQ.N_BZDDXTY.ToString(); this.drptyczddx.SelectedValue = mo_ZQ.N_CZDDXTY.ToString(); this.drptyabcrf.SelectedValue = mo_ZQ.N_ABCRFTY.ToString(); this.drptybbcrf.SelectedValue = mo_ZQ.N_BBCRFTY.ToString(); this.drptycbcrf.SelectedValue = mo_ZQ.N_CBCRFTY.ToString(); this.drptyabcdx.SelectedValue = mo_ZQ.N_ABCDXTY.ToString(); this.drptybbcdx.SelectedValue = mo_ZQ.N_BBCDXTY.ToString(); this.drptycbcdx.SelectedValue = mo_ZQ.N_CBCDXTY.ToString(); this.drptyabcdy.SelectedValue = mo_ZQ.N_ABCDYTY.ToString(); this.drptybbcdy.SelectedValue = mo_ZQ.N_BBCDYTY.ToString(); this.drptycbcdy.SelectedValue = mo_ZQ.N_CBCDYTY.ToString(); this.drptyarqs.SelectedValue = mo_ZQ.N_ARQSTY.ToString(); this.drptybrqs.SelectedValue = mo_ZQ.N_BRQSTY.ToString(); this.drptycrqs.SelectedValue = mo_ZQ.N_CRQSTY.ToString(); this.drptyabd.SelectedValue = mo_ZQ.N_ABDTY.ToString(); this.drptybbd.SelectedValue = mo_ZQ.N_BBDTY.ToString(); this.drptycbd.SelectedValue = mo_ZQ.N_CBDTY.ToString(); this.drptyabqc.SelectedValue = mo_ZQ.N_ABQCTY.ToString(); this.drptybbqc.SelectedValue = mo_ZQ.N_BBQCTY.ToString(); this.drptycbqc.SelectedValue = mo_ZQ.N_CBQCTY.ToString(); this.drptyagg.SelectedValue = mo_ZQ.N_AGGTY.ToString(); this.drptybgg.SelectedValue = mo_ZQ.N_BGGTY.ToString(); this.drptycgg.SelectedValue = mo_ZQ.N_CGGTY.ToString(); this.drptyagj.SelectedValue = mo_ZQ.N_AGJTY.ToString(); this.drptybgj.SelectedValue = mo_ZQ.N_BGJTY.ToString(); this.drptycgj.SelectedValue = mo_ZQ.N_CGJTY.ToString(); }