protected void btnSubmit_Click(object sender, EventArgs e)
{
string error = string.Empty;
Model.PerformanceReviewLog performancereviewlog = new PerformanceReviewLog();
performancereviewlog.Year = lbYear.Text;
performancereviewlog.Month = lbMonth.Text;
performancereviewlog.PerformanceReviewItem = lbProject.Text;
performancereviewlog.RowNumber = Convert.ToInt32(this.txtRowNumber.Text);
performancereviewlog.FullScore = Convert.ToInt32(this.txtFullScore.Text);
performancereviewlog.Deduction = Convert.ToInt32(this.txtDeduction.Text);
performancereviewlog.Score = Convert.ToInt32(this.txtScore.Text);
performancereviewlog.Description = txtDescription.Text;
performancereviewlog.Remark = this.txtRemark.Text.Trim();
performancereviewlog.Name = lbName.Text;
performancereviewlog.StatMode = Convert.ToInt32(performancereviewlog.StatMode);
bool result = PerformanceReviewLogManager.EditPerformanceReviewLogManager(performancereviewlog, ref error, ToolManager.GetQueryString("Year"), ToolManager.GetQueryString("Month"), Server.UrlDecode(ToolManager.GetQueryString("PerformanceReviewItem")), ToolManager.GetQueryString("Name"));
lbSubmit.Text = result == true ? "修改成功！" : "修改失败：原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑员工绩效信息" + performancereviewlog.RowNumber, "编辑成功");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑员工绩效信息" + performancereviewlog.RowNumber, "编辑失败！原因" + error);
return;
}
}
private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
//this.trId.Visible = false;
if (ToolManager.CheckQueryString("Year") || ToolManager.CheckQueryString("Month") || ToolManager.CheckQueryString("PerformanceReviewItem") || ToolManager.CheckQueryString("Name"))
{
sql = string.Format(@" select * from PerformanceReviewLog where Year='{0}' and Month='{1}' and PerformanceReviewItem='{2}' and Name='{3}'",
ToolManager.GetQueryString("Year"), ToolManager.GetQueryString("Month"), Server.UrlDecode(ToolManager.GetQueryString("PerformanceReviewItem")), ToolManager.GetQueryString("Name"));
PerformanceReviewLog performancereviewlog = PerformanceReviewLogManager.ConvertDataTableToModel(sql);
lbYear.Text = performancereviewlog.Year;
lbMonth.Text = performancereviewlog.Month;
lbProject.Text = performancereviewlog.PerformanceReviewItem;
this.txtRowNumber.Text = performancereviewlog.RowNumber.ToString();
this.txtFullScore.Text = performancereviewlog.FullScore.ToString();
this.txtScore.Text = performancereviewlog.Score.ToString();
this.txtRemark.Text = performancereviewlog.Remark;
this.txtDeduction.Text = performancereviewlog.Deduction.ToString();
this.txtDescription.Text = performancereviewlog.Description;
lbName.Text = performancereviewlog.Name;
this.drpStatMode.SelectedValue = performancereviewlog.StatMode.ToString();
btnSubmit.Text = "修改";
txtRowNumber.ReadOnly = true;
txtDescription.ReadOnly = true;
drpStatMode.Enabled = false;
}
}
/// DataTable 转对象
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static PerformanceReviewLog ConvertDataTableToModel(string sql)
{
DataTable dt = SqlHelper.GetTable(sql);
DataRow dr = dt.Rows[0];
PerformanceReviewLog performancereviewlog = new PerformanceReviewLog();
performancereviewlog.Year = dr["Year"] == null ? "" : dr["Year"].ToString();
performancereviewlog.Month = dr["Month"] == null ? "" : dr["Month"].ToString();
performancereviewlog.PerformanceReviewItem = dr["PerformanceReviewItem"] == null ? "" : dr["PerformanceReviewItem"].ToString();
performancereviewlog.RowNumber = Convert.ToInt32(dr["RowNumber"] == null ? "" : dr["RowNumber"].ToString());
performancereviewlog.FullScore = Convert.ToInt32(dr["FullScore"] == null ? "" : dr["FullScore"].ToString());
performancereviewlog.Deduction = Convert.ToInt32(dr["Deduction"] == null ? "" : dr["Deduction"].ToString());
performancereviewlog.Score = Convert.ToInt32(dr["Score"] == null ? "" : dr["Score"].ToString());
performancereviewlog.Description = dr["Description"] == null ? "" : dr["Description"].ToString();
performancereviewlog.StatMode = Convert.ToInt32(dr["StatMode"] == null ? "" : dr["StatMode"].ToString());
performancereviewlog.Remark = dr["Remark"] == null ? "" : dr["Remark"].ToString();
performancereviewlog.Name = dr["Name"] == null ? "" : dr["Name"].ToString();
return(performancereviewlog);
}
