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, "'" }))); }