protected void BtnSave_Click(object sender, EventArgs e) { EntStandardInfo entStandInfo = this.GetEntStandInfo(); if (this._Type == "Add") { int num = EntStandardAction.StandardAdd(entStandInfo); if (num == 1) { string text = "parent.desktop.flowclass.location=parent.desktop.flowclass.location;"; text += "alert('保存成功');"; text += "top.frameWorkArea.window.desktop.getActive().close();"; this.Js.Text = text; this.BtnSave.Enabled = false; return; } this.Js.Text = "alert('保存失败!'); "; return; } else { int num = EntStandardAction.StandUpd(entStandInfo, this._Id); if (num >= 1) { string text2 = "parent.desktop.flowclass.location=parent.desktop.flowclass.location;"; text2 += "alert('保存成功');"; text2 += "top.frameWorkArea.window.desktop.getActive().close();"; this.Js.Text = text2; this.BtnSave.Enabled = false; return; } this.Js.Text = "alert('保存失败!'); "; return; } }
public static int StandUpd(EntStandardInfo objInfo, string Id) { string str2 = " Begin "; string str3 = str2 + " update Prj_EnterpriseTechnologyCriterion set TechnologyCriterionID='" + objInfo.TechnologyCriterionID + "',TechnologyName='" + objInfo.TechnologyName; string str4 = str3 + "',TechnologyClassify='" + objInfo.TechnologyClassify.ToString() + "',TechnologyPromulgateTime='" + objInfo.TechnologyPromulgateTime; string str5 = str4 + "',Remark='" + objInfo.Remark + "' where MainKey ='" + Id + "'"; return(publicDbOpClass.ExecSqlString((str5 + " update Prj_TechnologyCriterion set TechnologyCriterionID='" + objInfo.TechnologyCriterionID + "',TechnologyClassify='" + objInfo.TechnologyClassify + "',TechnologyName='" + objInfo.TechnologyName + "',TechnologyPromulgateTime='" + objInfo.TechnologyPromulgateTime + "' where MainKey=" + Id) + " End")); }
public static int StandardAdd(EntStandardInfo objInfo) { string str = ""; str = " insert into Prj_EnterpriseTechnologyCriterion (ClassID,TechnologyCriterionID,TechnologyName,TechnologyClassify,TechnologyPromulgateTime,Remark,EnterGuid) values('"; string str2 = str; string str3 = str2 + objInfo.ClassID.ToString() + "','" + objInfo.TechnologyCriterionID + "','" + objInfo.TechnologyName + "','" + objInfo.TechnologyClassify.ToString() + "','"; return(publicDbOpClass.ExecSqlString(str3 + objInfo.TechnologyPromulgateTime + "','" + objInfo.Remark + "','" + objInfo.EnterGuid + "')")); }
private EntStandardInfo GetEntStandInfo() { EntStandardInfo entStandardInfo = new EntStandardInfo(); if (this._Type == "Upd") { this._Id = this.ViewState["Id"].ToString(); } else { entStandardInfo.MainKey = int.Parse(this._MaxId); entStandardInfo.ClassID = new Guid(this._ClassId); } entStandardInfo.TechnologyCriterionID = this.TxtStandCode.Text.Trim(); entStandardInfo.TechnologyName = this.TxtStandName.Text.Trim(); entStandardInfo.TechnologyClassify = ((EditDropDownList)this.lbPlanSort.FindControl("ddlPlanSort")).Text; entStandardInfo.TechnologyPromulgateTime = this.DatePublicTime.Text; entStandardInfo.Remark = this.TxtRemark.Text.Trim(); entStandardInfo.EnterGuid = this.hdnEnterGuid.Value.Trim(); return(entStandardInfo); }