public DataSet UpdateImageByProc2(Model.ProductColor model, string type) { SqlParameter recordCount = new SqlParameter(); recordCount.ParameterName = "@RecordCount"; recordCount.Direction = ParameterDirection.Output; recordCount.Size = 100; SqlParameter[] paras = { new SqlParameter("@ID", SqlDbType.BigInt), new SqlParameter("@Image", SqlDbType.NVarChar), new SqlParameter("@ActionType", SqlDbType.NVarChar), new SqlParameter("@UpdateUsee", SqlDbType.NVarChar), new SqlParameter("@UpdateDate", SqlDbType.NVarChar), recordCount }; paras[0].Value = model.ID; paras[1].Value = model.Image; paras[2].Value = type; paras[3].Value = model.UpdateUser; paras[4].Value = model.UpdateDate; DataSet ds = new DataSet(); ds = DbHelperSQL.RunProcedure("Sp_Product", paras, "Product"); return(ds); }
//上传图片 public void Upload(HttpContext context) { try { HttpPostedFile file; string fileName = string.Empty; Model.ProductColor model = new Model.ProductColor(); DataSet ds = new DataSet(); long ID = Convert.ToInt64(context.Request["lbID"]); for (int i = 0; i < context.Request.Files.Count; ++i) { file = context.Request.Files[i]; if (file == null || file.ContentLength == 0 || string.IsNullOrEmpty(file.FileName)) { continue; } file.SaveAs(HttpContext.Current.Server.MapPath("../ProductPic/" + Path.GetFileName(file.FileName))); fileName += file.FileName; model.ID = ID; model.UpdateUser = Convert.ToString(((Model.BaseUser)context.Session["login"]).UserID); model.UpdateDate = DateTime.Now; model.Image = file.FileName; ds = new BLL.ProductColor().UpdateImageByProc(model, "Update3"); context.Response.Write(ds.Tables[0].Rows[0][0].ToString()); } } catch (Exception ex) { context.Response.StatusCode = 500; context.Response.Write(ex.Message); context.Response.End(); } finally { context.Response.End(); } }
public bool EditColor(List <Model.ProductColor> insertList, List <Model.ProductColor> updateList, List <Model.ProductColor> delList, long UserID) { ArrayList arr = new ArrayList(); StringBuilder sbSql = new StringBuilder(); for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.ProductColor model = delList[i]; sbSql.Append("delete from ProductColor where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); Model.ProductColor model = updateList[i]; sbSql.Append("update ProductColor set Code='" + model.Code + "', Name='" + model.Name.Trim() + "',Image='" + model.Image + "',Value0='" + model.Value0 + "',Value1='" + model.Value1 + "',UpdateUser="******",UpdateDate=getdate()"); sbSql.Append(" where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); Model.ProductColor 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 ProductColor (Code,Name,Image,Value0,Value1,CreateUser,CreateDate) "); sbSql.Append(" values ( "); sbSql.Append("'" + model.Code + "','" + model.Name + "','" + model.Image + "','" + model.Value0 + "','" + model.Value1 + "','" + model.CreateUser + "',getdate()"); sbSql.Append(" ) "); arr.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(arr); return(true); }
public DataSet UpdateImageByProc(Model.ProductColor model, string type) { return(new DAL.ProductColor().UpdateImageByProc(model, type)); }