public static int ExperUpd(ExpertProjectInfo objInfo, string Id) { object obj2 = "update Prj_ExpertSchemeManage set PrjCode='" + objInfo.PrjCode + "',PrejectName='" + objInfo.PrejectName + "',SchemeName='" + objInfo.SchemeName; object obj3 = string.Concat(new object[] { obj2, "',WeavePeople='", objInfo.WeavePeople, "',WeaveDate='", objInfo.WeaveDate, "',FillPeople='", objInfo.FillPeople, "',FillDate='" }); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj3, objInfo.FillDate, "',SchemEbewrite='", objInfo.SchemEbewrite, "',Remark='", objInfo.Remark, "',ExamineApprove='", objInfo.ExamineApprove, "'" }) + " where MainId='" + Id + "'")); }
protected void BtnSave_Click(object sender, EventArgs e) { if (this._Type == "Auditing") { ExpertProjectInfo pPMContructInfo = this.GetPPMContructInfo(); int num = ExperProjectAction.SetPPMAudit(pPMContructInfo); if (num == 1) { string text = " parent.desktop.flowclass.location='/EPC/17/Frame.aspx?url=../../epc/17/Ppm/ScienceInnovate/ExpertProjectQuery.aspx&Type=Auditing&PrjState=0';"; text += "alert('审核成功');"; text += "top.frameWorkArea.window.desktop.getActive().close();"; this.Js.Text = text; return; } this.Js.Text = "alert('审核失败!'); "; return; } else { ExpertProjectInfo entContructInfo = this.GetEntContructInfo(); int num = ExperProjectAction.SetEntAudit(entContructInfo); if (num == 1) { string text2 = " parent.desktop.flowclass.location='/EPC/17/Frame.aspx?url=../../epc/17/Ppm/ScienceInnovate/ExpertProjectQuery.aspx&Type=List&PrjState=0';"; text2 += "alert('审核成功');"; text2 += "top.frameWorkArea.window.desktop.getActive().close();"; this.Js.Text = text2; return; } this.Js.Text = "alert('审核失败!'); "; return; } }
private ExpertProjectInfo GetExpertInfo() { ExpertProjectInfo expertProjectInfo = new ExpertProjectInfo(); if (this._Type == "Add") { expertProjectInfo.ManiId = int.Parse(this._RecordId); } else { expertProjectInfo.ManiId = int.Parse(this._Id); } expertProjectInfo.PrjCode = this.HdnUnit.Value; expertProjectInfo.PrejectName = this._PrjCode; expertProjectInfo.SchemeName = this.TxtExperName.Text; expertProjectInfo.WeavePeople = this.HdnWeaver.Value; expertProjectInfo.WeaveDate = Convert.ToDateTime(this.DateWeaverTime.Text); expertProjectInfo.FillPeople = this.HdnFillName.Value; expertProjectInfo.FillDate = Convert.ToDateTime(this.DateFillTime.Text); expertProjectInfo.ExamineApprove = this.TxtAuditCircs.Text; expertProjectInfo.SchemEbewrite = this.TxtScript.Text.Trim(); expertProjectInfo.Remark = this.TxtRemark.Text.Trim(); expertProjectInfo.FlowGuid = this.hdnFlowGuid.Value.Trim(); return(expertProjectInfo); }
public static int ExperAdd(ExpertProjectInfo objInfo) { string str = ""; str = " insert into Prj_ExpertSchemeManage (MainId,PrjCode,PrejectName,SchemeName,WeavePeople,WeaveDate,"; object obj2 = str; object obj3 = string.Concat(new object[] { obj2, "FillPeople,FillDate,SchemEbewrite,Remark,ExamineApprove,FlowGuid) values('", objInfo.ManiId, "','", objInfo.PrjCode, "','" }); object obj4 = string.Concat(new object[] { obj3, objInfo.PrejectName, "','", objInfo.SchemeName, "','", objInfo.WeavePeople, "','", objInfo.WeaveDate, "','", objInfo.FillPeople, "','" }); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj4, objInfo.FillDate, "','", objInfo.SchemEbewrite, "','", objInfo.Remark, "','", objInfo.ExamineApprove, "','", objInfo.FlowGuid, "')" }))); }
protected void BtnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.TxtExperName.Text)) { base.RegisterScript("top.ui.alert('方案名称不能为空');"); return; } ExpertProjectInfo expertInfo = this.GetExpertInfo(); int mark = 2; if (this.cbkmark.Checked) { mark = 3; } if (this._Type == "Add") { ExperProjectAction.ExperAdd(expertInfo); int num = this.coBll.UpdGuidang("Prj_ExpertSchemeManage", mark, Convert.ToInt32(this.DDTClass.SelectedValue.Trim()), " where MainID=" + expertInfo.ManiId); if (num == 1) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_expertprojectquery' })"); this.BtnSave.Enabled = false; return; } base.RegisterScript("top.ui.alert('保存失败');"); return; } else { ExperProjectAction.ExperUpd(expertInfo, this._Id); int num = this.coBll.UpdGuidang("Prj_ExpertSchemeManage", mark, Convert.ToInt32(this.DDTClass.SelectedValue.Trim()), " where MainId=" + expertInfo.ManiId); if (num == 1) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_expertprojectquery' })"); return; } base.RegisterScript("top.ui.alert('保存失败');"); return; } }
public static int SetEntAudit(ExpertProjectInfo objInfo) { object obj2 = "update Prj_ExpertSchemeManage set EntExamineApprovePeople='" + objInfo.EntExamineApprovePeople + "',EntExamineApproveDate='" + objInfo.EntExamineApproveDate.ToShortDateString() + "',EntExamineApproveResult='" + objInfo.EntExamineApproveResult.ToString(); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, "',EntExamineApproveIdea='", objInfo.EntExamineApproveIdea, "',EntRemark='", objInfo.EntRemark, "' where MainId='", objInfo.ManiId, "'" }))); }