大连融科 WMS
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

573 lines
20 KiB

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Reflection;
using Microsoft.Win32.SafeHandles;
namespace SiaSun.LMS.Implement
{
public class ManageUp : ManageBase
{
/// <summary>
/// 生成【立库实盘上架】任务
/// </summary>
/// <param name="STOCK_BARCODE">容器条码</param>
/// <param name="START_CELL_ID">起始站台索引【不能为0】</param>
/// <param name="END_CELL_ID">终止货位索引</param>
/// <param name="CELL_MODEL">货位规格</param>
/// <param name="bAutoSendControl">是否下达控制任务</param>
/// <param name="bTrans">是否独立事务</param>
/// <param name="Opertator">操作者</param>
/// <returns></returns>
public new bool ManageCreate(string STOCK_BARCODE,
int START_CELL_ID,
int END_CELL_ID,
string CELL_MODEL,
string LOGIC_AREA,
bool bAutoSendControl,
bool bTrans,
string Opertator,
out string sResult)
{
bool bResult = true;
sResult = string.Empty;
string ssResult = string.Empty;
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = null;
SiaSun.LMS.Model.MANAGE_LIST mMANAGE_LIST = null;
List<SiaSun.LMS.Model.MANAGE_LIST> lsMANAGE_LIST = new List<SiaSun.LMS.Model.MANAGE_LIST>();
try
{
#region 校验
#region 校验上架容器条码
if (string.IsNullOrEmpty(STOCK_BARCODE))
{
bResult = false;
sResult = string.Format("请输入容器条码");
return bResult;
}
//if (STOCK_BARCODE.Trim().Length != 6)
//{
// bResult = false;
// sResult = string.Format("容器条码[{0}]不合法", STOCK_BARCODE);
// return bResult;
//}
//SiaSun.LMS.Model.GOODS_MAIN mGOODS_MAIN_CONTAINER = this._P_GOODS_MAIN.GetModel(STOCK_BARCODE.Substring(0, 1).ToUpper());
//if (mGOODS_MAIN_CONTAINER == null)
//{
// bResult = false;
// sResult = string.Format("容器条码[{0}]不合法", STOCK_BARCODE);
// return bResult;
//}
#endregion
#region 校验托盘库存
IList<Model.STORAGE_MAIN> sTORAGE_MAINs = this._P_STORAGE_MAIN.GetListStockBarcode(STOCK_BARCODE);
if (sTORAGE_MAINs != null && sTORAGE_MAINs.Count > 1)
{
bResult = false;
sResult = string.Format("容器[{0}]存在多个库存", STOCK_BARCODE);
return bResult;
}
SiaSun.LMS.Model.STORAGE_MAIN mSTORAGE_MAIN = this._P_STORAGE_MAIN.GetModelStockBarcode(STOCK_BARCODE);
if (null == mSTORAGE_MAIN)
{
bResult = false;
sResult =string.Format("容器[{0}]不存在库存", STOCK_BARCODE) ;
return bResult;
}
SiaSun.LMS.Model.WH_CELL mWH_CELL = this._P_WH_CELL.GetModel(mSTORAGE_MAIN.CELL_ID);
if (mWH_CELL != null)
{
SiaSun.LMS.Model.WH_AREA mWH_AREA = this._P_WH_AREA.GetModel(mWH_CELL.AREA_ID);
if (mWH_AREA.AREA_TYPE != SiaSun.LMS.Enum.AREA_TYPE.XuNiKu.ToString())
{
bResult = false;
sResult = string.Format("容器[{0}]已在[{1}][{2}]", STOCK_BARCODE, mWH_AREA.AREA_NAME, mWH_CELL.CELL_NAME);
return bResult;
}
}
//if (this._P_STORAGE_MAIN.GetListStockBarcode(STOCK_BARCODE).Count > 1)
//{
// bResult= false;
// sResult = string.Format("容器[{0}]库存异常", STOCK_BARCODE) ;
// return bResult;
//}
//IList<Model.STORAGE_LIST> lsSTORAGE_LIST = this._P_STORAGE_LIST.GetListStorageID(mSTORAGE_MAIN.STORAGE_ID);
//if (lsSTORAGE_LIST.Count == 0)
//{
// bResult = false;
// sResult= string.Format("容器[{0}]的库存明细异常", STOCK_BARCODE) ;
// return bResult;
//}
#endregion
#region 校验起始站台
SiaSun.LMS.Model.WH_CELL mSTART_WH_CELL = this._P_WH_CELL.GetModel(START_CELL_ID);
if (mSTART_WH_CELL == null)
{
bResult = false;
sResult = string.Format("起始位置索引[{0}]不存在", START_CELL_ID) ;
return bResult;
}
if (mSTART_WH_CELL.CELL_INOUT.Equals(SiaSun.LMS.Enum.CELL_INOUT.Out.ToString()))
{
bResult = false;
sResult = string.Format("起始位置[{0}]入出类型[{1}]不合法", mSTART_WH_CELL.CELL_NAME, mSTART_WH_CELL.CELL_INOUT);
return bResult;
}
if (!mSTART_WH_CELL.CELL_TYPE.Equals(Enum.CELL_TYPE.Station.ToString()))
{
bResult = false;
sResult = string.Format("起始位置[{0}]类型[{1}]不合法", mSTART_WH_CELL.CELL_NAME, mSTART_WH_CELL.CELL_TYPE);
return bResult;
}
#endregion
#region 校验是否存在未进行的控制任务
//IList<SiaSun.LMS.Model.IO_CONTROL> LsIO_CONTROL = this._P_IO_CONTROL.GetList();
//foreach (SiaSun.LMS.Model.IO_CONTROL mIO_CONTROL in LsIO_CONTROL)
//{
// if (mIO_CONTROL.START_DEVICE_CODE == mSTART_WH_CELL.DEVICE_CODE && !(mIO_CONTROL.CONTROL_STATUS == 11))
// {
// bResult = false;
// sResult = string.Format("控制索引[{0}]未完成,不能申请新任务", mIO_CONTROL.CONTROL_ID);
// return bResult;
// }
//}
#endregion
#endregion
#region 获得入库货位
if (!bAutoSendControl)
{
//if(END_CELL_ID == 0)
//{
// bResult = false;
// sResult = string.Format("不关联调度的上架任务,必须指定终止位置") ;
// return bResult;
//}
}
if (END_CELL_ID == 0)
{
// LOGIC_AREA 成品和五金件分区存储
bResult = this._S_CellService.CellGetIn(0, 0, mSTART_WH_CELL.CELL_ID, SiaSun.LMS.Enum.CELL_STATUS.Nohave.ToString(), SiaSun.LMS.Enum.RUN_STATUS.Enable.ToString(), CELL_MODEL, LOGIC_AREA,STOCK_BARCODE, out END_CELL_ID, out sResult);
if (!bResult)
{
return bResult;
}
}
else
{
#region 校验终止货位
Model.WH_CELL mEND_WH_CELL = this._P_WH_CELL.GetModel(END_CELL_ID);
if (mEND_WH_CELL == null)
{
bResult = false;
sResult = string.Format("未找到终止货位索引[{0}]", END_CELL_ID);
return bResult;
}
//if(!(mEND_WH_CELL.LANE_WAY == mSTART_WH_CELL.LANE_WAY))
//{
// bResult = false;
// sResult = string.Format("终止货位[{0}]与入库位置不符", END_CELL_ID);
// return bResult;
//}
if (!mEND_WH_CELL.CELL_STATUS.Equals(Enum.CELL_STATUS.Nohave.ToString()))
{
bResult = false;
sResult = string.Format("终止货位[{0}]货位状态[{1}]不合法", mEND_WH_CELL.CELL_NAME, mEND_WH_CELL.CELL_STATUS);
return bResult;
}
if (!mEND_WH_CELL.RUN_STATUS.Equals(Enum.RUN_STATUS.Enable.ToString()))
{
bResult = false;
sResult = string.Format("终止货位[{0}]运行状态[{1}]不合法", mEND_WH_CELL.CELL_NAME, mEND_WH_CELL.RUN_STATUS );
return bResult;
}
Model.WH_AREA mEND_WH_AREA = this._P_WH_AREA.GetModel(mEND_WH_CELL.AREA_ID);
bResult = mEND_WH_AREA.AREA_GROUP.Contains(STOCK_BARCODE.Substring(0, 1));
if (!bResult)
{
sResult = string.Format("上架容器[{0}]不允许放在终止货位[{1}]所在区域[{2}]", STOCK_BARCODE, mEND_WH_CELL.CELL_NAME, mEND_WH_AREA.AREA_NAME);
return bResult;
}
#endregion
}
#endregion
#region 下达任务
#region 生成MANAGE_MAIN
mMANAGE_MAIN = new Model.MANAGE_MAIN();
mMANAGE_MAIN.PLAN_ID = 0;
mMANAGE_MAIN.PLAN_TYPE_CODE = string.Empty;
mMANAGE_MAIN.MANAGE_TYPE_CODE = SiaSun.LMS.Enum.MANAGE_TYPE.ManageUp.ToString();
mMANAGE_MAIN.MANAGE_STATUS = SiaSun.LMS.Enum.MANAGE_STATUS.Waiting.ToString();
mMANAGE_MAIN.STOCK_BARCODE = STOCK_BARCODE;
mMANAGE_MAIN.FULL_FLAG = mSTORAGE_MAIN.FULL_FLAG;
mMANAGE_MAIN.CELL_MODEL = CELL_MODEL;
mMANAGE_MAIN.START_CELL_ID = START_CELL_ID;
mMANAGE_MAIN.END_CELL_ID = END_CELL_ID;
mMANAGE_MAIN.MANAGE_OPERATOR = Opertator;
mMANAGE_MAIN.MANAGE_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetCurDateTimeString();
#endregion
#region 生成MANAGE_LIST
foreach (SiaSun.LMS.Model.STORAGE_LIST mSTORAGE_LIST in this._P_STORAGE_LIST.GetListStorageID(mSTORAGE_MAIN.STORAGE_ID))
{
mMANAGE_LIST = new Model.MANAGE_LIST();
mMANAGE_LIST.GOODS_ID = mSTORAGE_LIST.GOODS_ID;
mMANAGE_LIST.PLAN_LIST_ID = 0;
mMANAGE_LIST.STORAGE_LIST_ID = mSTORAGE_LIST.STORAGE_LIST_ID;
mMANAGE_LIST.MANAGE_LIST_QUANTITY = mSTORAGE_LIST.STORAGE_LIST_QUANTITY;
mMANAGE_LIST.MANAGE_LIST_REMARK = mSTORAGE_LIST.STORAGE_LIST_REMARK;
mMANAGE_LIST.GOODS_PROPERTY6=mSTORAGE_LIST.GOODS_PROPERTY6;
bResult = this._S_GoodsService.GoodsPropertySetValue(mSTORAGE_LIST.GOODS_ID, mMANAGE_LIST, mSTORAGE_LIST,out sResult);
if (!bResult)
{
return bResult;
}
lsMANAGE_LIST.Add(mMANAGE_LIST);
}
#endregion
bResult = base.ManageCreate(mMANAGE_MAIN, lsMANAGE_LIST, bAutoSendControl, bTrans, out sResult);
//直接报完成
if ((!bAutoSendControl )&& bResult)
{
bResult = this.ManageComplete(mMANAGE_MAIN.MANAGE_ID, bTrans, out sResult);
}
#endregion
}
catch (Exception ex)
{
bResult = false;
sResult = ex.Message;
this._log.Fatal(string.Format("调用方法{0}发生异常。", MethodBase.GetCurrentMethod().Name), ex);
}
if (bResult)
{
//this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 1, "任务类型:组盘上架");
//this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 2, "条码:" + mMANAGE_MAIN.STOCK_BARCODE);
//SiaSun.LMS.Model.WH_CELL wh_cell = this._P_WH_CELL.GetModel(mMANAGE_MAIN.END_CELL_ID);
//if (wh_cell != null)
//{
// this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 3, "货位:" + wh_cell.CELL_CODE);
//}
//else
//{
// this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 3, "货位:" + "未找到货位");
//}
}
return bResult;
}
/// <summary>完成
/// 完成
/// </summary>
/// <param name="MANAGE_ID"></param>
/// <param name="bTrans">是否独立事务</param>
/// <param name="sResult"></param>
/// <returns></returns>
public new bool ManageComplete(int MANAGE_ID, bool bTrans, out string sResult)
{
bool bResult = true;
sResult = string.Empty;
SiaSun.LMS.Model.MANAGE_MAIN mmMANAGE_MAIN = this._P_MANAGE_MAIN.GetModel(MANAGE_ID);
try
{
this._P_Base_House.BeginTransaction(bTrans);
#region 校验
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = this._P_MANAGE_MAIN.GetModel(MANAGE_ID);
bResult = null != mMANAGE_MAIN;
if (!bResult)
{
sResult = string.Format("管理任务索引[{0}]不存在", MANAGE_ID.ToString());
return bResult;
}
SiaSun.LMS.Model.IO_CONTROL mIO_CONTROL = this._P_IO_CONTROL.GetModelManageID(MANAGE_ID);
if ((null != mIO_CONTROL) && (!mIO_CONTROL.CONTROL_STATUS.Equals(999)))
{
bResult= false;
sResult = string.Format("控制任务索引[{0}]的控制任务未完成", mIO_CONTROL.CONTROL_ID);
return bResult;
}
SiaSun.LMS.Model.WH_CELL mSTART_WH_CELL = this._P_WH_CELL.GetModel(mMANAGE_MAIN.START_CELL_ID);
if (null == mSTART_WH_CELL)
{
bResult = false;
sResult = string.Format("起始位置索引[{0}]不存在", mMANAGE_MAIN.START_CELL_ID);
return bResult;
}
SiaSun.LMS.Model.WH_CELL mEND_WH_CELL = this._P_WH_CELL.GetModel(mMANAGE_MAIN.END_CELL_ID);
if (null == mEND_WH_CELL)
{
bResult = false;
sResult = string.Format("终止位置索引[{0}]不存在", mMANAGE_MAIN.END_CELL_ID);
return bResult;
}
#endregion
#region 更新库存-暂存区移至立库
bResult = this._S_StorageService.StorageMove(MANAGE_ID,out sResult);
if (!bResult)
{
return bResult;
}
#endregion
#region 更新货位状态
if (!this._P_WH_AREA.GetModel(mSTART_WH_CELL.AREA_ID).AREA_TYPE.Equals(SiaSun.LMS.Enum.AREA_TYPE.XuNiKu.ToString()))
{
string CELL_STATUS = SiaSun.LMS.Enum.CELL_STATUS.Nohave.ToString();
bResult = this._S_CellService.CellUpdateStatus(mMANAGE_MAIN.START_CELL_ID, CELL_STATUS, SiaSun.LMS.Enum.RUN_STATUS.Enable.ToString(),out sResult);
if (!bResult)
{
return bResult;
}
}
if (!this._P_WH_AREA.GetModel(mEND_WH_CELL.AREA_ID).AREA_TYPE.Equals(SiaSun.LMS.Enum.AREA_TYPE.XuNiKu.ToString()))
{
//string CELL_STATUS = mMANAGE_MAIN.FULL_FLAG == "1" ? SiaSun.LMS.Enum.CELL_STATUS.Full.ToString() : SiaSun.LMS.Enum.CELL_STATUS.Have.ToString();
string CELL_STATUS = SiaSun.LMS.Enum.CELL_STATUS.Full.ToString();
bResult = this._S_CellService.CellUpdateStatus(mMANAGE_MAIN.END_CELL_ID, CELL_STATUS, SiaSun.LMS.Enum.RUN_STATUS.Enable.ToString(),out sResult);
if (!bResult)
{
return bResult;
}
}
#endregion
#region 调用基类-更新管理任务;更新计划;生成入出库记录
bResult = this._S_ManageService.ManageComplete(MANAGE_ID, false,out sResult);
if (!bResult)
{
return bResult;
}
//this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 2, "条码:" + mMANAGE_MAIN.STOCK_BARCODE);
// this.updateLedText(mMANAGE_MAIN.START_CELL_ID, 3, "货位:" + mMANAGE_MAIN.END_CELL_ID.ToString());
#endregion
#region 删除任务信息
this._P_IO_CONTROL.DeleteManageID(mMANAGE_MAIN.MANAGE_ID);
this._P_MANAGE_DETAIL.DeleteManageID(mMANAGE_MAIN.MANAGE_ID);
this._P_MANAGE_LIST.DeleteManageID(mMANAGE_MAIN.MANAGE_ID);
this._P_MANAGE_MAIN.Delete(mMANAGE_MAIN.MANAGE_ID);
#endregion
}
catch (Exception ex)
{
bResult = false;
sResult = ex.Message;
this._log.Fatal(string.Format("调用方法{0}发生异常。", MethodBase.GetCurrentMethod().Name), ex);
}
finally
{
if (bResult)
{
this._P_Base_House.CommitTransaction(bTrans);
DataTable dt= this.GetList(string.Format(@"select * from V_STORAGE_LIST where goods_id=909 and cell_type='cell' and CELL_STATUS='pallet' order by CELl_y,CELL_CODE"));
if (dt.Rows.Count <= 0)
{
sResult = "无空盘库存";
}
else
{
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();
mMANAGE_MAIN.MANAGE_TYPE_CODE = "StockOut";
mMANAGE_MAIN.PLAN_ID = 0;
mMANAGE_MAIN.STOCK_BARCODE = dt.Rows[0]["STOCK_BARCODE"].ToString();
mMANAGE_MAIN.CELL_MODEL = "0";
mMANAGE_MAIN.START_CELL_ID =Convert.ToInt32( dt.Rows[0]["cell_id"].ToString());
mMANAGE_MAIN.END_CELL_ID = 13209;
mMANAGE_MAIN.MANAGE_OPERATOR = "Super";
mMANAGE_MAIN.MANAGE_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
mMANAGE_MAIN.MANAGE_STATUS = SiaSun.LMS.Enum.MANAGE_STATUS.Waiting.ToString();
mMANAGE_MAIN.MANAGE_LEVEL = string.Empty;
mMANAGE_MAIN.MANAGE_REMARK = string.Empty;
List<Model.MANAGE_LIST> listMANAGE_LIST = new List<Model.MANAGE_LIST>();
Model.MANAGE_LIST mANAGE_LIST = new Model.MANAGE_LIST();
mANAGE_LIST.PLAN_LIST_ID = 0;
mANAGE_LIST.GOODS_ID = 909;
mANAGE_LIST.STORAGE_LIST_ID =Convert.ToInt32(dt.Rows[0]["STORAGE_LIST_ID"].ToString());
mANAGE_LIST.MANAGE_LIST_QUANTITY = 1;
mANAGE_LIST.MANAGE_ID = 0;
mANAGE_LIST.MANAGE_LIST_ID = 0;
mANAGE_LIST.GOODS_PROPERTY1 = "0";
listMANAGE_LIST.Add(mANAGE_LIST);
StockOut sto = new StockOut();
bResult= sto.ManageCreate(mMANAGE_MAIN,listMANAGE_LIST,true,true,out sResult);
if (!bResult)
{
}
}
}
else
{
this._P_Base_House.RollBackTransaction(bTrans);
}
}
return bResult;
}
}
}