using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Common;
|
using Model;
|
using NLog;
|
|
namespace BLL.DAL
|
{
|
public class DALTaskManage
|
{
|
/// <summary>
|
/// 获取任务指令数据集
|
/// </summary>
|
/// <param name="taskManage">查询条件</param>
|
/// <param name="page">分页信息</param>
|
/// <returns>指令数据集合</returns>
|
public IList<TaskManageList> GetTaskManageList(TaskManage taskManage, ref PageInfo page)
|
{
|
try
|
{
|
StringBuilder stringBuilder = new StringBuilder();
|
stringBuilder.Append("select CmdId,(TaskID+ISNULL(NumberNo,'')) as OrdNo,Palno,isnull(Height,0) as Height, CmdType, ");
|
stringBuilder.Append("case CmdType when 'in' then '入库' when 'out' then '出库' when 'to' then '回库' when 'move' then '移库'end as CmdTypeStr ,");
|
stringBuilder.Append("(OldAddre + case ISNULL(NowAddre,'') when '' then '' else ' > '+NowAddre end) as Addre,");
|
stringBuilder.Append("CmdStatu,dbo.GetCmdStatuStr(CMDType,CMDStatu) as CmdStatuStr,");
|
stringBuilder.Append("CreateTime,Demo,case cast(IsDel as varchar) when '0' then '未完成' when '1' then '已完成' end as IsDel,guid ");
|
stringBuilder.Append("from WH_CMD where 1=1 ");
|
|
if (!string.IsNullOrEmpty(taskManage.OrdNo))
|
{
|
stringBuilder.Append("and (TaskID like '%" + taskManage.OrdNo + "%' or NumberNo like '%" + taskManage.OrdNo + "%')");
|
}
|
if (!string.IsNullOrEmpty(taskManage.Addre))
|
{
|
stringBuilder.Append("and (OldAddre like '%" + taskManage.Addre + "%' or NowAddre like '%" + taskManage + "%')");
|
}
|
if (!string.IsNullOrEmpty(taskManage.Palno))
|
{
|
stringBuilder.Append("and Palno like '%" + taskManage.Palno + "%' ");
|
}
|
if (taskManage.BeginTime != DateTime.MinValue && taskManage.BeginTime != null && taskManage.BeginTime != DateTime.MaxValue)
|
{
|
stringBuilder.Append("and CreateTime >= '" + Convert.ToDateTime(taskManage.BeginTime) + "' ");
|
}
|
if (taskManage.EndTime != DateTime.MinValue && taskManage.EndTime != null && taskManage.EndTime != DateTime.MaxValue)
|
{
|
stringBuilder.Append("and CreateTime <= '" + Convert.ToDateTime(taskManage.EndTime).ToShortDateString() + " 23:59:59.999" + "' ");
|
}
|
if (!string.IsNullOrEmpty(taskManage.IsDel))
|
{
|
stringBuilder.Append("and IsDel = '" + taskManage.IsDel + "'");
|
}
|
|
SqlParam[] para = null;
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(stringBuilder.ToString(), para, "CMDID", "Desc", ref page);
|
|
return ModelConvertHelper<TaskManageList>.DataTableToModel(dt);;
|
}
|
catch (Exception ex)
|
{
|
Logger logger = LogManager.GetCurrentClassLogger();
|
logger.Error(ex.Message, "获取任务指令集错误 ");
|
throw new NotImplementedException();
|
}
|
}
|
|
public bool DelCmd(string cmdId,string statu)
|
{
|
bool bl = false;
|
try
|
{
|
StringBuilder sqlString = new StringBuilder();
|
sqlString.Append("select * from WH_CMD where CMDID = '"+cmdId+"' and cmdstatu = '"+ statu + "' and isdel = '0';");
|
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sqlString);
|
if (dt.Rows.Count > 0)
|
{
|
sqlString.Clear();
|
|
string cmdType = dt.Rows[0]["CMDType"].ToString();
|
string cmdStatu = dt.Rows[0]["CMDStatu"].ToString();
|
switch (cmdType)
|
{
|
case "in":
|
if (cmdStatu == "2")
|
{
|
///
|
//string palno = dt.Rows[0]["palno"].ToString();
|
//string ordno = dt.Rows[0]["taskID"].ToString();
|
string addre = dt.Rows[0]["OldAddre"].ToString();
|
//sqlString.Append(" update IPalletBind set Statu = '3',IsDel = '1' ");
|
//sqlString.Append("where PalletNo = '" + palno + "' and OrdNo = '" + ordno + "' and Statu = '2' and IsDel = '0';");
|
sqlString.Append("update DepotsLocation set TurnoverDemand = '02' where LocationCode = '" + addre + "'; ");
|
}
|
break;
|
case "out":
|
; break;
|
case "to":
|
; break;
|
case "move":
|
; break;
|
default:return bl;
|
}
|
|
|
sqlString.Append(" Update WH_CMD set IsDel = '1',demo='手动完成指令' where CMDID = '"+cmdId+ "' and cmdstatu = '" + statu + "';");
|
int rowCount = DataFactory.SqlDataBase().ExecuteBySql(sqlString);
|
if (rowCount > 0)
|
{
|
bl = true;
|
}
|
else
|
{
|
bl = false;
|
}
|
}
|
|
return bl;
|
}
|
catch (Exception ex)
|
{
|
return bl;
|
}
|
}
|
}
|
}
|
