protected void gvSpcQlt_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string ID = gvSpcQlt.DataKeys[e.RowIndex]["ID"].ToString();
string specialtyKey = gvSpcQlt.DataKeys[e.RowIndex]["SpecialtyKey"].ToString();
CheckBox chkAvailable = (CheckBox)gvSpcQlt.Rows[e.RowIndex].FindControl("chkSpecialtyName");
int available = chkAvailable.Checked ? 1 : 0;
TextBox txtScore = (TextBox)gvSpcQlt.Rows[e.RowIndex].FindControl("txtQualityScore");
string strScore = txtScore.Text.Trim();
decimal? score = !string.IsNullOrEmpty(strScore) ? Convert.ToDecimal(strScore) : 0;
//TextBox txtTimeMultiple = (TextBox)gvSpcQlt.Rows[e.RowIndex].FindControl("txtTimeMultiple");
//string strTimeMultiple = txtTimeMultiple.Text.Trim();
//int? timeMultiple = !string.IsNullOrEmpty(strTimeMultiple) ? Convert.ToInt32(strTimeMultiple) : 1;
TaskAssignConfigDetails tacdModel = new TaskAssignConfigDetails();
tacdModel.ID = ID;
tacdModel.EMPLOYEEID = Request.QueryString["employeeID"].ToString();
tacdModel.SPECIALTYCATEGORY = specialtyKey;
tacdModel.QUALITYSCORE = score;
tacdModel.AVAILABLE = available;
//tacdModel.TIMEMULTIPLE = timeMultiple;
tacdModel.SPECIALTYTYPE = 0;
if (string.IsNullOrEmpty(ID))
{
tacdModel.ID = Guid.NewGuid().ToString();
tacdBll.Add(tacdModel);
}
else
{
tacdBll.Update(tacdModel);
}
gvSpcQlt.EditIndex = -1;
LoadSpecialtyQuality();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TaskAssignConfigDetails model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update taskassignconfigdetails set ");
strSql.Append("EMPLOYEEID=@EMPLOYEEID,");
strSql.Append("SPECIALTYCATEGORY=@SPECIALTYCATEGORY,");
strSql.Append("QUALITYSCORE=@QUALITYSCORE,");
strSql.Append("AVAILABLE=@AVAILABLE,");
strSql.Append("TIMEMULTIPLE=@TIMEMULTIPLE,");
strSql.Append("SPECIALTYTYPE=@SPECIALTYTYPE");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40),
new MySqlParameter("@SPECIALTYCATEGORY", MySqlDbType.VarChar, 2),
new MySqlParameter("@QUALITYSCORE", MySqlDbType.Decimal, 3),
new MySqlParameter("@AVAILABLE", MySqlDbType.Int32, 1),
new MySqlParameter("@TIMEMULTIPLE", MySqlDbType.Int32, 2),
new MySqlParameter("@SPECIALTYTYPE", MySqlDbType.Int32, 1),
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = model.EMPLOYEEID;
parameters[1].Value = model.SPECIALTYCATEGORY;
parameters[2].Value = model.QUALITYSCORE;
parameters[3].Value = model.AVAILABLE;
parameters[4].Value = model.TIMEMULTIPLE;
parameters[5].Value = model.SPECIALTYTYPE;
parameters[6].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TaskAssignConfigDetails model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into taskassignconfigdetails(");
strSql.Append("ID,EMPLOYEEID,SPECIALTYCATEGORY,QUALITYSCORE,AVAILABLE,TIMEMULTIPLE,SPECIALTYTYPE)");
strSql.Append(" values (");
strSql.Append("@ID,@EMPLOYEEID,@SPECIALTYCATEGORY,@QUALITYSCORE,@AVAILABLE,@TIMEMULTIPLE,@SPECIALTYTYPE)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40),
new MySqlParameter("@EMPLOYEEID", MySqlDbType.VarChar, 40),
new MySqlParameter("@SPECIALTYCATEGORY", MySqlDbType.VarChar, 2),
new MySqlParameter("@QUALITYSCORE", MySqlDbType.Decimal, 3),
new MySqlParameter("@AVAILABLE", MySqlDbType.Int32, 1),
new MySqlParameter("@TIMEMULTIPLE", MySqlDbType.Int32, 2),
new MySqlParameter("@SPECIALTYTYPE", MySqlDbType.Int32, 1)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.EMPLOYEEID;
parameters[2].Value = model.SPECIALTYCATEGORY;
parameters[3].Value = model.QUALITYSCORE;
parameters[4].Value = model.AVAILABLE;
parameters[5].Value = model.TIMEMULTIPLE;
parameters[6].Value = model.SPECIALTYTYPE;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TaskAssignConfigDetails DataRowToModel(DataRow row)
{
TaskAssignConfigDetails model = new TaskAssignConfigDetails();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["EMPLOYEEID"] != null)
{
model.EMPLOYEEID = row["EMPLOYEEID"].ToString();
}
if (row["SPECIALTYCATEGORY"] != null)
{
model.SPECIALTYCATEGORY = row["SPECIALTYCATEGORY"].ToString();
}
if (row["QUALITYSCORE"] != null && row["QUALITYSCORE"].ToString() != "")
{
model.QUALITYSCORE = decimal.Parse(row["QUALITYSCORE"].ToString());
}
if (row["AVAILABLE"] != null && row["AVAILABLE"].ToString() != "")
{
model.AVAILABLE = int.Parse(row["AVAILABLE"].ToString());
}
if (row["TIMEMULTIPLE"] != null && row["TIMEMULTIPLE"].ToString() != "")
{
model.TIMEMULTIPLE = int.Parse(row["TIMEMULTIPLE"].ToString());
}
if (row["SPECIALTYTYPE"] != null && row["SPECIALTYTYPE"].ToString() != "")
{
model.SPECIALTYTYPE = int.Parse(row["SPECIALTYTYPE"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TaskAssignConfigDetails GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,EMPLOYEEID,SPECIALTYCATEGORY,QUALITYSCORE,AVAILABLE,TIMEMULTIPLE,SPECIALTYTYPE from taskassignconfigdetails ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = ID;
TaskAssignConfigDetails model = new TaskAssignConfigDetails();
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(TaskAssignConfigDetails model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TaskAssignConfigDetails model)
{
return(dal.Add(model));
}
