智能立体仓储WMS库位分配C#实现

作者：weixin_40725706 | 2024-03-01 01:57:56

踩

智能立体仓储WMS库位分配C#实现

using System;
using System.Collections.Generic;
using Mirle.Def;
using System.Data;
using DataBase;

namespace DB.WMS.Fun
{
public class clsLocMst
{
/// <summary>
/// 確認儲位是否是外儲位
/// </summary>
/// <param name="sLoc"></param>
/// <param name="IsOutside"></param>
/// <param name="db"></param>
/// <returns></returns>
public int CheckLocIsOutside(string sLoc, ref bool IsOutside, ref string sLocDD, ref bool IsEmpty_DD, ref string BoxID_DD, DataBase.DB db)
{
try
{
int iRet = CheckLocIsOutside(sLoc, ref IsOutside, db);
if (iRet == DBResult.Success)
{
sLocDD = GetLocDD(sLoc, db);
if (string.IsNullOrWhiteSpace(sLocDD))
throw new Exception($"找不到{sLoc}的對照儲位！");
return CheckLocIsEmpty(sLocDD, ref IsEmpty_DD, ref BoxID_DD, db);
}

/// <summary>
/// 確認儲位是否是外儲位
/// </summary>
/// <param name="sLoc"></param>
/// <param name="IsOutside"></param>
/// <param name="db"></param>
/// <returns></returns>
public int CheckLocIsOutside(string sLoc, ref bool IsOutside, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select IS_INSIDE from {Parameter.clsLocMst.TableName} where {Parameter.clsLocMst.Column.Loc} = '{sLoc}' ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
IsOutside = Convert.ToString(dtTmp.Rows[0][0]) == "N" ? true : false;
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
}

return iRet;
}
catch (Exception ex)
{
var cmet = System.Reflection.MethodBase.GetCurrentMethod();
clsWriLog.Log.subWriteExLog(cmet.DeclaringType.FullName + "." + cmet.Name, ex.Message);
return DBResult.Exception;
}
finally
{
dtTmp = null;
}
}
public bool FunTestConnection(DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select TOP (10) {Parameter.clsLocMst.Column.Loc} from {Parameter.clsLocMst.TableName} ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
return true;
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
return false;
}
}
catch (Exception ex)
{
var cmet = System.Reflection.MethodBase.GetCurrentMethod();
clsWriLog.Log.subWriteExLog(cmet.DeclaringType.FullName + "." + cmet.Name, ex.Message);
return false;
}
finally
{
dtTmp = null;
}
}
public string GetLocDD(string sLoc, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select {Parameter.clsLocMst.Column.LocDD} from {Parameter.clsLocMst.TableName} where " +
$"{Parameter.clsLocMst.Column.Loc} = '{sLoc}' ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
return Convert.ToString(dtTmp.Rows[0][0]);
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
return string.Empty;
}
}
catch (Exception ex)
{
var cmet = System.Reflection.MethodBase.GetCurrentMethod();
clsWriLog.Log.subWriteExLog(cmet.DeclaringType.FullName + "." + cmet.Name, ex.Message);
return string.Empty;
}
finally
{
dtTmp = null;
}
}
public string GetLocDDandStatus(string sLoc, ref bool IsEmpty, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select {Parameter.clsLocMst.Column.Loc}, {Parameter.clsLocMst.Column.StorageSts}, {Parameter.clsLocMst.Column.OperateSts} from {Parameter.clsLocMst.TableName} where " +
$"{Parameter.clsLocMst.Column.LocDD} = '{sLoc}' ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
IsEmpty = ((Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.StorageSts]).Trim().ToUpper() == clsConstValue.LocSts.Empty) &&
(Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.OperateSts]).Trim().ToUpper() == clsConstValue.LocSts.Normal));
return Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.Loc]);
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
return string.Empty;
}
}
catch (Exception ex)
{
var cmet = System.Reflection.MethodBase.GetCurrentMethod();
clsWriLog.Log.subWriteExLog(cmet.DeclaringType.FullName + "." + cmet.Name, ex.Message);
return string.Empty;
}
finally
{
dtTmp = null;
}
}
public int CheckLocIsEmpty(string sLoc, ref bool IsEmpty, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select {Parameter.clsLocMst.Column.StorageSts} from {Parameter.clsLocMst.TableName} where {Parameter.clsLocMst.Column.Loc} = '{sLoc}' ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
IsEmpty = Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.StorageSts]).Trim().ToUpper() ==
clsConstValue.LocSts.Empty;
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
}

public int CheckLocIsEmpty(string sLoc, ref bool IsEmpty, ref string BoxID, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strEM = "";
string strSql = $"select {Parameter.clsLocMst.Column.StorageSts}, {Parameter.clsLocMst.Column.BoxID} from " +
$"{Parameter.clsLocMst.TableName} where {Parameter.clsLocMst.Column.Loc} = '{sLoc}' ";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
IsEmpty = Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.StorageSts]).Trim().ToUpper() == clsConstValue.LocSts.Empty;
BoxID = Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.BoxID]);
}
else
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
}

public int CheckLineByBoxID(string sBoxID, ref int StockerID, ref string sLoc, DataBase.DB db)
{
DataTable dtTmp = new DataTable();
try
{
string strSql = $"select * from {Parameter.clsLocMst.TableName} where {Parameter.clsLocMst.Column.BoxID} = '{sBoxID}' ";
string strEM = "";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet == DBResult.Success)
{
StockerID = Convert.ToInt32(dtTmp.Rows[0][Parameter.clsLocMst.Column.EquNo]);
sLoc = Convert.ToString(dtTmp.Rows[0][Parameter.clsLocMst.Column.Loc]);
}
else clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");

public string funSearchEmptyLoc(string Equ_No, clsEnum.LocSts_Double locSts, DataBase.DB db)
{
string strEM = "";
DataTable dtTmp = new DataTable();
try
{
string sSQL = $"SELECT TOP 1 {Parameter.clsLocMst.Column.Loc} FROM " +
$"{Parameter.clsLocMst.TableName} WHERE {Parameter.clsLocMst.Column.StorageSts} = '" + clsConstValue.LocSts.Empty + "' ";
sSQL += $" AND {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Normal}' and {Parameter.clsLocMst.Column.EquNo} = '" + Equ_No + "' ";

if (locSts == clsEnum.LocSts_Double.NNNN) //找外側空庫位
{
sSQL += $" AND {Parameter.clsLocMst.Column.Loc} IN (SELECT {Parameter.clsLocMst.Column.LocDD} FROM " +
$"{Parameter.clsLocMst.TableName}" +
$" WHERE {Parameter.clsLocMst.Column.StorageSts}='{clsConstValue.LocSts.Empty}' AND {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Normal}'" +
$" AND IS_INSIDE = 'Y') ";
}
else if (locSts == clsEnum.LocSts_Double.SNNS)
{
sSQL += $" AND {Parameter.clsLocMst.Column.Loc} IN (SELECT {Parameter.clsLocMst.Column.LocDD} FROM " +
$"{Parameter.clsLocMst.TableName}" +
$" WHERE {Parameter.clsLocMst.Column.StorageSts} in ('{clsConstValue.LocSts.Full}','{clsConstValue.LocSts.NotFull}')" +
$" AND {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Normal}' AND IS_INSIDE = 'N') ";
}
else if (locSts == clsEnum.LocSts_Double.ENNE)
{
sSQL += $" AND {Parameter.clsLocMst.Column.Loc} IN (SELECT {Parameter.clsLocMst.Column.LocDD} FROM " +
$"{Parameter.clsLocMst.TableName}" +
$" WHERE {Parameter.clsLocMst.Column.StorageSts} = '{clsConstValue.LocSts.EmptyBox}' AND {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Normal}'" +
" AND IS_INSIDE = 'N') ";
}
else if (locSts == clsEnum.LocSts_Double.XNNX)
{
sSQL += $" AND {Parameter.clsLocMst.Column.Loc} IN (SELECT {Parameter.clsLocMst.Column.LocDD} FROM " +
$"{Parameter.clsLocMst.TableName}" +
$" WHERE {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Block}' AND IS_INSIDE = 'N') ";
}
else { } //Single Deep

sSQL += $" ORDER BY {Parameter.clsLocMst.Column.BAY}, {Parameter.clsLocMst.Column.LEVEL}, {Parameter.clsLocMst.Column.ROW} DESC";

dtTmp = new DataTable();
string sNewLoc;
if (db.GetDataTable(sSQL, ref dtTmp, ref strEM) == DBResult.Success)
{
sNewLoc = dtTmp.Rows[0][Parameter.clsLocMst.Column.Loc].ToString();
}
else
{
sNewLoc = "";
}

return sNewLoc;
}
catch (Exception ex)
{
var cmet = System.Reflection.MethodBase.GetCurrentMethod();
clsWriLog.Log.subWriteExLog(cmet.DeclaringType.FullName + "." + cmet.Name, ex.Message);
return "";
}
finally
{
dtTmp = null;
}
}

public string funSearchEmptyLoc_Abnormal(string Equ_No, clsEnum.LocSts_Double locSts, string sSource, DataBase.DB db)
{
string sNewLoc = "";
string strEM = "";
DataTable dtTmp = new DataTable();
try
{
string sSQL = $"SELECT TOP 1 {Parameter.clsLocMst.Column.Loc} FROM " +
$"{Parameter.clsLocMst.TableName} WHERE {Parameter.clsLocMst.Column.StorageSts} = '" + clsConstValue.LocSts.Empty + "' ";
sSQL += $" AND {Parameter.clsLocMst.Column.OperateSts} = '{clsConstValue.LocSts.Normal}' and {Parameter.clsLocMst.Column.EquNo} = '" + Equ_No + "' ";
switch (sSource.Substring(0, 2))
{
case "09":
case "11":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('09','11') ";
break;
case "10":
case "12":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('10','12') ";
break;
case "13":
case "15":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('13','15') ";
break;
case "14":
case "16":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('14','16') ";
break;
case "17":
case "19":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('17','19') ";
break;
case "18":
case "20":
sSQL += $" and SUBSTRING({Parameter.clsLocMst.Column.Loc},1,2) IN ('18','20') ";
break;
default:
return "";
}

sSQL += $" ORDER BY {Parameter.clsLocMst.Column.BAY}, {Parameter.clsLocMst.Column.LEVEL}, {Parameter.clsLocMst.Column.ROW} DESC";

dtTmp = new DataTable();
if (db.GetDataTable(sSQL, ref dtTmp, ref strEM) == DBResult.Success)
{
sNewLoc = dtTmp.Rows[0][Parameter.clsLocMst.Column.Loc].ToString();
}
else
{
sNewLoc = "";
}

public int funCheckCountForEmptyLoc(ref DataTable dtTmp, DataBase.DB db)
{
try
{
string strEM = "";
string strSql = $"select {clsConstValue.LineName.Line3} = (SELECT COUNT({Parameter.clsLocMst.Column.StorageSts}) from {Parameter.clsLocMst.TableName} WHERE ({Parameter.clsLocMst.Column.StorageSts} = '{clsConstValue.LocSts.Empty}' AND CRANE = '{clsConstValue.CraneName.Line3}')), " +
$"{clsConstValue.LineName.Line4} = (SELECT COUNT({Parameter.clsLocMst.Column.StorageSts}) from {Parameter.clsLocMst.TableName} WHERE ({Parameter.clsLocMst.Column.StorageSts} = '{clsConstValue.LocSts.Empty}' AND CRANE = '{clsConstValue.CraneName.Line4}')), " +
$"{clsConstValue.LineName.Line5} = (SELECT COUNT({Parameter.clsLocMst.Column.StorageSts}) from {Parameter.clsLocMst.TableName} WHERE ({Parameter.clsLocMst.Column.StorageSts} = '{clsConstValue.LocSts.Empty}' AND CRANE = '{clsConstValue.CraneName.Line5}'))";
int iRet = db.GetDataTable(strSql, ref dtTmp, ref strEM);
if (iRet != DBResult.Success)
{
clsWriLog.Log.FunWriLog(WriLog.clsLog.Type.Error, $"{strSql} => {strEM}");
}

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/weixin_40725706/article/detail/170169