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));
}
