protected void btn_save_Click(object sender, EventArgs e)
{
CostInputPri costInputPri = new CostInputPri();
costInputPri.RecordID = this.RecordID;
costInputPri.PrjCode = this.PrjCode.ToString();
costInputPri.CostItemName = this.txtItemName.Text.Trim();
costInputPri.HappenDate = Convert.ToDateTime(this.dbDate.Text.Trim());
costInputPri.HappenUnit = this.txtDept.Text.Trim();
costInputPri.FillPeople = this.txtUser.Text.Trim();
costInputPri.TouchMan = this.HdnPerson.Value.Trim();
this.DataGridToSession();
if (CostInputPriAction.insertCostInput(costInputPri, (DataTable)this.ViewState["CostSlave"], this.opType))
{
this.JS.Text = "alert('保存成本数据成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存成本数据失败！请与管理员联系！');window.returnValue=true;window.close();";
}
protected void btn_save_Click(object sender, EventArgs e)
{
try
{
CostInputPri objInfo = this.CreatModelObject();
int num = CostInputPriAction.updateCostJudgePri(objInfo);
if (num == 1)
{
this.Js.Text = "alert('审核成功!');window.close();";
}
else
{
this.Js.Text = "alert('审核失败!');";
}
}
catch (Exception ex)
{
this.Js.Text = "alert('数据库连接失败!')";
throw ex;
}
}
public static bool insertCostInput(CostInputPri objInfo, DataTable dt, string opType)
{
string str = "begin ";
if (opType == "add")
{
object obj2 = str + " insert into EPM_CostImport(RecordID,PrjCode,CostItemName,HappenUnit,HappenDate,FillPeople,TouchMan) values('";
str = string.Concat(new object[] { obj2, objInfo.RecordID.ToString(), "','", objInfo.PrjCode, "' ,'", objInfo.CostItemName, "' ,'", objInfo.HappenUnit, "','", objInfo.HappenDate, "','", objInfo.FillPeople, "','", objInfo.TouchMan, "')" });
for (int i = 0; i < dt.Rows.Count; i++)
{
string str2 = str + " insert into EPM_CostImportChild (RecordID,ItemName,Price,CostCode,Remark) values ('";
string str3 = str2 + dt.Rows[i]["RecordID"].ToString() + "','" + dt.Rows[i]["ItemName"].ToString() + "',cast('";
str = (str3 + dt.Rows[i]["Price"].ToString() + "' as money),'" + dt.Rows[i]["CostCode"].ToString() + "','") + dt.Rows[i]["Remark"].ToString() + "')";
}
}
else if (opType == "edit")
{
string str4 = str;
object obj3 = str4 + " update EPM_CostImport set CostItemName = '" + objInfo.CostItemName + "',HappenUnit = '" + objInfo.HappenUnit + "',";
str = string.Concat(new object[] { obj3, " HappenDate = '", objInfo.HappenDate, "',FillPeople = '", objInfo.FillPeople, "',TouchMan = '", objInfo.TouchMan, "'" }) + " where RecordID = '" + objInfo.RecordID.ToString() + "'";
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["ChildID"].ToString() == "0")
{
string str5 = str + " insert into EPM_CostImportChild (RecordID,ItemName,Price,CostCode,Remark) values ('";
string str6 = str5 + dt.Rows[j]["RecordID"].ToString() + "','" + dt.Rows[j]["ItemName"].ToString() + "',cast('";
str = (str6 + dt.Rows[j]["Price"].ToString() + "' as money),'" + dt.Rows[j]["CostCode"].ToString() + "','") + dt.Rows[j]["Remark"].ToString() + "')";
}
else
{
string str7 = str + " update EPM_CostImportChild set ItemName = '" + dt.Rows[j]["ItemName"].ToString() + "',";
string str8 = str7 + " Price = cast('" + dt.Rows[j]["Price"].ToString() + "' as money),CostCode = '" + dt.Rows[j]["CostCode"].ToString() + "',";
str = str8 + " Remark = '" + dt.Rows[j]["Remark"].ToString() + "' where ChildID = " + dt.Rows[j]["ChildID"].ToString();
}
}
}
return(publicDbOpClass.NonQuerySqlString(str + " end"));
}
public static int updateCostJudgePri(CostInputPri objInfo)
{
object obj2 = string.Concat(new object[] { "update EPM_CostImport set AuditPeople = '", objInfo.AuditPeople, "', AuditDate = '", objInfo.AuditDate, "', AuditResult = ", objInfo.AuditResult, ", Remark = '", objInfo.Remark, "'" });
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " where RecordID = '", objInfo.RecordID, "'" })));
}
