295 lines
9.4 KiB
C#
295 lines
9.4 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using WMS.Model.Stock;
|
||
using System.Data;
|
||
using WMS.IData;
|
||
using WMS.Common;
|
||
using WMS.Model.Base;
|
||
|
||
namespace WMS.Business.Stock
|
||
{
|
||
|
||
public partial class BussMIStock : IBussFactory
|
||
{
|
||
public string UpdateMisLoc(string locId, string sts)
|
||
{
|
||
DataProvider.Instance.MIStock.UpdateMisLoc(locId, sts);
|
||
return ErrText;
|
||
}
|
||
public DataTable GetCtMisTable(string locId)
|
||
{
|
||
return DataProvider.Instance.MIStock.GetCtMisTable(locId);
|
||
}
|
||
public DataSet GetCTlGoods(string ctl)
|
||
{
|
||
|
||
DataTable table = DataProvider.Instance.MIStock.GetCTlGoods(ctl);
|
||
DataSet ds = new DataSet();
|
||
ds.Tables.Add(table);
|
||
return ds;
|
||
}
|
||
|
||
public void DeleteMIStock(string ctl, string locid, string goodid, ref string errText)
|
||
{
|
||
//删除库存
|
||
DataProvider.Instance.MIStock.DeleteMIStock(ctl, locid, goodid);
|
||
//释放库位
|
||
DataProvider.Instance.AutoRkData.UpdateLocSts(locid);
|
||
}
|
||
|
||
public bool UpdateMis(string num, string locId, string stoid, string goodid)
|
||
{
|
||
return DataProvider.Instance.MIStock.UpdateMis(num, locId, stoid, goodid);
|
||
|
||
}
|
||
public bool UpdateMis(string locId, string stoid)
|
||
{
|
||
return DataProvider.Instance.MIStock.UpdateMis(locId, stoid);
|
||
|
||
}
|
||
|
||
|
||
public DataTable GetMistockLocData(string devid)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetMistockLocData(devid);
|
||
//if (table != null)
|
||
//{
|
||
// List<BussMIStock> model = ConvertHelper<BussMIStock>.ConvertToList(table);
|
||
// return model;
|
||
//}
|
||
return table;
|
||
}
|
||
|
||
|
||
public DataSet GetStockTaskLtk(string ck, string kq)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetStockTaskLtk(ck,kq);
|
||
DataSet ds = new DataSet();
|
||
ds.Tables.Add(table);
|
||
return ds;
|
||
|
||
}
|
||
/// <summary>
|
||
/// 查询空托盘
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable GetMisDataNullOut(string size)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetMisDataNullOut(size);
|
||
return table;
|
||
}
|
||
/// <summary>
|
||
/// 查询空库位
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
public DataTable GetNullLocal(string STORAGE_ID)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetNullLocal(STORAGE_ID);
|
||
return table;
|
||
}
|
||
|
||
public DataSet GetStockName(string name)
|
||
{
|
||
DataSet ds = DataProvider.Instance.MIStock.GetStockName(name);
|
||
|
||
return ds;
|
||
}
|
||
public DataTable GetMisDataOut(string locid,string goodsiD,string STORAGE_ID)
|
||
{
|
||
return DataProvider.Instance.MIStock.GetMisDataOut(locid, goodsiD, STORAGE_ID);
|
||
}
|
||
/// <summary>
|
||
/// 获取库存表结果集
|
||
/// </summary>
|
||
/// <returns>库存表</returns>
|
||
public List<MIStockModel> GetMIStockList(MIStockModel model)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetMIStockDT(model);
|
||
if (table != null)
|
||
{
|
||
List<MIStockModel> MIStockModel = new List<MIStockModel>();
|
||
MIStockModel = ConvertHelper<MIStockModel>.ConvertToList(table);
|
||
return MIStockModel;
|
||
}
|
||
|
||
return null;
|
||
}
|
||
|
||
public DataTable GetLoctionGoodLtk(string goodslId)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.GetLoctionGoodLtk(goodslId);
|
||
//DataSet ds = new DataSet();
|
||
//ds.Tables.Add(table);
|
||
return table;
|
||
|
||
}
|
||
public DataSet LtkDataMis(string goodsId, string STORAGE_ID, string AREA_ID)
|
||
{
|
||
DataTable table = DataProvider.Instance.MIStock.LtkDataMis(goodsId, STORAGE_ID, AREA_ID);
|
||
DataSet ds = new DataSet();
|
||
ds.Tables.Add(table);
|
||
return ds;
|
||
}
|
||
//// DataTable LtkDataMis(string goodsId, string STORAGE_ID, string AREA_ID);/ <summary>
|
||
///// 用于库存查看窗体查询
|
||
///// </summary>
|
||
///// <param name="model"></param>
|
||
///// <returns></returns>
|
||
//public List<MIStockModel> GetMiStockForLookUp(MIStockModel model)
|
||
//{
|
||
// DataTable table = DataProvider.Instance.MIStock.GetMiStockForLookUp(model);
|
||
|
||
// List<MIStockModel> MIStockModel = new List<MIStockModel>();
|
||
// MIStockModel = ConvertHelper<MIStockModel>.ConvertToList(table);
|
||
|
||
// if (DataLogErrWrite(table, "获取库存表用于查询窗体"))
|
||
// {
|
||
// return MIStockModel;
|
||
// }
|
||
// return null;
|
||
//}
|
||
|
||
|
||
|
||
|
||
/// <summary>
|
||
/// 删除库存表
|
||
/// </summary>
|
||
/// <param name="MIStock">库存表</param>
|
||
/// <returns>是否成功</returns>
|
||
public string DeleteMIStock(MIStockModel model)
|
||
{
|
||
|
||
DataProvider.Instance.MIStock.DeleteMIStock(model);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
|
||
Transaction = DataProvider.Instance.TranOracle;
|
||
TaCmtOrRak();
|
||
return ErrText;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 新增库存表
|
||
/// </summary>
|
||
/// <param name="MIStockModel">库存表Model</param>
|
||
/// <returns>是否成功</returns>
|
||
public string InsertMIStockAndTab(MIStockModel MIStockModel)
|
||
{
|
||
//新增库存表
|
||
DataProvider.Instance.MIStock.InsertMIStock(MIStockModel);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
|
||
Transaction = DataProvider.Instance.TranOracle;
|
||
|
||
TaCmtOrRak();
|
||
return ErrText;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 修改库存表
|
||
/// </summary>
|
||
/// <param name="MIStockModel">库存表Model</param>
|
||
/// <returns>是否成功</returns>
|
||
public string UpdateMIStockAndTab(MIStockModel MIStockModel)
|
||
{
|
||
DataProvider.Instance.MIStock.UpdateMIStock(MIStockModel);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
|
||
Transaction = DataProvider.Instance.TranOracle;
|
||
|
||
TaCmtOrRak();
|
||
return ErrText;
|
||
}
|
||
|
||
/// <summary>
|
||
/// 修改库存数量
|
||
/// </summary>
|
||
/// <param name="MIStockModel">库存表Model</param>
|
||
/// <returns>是否成功</returns>
|
||
public string UpdateMIStockNum(MIStockModel MIStockModel)
|
||
{
|
||
DataProvider.Instance.MIStock.UpdateMIStockNum(MIStockModel);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
|
||
Transaction = DataProvider.Instance.TranOracle;
|
||
|
||
TaCmtOrRak();
|
||
return ErrText;
|
||
}
|
||
|
||
GoodsInfoModel temp = new GoodsInfoModel();
|
||
/// <summary>
|
||
/// 通过库存Model获取商品表
|
||
/// </summary>
|
||
/// <returns>商品表</returns>
|
||
public List<GoodsInfoModel> GetGoodsListByMIStock(MIStockModel model)
|
||
{
|
||
List<MIStockModel> list = GetMIStockList(model);
|
||
List<GoodsInfoModel> goodsList = new List<GoodsInfoModel>();
|
||
foreach (MIStockModel item in list)
|
||
{
|
||
DataTable dt = DataProvider.Instance.Goods.GetGoodsDataTable(item.GOODS_ID, "", "", "");
|
||
|
||
temp = ConvertHelper<GoodsInfoModel>.ConvertToList(dt)[0];
|
||
if (!goodsList.Exists(MatchPRE)) {
|
||
goodsList.Add(temp);
|
||
}
|
||
}
|
||
|
||
return goodsList;
|
||
}
|
||
/// <summary>
|
||
/// 条件匹配函数，goodsList中每个元素都会传入P中
|
||
/// </summary>
|
||
/// <param name="p"></param>
|
||
/// <returns></returns>
|
||
private bool MatchPRE(GoodsInfoModel p)
|
||
{
|
||
|
||
if (p.GOODS_ID == temp.GOODS_ID)//此句为匹配条件，如果匹配，返回，你可以随意更改成你想要的值
|
||
{
|
||
return true;
|
||
}
|
||
|
||
return false;
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
/// 批量增加库存
|
||
/// </summary>
|
||
/// <param name="goodsModelList"></param>
|
||
/// <returns></returns>
|
||
public string AddMIStockList(List<MIStockModel> MIStockList)
|
||
{
|
||
string locd = string.Empty;
|
||
|
||
for (int i = 0; i < MIStockList.Count; i++)
|
||
{
|
||
|
||
|
||
if (MIStockList[i].SHELVES_NUM > 0)
|
||
{
|
||
DataProvider.Instance.MIStock.InsertMIStock(MIStockList[i]);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
if (i == 0)
|
||
{
|
||
Transaction = DataProvider.Instance.TranOracle;
|
||
}
|
||
if (locd != MIStockList[i].LOCATION_ID)
|
||
{
|
||
//DataProvider.Instance.PickingWaveGoods.SerLocWaitInSts(MIStockList[i].LOCATION_ID);
|
||
logList.Add(DataProvider.Instance.logData);
|
||
locd = MIStockList[i].LOCATION_ID;
|
||
}
|
||
}
|
||
}
|
||
|
||
TaCmtOrRak();
|
||
return ErrText;
|
||
}
|
||
}
|
||
}
|