/// <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, "添加失败，请检查各输入框是否正确！", ""));
}
}
