/// <summary> /// 更新一条数据 /// </summary> public bool Update(TaskAssignConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update taskassignconfig set "); strSql.Append("EMPLOYEEID=@EMPLOYEEID,"); strSql.Append("AVAILABLE=@AVAILABLE,"); strSql.Append("TARGETAMOUNT=@TARGETAMOUNT,"); strSql.Append("TIMEMULTIPLE=@TIMEMULTIPLE"); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@AVAILABLE", MySqlDbType.Decimal, 1), new MySqlParameter("@TARGETAMOUNT", MySqlDbType.Decimal, 8), new MySqlParameter("@TIMEMULTIPLE", MySqlDbType.Int32, 2), new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = model.EMPLOYEEID; parameters[1].Value = model.AVAILABLE; parameters[2].Value = model.TARGETAMOUNT; parameters[3].Value = model.TIMEMULTIPLE; parameters[4].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void gvEmpTaskAssignConfig_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string taskAssignID = gvEmpTaskAssignConfig.DataKeys[e.Row.RowIndex].Value.ToString(); TaskAssignConfig taskAssign = new TaskAssignConfig(); taskAssign = taBll.GetModel(taskAssignID); // 如果显示隐藏的复选框没选中,默认不显示禁用的数据 if (!cbxShowVisible.Checked && taskAssign.AVAILABLE == 0) { e.Row.Visible = false; } HiddenField hidEmpID = e.Row.FindControl("hidEmpID") as HiddenField; DataTable dt = tacdBll.GetTaskAssignDetails(hidEmpID.Value, "0").Tables[0]; StringBuilder sbTip = new StringBuilder(); if (dt != null && dt.Rows.Count > 0) { dt.AsEnumerable().Where(item => item.Field <Int64>("available") == 1).ToList().ForEach(item => sbTip.Append(item.Field <string>("specialtyName") + ":" + string.Format("{0:0.##}", item.Field <decimal>("QUALITYSCORE")) + ",")); } sbTip.Append("<br/>预期目标:" + string.Format("{0:0.##}", taskAssign.TARGETAMOUNT) + ",工时倍数:" + taskAssign.TIMEMULTIPLE + "<br/>"); Label lblTip = e.Row.FindControl("lblTip") as Label; if (lblTip != null) { lblTip.Text = sbTip.ToString(); } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TaskAssignConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into taskassignconfig("); strSql.Append("ID,EMPLOYEEID,AVAILABLE,TARGETAMOUNT,TIMEMULTIPLE)"); strSql.Append(" values ("); strSql.Append("@ID,@EMPLOYEEID,@AVAILABLE,@TARGETAMOUNT,@TIMEMULTIPLE)"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40), new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40), new MySqlParameter("@AVAILABLE", MySqlDbType.Decimal, 1), new MySqlParameter("@TARGETAMOUNT", MySqlDbType.Decimal, 8), new MySqlParameter("@TIMEMULTIPLE", MySqlDbType.Int32, 2) }; parameters[0].Value = model.ID; parameters[1].Value = model.EMPLOYEEID; parameters[2].Value = model.AVAILABLE; parameters[3].Value = model.TARGETAMOUNT; parameters[4].Value = model.TIMEMULTIPLE; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TaskAssignConfig DataRowToModel(DataRow row) { TaskAssignConfig model = new TaskAssignConfig(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["EMPLOYEEID"] != null) { model.EMPLOYEEID = row["EMPLOYEEID"].ToString(); } if (row["AVAILABLE"] != null && row["AVAILABLE"].ToString() != "") { model.AVAILABLE = decimal.Parse(row["AVAILABLE"].ToString()); } if (row["TARGETAMOUNT"] != null && row["TARGETAMOUNT"].ToString() != "") { model.TARGETAMOUNT = decimal.Parse(row["TARGETAMOUNT"].ToString()); } if (row["TIMEMULTIPLE"] != null && row["TIMEMULTIPLE"].ToString() != "") { model.TIMEMULTIPLE = int.Parse(row["TIMEMULTIPLE"].ToString()); } } return(model); }
protected void gvEmpTaskAssignConfig_RowUpdating(object sender, GridViewUpdateEventArgs e) { string taskAssignID = gvEmpTaskAssignConfig.DataKeys[e.RowIndex].Value.ToString(); TaskAssignConfig taskAssign = new TaskAssignConfig(); taskAssign = taBll.GetModel(taskAssignID); taskAssign.AVAILABLE = taskAssign.AVAILABLE == 0 ? 1 : 0; if (taBll.Update(taskAssign)) { LoadTaskAssignList(); } }
protected void btnSaveTimeMultiple_Click(object sender, EventArgs e) { string employeeID = Convert.ToString(Request.QueryString["employeeID"]); DataTable dt = tacBll.GetList("employeeID = '" + employeeID + "'").Tables[0]; if (dt != null && dt.Rows.Count > 0) { string ID = Convert.ToString(dt.Rows[0]["ID"]); TaskAssignConfig tacModel = new TaskAssignConfig(); tacModel = tacBll.GetModel(ID); tacModel.TIMEMULTIPLE = Convert.ToInt32(txtTimeMultiple.Text.Trim()); tacBll.Update(tacModel); LoadEmpTargetAmountAndTimeMultiple(); ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "alert('修改成功');", true); } }
protected void btnSaveTargetAmount_Click(object sender, EventArgs e) { #region Fold //string employeeID = Request.QueryString["employeeID"]; //foreach (ListItem item in cblstSpecialtyMinor.Items) //{ // string specialtyKey = item.Value; // DataTable dt = tacdBll.GetTaskAssignDetails(Convert.ToString(Request.QueryString["employeeID"]), "1").Tables[0]; // if (dt != null && dt.Rows.Count > 0) // { // DataRow[] dr = dt.Select("specialtyKey = '" + specialtyKey + "'"); // if (dr.Length > 0) // { // string ID = Convert.ToString(dr[0]["ID"]); // TaskAssignConfigDetails tacdModel = new TaskAssignConfigDetails(); // tacdModel.ID = ID; // tacdModel.EMPLOYEEID = employeeID; // tacdModel.SPECIALTYCATEGORY = specialtyKey; // tacdModel.AVAILABLE = item.Selected ? 1 : 0; // tacdModel.SPECIALTYTYPE = 1; // if (string.IsNullOrEmpty(ID)) // { // tacdModel.ID = Guid.NewGuid().ToString(); // tacdBll.Add(tacdModel); // } // else // { // tacdBll.Update(tacdModel); // } // } // } //} #endregion string employeeID = Convert.ToString(Request.QueryString["employeeID"]); DataTable dt = tacBll.GetList("employeeID = '" + employeeID + "'").Tables[0]; if (dt != null && dt.Rows.Count > 0) { string ID = Convert.ToString(dt.Rows[0]["ID"]); TaskAssignConfig tacModel = new TaskAssignConfig(); tacModel = tacBll.GetModel(ID); tacModel.TARGETAMOUNT = Convert.ToDecimal(txtTargetAmount.Text.Trim()); tacBll.Update(tacModel); LoadEmpTargetAmountAndTimeMultiple(); ClientScript.RegisterClientScriptBlock(this.GetType(), Guid.NewGuid().ToString(), "alert('修改成功');", true); } }
protected void btnAddToList_Click(object sender, EventArgs e) { string employeeID = ddlEmployeeName.SelectedValue; TaskAssignConfig taskAssign = new TaskAssignConfig(); taskAssign.ID = Guid.NewGuid().ToString(); taskAssign.EMPLOYEEID = employeeID; taskAssign.AVAILABLE = 1; if (!taBll.ExistsByEmployeeID(employeeID)) { if (!taBll.Add(taskAssign)) { LogHelper.WriteLine("添加员工到专业分配表失败"); } } LoadEmployee(); LoadTaskAssignList(); }
/// <summary> /// 得到一个对象实体 /// </summary> public TaskAssignConfig GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,EMPLOYEEID,AVAILABLE,TARGETAMOUNT,TIMEMULTIPLE from taskassignconfig "); strSql.Append(" where ID=@ID "); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.VarChar, 40) }; parameters[0].Value = ID; TaskAssignConfig model = new TaskAssignConfig(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TaskAssignConfig model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TaskAssignConfig model) { return(dal.Add(model)); }