protected void Page_Load(object sender, EventArgs e) { //删除 if (ToolManager.CheckQueryString("ids")) { string temp = ExaminationLogManager.DeleteData(ToolManager.GetQueryString("ids")); bool result = temp == "1" ? true : false; if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除员工考试成绩" + ToolManager.CheckQueryString("ids"), "删除成功"); Response.Write(temp); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除员工考试成绩" + ToolManager.CheckQueryString("ids"), "删除失败!原因" + temp); Response.Write(temp); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPageRepeater("EditExaminationLogList.aspx", "btnSearch", "320", "550"); } }
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; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string error = string.Empty; Model.ExaminationLog examinationlog = new ExaminationLog(); //examinationlog.Year = this.drpYear.SelectedValue; //examinationlog.Month = this.drpMonth.SelectedValue; //examinationlog.Name = this.drpName.SelectedValue; //examinationlog.WorkAttendance = Convert.ToDecimal(this.txtWorkAttendance.Text); examinationlog.Score = Convert.ToDecimal(this.txtScore.Text); examinationlog.LeaderScore = Convert.ToDecimal(this.txtLeaderScore.Text); examinationlog.TotalScore = Convert.ToDecimal(this.txtTotalScore.Text); examinationlog.TotalScore = Convert.ToDecimal(Request.Form["txtTotalScore"].ToString()); examinationlog.Operation = Convert.ToDecimal(this.txtOperation.Text); examinationlog.WorkState = Convert.ToDecimal(this.txtWorkState.Text); examinationlog.Teamwork = Convert.ToDecimal(this.txtTeamwork.Text); examinationlog.RejectsProduct = Convert.ToDecimal(this.txtRejectsProduct.Text); examinationlog.Security = Convert.ToDecimal(this.txtSecurity.Text); examinationlog.Remark = this.txtRemark.Text; bool result = false; if (btnSubmit.Text.Equals("添加")) { if (string.IsNullOrEmpty(this.drpYear.Text) || string.IsNullOrEmpty(this.drpMonth.Text) || string.IsNullOrEmpty(this.drpName.Text)) { lbSubmit.Text = "请将带*号的内容填写完整!"; return; } string sql = string.Format(@" select * from ExaminationLog where YEAR='{0}' and MONTH='{1}' and Name='{2}'", examinationlog.Year, examinationlog.Month, examinationlog.Name); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { lbSubmit.Text = "当前年份、月份,已有该用户信息,请重新填写!"; return; } result = ExaminationLogManager.AddExaminationLog(examinationlog, ref error); lbSubmit.Text = result == true ? "添加成功!" : "添加失败,原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "增加员工考试成绩信息" + examinationlog.Id, "增加成功"); ToolCode.Tool.ResetControl(this.Controls); return; } else { Tool.WriteLog(Tool.LogType.Operating, "增加员工考试成绩信息" + examinationlog.Id, "增加失败!原因:" + error); return; } } else { examinationlog.Year = this.lblYear.Text.Trim(); examinationlog.Month = this.lblMonth.Text.Trim(); examinationlog.Name = this.lblName.Text.Trim(); examinationlog.WorkAttendance = Convert.ToDecimal(this.lbWorkAttendance.Text.Trim()); result = ExaminationLogManager.EditExaminationLog(examinationlog, ref error); lbSubmit.Text = result == true ? "修改成功!" : "修改失败:原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "编辑员工考试成绩信息维护" + examinationlog.Id, "编辑成功"); return; } else { Tool.WriteLog(Tool.LogType.Operating, "编辑员工考试成绩信息维护" + examinationlog.Id, "编辑失败!原因:" + error); return; } } }