예제 #1
0
        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 + "'"));
        }
예제 #2
0
 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;
     }
 }
예제 #3
0
    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);
    }
예제 #4
0
        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, "')" })));
        }
예제 #5
0
    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;
        }
    }
예제 #6
0
        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, "'" })));
        }