Пример #1
0
    private void dglist_UpdateCommand(object source, DataGridCommandEventArgs e)
    {
        ProgressEvaluateInfo progressEvaluateInfo = new ProgressEvaluateInfo();

        progressEvaluateInfo.Appraise       = ((TextBox)e.Item.Cells[2].FindControl("Appraise")).Text.Trim();
        progressEvaluateInfo.AppraisePeople = e.Item.Cells[0].Text.Trim();
        progressEvaluateInfo.AppraiseTime   = DateTime.Parse(((TextBox)e.Item.Cells[1].FindControl("AppriaseTime")).Text.Trim());
        progressEvaluateInfo.MainID         = this.dglist.DataKeys[e.Item.ItemIndex].ToString();
        UserInfo currentUserInfo = userManageDb.GetCurrentUserInfo();

        if (currentUserInfo == null)
        {
            this.js.Text = "alert('用户身份过期,请重新登录!');window.close();";
            return;
        }
        if (e.Item.Cells[0].Text.Trim() != currentUserInfo.UserName)
        {
            this.js.Text = "alert(\"没有操作权限!\");";
            return;
        }
        if (ProgressImplementAction.EditEvaluation(progressEvaluateInfo))
        {
            this.js.Text = "alert(\"操作成功!\");";
            this.dglist.EditItemIndex = -1;
            this.BindData();
            return;
        }
        this.js.Text = "alert(\"操作失败!\");";
    }
Пример #2
0
        public ProgressEvaluateInfo GetEvaluateInfo(string MainId)
        {
            string sqlString           = string.Format("select * from Prj_ProgressPlan_Appraise where MainID='{0}'", MainId);
            ProgressEvaluateInfo info  = new ProgressEvaluateInfo();
            DataTable            table = publicDbOpClass.DataTableQuary(sqlString);

            if (table.Rows.Count > 0)
            {
                info = this.FormatToEvaModel(table.Rows[0]);
            }
            table.Dispose();
            return(info);
        }
Пример #3
0
    private void BindData()
    {
        UserInfo currentUserInfo = userManageDb.GetCurrentUserInfo();
        ProgressImplementAction progressImplementAction = new ProgressImplementAction();
        ProgressEvaluateInfo    evaluateInfo            = progressImplementAction.GetEvaluateInfo(this.AppraiseId);

        this.txtAppraise.Text         = evaluateInfo.Appraise;
        this.txtAppraiseTime.Text     = evaluateInfo.AppraiseTime.ToShortDateString();
        this.txtAppraiseTime.ReadOnly = true;
        if (currentUserInfo != null)
        {
            this.txtAppraisePeople.Text = currentUserInfo.UserName;
            return;
        }
        this.js.Text = "alert(\"登录时间过期,请重新登陆!\");window.close();";
    }
Пример #4
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        ProgressEvaluateInfo progressEvaluateInfo = new ProgressEvaluateInfo();
        bool isEdit = this.ViewState["ISNEW"] != null && !Convert.ToBoolean(this.ViewState["ISNEW"].ToString().ToLower());

        progressEvaluateInfo.AppraisePeople = this.txtAppraisePeople.Text;
        progressEvaluateInfo.AppraiseTime   = DateTime.Parse(this.txtAppraiseTime.Text);
        progressEvaluateInfo.ParentMainID   = this.mainId;
        progressEvaluateInfo.MainID         = this.AppraiseId;
        progressEvaluateInfo.Appraise       = this.txtAppraise.Text;
        if (ProgressImplementAction.AddEvaluate(progressEvaluateInfo, isEdit))
        {
            base.RegisterScript("top.ui.tabSuccess({ parentName: '_progressimplementitem' });");
        }
        else
        {
            base.RegisterScript("top.ui.alert('保存失败');");
        }
        this.BindData();
    }
Пример #5
0
        public static bool AddEvaluate(ProgressEvaluateInfo objInfo, bool isEdit)
        {
            string sqlString = "select * from Prj_ProgressPlan_Appraise where MainId='" + objInfo.MainID + "'";

            if (publicDbOpClass.DataTableQuary(sqlString).Rows.Count > 0)
            {
                if (!isEdit)
                {
                    objInfo.MainID = GetNewAppraiseId();
                    AddEvaluate(objInfo, isEdit);
                }
                else
                {
                    sqlString = string.Format("update Prj_ProgressPlan_Appraise set AppraisePeople='{0}',AppraiseTime='{1}',Appraise='{2}' where MainID='{3}'", new object[] { objInfo.AppraisePeople, objInfo.AppraiseTime, objInfo.Appraise, objInfo.MainID });
                }
            }
            else
            {
                string str2 = "insert into Prj_ProgressPlan_Appraise values('" + objInfo.MainID + "','";
                sqlString = (str2 + objInfo.ParentMainID + "','" + objInfo.AppraisePeople + "','" + objInfo.AppraiseTime.ToString()) + "','" + objInfo.Appraise + "')";
            }
            return(publicDbOpClass.NonQuerySqlString(sqlString));
        }
Пример #6
0
 public static bool EditEvaluation(ProgressEvaluateInfo objInfo)
 {
     return(publicDbOpClass.NonQuerySqlString("update Prj_ProgressPlan_Appraise set Appraise='" + objInfo.Appraise + "',AppraisePeople='" + objInfo.AppraisePeople + "',AppraiseTime='" + objInfo.AppraiseTime.ToString() + "' where MainId='" + objInfo.MainID + "'"));
 }