private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Name") && ToolManager.CheckQueryString("Year") && ToolManager.CheckQueryString("Month"))
{
string name = Server.UrlDecode(ToolManager.GetQueryString("Name"));
sql = string.Format(@" select e.Year,e.Month,pu.USER_NAME as Name,e.Score,e.LeaderScore,
e.Operation,e.WorkAttendance,e.WorkState,e.Teamwork,
e.RejectsProduct,e.Security, e.TotalScore,e.Remark
from ExaminationLog e left join PM_USER pu on e.Name=pu.USER_ID where year='{0}' and month='{1}'
and pu.USER_NAME='{2}' ", ToolManager.GetQueryString("Year"), ToolManager.GetQueryString("Month"),
name);
ExaminationLog examinationlog = ExaminationLogManager.ConvertDataTableToModel(sql);
this.lblYear.Text = examinationlog.Year;
this.lblMonth.Text = examinationlog.Month;
this.lblName.Text = examinationlog.Name;
this.drpName.SelectedValue = examinationlog.Name;
this.txtScore.Text = examinationlog.Score.ToString();
this.txtLeaderScore.Text = examinationlog.LeaderScore.ToString();
this.txtTotalScore.Text = examinationlog.TotalScore.ToString();
this.txtOperation.Text = examinationlog.Operation.ToString();
this.lbWorkAttendance.Text = examinationlog.WorkAttendance.ToString();
this.txtWorkState.Text = examinationlog.WorkState.ToString();
this.txtTeamwork.Text = examinationlog.Teamwork.ToString();
this.txtRejectsProduct.Text = examinationlog.RejectsProduct.ToString();
this.txtSecurity.Text = examinationlog.Security.ToString();
this.txtRemark.Text = examinationlog.Remark;
btnSubmit.Text = "修改";
this.txtWorkAttendance.Visible = false;
drpYear.Visible = false;
drpMonth.Visible = false;
drpName.Visible = false;
lblMonth.Visible = false;
lblMonth.Visible = true;
lblYear.Visible = true;
lblName.Visible = true;
}
else
{
btnSubmit.Text = "添加";
lblMonth.Visible = false;
lblYear.Visible = false;
lblName.Visible = false;
}
}
