/// <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>
/// <param name="TASK_INFOID">任务信息ID</param>
/// <returns>参见模型</returns>
public static Message Add(TASK_TURNOVER_Model m, string TASK_INFOID)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO TASK_TURNOVER(TASK_INFOID, OPUID, OPTIME, OPSTATUS, OPTITLE, OPIP)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(TASK_INFOID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPUID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPSTATUS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPTITLE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPIP));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
