public string Group_Edit(HttpContext context) { long id = Convert.ToInt64(context.Request["ParentID"].ToString()); Model.BaseUser user = ((Model.BaseUser)context.Session["login"]); string allstr = context.Request.Params["allstr"].Trim(); string addstr = context.Request.Params["addstr"].Trim(); string updatestr = context.Request.Params["updatestr"].Trim(); string delstr = context.Request.Params["delstr"].Trim(); Model.ProductPriceColorShip model = new Model.ProductPriceColorShip(); List <Model.ProductPriceColorShip> insert = new List <Model.ProductPriceColorShip>(); insert = JsonSerializerHelper.JSONStringToList <Model.ProductPriceColorShip>(addstr); List <Model.ProductPriceColorShip> update = new List <Model.ProductPriceColorShip>(); update = JsonSerializerHelper.JSONStringToList <Model.ProductPriceColorShip>(updatestr); List <Model.v_ProductColorShip> del = new List <Model.v_ProductColorShip>(); del = JsonSerializerHelper.JSONStringToList <Model.v_ProductColorShip>(delstr); List <Model.ProductPriceColorShip> sequence = new List <Model.ProductPriceColorShip>(); sequence = JsonSerializerHelper.JSONStringToList <Model.ProductPriceColorShip>(allstr); return(new BLL.ProductPriceColorShip().Edit(insert, update, del, sequence, Convert.ToInt32(((Model.BaseUser)(context.Session["login"])).UserID.ToString()), id)); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "ProductItem"; * parameters[1].Value = "ID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// /// </summary> /// <param name="insertList"></param> /// <param name="updateList"></param> /// <param name="delList"></param> /// <param name="sequenceList"></param> /// <param name="UserID">用户ID</param> /// <param name="id">ProductID</param> /// <returns></returns> public bool Edit(List <Model.ProductPriceColorShip> insertList, List <Model.ProductPriceColorShip> updateList, List <Model.v_ProductColorShip> delList, List <Model.ProductPriceColorShip> sequenceList, long UserID, long id) { ArrayList arr = new ArrayList(); StringBuilder sbSql = new StringBuilder(); for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.v_ProductColorShip model = delList[i]; sbSql.Append("delete from ProductItem where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); Model.ProductPriceColorShip model = updateList[i]; sbSql.Append("update ProductItem set ProductID='" + id + "',Corlor='" + model.Corlor + "',Code='" + model.Code + "',Size='" + model.Size + "',Quality='" + model.Quality + "'"); sbSql.Append(",Brand='" + model.Brand + "',NFK='" + model.NFK + "',Attribute='" + model.Attribute + "',BarginPriceOut='" + model.BarginPriceOut + "',ReferencePriceOut='" + model.ReferencePriceOut + "'"); sbSql.Append(",StandardPriceIn='" + model.StandardPriceIn + "',MinPriceOut='" + model.MinPriceOut + "',Profit='" + model.Profit + "',TagPrice='" + model.TagPrice + "',MaxStock='" + model.MaxStock + "'"); sbSql.Append(",MinStock='" + model.MinStock + "',ReferencePriceA='" + model.ReferencePriceA + "',ReferencePriceB='" + model.ReferencePriceB + "',ReferencePriceC='" + model.ReferencePriceC + "',ReferencePriceD='" + model.ReferencePriceD + "'"); sbSql.Append(",ReferencePriceE='" + model.ReferencePriceE + "',ReferencePriceF='" + model.ReferencePriceF + "',value0='" + model.value0 + "',value1='" + model.value1 + "'"); sbSql.Append(" where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); Model.ProductPriceColorShip model = insertList[i]; //sbSql.Append("insert into ProductColor (ParentID,Code,Name,Enabled,Status,Remark,Value0,Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,CreateUser,CreateDate,UpdateUser,UpdateDate) "); sbSql.Append("insert into ProductItem (ProductID,ColorID,Corlor,Size,MaxStock,MinStock,Brand,ReferencePriceOut,StandardPriceIn,ReferencePriceA,ReferencePriceB,ReferencePriceC,ReferencePriceD,ReferencePriceE,ReferencePriceF) "); sbSql.Append(" values ( "); sbSql.Append("'" + id + "',0,'" + model.Corlor + "','" + model.Size + "','" + model.MaxStock + "','" + model.MinStock + "','" + model.Brand + "','" + model.ReferencePriceOut + "','" + model.StandardPriceIn + "','" + model.ReferencePriceA + "','" + model.ReferencePriceB + "','" + model.ReferencePriceC + "','" + model.ReferencePriceD + "','" + model.ReferencePriceE + "','" + model.ReferencePriceF + "'"); sbSql.Append(" ) "); arr.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(arr); return(true); }