449 lines
15 KiB
C#
449 lines
15 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using WMS.Model.Stock;
|
|||
|
|
using WMS.IData;
|
|||
|
|
using WMS.Common;
|
|||
|
|
using System.Data;
|
|||
|
|
using WMS.Model.Base;
|
|||
|
|
using WMS.Model.RK;
|
|||
|
|
|
|||
|
|
namespace WMS.Business.Stock
|
|||
|
|
{
|
|||
|
|
public class BussProvideRep : IBussFactory
|
|||
|
|
{
|
|||
|
|
#region 获得验收流水号
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获得验收流水号
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string GetNextValNum()
|
|||
|
|
{
|
|||
|
|
return DataProvider.Instance.ProvideRep.GetNextValNum();
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 查主表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获得供应商补货主表List集合
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">供应商补货Model</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<ProvideRepModel> GetProvideRepData(ProvideRepModel model)
|
|||
|
|
{
|
|||
|
|
DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepData(model);
|
|||
|
|
|
|||
|
|
if (dt != null)
|
|||
|
|
{
|
|||
|
|
List<ProvideRepModel> list = list = ConvertHelper<ProvideRepModel>.ConvertToList(dt);
|
|||
|
|
return list;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
#region 查明细表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 查询供应商补货明细表信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="proID">供应商补货编号ID</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public List<ProvideRepInfoModel> GetProvideRepInfoData(string proID)
|
|||
|
|
{
|
|||
|
|
DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepInfoData(proID);
|
|||
|
|
if (dt != null)
|
|||
|
|
{
|
|||
|
|
List<ProvideRepInfoModel> list = ConvertHelper<ProvideRepInfoModel>.ConvertToList(dt);
|
|||
|
|
return list;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return null;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时新增供应商补货主表明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">供应商补货Model</param>
|
|||
|
|
/// <param name="list">供应商补货明细Model集合</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string InsertProvideRepData(ProvideRepModel model, List<ProvideRepInfoModel> list )
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.InsertProvideRepData(model, list);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时更新 供应商补货主表 明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">主表Model</param>
|
|||
|
|
/// <param name="lsit">明细表List</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string UpdateProvideRepData(ProvideRepModel model, List<ProvideRepInfoModel> lsit)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
DataProvider.Instance.ProvideRep.UpdateProvideRepData(model, lsit);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (model.PROREP_STATUS == "1")
|
|||
|
|
{
|
|||
|
|
#region 入库单生成
|
|||
|
|
//新增调拨入库通知单
|
|||
|
|
// WareNoticeModel wareNoticeModel = new WareNoticeModel();
|
|||
|
|
// List<WareNoticeTabModel> listWareNoticeTab = new List<WareNoticeTabModel>();
|
|||
|
|
// int flag = 0;
|
|||
|
|
// //string strwareNoticeID = DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag);
|
|||
|
|
|
|||
|
|
// //新增调拨入库单主表
|
|||
|
|
// //wareNoticeModel.WAREHOUSING_ID = strwareNoticeID;
|
|||
|
|
// wareNoticeModel.PURCHASE_ID = "";
|
|||
|
|
// wareNoticeModel.ORDER_DATE = DateTime.Now;
|
|||
|
|
// wareNoticeModel.PROVIDER_ID = model.PRO_ID;
|
|||
|
|
// wareNoticeModel.PURCHASE_COUNT = model.TOTAL_NUM;
|
|||
|
|
// wareNoticeModel.AMOUNT = 0;
|
|||
|
|
// wareNoticeModel.TOTAL_VOLUME = 0;
|
|||
|
|
// wareNoticeModel.TOTAL_ROUGH_WEIGHT = 0;
|
|||
|
|
// wareNoticeModel.TOTAL_NET_WEIGH = 0;
|
|||
|
|
// wareNoticeModel.TOTAL_MONEY = 0;
|
|||
|
|
// wareNoticeModel.WARE_COUNT = 0;
|
|||
|
|
// wareNoticeModel.SHELVES_COUNT = 0;
|
|||
|
|
// wareNoticeModel.WAYBILL_ID = "";
|
|||
|
|
// wareNoticeModel.SHIPPERS = "";
|
|||
|
|
// wareNoticeModel.CARNO = "";
|
|||
|
|
// wareNoticeModel.DRIVER = "";
|
|||
|
|
// wareNoticeModel.CONFIRM_PERSON = "";
|
|||
|
|
// wareNoticeModel.CONFIRM_DATE = DateTime.MinValue;
|
|||
|
|
// wareNoticeModel.EXPECTED_DELIVERY_DATE = model.EXPECT_DATE;
|
|||
|
|
// //终止日期在原预计到货延后2天
|
|||
|
|
// wareNoticeModel.END_DELIVERY_DATE = model.EXPECT_DATE.AddDays(1);
|
|||
|
|
// wareNoticeModel.REAL_DELIVERY_DATE = model.EXPECT_DATE;
|
|||
|
|
// wareNoticeModel.RECIPIENTS = "";
|
|||
|
|
// wareNoticeModel.CLASS_GROUP = "";
|
|||
|
|
// wareNoticeModel.WARE_DATE = model.EXPECT_DATE;
|
|||
|
|
// wareNoticeModel.SHELVES_DATE = model.EXPECT_DATE;
|
|||
|
|
// wareNoticeModel.RECORD_PERSON = model.CONFIRM_MAN;
|
|||
|
|
// //parameters[24].Value = model.RECORD_DATE;
|
|||
|
|
// wareNoticeModel.CLOSE_PERSON = "";
|
|||
|
|
// wareNoticeModel.CLOSE_DATE = DateTime.MinValue;
|
|||
|
|
// wareNoticeModel.CLOSE_REASON = "";
|
|||
|
|
// wareNoticeModel.ORDER_MODE = "0";
|
|||
|
|
// wareNoticeModel.STORAGE_MODE = "0";
|
|||
|
|
// //已到货
|
|||
|
|
// wareNoticeModel.STATE = "0";
|
|||
|
|
// wareNoticeModel.TRAY_STATE = "0";
|
|||
|
|
// wareNoticeModel.DISPATCHING_STATE = "0";
|
|||
|
|
// wareNoticeModel.REMARK = model.REMARK;
|
|||
|
|
// wareNoticeModel.PALLET_COUNT = 0;
|
|||
|
|
// wareNoticeModel.PURCHASE_COUNT = model.TOTAL_NUM;
|
|||
|
|
// wareNoticeModel.ACCE_NUM = model.TOTAL_NUM;
|
|||
|
|
// wareNoticeModel.PASS_NUM = model.TOTAL_NUM;
|
|||
|
|
// // DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag);
|
|||
|
|
// //新增入库调拨单明细表
|
|||
|
|
// string strwareNoticeID = DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag);
|
|||
|
|
|
|||
|
|
// foreach (ProvideRepInfoModel item in lsit)
|
|||
|
|
// {
|
|||
|
|
// WareNoticeTabModel wareNoticeTabModel = new WareNoticeTabModel();
|
|||
|
|
// wareNoticeTabModel.WAREHOUSING_ID = strwareNoticeID;
|
|||
|
|
// wareNoticeTabModel.PURCHASE_ID = "";
|
|||
|
|
// wareNoticeTabModel.GOODS_ID = item.GOODS_ID;
|
|||
|
|
|
|||
|
|
// //通过商品编号 查出商品信息 体积 毛重 等
|
|||
|
|
// List<GoodsInfoModel> goodsinfo = ConvertHelper<GoodsInfoModel>.ConvertToList(DataProvider.Instance.Goods.GetGoodsDataTable(item.GOODS_ID, "", "", ""));
|
|||
|
|
// wareNoticeTabModel.AMOUNT = item.GOODS_COUNT;
|
|||
|
|
// if (goodsinfo.Count != 0)
|
|||
|
|
// {
|
|||
|
|
// wareNoticeTabModel.TOTAL_VOLUME = goodsinfo[0].GVOLUME;
|
|||
|
|
// wareNoticeTabModel.TOTAL_ROUGH_WEIGHT = goodsinfo[0].GROSS_WEIGHT;
|
|||
|
|
// wareNoticeTabModel.TOTAL_NET_WEIGH = goodsinfo[0].NET_WEIGHT;
|
|||
|
|
// }
|
|||
|
|
// wareNoticeTabModel.TOTAL_MONEY = item.SUMPRICE;
|
|||
|
|
// wareNoticeTabModel.PRODUCTION_DATE = DateTime.MinValue;
|
|||
|
|
// wareNoticeTabModel.STORAGE_ID = model.STORAGE_ID;
|
|||
|
|
// wareNoticeTabModel.STORAGE_AREA_ID = "";
|
|||
|
|
// wareNoticeTabModel.PACKAGE_ID = "";
|
|||
|
|
// wareNoticeTabModel.REMARK = item.REMARK;
|
|||
|
|
// wareNoticeTabModel.OPERATORID = "";
|
|||
|
|
// wareNoticeTabModel.UNIT = item.UNIT;
|
|||
|
|
// wareNoticeTabModel.PRICE = item.PRICE;
|
|||
|
|
// wareNoticeTabModel.SCALE_UNIT = item.SCALE_UNIT;
|
|||
|
|
// wareNoticeTabModel.GVOLUME = 0;
|
|||
|
|
// wareNoticeTabModel.GOODS_TYPE_ID = "";
|
|||
|
|
// wareNoticeTabModel.PROVIDER_ID = "";
|
|||
|
|
// DataProvider.Instance.WareNoticeTab.InsertOrUpdateWareNoticeTab(wareNoticeTabModel, 0);
|
|||
|
|
// logList.Add(DataProvider.Instance.logData);
|
|||
|
|
// }
|
|||
|
|
|
|||
|
|
//logList.Add(DataProvider.Instance.logData);
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
}
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时删除主表明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="strlist"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string DeleteProvideRepData(List<string> strlist)
|
|||
|
|
{
|
|||
|
|
//删主表
|
|||
|
|
DataProvider.Instance.ProvideRep.DeleteProvideRepData(strlist);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 单独增主表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="list"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string Add(List<ProvideRepInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.Add(list);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 单独删除明细数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="list"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string Delete(List<ProvideRepInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.Delete(list);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 单独更新供应商补货明细
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="upFuc"></param>
|
|||
|
|
/// <param name="insertFuc"></param>
|
|||
|
|
/// <param name="delFuc"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string NewProvideRepInfoFuc(ProvideRepModel prM, List<ProvideRepInfoModel> upFuc, List<ProvideRepInfoModel> insertFuc, List<ProvideRepInfoModel> delFuc)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.NewProvideRepInfoFuc(prM, upFuc, insertFuc, delFuc);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
//修改规格明细
|
|||
|
|
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 同时删除主表和明细表数据
|
|||
|
|
/// <summary>
|
|||
|
|
/// 同时删除供应商补货主表和明细表数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="strlist">ID集合</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string DeleteProvideRepByID(List<string> strlist)
|
|||
|
|
{
|
|||
|
|
//删主表
|
|||
|
|
DataProvider.Instance.ProvideRep.DeleteProvideRep(strlist);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
//删明细
|
|||
|
|
DataProvider.Instance.ProvideRep.DeleteProvideRepInfo(strlist);
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 改主表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 更新主表单据一条数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">更新主表一条数据</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string UpdateProvideRep(ProvideRepModel model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.UpdateProvideRep(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
#region 改明细
|
|||
|
|
/// <summary>
|
|||
|
|
/// 更新供应商补货明细表多条数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="list">供应商补货明细Model集合</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string UpdateProvideRepInfo(List<ProvideRepInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.UpdateProvideRepInfo(list);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 增主表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 供应商补货主表增一条数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">供应商补货Model</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string InsertProvideRep(ProvideRepModel model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.InsertProvideRep(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
#region 增明细表
|
|||
|
|
/// <summary>
|
|||
|
|
/// 供应商补货明细表增多条数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="list">供应商补货明细Model集合</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string InsertStorageInfoRep(List<ProvideRepInfoModel> list)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.InsertProvideRepInfo(list);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 打印完成
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model">移位单</param>
|
|||
|
|
/// <returns>是否成功</returns>
|
|||
|
|
public string PrintOK(ProvideRepModel model)
|
|||
|
|
{
|
|||
|
|
//修改捡货单打印次数
|
|||
|
|
model.PRINT_COUNT += 1;
|
|||
|
|
DataProvider.Instance.ProvideRep.UpdateProvideRep(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
|
|||
|
|
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
return ErrText;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
#region 已废 删主表
|
|||
|
|
public string DeleteProvideRep(List<ProvideRepModel> model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.DeleteProvideRep(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
#region 已废 删明细
|
|||
|
|
//删明细
|
|||
|
|
public string DeleteProvideRepInfo(List<ProvideRepInfoModel> model)
|
|||
|
|
{
|
|||
|
|
DataProvider.Instance.ProvideRep.DeleteProvideRepInfo(model);
|
|||
|
|
|
|||
|
|
Transaction = DataProvider.Instance.TranOracle;
|
|||
|
|
logList.Add(DataProvider.Instance.logData);
|
|||
|
|
TaCmtOrRak();
|
|||
|
|
|
|||
|
|
return this.ErrText;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|