/// <summary> /// 得到一个对象实体 /// </summary> public PAFormDetail GetPAFormHead(string PAFormID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select P.UserID,U.LoginName,U.loginIPosition,P.Month,P.AttendDays,P.LeaveDays,P.FullAttendBonus,P.Status FROM tb_UserMonthPAFormHead P left join tb_user U on P.UserID=U.id where P.PAFormID=" + PAFormID); PAFormDetail thisPAFormDetail = new PAFormDetail(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { thisPAFormDetail.UserID = int.Parse(dataReader["UserID"].ToString()); thisPAFormDetail.UserName = dataReader["LoginName"].ToString(); thisPAFormDetail.UserIPosition = dataReader["loginIPosition"].ToString(); thisPAFormDetail.Month = dataReader["Month"].ToString(); thisPAFormDetail.AttendDays = decimal.Parse(dataReader["AttendDays"].ToString()); thisPAFormDetail.LeaveDays = decimal.Parse(dataReader["LeaveDays"].ToString()); thisPAFormDetail.FullAttendBonus = decimal.Parse(dataReader["FullAttendBonus"].ToString()); thisPAFormDetail.Status = int.Parse(dataReader["Status"].ToString()); } } } return(thisPAFormDetail); }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { Section = PAFormDetailSer.GetPAFormSection(base.Request["PAFormId"]); for (int i = 0; i < Section.Count; i++) { ScoreSum.Add(0); FirstSum.Add(0); SecondSum.Add(0); AmountSum.Add(0); } PAFormDetailHead = PAFormDetailSer.GetPAFormHead(base.Request["PAFormId"]); PAItemDetail = PAFormDetailSer.GetPAFormDetail(base.Request["PAFormId"]); lblStatus.Text = PAFormDetailHead.Status.ToString(); lblUserName.Text = PAFormDetailHead.UserName.ToString(); lblDepartment.Text = PAFormDetailHead.UserIPosition.ToString(); lblMonth.Text = PAFormDetailHead.Month.ToString(); lblAttendDays.Text = PAFormDetailHead.AttendDays.ToString(); lblLeaveDays.Text = PAFormDetailHead.LeaveDays.ToString(); lblFullAttendBonus.Text = PAFormDetailHead.AttendDays.ToString(); gvList.DataSource = PAItemDetail; gvList.DataBind(); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(string PAFormID, PAFormDetail model, string UserID) { try { string strSql3 = ""; if (model.PAItem.Count > 0) { for (int i = 0; i < model.PAItem.Count; i++) { if (model.PAFirstReviewUserID[i].ToString() == UserID && model.PASecondReviewUserID[i].ToString() == UserID) { strSql3 = "update tb_UserMonthPAForm set FirstReviewScore=" + model.PAFirstReviewScore[i].ToString() + ",FirstReviewTime=getdate(),SecondReviewScore=" + model.PASecondReviewScore[i].ToString() + ",SecondReviewTime=getdate(),ReviewAmount=" + model.PAAmount[i].ToString() + ",Note='" + model.PANote[i].ToString() + "' where PAFormID=" + PAFormID.ToString() + " and PAItemID=" + model.PAItem[i].ToString(); } else { if (model.Status == 1) { strSql3 = "update tb_UserMonthPAForm set FirstReviewScore=" + model.PAFirstReviewScore[i].ToString() + ","; if (model.PAFirstReviewUserID[i].ToString() == UserID) { strSql3 += "FirstReviewTime=getdate(),"; } strSql3 += "ReviewAmount=" + model.PAAmount[i].ToString() + ",Note='" + model.PANote[i].ToString() + "' where PAFormID=" + PAFormID.ToString() + " and PAItemID=" + model.PAItem[i].ToString(); } else if (model.Status == 2) { strSql3 = "update tb_UserMonthPAForm set SecondReviewScore=" + model.PASecondReviewScore[i].ToString() + ","; if (model.PASecondReviewUserID[i].ToString() == UserID) { strSql3 += "SecondReviewTime=getdate(),"; } strSql3 += "ReviewAmount=" + model.PAAmount[i].ToString() + ",Note='" + model.PANote[i].ToString() + "' where PAFormID=" + PAFormID.ToString() + " and PAItemID=" + model.PAItem[i].ToString(); } } object obj2 = DBHelp.ExeScalar(strSql3.ToString()); } } StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_UserMonthPAFormHead set "); strSql.Append("AttendDays=" + model.AttendDays.ToString() + ","); strSql.Append("LeaveDays=" + model.LeaveDays.ToString() + ","); strSql.Append("FullAttendBonus=" + model.FullAttendBonus.ToString() + ","); strSql.Append("Status=dbo.set_PAForm_Status(" + PAFormID + "),"); int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where PAFormID=" + PAFormID + ""); DBHelp.ExeCommand(strSql.ToString()); return(0); } catch (Exception ex) { return(1); } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { thisPAFormDetail = PAFormDetailSer.GetPAFormHead(base.Request["PAFormId"]); lblStatus.Text = thisPAFormDetail.Status.ToString(); lblUserName.Text = thisPAFormDetail.UserName.ToString(); lblDepartment.Text = thisPAFormDetail.UserIPosition.ToString(); lblMonth.Text = thisPAFormDetail.Month.ToString(); lblAttendDays.Text = thisPAFormDetail.AttendDays.ToString(); lblLeaveDays.Text = thisPAFormDetail.LeaveDays.ToString(); lblFullAttendBonus.Text = thisPAFormDetail.AttendDays.ToString(); gvList.DataSource = PAFormDetailSer.GetPAFormDetail(base.Request["PAFormId"]); gvList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { Section = PAFormDetailSer.GetPAFormSection(base.Request["PAFormId"]); for (int i = 0; i < Section.Count; i++) { ScoreSum.Add(0); FirstSum.Add(0); SecondSum.Add(0); AmountSum.Add(0); } if (!base.IsPostBack) { thisPAFormDetail = PAFormDetailSer.GetPAFormHead(base.Request["PAFormId"]); lblStatus.Text = thisPAFormDetail.Status.ToString(); lblUserName.Text = thisPAFormDetail.UserName.ToString(); lblDepartment.Text = thisPAFormDetail.UserIPosition.ToString(); lblMonth.Text = thisPAFormDetail.Month.ToString(); txtAttendDays.Text = thisPAFormDetail.AttendDays.ToString(); txtLeaveDays.Text = thisPAFormDetail.LeaveDays.ToString(); lblAttendDays.Text = thisPAFormDetail.AttendDays.ToString(); lblLeaveDays.Text = thisPAFormDetail.LeaveDays.ToString(); lblFullAttendBonus.Text = thisPAFormDetail.AttendDays.ToString(); txtFullAttendBonus.Text = thisPAFormDetail.FullAttendBonus.ToString(); if (thisPAFormDetail.Status == 0) { string strSql1 = "update tb_UserMonthPAFormHead set Status=1 where PAFormID=" + base.Request["PAFormId"]; object obj1 = DBHelp.ExeScalar(strSql1.ToString()); lblStatus.Text = "1"; } if (thisPAFormDetail.Status > 2) { btnSave.Visible = false; btnSet.Visible = false; lblAttendDays.Visible = true; lblLeaveDays.Visible = true; lblFullAttendBonus.Visible = true; txtAttendDays.Visible = false; txtLeaveDays.Visible = false; txtFullAttendBonus.Visible = false; } else { btnSave.Visible = true; btnSet.Visible = true; lblAttendDays.Visible = false; lblLeaveDays.Visible = false; lblFullAttendBonus.Visible = false; txtAttendDays.Visible = true; txtLeaveDays.Visible = true; txtFullAttendBonus.Visible = true; } if (NewShowAll_textName("我要评估的绩效考核表", "预设")) { ViewState["Load"] = "1"; } TablePAFormDetail = PAFormDetailSer.GetPAFormDetail(base.Request["PAFormId"]); gvList.DataSource = TablePAFormDetail; gvList.DataBind(); } }