public string UpdateImage(Model.project_product_item model)
{
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.sid;
paras[1].Value = model.pic;
paras[2].Value = "Update2";
paras[3].Value = model.update_person;
paras[4].Value = DateTime.Now;
DataSet ds = new DataSet();
string sql = "update project_product_item set pic=" + model.pic + ", UpdateUser="******", UpdateDate=getdate() WHERE sid=" + model.sid + "";
try
{
int i = DbHelperSQL.ExecuteSql(sql, paras);
string getImg = "select Image from project_product_item where sid=" + model.sid + "";
ds = DbHelperSQL.Query(getImg);
}
catch
{
}
return(ds.Tables[0].Rows[0]["pic"].ToString());
}
public string Edit(HttpContext context)
{
string number = context.Request["number"];
//string projectName = context.Request["projectName"];
int detail = context.Request["detail"] == "" ? 0 : Convert.ToInt32(context.Request["detail"]);
string paintColor = context.Request["paintColor"];
string useSpace = context.Request["useSpace"];
string spaceCount = context.Request["spaceCount"];
string install = context.Request["install"];
string usePart = context.Request["usePart"];
string unit = context.Request["unit"];
string amount = context.Request["amount"];
string paintPaletteNumber = context.Request["paintPaletteNumber"];
string EndProduct = context.Request["EndProduct"];
string remark = context.Request["remark"];
if (number != "" && detail != 0 && paintColor != "" && useSpace != "" && spaceCount != "" && install != "" && usePart != "" && unit != "" && amount != "" && paintPaletteNumber != "" && EndProduct != "")
{
int pssid = Convert.ToInt32(context.Request["ps_sid"]); //项目类型
int parent_sid = Convert.ToInt32(context.Request["parent_sid"]); //psi --parent_sid
int ppiSid = Convert.ToInt32(context.Request["ppiSid"]); //ppiSid
int ppSid = Convert.ToInt32(context.Request["ppSid"]); //ppSid
DataSet ds = new BLL.project_product_item().GetList(" sid=" + ppiSid + "");
if (ds.Tables[0].Rows[0]["EndProduct"].ToString() != EndProduct)
{
}
Model.project_product_item model = new Model.project_product_item();
model.number = number;
//model.projectName = projectName;
model.paintColor = paintColor;
model.useSpace = useSpace;
model.spaceCount = Convert.ToInt32(spaceCount);
model.install = install;
model.usePart = usePart;
model.unit = unit;
model.amount = Convert.ToInt32(amount);
model.paintPaletteNumber = paintPaletteNumber;
model.EndProduct = EndProduct;
model.remark = remark;
model.sid = ppiSid;
model.update_person = ((Model.BaseUser)context.Session["login"]).Name;
model.update_date = DateTime.Now;
string result = new BLL.project_product_item().Update(model, detail, pssid, ppiSid, parent_sid, ppSid);
return(result);
}
else
{
return("*号内容不能为空！");
}
}
public string Save(HttpContext context)
{
string number = context.Request["number"];
string projectName = context.Request["projectName"];
int detail = context.Request["detail"] == "" ? 0 : Convert.ToInt32(context.Request["detail"]);
string paintColor = context.Request["paintColor"];
string useSpace = context.Request["useSpace"];
string spaceCount = context.Request["spaceCount"];
string install = context.Request["install"];
string usePart = context.Request["usePart"];
string unit = context.Request["unit"];
string amount = context.Request["amount"];
string paintPaletteNumber = context.Request["paintPaletteNumber"];
string EndProduct = context.Request["EndProduct"];
string remark = context.Request["remark"];
int pssid = Convert.ToInt32(context.Request["ps_sid"]); //项目类型
if (number != "" && detail != 0 && paintColor != "" && useSpace != "" && spaceCount != "" && install != "" && usePart != "" && unit != "" && amount != "" && paintPaletteNumber != "" && EndProduct != "")
{
Model.project_product_item model = new Model.project_product_item();
model.number = number;
model.projectName = projectName;
model.paintColor = paintColor;
model.useSpace = useSpace;
model.spaceCount = Convert.ToInt32(spaceCount);
model.install = install;
model.usePart = usePart;
model.unit = unit;
model.amount = Convert.ToInt32(amount);
model.paintPaletteNumber = paintPaletteNumber;
model.EndProduct = EndProduct;
model.remark = remark;
model.create_person = ((Model.BaseUser)context.Session["login"]).Name;
model.create_date = DateTime.Now;
int result = new BLL.project_product_item().Add(model, detail, pssid);
if (result > 0)
{
return("success");
}
else
{
return("fail");
}
}
else
{
return("*号内容不能为空！");
}
}
public string UpdateImage(Model.project_product_item model)
{
return(new BLL.project_product_item().UpdateImage(model));
}
