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