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