/// <summary> /// 查詢帳號本身的設定 /// </summary> public void SetUI() { KFB_SETUPCP mo_ZQ = this.objAgentManageAddDB.GetModelCP(this.GetUser); this.txtdzbq.Text = mo_ZQ.N_BQDZ.ToString(); this.txtdcbq.Text = mo_ZQ.N_BQDC.ToString(); this.txtdzlq.Text = mo_ZQ.N_LQDZ.ToString(); this.txtdclq.Text = mo_ZQ.N_LQDC.ToString(); this.txtdzzq.Text = mo_ZQ.N_ZQDZ.ToString(); this.txtdczq.Text = mo_ZQ.N_ZQDC.ToString(); this.txtdzgs.Text = mo_ZQ.N_GSDZ.ToString(); this.txtdcgs.Text = mo_ZQ.N_GSDC.ToString(); this.txtdzqz.Text = mo_ZQ.N_QZDZ.ToString(); this.txtdcqz.Text = mo_ZQ.N_QZDC.ToString(); KFB_ZHGL mo_zhgl = new KFB_ZHGL(); mo_zhgl = this.objAgentManageDB.GetModel(this.GetUser); if (mo_zhgl == null) { KFB_HYGL mo_hygl = this.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.drptybq.SelectedValue = mo_ZQ.N_BQTY.ToString(); this.drptylq.SelectedValue = mo_ZQ.N_BQDC.ToString(); this.drptyzq.SelectedValue = mo_ZQ.N_ZQTY.ToString(); this.drptygs.SelectedValue = mo_ZQ.N_GSTY.ToString(); this.drptyqz.SelectedValue = mo_ZQ.N_QZTY.ToString(); }
/// <summary> /// 取得下級的設置 /// </summary> /// <param name="strlvl"></param> /// <param name="strparid"></param> public void GetSUB(string strlvl, string strparid) { string strSpName = "(" + Comm.GetLvSName(Convert.ToString(Convert.ToDecimal(strlvl) + 1)) + ")"; KFB_SETUPCP mo_lq = this.objAgentManageAddDB.GetModelCP(strlvl, strparid); this.lbtybqt.Text = mo_lq.N_BQTY.ToString(); this.lbdzbqt.Text = mo_lq.N_BQDZ.ToString(); this.lbdcbqt.Text = mo_lq.N_BQDC.ToString(); this.lbtylqt.Text = mo_lq.N_LQTY.ToString(); this.lbdzlqt.Text = mo_lq.N_LQDZ.ToString(); this.lbdclqt.Text = mo_lq.N_LQDC.ToString(); this.lbtyzqt.Text = mo_lq.N_ZQTY.ToString(); this.lbdzzqt.Text = mo_lq.N_ZQDZ.ToString(); this.lbdczqt.Text = mo_lq.N_ZQDC.ToString(); this.lbtygst.Text = mo_lq.N_GSTY.ToString(); this.lbdzgst.Text = mo_lq.N_GSDZ.ToString(); this.lbdcgst.Text = mo_lq.N_GSDC.ToString(); this.lbtyqzt.Text = mo_lq.N_QZTY.ToString(); this.lbdzqzt.Text = mo_lq.N_QZDZ.ToString(); this.lbdcqzt.Text = mo_lq.N_QZDC.ToString(); }
/// <summary> /// 上級帳號上層賦值 /// </summary> public void ZHFZ(string strparid, string strlvl) { string strzh = ""; if (strlvl == "10") { KFB_HYGL mo_hygl = this.objHYGL.GetModel(strparid); strzh = mo_hygl.N_DLDH; } else { strzh = Comm.GetUPID(strparid, strlvl); } KFB_SETUPCP mo_lq = this.objAgentManageAddDB.GetModelCP(strzh); this.lbdzbq.Text = mo_lq.N_BQDZ.ToString(); this.lbdcbq.Text = mo_lq.N_BQDC.ToString(); this.lbdzlq.Text = mo_lq.N_LQDZ.ToString(); this.lbdclq.Text = mo_lq.N_LQDC.ToString(); this.lbdzzq.Text = mo_lq.N_ZQDZ.ToString(); this.lbdczq.Text = mo_lq.N_ZQDC.ToString(); this.lbdzgs.Text = mo_lq.N_GSDZ.ToString(); this.lbdcgs.Text = mo_lq.N_GSDC.ToString(); this.lbdzqz.Text = mo_lq.N_QZDZ.ToString(); this.lbdcqz.Text = mo_lq.N_QZDC.ToString(); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_lq.N_BQTY.Value / 100), this.drptybq); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_lq.N_LQTY.Value / 100), this.drptylq); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_lq.N_ZQTY.Value / 100), this.drptyzq); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_lq.N_GSTY.Value / 100), this.drptygs); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(mo_lq.N_QZTY.Value / 100), this.drptyqz); string s_TYA = "N_BQTY,N_LQTY,N_ZQTY,N_GSTY,N_QZTY"; string s_LeastA = this.objAgentManageAddDB.GetLeast("kfb_setupcp", "least", s_TYA, " where n_hydh='" + GetUser + "'"); Comm.SetTS(Comm.Fcjg, Convert.ToDouble(s_LeastA) / 100, this.drptyall); }
/// <summary> /// 保存按鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { #region "修改運彩設定檔" KFB_SETUPCP mo_cp = new KFB_SETUPCP(); Hashtable GetSql = new Hashtable(); KFB_ZHGL mo_zhgl = new KFB_ZHGL(); mo_zhgl = this.objAgentManageDB.GetModel(this.lblName.Text.ToString().Trim()); mo_cp.N_HYDH = this.lblName.Text; mo_cp.N_BQTY = Convert.ToDecimal(this.drptybq.Text); mo_cp.N_BQDZ = Convert.ToDecimal(this.txtdzbq.Text); mo_cp.N_BQDC = Convert.ToDecimal(this.txtdcbq.Text); mo_cp.N_LQTY = Convert.ToDecimal(this.drptylq.Text); mo_cp.N_LQDZ = Convert.ToDecimal(this.txtdzlq.Text); mo_cp.N_LQDC = Convert.ToDecimal(this.txtdclq.Text); mo_cp.N_ZQTY = Convert.ToDecimal(this.drptyzq.Text); mo_cp.N_ZQDZ = Convert.ToDecimal(this.txtdzzq.Text); mo_cp.N_ZQDC = Convert.ToDecimal(this.txtdczq.Text); mo_cp.N_GSTY = Convert.ToDecimal(this.drptygs.Text); mo_cp.N_GSDZ = Convert.ToDecimal(this.txtdzgs.Text); mo_cp.N_GSDC = Convert.ToDecimal(this.txtdcgs.Text); mo_cp.N_QZTY = Convert.ToDecimal(this.drptyqz.Text); mo_cp.N_QZDZ = Convert.ToDecimal(this.txtdzqz.Text); mo_cp.N_QZDC = Convert.ToDecimal(this.txtdcqz.Text); this.objAgentManageDB.UpdateCP(mo_cp, 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("cp", strvalue[0].ToString(), strvalue[1].ToString(), strZH); } } } #endregion this.ShowMsg("修改成功!"); } catch (Exception ex) { this.ShowMsg("修改失敗,請通知管理員!"); } }