/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.Sys_Task DataRowToModel(DataRow row)
{
XHD.Model.Sys_Task model = new XHD.Model.Sys_Task();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["ItemName"] != null)
{
model.ItemName = row["ItemName"].ToString();
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
if (row["CreatePersonName"] != null)
{
model.CreatePersonName = row["CreatePersonName"].ToString();
}
if (row["CreatePersonId"] != null && row["CreatePersonId"].ToString() != "")
{
model.CreatePersonId = int.Parse(row["CreatePersonId"].ToString());
}
if (row["CreatePDtypeId"] != null && row["CreatePDtypeId"].ToString() != "")
{
model.CreatePDtypeId = int.Parse(row["CreatePDtypeId"].ToString());
}
if (row["IsCheck"] != null && row["IsCheck"].ToString() != "")
{
if ((row["IsCheck"].ToString() == "1") || (row["IsCheck"].ToString().ToLower() == "true"))
{
model.IsCheck = true;
}
else
{
model.IsCheck = false;
}
}
if (row["CheckPId"] != null && row["CheckPId"].ToString() != "")
{
model.CheckPId = int.Parse(row["CheckPId"].ToString());
}
if (row["ItemContent"] != null)
{
model.ItemContent = row["ItemContent"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.Sys_Task GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ItemName,CreateDate,CreatePersonName,CreatePersonId,CreatePDtypeId,IsCheck,CheckPId,apply_userId,apply_userName,ItemContent,taskItme_Id,taskItme_Name,task_classify from Sys_Task ");
strSql.Append(" where Id=@Id limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = Id;
XHD.Model.Sys_Task model = new XHD.Model.Sys_Task();
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 int Add(XHD.Model.Sys_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Task(");
strSql.Append("Factory_Id,ItemName,CreateDate,CreatePersonName,CreatePersonId,CreatePDtypeId,IsCheck,CheckPId,apply_userId,apply_userName,ItemContent,taskItme_Id,taskItme_Name,task_classify)");
strSql.Append(" values (");
strSql.Append("@Factory_Id,@ItemName,@CreateDate,@CreatePersonName,@CreatePersonId,@CreatePDtypeId,@IsCheck,@CheckPId,@apply_userId,@apply_userName,@ItemContent,@taskItme_Id,@taskItme_Name,@task_classify)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60),
new MySqlParameter("@ItemName", MySqlDbType.VarChar, 50),
new MySqlParameter("@CreateDate", MySqlDbType.Date),
new MySqlParameter("@CreatePersonName", MySqlDbType.VarChar, 50),
new MySqlParameter("@CreatePersonId", MySqlDbType.Int32, 11),
new MySqlParameter("@CreatePDtypeId", MySqlDbType.Int32, 11),
new MySqlParameter("@IsCheck", MySqlDbType.TinyText, 4),
new MySqlParameter("@CheckPId", MySqlDbType.Int32, 11),
new MySqlParameter("@apply_userId", MySqlDbType.VarChar, 500),
new MySqlParameter("@apply_userName", MySqlDbType.VarChar, 500),
new MySqlParameter("@ItemContent", MySqlDbType.Text),
new MySqlParameter("@taskItme_Id", MySqlDbType.Int32, 11),
new MySqlParameter("@taskItme_Name", MySqlDbType.VarChar, 100),
new MySqlParameter("@task_classify", MySqlDbType.VarChar, 1)
};
parameters[0].Value = model.Factory_Id;
parameters[1].Value = model.ItemName;
parameters[2].Value = model.CreateDate;
parameters[3].Value = model.CreatePersonName;
parameters[4].Value = model.CreatePersonId;
parameters[5].Value = model.CreatePDtypeId;
parameters[6].Value = model.IsCheck;
parameters[7].Value = model.CheckPId;
parameters[8].Value = model.apply_userId;
parameters[9].Value = model.apply_userName;
parameters[10].Value = model.ItemContent;
parameters[11].Value = model.taskItme_Id;
parameters[12].Value = model.taskItme_Name;
parameters[13].Value = model.task_classify;
//int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
//if (rows > 0)
//{
// return true;
//}
//else
//{
// return false;
//}
object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XHD.Model.Sys_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Task set ");
strSql.Append("ItemName=@ItemName,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("CreatePersonName=@CreatePersonName,");
strSql.Append("CreatePersonId=@CreatePersonId,");
strSql.Append("CreatePDtypeId=@CreatePDtypeId,");
strSql.Append("IsCheck=@IsCheck,");
strSql.Append("CheckPId=@CheckPId,");
strSql.Append("apply_userId=@apply_userId,");
strSql.Append("apply_userName=@apply_userName,");
strSql.Append("ItemContent=@ItemContent,");
strSql.Append("taskItme_Id=@taskItme_Id,");
strSql.Append("taskItme_Name=@taskItme_Name");
//strSql.Append("task_classify=@task_classify ");
strSql.Append(" where Id=@Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ItemName", MySqlDbType.VarChar, 50),
new MySqlParameter("@CreateDate", MySqlDbType.Date),
new MySqlParameter("@CreatePersonName", MySqlDbType.VarChar, 50),
new MySqlParameter("@CreatePersonId", MySqlDbType.Int32, 11),
new MySqlParameter("@CreatePDtypeId", MySqlDbType.Int32, 11),
new MySqlParameter("@IsCheck", MySqlDbType.TinyText, 4),
new MySqlParameter("@CheckPId", MySqlDbType.Int32, 11),
new MySqlParameter("@apply_userId", MySqlDbType.VarChar, 500),
new MySqlParameter("@apply_userName", MySqlDbType.VarChar, 500),
new MySqlParameter("@ItemContent", MySqlDbType.Text),
new MySqlParameter("@taskItme_Id", MySqlDbType.Int32, 11),
new MySqlParameter("@taskItme_Name", MySqlDbType.VarChar, 100),
//new MySqlParameter("@task_classify",MySqlDbType.VarChar,1),
new MySqlParameter("@Id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.ItemName;
parameters[1].Value = model.CreateDate;
parameters[2].Value = model.CreatePersonName;
parameters[3].Value = model.CreatePersonId;
parameters[4].Value = model.CreatePDtypeId;
parameters[5].Value = model.IsCheck;
parameters[6].Value = model.CheckPId;
parameters[7].Value = model.apply_userId;
parameters[8].Value = model.apply_userName;
parameters[9].Value = model.ItemContent;
parameters[10].Value = model.taskItme_Id;
parameters[11].Value = model.taskItme_Name;
//parameters[12].Value = model.task_classify;
parameters[12].Value = model.Id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//修改标准
public bool UpdateStandard(XHD.Model.Sys_Task model, DataTable dt)
{
return(dal.UpdateStandard(model, dt));
}
//修改任务及标准
public bool UpdateStandard(XHD.Model.Sys_Task model, DataTable dt)
{
List <string> strSqlList = new List <string>();
string strSql = string.Empty;
strSql = string.Format(@" update Sys_Task set ItemName='{0}',CreateDate='{1}',CreatePersonName='{2}',CreatePersonId='{3}',CreatePDtypeId='{4}',IsCheck='{5}',CheckPId='{6}',apply_userId='{7}',
apply_userName='******',ItemContent='{9}',taskItme_Id='{10}',taskItme_Name='{11}' where Id='{12}'",
model.ItemName, model.CreateDate, model.CreatePersonName, model.CreatePersonId, model.CreatePDtypeId, model.IsCheck, model.CheckPId, model.apply_userId,
model.apply_userName, model.ItemContent, model.taskItme_Id, model.taskItme_Name, model.Id);
strSqlList.Add(strSql);
string oldstandIdList = string.Empty;
string newstandIdList = string.Empty;
DataSet df = GetList(" task_id ='" + model.Id + "'");
if (df != null && df.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < df.Tables[0].Rows.Count; i++)
{
if (i == df.Tables[0].Rows.Count - 1)
{
oldstandIdList += "'" + df.Tables[0].Rows[i]["id"].ToString() + "'";
}
else
{
oldstandIdList += "'" + df.Tables[0].Rows[i]["id"].ToString() + "',";
}
}
}
string[] oldIdList = oldstandIdList.Split(',');
List <string> list = new List <string>();
foreach (var items in oldIdList)
{
if (!list.Contains(items))
{
list.Add(items);
}
}
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["id"].ToString() != "undefined")
{
if (dt.Rows[i]["id"].ToString() != "0")
{
if (i == dt.Rows.Count)
{
newstandIdList += "'" + dt.Rows[i]["id"].ToString() + "'";
}
else
{
newstandIdList += "'" + dt.Rows[i]["id"].ToString() + "',";
}
strSql = string.Format(@"update ims_check_task_standard set standard_name='{0}',standard_score='{1}',standard_remarks='{2}' where task_id='{3}' and id='{4}'",
dt.Rows[i]["standard"].ToString(), Convert.ToDecimal(dt.Rows[i]["standardScore"]), "", model.Id, Convert.ToInt32(dt.Rows[i]["id"].ToString()));
strSqlList.Add(strSql);
}
else
{
strSql = string.Format(@"insert into ims_check_task_standard(task_id,standard_name,standard_score,standard_remarks) values ('{0}','{1}','{2}','{3}')",
model.Id, dt.Rows[i]["standard"].ToString(), Convert.ToDecimal(dt.Rows[i]["standardScore"]), "");
strSqlList.Add(strSql);
}
}
}
}
string[] newList = newstandIdList.Split(',');
foreach (var idlsit in newList)
{
if (list.Contains(idlsit))
{
list.Remove(idlsit);
}
}
newList = list.ToArray();
if (newList.Length > 0)
{
strSql = string.Format(@" delete from ims_check_task_standard where id in ({0})", newList);
strSqlList.Add(strSql);
}
int rows = DbHelperMySQL.ExecuteSqlTran(strSqlList);
if (rows >= 0)
{
return(true);
}
else
{
return(false);
}
}
