using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.ComponentModel.Design;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using WMS.Entity.BllAsnEntity;
|
using WMS.Entity.BllCheckEntity;
|
using WMS.Entity.BllSoEntity;
|
using WMS.Entity.Context;
|
using WMS.Entity.LogEntity;
|
using WMS.Entity.SysEntity;
|
|
namespace WMS.DAL
|
{
|
public class Common
|
{
|
//public static readonly DataContext Db = new DataContext();
|
|
|
/// <summary>
|
/// 获取深度为1的储位号（根据深度为2的储位号）
|
/// </summary>
|
/// <param name="houseNo">仓库号</param>
|
/// <param name="locateNo">储位号</param>
|
/// <returns></returns>
|
public SysStorageLocat GetLocateNoDepth1(string houseNo, string locateNo)
|
{
|
try
|
{
|
var Db = DataContext.Db;
|
var ceshi = Db.Queryable<SysStorageLocat>()
|
.Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && m.LocatNo == locateNo).ToList();
|
|
//获取储位信息
|
var sql = $@"select * from SysStorageLocat where WareHouseNo = '{houseNo}' and LocatNo = '{locateNo}'; ";
|
var locate = Db.Ado.SqlQuery<SysStorageLocat>(sql).First();
|
if (locate == null)
|
{
|
throw new Exception($"未查询到仓库号为{houseNo}、储位号为{locateNo}的信息");
|
}
|
//获取深度为2的储位信息
|
var sql2 = $@"select * from SysStorageLocat where WareHouseNo = '{houseNo}' and row = {locate.Row} and [Column] = {locate.Column} and Layer = {locate.Layer} and Depth = '01'; ";
|
var data = Db.Ado.SqlQuery<SysStorageLocat>(sql2).First();
|
if (data == null)
|
{
|
throw new Exception($"未查询到仓库号为{houseNo}、储位号为{locateNo}的里面储位信息");
|
}
|
|
return data;
|
}
|
catch (Exception e)
|
{
|
throw new Exception(e.Message);
|
}
|
}
|
/// <summary>
|
/// 获取深度为2的储位号（根据深度为1的储位号）
|
/// </summary>
|
/// <param name="houseNo">仓库号</param>
|
/// <param name="locateNo">储位号</param>
|
/// <returns></returns>
|
public SysStorageLocat GetLocateNoDepth2(string houseNo, string locateNo)
|
{
|
try
|
{
|
var Db = DataContext.Db;
|
//获取储位信息
|
var sql = $@"select * from SysStorageLocat where WareHouseNo = '{houseNo}' and LocatNo = '{locateNo}'; ";
|
var locate = Db.Ado.SqlQuery<SysStorageLocat>(sql).First();
|
if (locate == null)
|
{
|
throw new Exception($"未查询到仓库号为{houseNo}、储位号为{locateNo}的信息");
|
}
|
//获取深度为2的储位信息
|
var sql2 = $@"select * from SysStorageLocat where WareHouseNo = '{houseNo}' and row = {locate.Row} and [Column] = {locate.Column} and Layer = {locate.Layer} and Depth = '02'; ";
|
var data = Db.Ado.SqlQuery<SysStorageLocat>(sql2).First();
|
if (data == null)
|
{
|
throw new Exception($"未查询到仓库号为{houseNo}、储位号为{locateNo}的里面储位信息");
|
}
|
return data;
|
}
|
catch (Exception e)
|
{
|
throw new Exception(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 根据前缀获取最大单据号
|
/// </summary>
|
/// <param name="codeFlag">单据前缀</param>
|
/// <returns></returns>
|
public string GetMaxNo(string codeFlag)
|
{
|
try
|
{
|
var maxNo = "";
|
//获取异常号
|
maxNo = SelectMaxNo(codeFlag);
|
if (!string.IsNullOrEmpty(maxNo))
|
{
|
maxNo = maxNo.Substring(codeFlag.Length);
|
}
|
//获取数据库时间八位
|
string date = DateTime.Now.ToString("yyyyMMdd").Trim();
|
string no = "";
|
if (string.IsNullOrEmpty(maxNo))
|
{
|
no = codeFlag + date + "00001";
|
}
|
else
|
{
|
if (maxNo.Substring(0, 8) == date)
|
{
|
int lastNo = Convert.ToInt32(maxNo.Substring(8, 5)) + 1;
|
no = codeFlag + date + (lastNo.ToString().PadLeft(5, '0'));
|
}
|
else
|
{
|
no = codeFlag + date + "00001";
|
}
|
}
|
return no;
|
}
|
catch (Exception e)
|
{
|
Console.WriteLine(e);
|
throw;
|
}
|
}
|
/// <summary>
|
/// 根据前缀判断出当前最大单据号
|
/// </summary>
|
/// <param name="codeFlag">单据前缀</param>
|
/// <returns></returns>
|
public string SelectMaxNo(string codeFlag)
|
{
|
try
|
{
|
string orderNo = "";
|
if (codeFlag == InOutFlag.SO.ToString())//出库
|
{
|
var list = DataContext.Db.Queryable<BllExportNotice>().Where(m => m.SONo.StartsWith("SO")).ToList();
|
orderNo = list.Max(a => a.SONo);
|
}
|
if (codeFlag == InOutFlag.WSO.ToString())//波次出库
|
{
|
}
|
else if (codeFlag == InOutFlag.ASN.ToString())//入库
|
{
|
var list = DataContext.Db.Queryable<BllArrivalNotice>().Where(m => m.ASNNo.StartsWith("ASN")).ToList();
|
orderNo = list.Select(a => a.ASNNo).Max();
|
}
|
else if (codeFlag == InOutFlag.PM.ToString())//移库
|
{
|
}
|
else if (codeFlag == InOutFlag.CR.ToString())//盘点
|
{
|
var list = DataContext.Db.Queryable<BllStockCheck>().Where(m => m.CRNo.StartsWith("CR")).ToList();
|
orderNo = list.Select(a => a.CRNo).Max();
|
}
|
else if (codeFlag == InOutFlag.TK.ToString())//任务
|
{
|
var list = DataContext.Db.Queryable<LogTask>().Where(m => m.TaskNo.StartsWith("TK")).ToList();
|
orderNo = list.Max(m=>m.TaskNo);
|
}
|
else if (codeFlag == InOutFlag.EX.ToString())//异常
|
{
|
var list = DataContext.Db.Queryable<SysException>().Where(m => m.ExceptionNo.StartsWith("EX")).ToList();
|
orderNo = list.Max(a => a.ExceptionNo);
|
}
|
|
return orderNo;
|
}
|
catch (Exception e)
|
{
|
throw new Exception(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 执行sql语句获取行数
|
/// </summary>
|
/// <param name="sqlString">查询语句</param>
|
/// <returns>行数</returns>
|
public int GetRowCount(string sqlString)
|
{
|
try
|
{
|
var db = DataContext.Db;
|
var rowCount = db.Ado.GetInt(sqlString);
|
|
return rowCount;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 判断托盘是否在入库中
|
/// </summary>
|
/// <param name="palletNo">托盘号</param>
|
/// <returns></returns>
|
public LogTask GetImTask(string palletNo)
|
{
|
try
|
{
|
var db = DataContext.Db;
|
//查询托盘是否有正在入库的任务
|
var imTask = db.Queryable<LogTask>().First(m => m.PalletNo == palletNo && m.IsDel == "0" && m.Status == "1");
|
|
return imTask;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.Message);
|
}
|
}
|
|
}
|
public enum InOutFlag
|
{
|
/// <summary>
|
/// 入库单
|
/// </summary>
|
[Description("入库单")]
|
ASN,
|
/// <summary>
|
/// 出库单
|
/// </summary>
|
[Description("出库单")]
|
SO,
|
/// <summary>
|
/// 波次出库单
|
/// </summary>
|
[Description("波次出库单")]
|
WSO,
|
/// <summary>
|
/// 出库单
|
/// </summary>
|
[Description("盘点单")]
|
CR,
|
/// <summary>
|
/// 移库单
|
/// </summary>
|
[Description("移库单")]
|
PM,
|
|
/// <summary>
|
/// 任务
|
/// </summary>
|
[Description("任务")]
|
TK,
|
/// <summary>
|
/// 异常号
|
/// </summary>
|
[Description("异常")]
|
EX
|
}
|
}
|
