using HH.Redis.ReisModel;
|
using HH.WMS.Common;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Common;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WMS.DAL.InStock
|
{
|
public class TN_WM_HKINDAL : DapperBaseDAL
|
{
|
#region 更新工单状态
|
/// <summary>
|
/// 更新工单状态
|
/// </summary>
|
/// <param name="woNo">单号</param>
|
/// <param name="examineType">审批状态</param>
|
/// <returns></returns>
|
/// <History>[HANHE(XDL)] CREATED BY 2019-02-20</History>
|
public OperateResult ExamineMst(string woNo, string examineType, RedisUserEntity userEntity, IDbTransaction trans)
|
{
|
OperateResult result = new OperateResult();
|
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append(" UPDATE TN_WM_WORK_ORDER SET CN_S_STATUS=@CN_S_STATUS,CN_S_MODIFY=@CN_S_MODIFY,CN_S_MODIFY_BY=@CN_S_MODIFY_BY,CN_T_MODIFY=@CN_T_MODIFY WHERE CN_S_WO_NO=@CN_S_WO_NO");
|
|
return result = ExecuteTranSql(strSql.ToString(), new
|
{
|
CN_S_STATUS = examineType,
|
CN_S_WO_NO = woNo,
|
CN_S_MODIFY = userEntity.CN_S_LOGIN,
|
CN_S_MODIFY_BY = userEntity.CN_S_NAME,
|
CN_T_MODIFY = DateTime.Now
|
}, trans);
|
}
|
|
#endregion
|
|
#region 查询工单列表
|
/// <summary>
|
/// 查询工单列表
|
/// </summary>
|
/// <param name="searchModel">实体</param>
|
/// <returns></returns>
|
/// <History>[HANHE(XDL)] CREATED BY 2018-12-18</History>
|
public OperateResult GetInOrderList(SearchModel searchModel)
|
{
|
var condition = searchModel.SearchCondition;
|
string ConStr = "where 1=1 ";
|
if (condition != null)
|
{
|
if (!string.IsNullOrEmpty(condition.CN_S_WO_NO.ToString()))
|
{
|
ConStr = ConStr + " and CN_S_WO_NO like '%" + condition.CN_S_WO_NO + "%'";
|
}
|
string state = condition.CN_S_STATUS.ToString();
|
if (!string.IsNullOrEmpty(state))
|
{
|
if (state.IndexOf(",") > 0)
|
{
|
state = "'" + state.Replace(",", "','") + "'";
|
ConStr = ConStr + " and CN_S_STATUS in (" + state + ")";
|
}
|
else
|
{
|
ConStr = ConStr + " and CN_S_STATUS='" + state + "'";
|
}
|
}
|
if (!string.IsNullOrEmpty(condition.CN_T_START.ToString()))
|
{
|
ConStr = ConStr + " and CN_T_CREATE >= '" + Util.ToStringInput(condition.CN_T_START) + " 00:00:00'";
|
}
|
if (!string.IsNullOrEmpty(condition.CN_T_END.ToString()))
|
{
|
ConStr = ConStr + " and CN_T_CREATE <= '" + Util.ToStringInput(condition.CN_T_END) + " 23:59:59'";
|
}
|
|
if (!string.IsNullOrEmpty(condition.CN_S_LINE.ToString()))
|
{
|
ConStr = ConStr + " and CN_S_LINE = '" + condition.CN_S_LINE + "'";
|
}
|
}
|
string sql = @"(select * from TN_WM_WORK_ORDER ) T " + ConStr;
|
|
OperateResult result = new OperateResult();
|
|
return ExecutePagingResult(sql, searchModel.PageIndex, searchModel.PageSize, "", "");
|
}
|
#endregion
|
|
#region 根据产线编号查询该产线正在执行中的工单信息
|
/// <summary>
|
/// 查询到货单列表
|
/// </summary>
|
/// <param name="searchModel">实体</param>
|
/// <returns></returns>
|
/// <History>[HANHE(XDL)] CREATED BY 2018-12-18</History>
|
public List<TN_WM_WORK_ORDEREntity> GetOrderInfoByLine(string lineNo)
|
{
|
StringBuilder ConStr = new StringBuilder();
|
ConStr.Append("where 1=1 ");
|
|
if (!string.IsNullOrEmpty(lineNo))
|
{
|
ConStr.Append(" AND CN_S_LINE = '" + lineNo + "'");
|
}
|
ConStr.Append(" AND CN_S_STATUS = '执行中'");
|
|
string sql = @"select * from TN_WM_WORK_ORDER " + ConStr.ToString();
|
|
OperateResult result = new OperateResult();
|
|
return ExecuteQuery<TN_WM_WORK_ORDEREntity>(sql, null);
|
}
|
#endregion
|
|
}
|
}
|
