/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Update(TASK_FEEDBACK_Model m) { List <string> sqllist = new List <string>(); if (!string.IsNullOrEmpty(m.OHID) || !string.IsNullOrEmpty(m.NHID)) { if (!string.IsNullOrEmpty(m.OHID)) { var OHID = m.OHID.Split(','); for (int i = 0; i < OHID.Length; i++)//更新原有护林员的状态 { StringBuilder sb = new StringBuilder(); sb.AppendFormat("update TASK_FEEDBACK set "); //sb.AppendFormat(" HID= '{0}',", ClsSql.EncodeSql(OHID[i])); sb.AppendFormat(" RECEIVETIME='{0}',", ClsSql.EncodeSql(m.RECEIVETIME)); sb.AppendFormat(" ACCEPTTIME= '{0}',", ClsSql.EncodeSql(m.ACCEPTTIME)); sb.AppendFormat(" FEEDBACKTIME= '{0}',", ClsSql.EncodeSql(m.FEEDBACKTIME)); sb.AppendFormat(" FEEDBACKCONTENT= '{0}',", ClsSql.EncodeSql(m.FEEDBACKCONTENT)); sb.AppendFormat(" FEEDBACKSTATUS= '{0}'", "-1"); sb.AppendFormat(" where TASK_INFOID = '{0}'", ClsSql.EncodeSql(m.TASK_INFOID)); sb.AppendFormat(" and HID = '{0}'", ClsSql.EncodeSql(OHID[i])); sqllist.Add(sb.ToString()); } } if (!string.IsNullOrEmpty(m.NHID)) { var NHID = m.NHID.Split(','); StringBuilder sbInsert = new StringBuilder(); sbInsert.AppendFormat("INSERT INTO TASK_FEEDBACK(HID, TASK_INFOID, RECEIVETIME, ACCEPTTIME, FEEDBACKTIME, FEEDBACKCONTENT, FEEDBACKSTATUS)"); for (int i = 0; i < NHID.Length; i++) { sbInsert.AppendFormat(" select '{0}'", ClsSql.EncodeSql(NHID[i])); //护林员id sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.TASK_INFOID)); //任务id sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.RECEIVETIME)); //接收时间 sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ACCEPTTIME)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKTIME)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKCONTENT)); sbInsert.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKSTATUS)); sbInsert.AppendFormat(" UNION ALL "); } string insertStr = sbInsert.ToString(); if (insertStr.Contains(" UNION ALL ")) { insertStr = insertStr.Substring(0, insertStr.Length - 10); sqllist.Add(insertStr); } } var j = DataBaseClass.ExecuteSqlTran(sqllist); if (j > 0) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } } return(new Message(true, "修改成功!", "")); }
/// <summary> /// 任务增删改 /// </summary> /// <param name="m"></param> /// <param name="m1"></param> /// <param name="m2"></param> /// <returns></returns> public static Message Manager(TASK_INFO_Model m, TASK_FEEDBACK_Model m1, TASK_TURNOVER_Model m2) { if (m.opMethod == "Add") { Message msgUser = BaseDT.TASK_INFO.Add(m); //任务信息表 var TASK_INFOID = msgUser.Url; //获得添加记录的TASK_INFOID Message msgUser1 = BaseDT.TASK_FEEDBACK.Add(m1, TASK_INFOID); //任务反馈表 Message msgUser2 = BaseDT.TASK_TURNOVER.Add(m2, TASK_INFOID); //流转表 return(new Message(msgUser2.Success, msgUser2.Msg, msgUser2.Url)); } else if (m.opMethod == "Del") { Message msgUser = BaseDT.TASK_INFO.Del(m); Message msgUser1 = BaseDT.TASK_FEEDBACK.Del(m1); Message msgUser2 = BaseDT.TASK_TURNOVER.Add(m2, m.TASK_INFOID);//流转表 return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } else if (m.opMethod == "Mdy") { Message msgUser = BaseDT.TASK_INFO.Update(m); Message msgUser1 = BaseDT.TASK_FEEDBACK.Update(m1); Message msgUser2 = BaseDT.TASK_TURNOVER.Add(m2, m.TASK_INFOID);//流转表 return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } else if (m.opMethod == "End") { Message msgUser = BaseDT.TASK_INFO.Update(m); //Message msgUser1 = BaseDT.TASK_FEEDBACK.Update(m1); Message msgUser2 = BaseDT.TASK_TURNOVER.Add(m2, m.TASK_INFOID);//流转表 return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 删除 /// </summary> /// <param name="m"></param> /// <returns></returns> public static Message Del(TASK_FEEDBACK_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete from TASK_FEEDBACK"); sb.AppendFormat(" where 1=1 "); if (string.IsNullOrEmpty(m.TASK_INFOID) == false) { sb.AppendFormat(" AND TASK_INFOID = '{0}'", ClsSql.EncodeSql(m.TASK_INFOID)); } bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败!", "")); } }
/// <summary> /// 根据查询条件获取某一条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static TASK_FEEDBACK_Model getModel(TASK_FEEDBACK_SW sw) { TASK_FEEDBACK_Model m = new TASK_FEEDBACK_Model(); DataTable dt = BaseDT.TASK_FEEDBACK.getDT(sw);//列表 if (dt.Rows.Count > 0) { int i = 0; m.TASK_FEEDBACKID = dt.Rows[i]["TASK_FEEDBACKID"].ToString(); m.HID = dt.Rows[i]["HID"].ToString(); m.TASK_INFOID = dt.Rows[i]["TASK_INFOID"].ToString(); m.RECEIVETIME = dt.Rows[i]["RECEIVETIME"].ToString(); m.ACCEPTTIME = dt.Rows[i]["ACCEPTTIME"].ToString(); m.FEEDBACKTIME = dt.Rows[i]["FEEDBACKTIME"].ToString(); m.HNAME = BaseDT.T_IPSFR_USER.getName(dt.Rows[i]["HID"].ToString()); m.FEEDBACKCONTENT = dt.Rows[i]["FEEDBACKCONTENT"].ToString(); m.FEEDBACKSTATUS = dt.Rows[i]["FEEDBACKSTATUS"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 根据查询条件获取列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <TASK_FEEDBACK_Model> getModelList(TASK_FEEDBACK_SW sw) { var result = new List <TASK_FEEDBACK_Model>(); DataTable dt = BaseDT.TASK_FEEDBACK.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { TASK_FEEDBACK_Model m = new TASK_FEEDBACK_Model(); m.TASK_FEEDBACKID = dt.Rows[i]["TASK_FEEDBACKID"].ToString(); m.HID = dt.Rows[i]["HID"].ToString(); m.TASK_INFOID = dt.Rows[i]["TASK_INFOID"].ToString(); m.RECEIVETIME = dt.Rows[i]["RECEIVETIME"].ToString(); m.ACCEPTTIME = dt.Rows[i]["ACCEPTTIME"].ToString(); m.FEEDBACKTIME = dt.Rows[i]["FEEDBACKTIME"].ToString(); m.HNAME = BaseDT.T_IPSFR_USER.getName(dt.Rows[i]["HID"].ToString()); m.FEEDBACKCONTENT = dt.Rows[i]["FEEDBACKCONTENT"].ToString(); m.FEEDBACKSTATUS = dt.Rows[i]["FEEDBACKSTATUS"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 添加 /// </summary> /// <param name="m">model</param> /// <param name="TASK_INFOID">任务序号</param> /// <returns></returns> public static Message Add(TASK_FEEDBACK_Model m, string TASK_INFOID) { List <string> sqllist = new List <string>(); var HID = m.HID.Split(','); StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO TASK_FEEDBACK(HID, TASK_INFOID, RECEIVETIME, ACCEPTTIME, FEEDBACKTIME, FEEDBACKCONTENT, FEEDBACKSTATUS)"); for (int i = 0; i < HID.Length; i++) { sb.AppendFormat(" select '{0}'", ClsSql.EncodeSql(HID[i])); //护林员id sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(TASK_INFOID)); //任务id sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.RECEIVETIME)); //接收时间 sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ACCEPTTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKCONTENT)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FEEDBACKSTATUS)); sb.AppendFormat(" UNION ALL "); } string insertStr = sb.ToString(); if (insertStr.Contains(" UNION ALL ")) { insertStr = insertStr.Substring(0, insertStr.Length - 10); sqllist.Add(insertStr); } var j = DataBaseClass.ExecuteSqlTran(sqllist); if (j > 0) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }