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