public void DataBindLink() { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID); if (Dis != null) { if (!string.IsNullOrEmpty(Dis.pic)) { string[] files = Dis.pic.Split(new char[] { ',' }); foreach (string file in files) { if (!string.IsNullOrEmpty(file)) { LinkButton linkFile = new LinkButton(); linkFile.Click += new EventHandler(Download_Click); if (file.LastIndexOf("_") != -1) { string text = file.Substring(0, file.LastIndexOf("_")) + Path.GetExtension(file); linkFile.Text = text; } else { string text = file.Substring(0, file.LastIndexOf("-")) + Path.GetExtension(file); linkFile.Text = text; } linkFile.Style.Add("margin-right", "15px"); linkFile.Style.Add("text-decoration", "underline"); linkFile.Attributes.Add("fileName", file); DFile.Controls.Add(linkFile); } } } } }
/// <summary> /// 验证代理商名字是否重复 /// </summary> /// <param name="name"></param> /// <param name="value"></param> /// <param name="str"></param> /// <param name="index"></param> /// <param name="Tran"></param> /// <returns></returns> public string DisExistsAttribute(string name, string value, string str, DataRow dr, DataTable dt) { if (string.IsNullOrEmpty(value)) { return(value); } List <Hi.Model.BD_Distributor> Dis = new Hi.BLL.BD_Distributor().GetList("", " " + name + "='" + value + "' and CompID=" + CompID + " and isnull(dr,0)=0 ", ""); if (Dis.Count > 0) { dr["chkstr"] = value + str + "已存在"; // Eroor = true; // TitleError += "Excel行号为: <i error>" + (index + TitleIndex + 1) + "</i> 的数据有误。" + str + "已存在,请修改后重新导入。<br/>"; //throw new ApplicationException(""); } else { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["disname"].ToString() == value.Trim()) { dr["chkstr"] = value + str + "Excel已存在"; return(value); } } } return(value); }
public string DelType(string id) { string json = string.Empty; if (!string.IsNullOrEmpty(id)) { List <Hi.Model.BD_DisType> List = new Hi.BLL.BD_DisType().GetList(null, " CompID=" + CompID + " and isnull(dr,0)=0 and ParentId=" + id, null); if (List.Count > 0) { return("{\"result\":false,\"code\":\"此类别下还有子级类别,请先删除子级类别!\"}"); } List <Hi.Model.BD_Distributor> Dis = new Hi.BLL.BD_Distributor().GetList(null, " CompID=" + CompID + " and isnull(dr,0)=0 and DisTypeID=" + id, null); if (Dis.Count > 0) { return("{\"result\":false,\"code\":\"此分类已被使用,不允许删除!\"}"); } List <Hi.Model.BD_DisPrice> disp = new Hi.BLL.BD_DisPrice().GetList(null, " CompID=" + CompID + " and type=" + 1 + " and( One=" + id + " or two=" + id + " or three=" + id + ") and dr=0", null); if (disp.Count > 0) { return("{\"result\":false,\"code\":\"此区域下有代理商价格,不允许删除!\"}"); } Hi.Model.BD_DisType type = new Hi.BLL.BD_DisType().GetModel(id.ToInt(0)); type.dr = 1; type.ts = DateTime.Now; type.modifyuser = UserID; if (new Hi.BLL.BD_DisType().Update(type)) { return("{\"result\":true,\"code\":\"操作成功\"}"); } } return(json); }
public void DataBinds() { int pageCount = 0; int Counts = 0; if (this.txtPageSize.Value.ToString() != "") { if (this.txtPageSize.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPageSize.Value = "100"; } else { Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0); } } //List<Hi.Model.BD_Distributor> LUser = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", false, SearchWhere(), out pageCount, out Counts); const string joinTableStr = " BD_Distributor A left join SYS_CompUser cu on A.ID=cu.DisID"; DataTable LUser = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "A.Createdate", true, string.Join(",", typeof(Hi.Model.BD_Distributor).GetProperties().Select(p => "A." + p.Name)), joinTableStr, SearchWhere(), out pageCount, out Counts); this.Rpt_Distribute.DataSource = LUser; this.Rpt_Distribute.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); //this.Org.SelectedValue = this.OrgID == 0 ? Org.SelectedValue : this.OrgID.ToString(); }
protected void btnDelete_Click(object sender, EventArgs e) { List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList("", " Compid=" + CompID + "", ""); foreach (Hi.Model.BD_Distributor model in dis) { new Hi.BLL.BD_Distributor().Delete(model.ID); List <Hi.Model.BD_DisAddr> Daddr = new Hi.BLL.BD_DisAddr().GetList("", " disid='" + model.ID + "'", ""); foreach (Hi.Model.BD_DisAddr mo in Daddr) { new Hi.BLL.BD_DisAddr().Delete(mo.ID); } List <Hi.Model.SYS_Users> user = new Hi.BLL.SYS_Users().GetList("", " disid='" + model.ID + "' and type=5", ""); foreach (Hi.Model.SYS_Users mo in user) { new Hi.BLL.SYS_Users().Delete(mo.ID); } } List <Hi.Model.BD_DisType> Dtype = new Hi.BLL.BD_DisType().GetList("", " Compid=" + CompID + "", ""); foreach (Hi.Model.BD_DisType model in Dtype) { new Hi.BLL.BD_DisType().Delete(model.ID); } }
//修改支付密码 protected void A_Save(object sender, EventArgs e) { if (paypwd1.Value == "123456") { ClientScript.RegisterStartupScript(GetType(), "", "<script>layerCommon.alert('新支付密码不能为默认密码', IconOption.错误);</script>"); return; } if (paypwd1.Value == paypwd2.Value) { Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); dis.Paypwd = Util.md5(paypwd1.Value); dis.ts = DateTime.Now; dis.modifyuser = this.UserID; if (new Hi.BLL.BD_Distributor().Update(dis)) { spanpaypwd.Attributes.CssStyle.Value = "display:none;"; ClientScript.RegisterStartupScript(GetType(), "", "<script>layerCommon.alert('恭喜您,您的支付密码已经修改成功!', IconOption.笑脸);</script>"); divpaypwd.Attributes.Add("style", "display:none"); zzc.Attributes.Add("style", "display:none"); return; } else { spanpaypwd.Attributes.CssStyle.Value = "display:inline-block;color:Red;"; spanpaypwd.InnerText = "修改失败请重试!"; return; } } else { spanpaypwd.Attributes.CssStyle.Value = "display:inline-block;color:Red;"; spanpaypwd.InnerText = "两次输入的密码不一致!"; return; } }
/// <summary> /// 转账汇款审核 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSh_Click(object sender, EventArgs e) { string shId = this.hidShId.Value; //调用model,对属性进行赋值 Hi.Model.PAY_PrePayment shModel = new Hi.BLL.PAY_PrePayment().GetModel(Convert.ToInt32(shId)); shModel.AuditState = 2; //调用修改方法 Hi.BLL.PAY_PrePayment shUpdate = new Hi.BLL.PAY_PrePayment(); bool shUp = shUpdate.Update(shModel); if (shUp == bool.Parse("true")) { int hidShIds = shModel.DisID; Hi.BLL.PAY_PrePayment prePayModel = new Hi.BLL.PAY_PrePayment(); //sum代理商全部录入,冲正以及审核通过的转账汇款金额 decimal sums = prePayModel.sums(hidShIds, shModel.CompID); //修改代理商的企业钱包金额 //调用model,对属性进行赋值 Hi.Model.BD_Distributor disSumModel = new Hi.BLL.BD_Distributor().GetModel(Convert.ToInt32(hidShIds)); disSumModel.DisAccount = sums; disSumModel.ID = shModel.ID; //调用修改方法 Hi.BLL.BD_Distributor disupdate = new Hi.BLL.BD_Distributor(); bool disup = disupdate.Update(disSumModel); if (disup) { JScript.AlertMethod(this, "审核成功", JScript.IconOption.笑脸, "function (){ location.replace('" + ("PayExamineList.aspx") + "'); }"); } } }
/// <summary> /// 代理商列表显示 /// </summary> public void Bind() { //查询代理商 int pageCount = 0; int Counts = 0; string strwhere = string.Empty; if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } if (this.txtPager.Value.Trim().ToString() != "") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "shortindex", true, strwhere, out pageCount, out Counts); this.rptDis.DataSource = dis; this.rptDis.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
protected void AddMessAge(object sender, EventArgs e) { Hi.Model.DIS_Suggest suggest = new Hi.Model.DIS_Suggest(); Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(DisID); if (dis != null) { suggest.Title = Common.NoHTML(txtTitle.Value); suggest.DisUserID = this.UserID; suggest.Remark = Common.NoHTML(txtRemark.Value); suggest.CreateDate = DateTime.Now; suggest.CompID = this.CompID; suggest.Stype = 0; suggest.DisID = this.DisID; suggest.IsAnswer = 0; suggest.ts = DateTime.Now; suggest.dr = 0; suggest.modifyuser = this.UserID; if (new Hi.BLL.DIS_Suggest().Add(suggest) > 0) { Response.Redirect("MessAgeList.aspx"); } else { JScript.AlertMsgOne(this, "添加失败!", JScript.IconOption.错误); } } }
protected void Page_Load(object sender, EventArgs e) { hidCompId.Value = CompID.ToString(); if (!IsPostBack) { DataBinds(); if (KeyID != 0) { List <Hi.Model.BD_Distributor> Ldis = new Hi.BLL.BD_Distributor().GetList("", "auditstate=2 and isnull(IsEnabled,0)=1 and isnull(dr,0)=0 and SMID = " + KeyID + " and CompID=" + CompID, ""); if (Ldis.Count > 0) { tbdis.Attributes["style"] = "display:block;"; } else { tbdis.Attributes["style"] = "display:none;"; } Rpt_Dis.DataSource = Ldis; Rpt_Dis.DataBind(); for (int i = 0; i < Ldis.Count; i++) { hidselectDis.Value += Ldis[i].ID + ","; } hidselectDis.Value = hidselectDis.Value.TrimEnd(','); } } }
public void DataBinds() { int pageCount = 0; int Counts = 0; if (this.txtPageSize.Value.ToString() != "") { if (this.txtPageSize.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPageSize.Value = "100"; } else { Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0); } } // List<Hi.Model.BD_Distributor> LDis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", false, SearchWhere()+date, out pageCount, out Counts); DataTable LDis = new Hi.BLL.BD_Distributor().getDataTable(Pager.PageSize, Pager.CurrentPageIndex, SearchWhere() + date, out pageCount, out Counts, Pager.RecordCount); this.Rpt_Distribute.DataSource = LDis; this.Rpt_Distribute.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
protected void btn_NUse(object sender, EventArgs e) { Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(KeyID); comp.IsEnabled = 0; comp.ts = DateTime.Now; comp.modifyuser = UserID; if (new Hi.BLL.BD_Company().Update(comp)) { //List<Hi.Model.SYS_Users> user = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and compid=" + KeyID + "", ""); //foreach (Hi.Model.SYS_Users model1 in user) //{ // model1.IsEnabled = 0; // model1.ts = DateTime.Now; // model1.modifyuser = UserID; // new Hi.BLL.SYS_Users().Update(model1); //} List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList("", " isnull(dr,0)=0 and compid=" + KeyID + "", ""); foreach (Hi.Model.BD_Distributor model2 in dis) { model2.IsEnabled = 0; model2.ts = DateTime.Now; model2.modifyuser = UserID; new Hi.BLL.BD_Distributor().Update(model2); } JScript.AlertMsgMo(this, "用户禁用成功", "function(){ window.location.href='CompList.aspx'; }"); } }
protected void btn_Use(object sender, EventArgs e) { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID); if (Dis != null) { List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and DisID=" + KeyID + " and Utype in (1,5) and Ctype=2 and CompID=" + this.CompID, ""); foreach (Hi.Model.SYS_CompUser model in luser) { model.IsEnabled = 1; model.ts = DateTime.Now; model.modifyuser = Common.UserID(); new Hi.BLL.SYS_CompUser().Update(model); } if (Request["nextstep"] + "" == "1") { Response.Redirect("DisList.aspx?nextstep=1"); } else { Response.Redirect("DisInfo.aspx?KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey) + "&type=2"); } } }
public void DataBinds() { List <Hi.Model.BD_Distributor> LDis = new Hi.BLL.BD_Distributor().GetList("", SearchWhere(), "Createdate desc"); this.Rpt_Dis.DataSource = LDis; this.Rpt_Dis.DataBind(); ClientScript.RegisterStartupScript(this.GetType(), "", "<script>$(function(){ $(\"#CB_SelAll\").trigger(\"click\");})</script>"); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { SqlTransaction Tran = null; try { Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); object disId = Request["disId"]; //代理商id object goodsId = Request["goodsId"]; //商品Id if (disId != null && goodsId != null) { for (int i = 0; i < disId.ToString().Split(',').Length; i++) { for (int z = 0; z < goodsId.ToString().Split(',').Length; z++) { List <Hi.Model.BD_GoodsAreas> l = new Hi.BLL.BD_GoodsAreas().GetList("", "isnull(dr,0)=0 and compId=" + this.CompID + " and disId=" + disId.ToString().Split(',')[i] + " and goodsId=" + goodsId.ToString().Split(',')[z], "", Tran); if (l.Count == 0) { Hi.Model.BD_GoodsAreas model = new Hi.Model.BD_GoodsAreas(); Hi.Model.BD_Distributor model2 = new Hi.BLL.BD_Distributor().GetModel(Convert.ToInt32(disId.ToString().Split(',')[i]), Tran); Hi.Model.BD_Goods model3 = new Hi.BLL.BD_Goods().GetModel(Convert.ToInt32(goodsId.ToString().Split(',')[z]), Tran); model.CompID = this.CompID; model.areaID = model2.AreaID; model.GoodsID = Convert.ToInt32(goodsId.ToString().Split(',')[z]); model.CategoryID = model3.CategoryID; model.ts = DateTime.Now; model.dr = 0; model.modifyuser = this.UserID; model.DisID = Convert.ToInt32(disId.ToString().Split(',')[i]); new Hi.BLL.BD_GoodsAreas().Add(model, Tran); } else { continue; } } } } Tran.Commit(); Response.Redirect("GoodsAreaList.aspx"); } catch (Exception ex) { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } } JScript.AlertMethod(this, "保存失败了", JScript.IconOption.错误, "function(){location.href='GoodsAreaList.aspx';}"); return; } finally { DBUtility.SqlHelper.ConnectionClose(); } }
protected void btn_Del(object sender, EventArgs e) { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID); if (Dis != null) { //if (Dis.AuditState == 2 && Dis.IsEnabled == 1) //{ // JScript.AlertMsgOne(this, "已审核未被禁用的代理商不允许删除!", JScript.IconOption.错误); // return; //} //Dis.dr = 1; //Dis.ts = DateTime.Now; //Dis.modifyuser = Common.UserID(); List <int> ListUserid = new List <int>(); List <int> ListDelUserid = new List <int>(); List <Hi.Model.SYS_CompUser> luser = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and DisID=" + KeyID + " and Utype in (1,5) and Ctype=2 and CompID=" + this.CompID, ""); foreach (Hi.Model.SYS_CompUser model in luser) { if (model.IsAudit == 2 && model.IsEnabled == 1) { JScript.AlertMsgOne(this, "已审核未被禁用的代理商不允许删除!", JScript.IconOption.错误); return; } if (!ListUserid.Contains(model.UserID)) { List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("id", " dr=0 and Userid=" + model.UserID + " and CompID=" + this.CompID, ""); if (ListCompUser.Count == 1) { ListDelUserid.Add(model.UserID); } ListUserid.Add(model.UserID); } model.dr = 1; model.ts = DateTime.Now; model.modifyuser = Common.UserID(); new Hi.BLL.SYS_CompUser().Update(model); } if (ListDelUserid.Count > 0) { List <Hi.Model.SYS_Users> ListUsers = new Hi.BLL.SYS_Users().GetList("", " dr=0 and id in(" + string.Join(",", ListDelUserid) + ")", ""); foreach (Hi.Model.SYS_Users model in ListUsers) { model.dr = 1; model.ts = DateTime.Now; model.modifyuser = Common.UserID(); new Hi.BLL.SYS_Users().Update(model); } } //string Phone = Common.GetDis(Dis.ID, "Phone"); //string msg = "您所注册的代理商:" + Dis.DisName + "已注销![ " + Common.GetCompValue(CompID, "CompName") + " ]"; //Common.GetPhone(Phone, msg); JScript.AlertMethod(this, "删除成功!", JScript.IconOption.错误, "function(){ window.location.href='DisList.aspx'; }"); } }
public void DataBindLink() { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); if (Dis != null) { if (!string.IsNullOrEmpty(Dis.pic)) { string[] files = Dis.pic.Split(new char[] { ',' }); foreach (string file in files) { if (!string.IsNullOrEmpty(file)) { LinkButton linkFile = new LinkButton(); linkFile.Click += new EventHandler(Download_Click); if (file.LastIndexOf("_") != -1) { string text = file.Substring(0, file.LastIndexOf("_")) + Path.GetExtension(file); if (text.Length < 15) { linkFile.Text = text; } else { linkFile.Text = text.Substring(0, 15) + "..."; } linkFile.Attributes.Add("title", text); } else { string text = file.Substring(0, file.LastIndexOf("-")) + Path.GetExtension(file); if (text.Length < 15) { linkFile.Text = text; } else { linkFile.Text = text.Substring(0, 15) + "..."; } linkFile.Attributes.Add("title", text); } linkFile.Style.Add("margin-right", "5px"); linkFile.Style.Add("text-decoration", "underline"); linkFile.Attributes.Add("fileName", file); HtmlGenericControl div = new HtmlGenericControl("div"); div.Controls.Add(linkFile); //HtmlImage img = new HtmlImage(); //img.Src = "../images/icon_del.png"; //img.Attributes.Add("title", "删除附件"); //img.Attributes.Add("onclick", "ConFirmDelteAnnex(this,'Dis'," + this.DisID + ",'" + file + "')"); //div.Controls.Add(img); DFile.Controls.Add(div); } } } } }
public void Bind(string Id) { Hi.Model.BD_Distributor disModel = new Hi.BLL.BD_Distributor().GetModel(Id.ToInt(0)); if (disModel != null) { this.txtuserphone.Value = Phone; this.txtusername.Value = disModel.Principal; } }
protected void btn_Save1(object sender, EventArgs e) { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); if (Dis != null) { if (Common.DisExistsAttribute("DisName", txtDisName.Value.Trim(), this.CompID.ToString(), this.DisID.ToString())) { JScript.AlertMsgOne(this, "代理商已存在!", JScript.IconOption.错误, 2500); return; } Dis.Province = Common.NoHTML(hidProvince.Value.Trim()); Dis.City = Common.NoHTML(hidCity.Value.Trim()); Dis.Area = Common.NoHTML(hidArea.Value.Trim()); Dis.DisName = Common.NoHTML(txtDisName.Value.Trim()); Dis.Licence = Common.NoHTML(txtLicence.Value.Trim()); Dis.Tel = Common.NoHTML(txtTel.Value.Trim()); Dis.Principal = Common.NoHTML(txtname.Value); Dis.Phone = Common.NoHTML(txtnamephone.Value); Dis.Zip = Common.NoHTML(txtZip.Value.Trim()); Dis.Fax = Common.NoHTML(txtFax.Value.Trim()); Dis.Address = Common.NoHTML(txtAddress.Value.Trim()); Dis.Leading = Common.NoHTML(txtLeading.Value.Trim()); Dis.LeadingPhone = Common.NoHTML(txtLeadingPhone.Value.Trim()); if (!string.IsNullOrEmpty(HidFfileName.Value)) { if (Dis.pic == "") { Dis.pic = Common.NoHTML(HidFfileName.Value); } else { Dis.pic += "," + Common.NoHTML(HidFfileName.Value); } } Dis.ts = DateTime.Now; Dis.modifyuser = this.UserID; if (new Hi.BLL.BD_Distributor().Update(Dis)) { List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("UserID", " isnull(dr,0)=0 and disId='" + this.DisID + "' and utype=5", ""); if (user2.Count > 0) { Hi.Model.SYS_Users u = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID); if (u != null) { u.ts = DateTime.Now; u.modifyuser = this.UserID; u.TrueName = Common.NoHTML(txtUserTrueName.Value); new Hi.BLL.SYS_Users().Update(u); } } Response.Redirect("PhoneEdit.aspx?type=hf"); } } }
public void DisDataBind() { int pageCount = 0; int Counts = 0; List <Hi.Model.BD_Distributor> LDis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", false, " and isnull(dr,0)=0 and CompID=" + KeyID + "", out pageCount, out Counts); this.Rpt_Distribute.DataSource = LDis; this.Rpt_Distribute.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
public void Databind() { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID); if (Dis != null) { hidProvince.Value = Dis.Province; hidCity.Value = Dis.City; hidArea.Value = Dis.Area; txtDisName.Value = Dis.DisName; txtLicence.Value = Dis.Licence; txtTel.Value = Dis.Tel; txtname.Value = Dis.Principal; txtnamephone.Value = Dis.Phone; txtZip.Value = Dis.Zip; txtFax.Value = Dis.Fax; txtAddress.Value = Dis.Address; txtLeading.Value = Dis.Leading; txtLeadingPhone.Value = Dis.LeadingPhone; List <Hi.Model.SYS_CompUser> user2 = new Hi.BLL.SYS_CompUser().GetList("", " isnull(dr,0)=0 and disId='" + this.DisID + "' and utype=5", ""); if (user2.Count > 0) { Hi.Model.SYS_Users u = new Hi.BLL.SYS_Users().GetModel(user2[0].UserID); if (u != null) { //List<Hi.Model.SYS_Users> u = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and DisID='" + this.DisID + "' and type=5", ""); //if (u.Count > 0) //{ txtUsername.Disabled = true; txtUserPhone.Disabled = true; txtUsername.Value = u.UserName; txtUserPhone.Value = u.Phone; txtUserTrueName.Value = u.TrueName; } } else { List <Hi.Model.SYS_Users> users = new Hi.BLL.SYS_Users().GetList("", " DisID='" + this.DisID + "'", ""); if (users.Count > 0) { //List<Hi.Model.SYS_Users> u = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and DisID='" + this.DisID + "' and type=5", ""); //if (u.Count > 0) //{ txtUsername.Disabled = true; txtUserPhone.Disabled = true; txtUsername.Value = users[0].UserName; txtUserPhone.Value = users[0].Phone; txtUserTrueName.Value = users[0].TrueName; } } } }
protected void btn_NUse(object sender, EventArgs e) { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID); string sql = "select * from SYS_CompUser where ISNULL(dr,0)=0 and DisID=" + KeyID; DataTable userDT = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; if (userDT.Rows.Count > 0) { SqlTransaction Tran = null; try { Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); for (int i = 0; i < userDT.Rows.Count; i++) { Hi.Model.SYS_CompUser user = new Hi.BLL.SYS_CompUser().GetModel(Convert.ToInt32(userDT.Rows[i]["ID"].ToString())); user.IsEnabled = 0; user.ts = DateTime.Now; user.modifyuser = UserID; new Hi.BLL.SYS_CompUser().Update(user, Tran); } Tran.Commit(); } catch { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } JScript.AlertMethod(this, "操作失败!", JScript.IconOption.错误, "function(){ window.location.href=window.location.href; }"); } } } if (Dis != null) { Dis.IsEnabled = 0; Dis.ts = DateTime.Now; Dis.modifyuser = UserID; if (new Hi.BLL.BD_Distributor().Update(Dis)) { if (Request["nextstep"] + "" == "1") { Response.Redirect("DisList.aspx?nextstep=1"); } else { Response.Redirect("DisInfo.aspx?KeyID=" + KeyID.ToString() + "&type=2"); } } } }
/// <summary> /// 数据绑定 /// </summary> public void DataBinds() { int pageCount = 0; int Counts = 0; //List<Hi.Model.BD_Distributor> LDis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", false, SearchWhere(), out pageCount, out Counts); DataTable LDis = new Hi.BLL.BD_Distributor().getDataTable(Pager.PageSize, Pager.CurrentPageIndex, SearchWhere(), out pageCount, out Counts, Pager.RecordCount); this.Rpt_Distribute.DataSource = LDis; this.Rpt_Distribute.DataBind(); Pager.RecordCount = LDis.Rows.Count; page = Pager.CurrentPageIndex.ToString(); }
public int Fanli = 0; //是否启用返利 protected void Page_Load(object sender, EventArgs e) { object obj = Request["action"]; if (obj != null) { if (obj.ToString() == "dislist") { string compid = Request["compId"] + ""; string disid = Request["disId"] + ""; Response.Write(disBing(compid, disid)); Response.End(); } } if (!IsPostBack) { DataTable dt = Common.BindDisList(this.CompID.ToString());//代理商绑定 if (dt != null) { this.rptDisList.DataSource = dt; this.rptDisList.DataBind(); } this.hidType2.Value = Request.QueryString["type"] + "";//2 再次购买 this.hidKeyId.Value = KeyID.ToString(); this.hidCompId.Value = this.CompID.ToString(); Fanli = OrderInfoType.rdoOrderAudit("订单支付返利是否启用", CompID).ToInt(0); this.hidFanl.Value = Fanli.ToString(); //是否启用返利 IsInve = OrderInfoType.rdoOrderAudit("商品是否启用库存", CompID).ToInt(0); //是否启用库存 //代理商列表 List <Hi.Model.BD_Distributor> list = new Hi.BLL.BD_Distributor().GetList("ID,DisName", "isnull(dr,0)=0 and compid=" + this.CompID, ""); this.divDisList.InnerText = ConvertJson.ToJson(Common.FillDataTable(list)); if (KeyID != 0) { if (Request.QueryString["type"] + "" != "2") { Hi.Model.DIS_Order model = new Hi.BLL.DIS_Order().GetModel(KeyID); //判断订单是否可以修改 企业下单订单已审未支付,代理商下单企业不能修改 if (model.OState > (int)Enums.OrderState.待审核) { JScript.AlertAndRedirect("订单已被其他人修改,请刷新后再重新操作!", "orderdetail.aspx?top=1&KeyID=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey)); return; } } else { this.hidType.Value = Request.QueryString["type"] + ""; } Bind(); } } }
/// <summary> /// 代理商列表显示 /// </summary> public void Bind() { //查询代理商 int pageCount = 0; int Counts = 0; string strwhere = string.Empty; string IDlist = string.Empty;//销售经理下属 员工ID集合 if (DisSalesManID != 0) { if (Common.GetDisSalesManType(DisSalesManID.ToString(), out IDlist)) { //销售经理 strwhere = "and ID in(select ID from BD_Distributor where smid in(" + IDlist + "))"; } else { strwhere = "and ID in(select ID from BD_Distributor where smid = " + DisSalesManID + ")"; } } strwhere += " and dr=0 and AuditState=2 and CompID =" + CompID; if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } if (this.txtPager.Value.Trim().ToString() != "") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "shortindex", true, strwhere, out pageCount, out Counts); this.rptDis.DataSource = dis; this.rptDis.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
public void DataBinds() { txtDisAreaBox.CompID = Compid; txtDisType.CompID = Compid; int pageCount = 0; int Counts = 0; List <Hi.Model.BD_Distributor> LDis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", false, SearchWhere(), out pageCount, out Counts); this.Rpt_Dis.DataSource = LDis; this.Rpt_Dis.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
public void DataBinds() { if (KeyID != 0) { Hi.Model.BD_Distributor Dis = new Hi.BLL.BD_Distributor().GetModel(KeyID); if (Dis != null) { lblDisName.InnerText = Dis.DisName; //lblTyoeName.InnerText = Common.GetDisTypeNameById(Dis.DisTypeID); //lblAreaName.InnerText = Common.GetDisAreaNameById(Dis.AreaID); //lblDisLevel.InnerText = Dis.DisLevel; lblLeading.InnerText = Dis.Leading; lblLeadingPhone.InnerText = Dis.LeadingPhone; lblFax.InnerText = Dis.Fax; lblTel.InnerText = Dis.Tel; lblLicence.InnerText = Dis.Licence; lblPerson.InnerText = Dis.Principal; lblPhone.InnerText = Dis.Phone; lblAddress.InnerText = Dis.Address; lblZip.InnerText = Dis.Zip; lblRemark.InnerText = Dis.Remark; lblIsEnabled.InnerHtml = Dis.IsEnabled == 1 ? "启用" : "<i style='color:red;'>禁用</i>"; if (Dis.IsEnabled == 1) { libtnNUse.Visible = true; libtnUse.Visible = false; } else { libtnUse.Visible = true; libtnNUse.Visible = false; } //rdAuditYes.InnerHtml = Dis.IsCheck == 1 ? "是" : "<i style='color:red;'>否</i>"; //rdCreditYes.InnerHtml = Dis.CreditType == 0 ? "<i style='color:red;'>否</i>" : "是"; } else { JScript.AlertMsg(this, "代理商不存在!"); return; } } else { JScript.AlertMsg(this, "数据错误!"); return; } }
/// <summary> /// 根据区域id得到代理商 /// </summary> /// <param name="id"></param> /// <returns></returns> public string GetDisList(string areaId) { string aredIdList = Common.DisAreaId(Convert.ToInt32(areaId), this.CompID);//递归得到区域id List <Hi.Model.BD_Distributor> ll = new Hi.BLL.BD_Distributor().GetList("ID,DisName", "isnull(dr,0)=0 and compId=" + this.CompID + " and areaId in(" + aredIdList + ")", ""); if (ll.Count > 0) { DataTable dt2 = Common.FillDataTable <Hi.Model.BD_Distributor>(ll); if (dt2.Rows.Count != 0) { return(ConvertJson.ToJson(dt2)); } } return("[{}]"); }
/// <summary> /// 查询代理商 /// </summary> public void GetDis(int Id) { List <Hi.Model.BD_Distributor> li = new Hi.BLL.BD_Distributor().GetList("", " CompID=" + Id + "and isnull(AuditState,0)=2 and isnull(IsEnabled,0)=1 and isnull(dr,0)=0", "Id desc"); if (li != null) { if (li.Count > 0) { foreach (Hi.Model.BD_Distributor item in li) { Dislist.Add(item); } } } }
protected void Btn_Dis(object sender, EventArgs e) { List <Hi.Model.BD_Distributor> Ldis = new Hi.BLL.BD_Distributor().GetList("", "isnull(dr,0)=0 and id in (" + hidselectDis.Value + ")", ""); if (Ldis.Count > 0) { tbdis.Attributes["style"] = "display:block;"; } else { tbdis.Attributes["style"] = "display:none;"; } Rpt_Dis.DataSource = Ldis; Rpt_Dis.DataBind(); }