/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { List <int> l = new List <int>(); foreach (RepeaterItem row in this.rptGoodsAreas.Items) { CheckBox cb = row.FindControl("CB_SelItem") as CheckBox; if (cb != null && cb.Checked) { HiddenField fld = row.FindControl("HF_Id") as HiddenField; if (fld != null) { int id = Convert.ToInt32(fld.Value); l.Add(id); Hi.Model.BD_GoodsAreas model = new Hi.BLL.BD_GoodsAreas().GetModel(id); if (model != null) { model.ts = DateTime.Now; model.modifyuser = this.UserID; model.dr = 1; model.CompID = this.CompID; bool bol = new Hi.BLL.BD_GoodsAreas().Update(model); } } } } Bind(); }
/// <summary> /// 商品列表绑定 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strWhere = " and ISNULL(dr,0)=0 and ComPid=" + this.CompID; if (ViewState["strWhere"] != null) { strWhere += ViewState["strWhere"].ToString(); } //每页显示的数据设置 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_GoodsAreas> l = new Hi.BLL.BD_GoodsAreas().GetList(Pager.PageSize, Pager.CurrentPageIndex, "id", true, strWhere, out pageCount, out Counts); this.rptGoodsAreas.DataSource = l; this.rptGoodsAreas.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <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(); } }
/// <summary> /// 查询条件 /// </summary> /// <returns></returns> private string Where() { int areaid = 0; if (!Util.IsEmpty(txtDisAreaBox.areaId)) { areaid = Convert.ToInt32(txtDisAreaBox.areaId); } string strWhere = string.Empty; string goodsid = string.Empty; List <Hi.Model.BD_GoodsAreas> lll = new Hi.BLL.BD_GoodsAreas().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and areaid=" + areaid, ""); if (lll.Count > 0) { foreach (Hi.Model.BD_GoodsAreas item in lll) { goodsid += item.GoodsID + ","; } } if (!Util.IsEmpty(goodsid)) { goodsid = goodsid.Substring(0, goodsid.Length - 1); strWhere += " and id not in(" + goodsid + ")"; } //赋值 string goodsName = this.txtGoodsName.Value.Trim(); //商品名称 string hideID = this.txtCategory.treeId; //类别id string idlist = string.Empty; if (!Util.IsEmpty(goodsName)) { //List<Hi.Model.BD_Goods> l = new Hi.BLL.BD_Goods().GetList("", "goodsname like '%" + goodsName + "%' and isnull(dr,0)=0 and isenabled=1 and compid=" + this.CompID, ""); //if (l.Count > 0) //{ // foreach (Hi.Model.BD_Goods item in l) // { // idlist += item.ID + ","; // } //} //if (!Util.IsEmpty(idlist)) //{ // strWhere += string.Format(" and id in( {0})", idlist.Substring(0, idlist.Length - 1)); //} //else //{ // strWhere += string.Format(" and id = ''"); //} strWhere += " and goodsName like'%" + goodsName + "%'"; } if (!Util.IsEmpty(hideID)) { string cateID = Common.CategoryId(Convert.ToInt32(hideID), this.CompID);//商品分类递归 //List<Hi.Model.BD_Goods> ll = new Hi.BLL.BD_Goods().GetList("", "categoryID in(" + cateID + ") and isnull(dr,0)=0 and isenabled=1 and compId=" + this.CompID, ""); //if (ll.Count > 0) //{ // foreach (Hi.Model.BD_Goods item in ll) // { // idlist += item.ID + ","; // } //} //if (!Util.IsEmpty(idlist)) //{ // strWhere += string.Format(" and id in( {0})", idlist.Substring(0, idlist.Length - 1)); //} //else //{ strWhere += " and categoryID in(" + cateID + ")"; // } } return(strWhere); }