/// <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();
}
}
