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 获得验收流水号
///
/// 获得验收流水号
///
///
public string GetNextValNum()
{
return DataProvider.Instance.ProvideRep.GetNextValNum();
}
#endregion
#region 查主表
///
/// 获得供应商补货主表List集合
///
/// 供应商补货Model
///
public List GetProvideRepData(ProvideRepModel model)
{
DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepData(model);
if (dt != null)
{
List list = list = ConvertHelper.ConvertToList(dt);
return list;
}
return null;
}
#endregion
#region 查明细表
///
/// 查询供应商补货明细表信息
///
/// 供应商补货编号ID
///
public List GetProvideRepInfoData(string proID)
{
DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepInfoData(proID);
if (dt != null)
{
List list = ConvertHelper.ConvertToList(dt);
return list;
}
return null;
}
#endregion
///
/// 同时新增供应商补货主表明细表数据
///
/// 供应商补货Model
/// 供应商补货明细Model集合
///
public string InsertProvideRepData(ProvideRepModel model, List list )
{
DataProvider.Instance.ProvideRep.InsertProvideRepData(model, list);
TaCmtOrRak();
return this.ErrText;
}
///
/// 同时更新 供应商补货主表 明细表数据
///
/// 主表Model
/// 明细表List
///
public string UpdateProvideRepData(ProvideRepModel model, List 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 listWareNoticeTab = new List();
// 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 goodsinfo = ConvertHelper.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;
}
///
/// 同时删除主表明细表数据
///
///
///
public string DeleteProvideRepData(List strlist)
{
//删主表
DataProvider.Instance.ProvideRep.DeleteProvideRepData(strlist);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
///
/// 单独增主表数据
///
///
///
public string Add(List list)
{
DataProvider.Instance.ProvideRep.Add(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
///
/// 单独删除明细数据
///
///
///
public string Delete(List list)
{
DataProvider.Instance.ProvideRep.Delete(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
///
/// 单独更新供应商补货明细
///
///
///
///
///
public string NewProvideRepInfoFuc(ProvideRepModel prM, List upFuc, List insertFuc, List delFuc)
{
DataProvider.Instance.ProvideRep.NewProvideRepInfoFuc(prM, upFuc, insertFuc, delFuc);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
//修改规格明细
TaCmtOrRak();
return this.ErrText;
}
#region 同时删除主表和明细表数据
///
/// 同时删除供应商补货主表和明细表数据
///
/// ID集合
///
public string DeleteProvideRepByID(List 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 改主表
///
/// 更新主表单据一条数据
///
/// 更新主表一条数据
///
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 改明细
///
/// 更新供应商补货明细表多条数据
///
/// 供应商补货明细Model集合
///
public string UpdateProvideRepInfo(List list)
{
DataProvider.Instance.ProvideRep.UpdateProvideRepInfo(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
#endregion
#region 增主表
///
/// 供应商补货主表增一条数据
///
/// 供应商补货Model
///
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 增明细表
///
/// 供应商补货明细表增多条数据
///
/// 供应商补货明细Model集合
///
public string InsertStorageInfoRep(List list)
{
DataProvider.Instance.ProvideRep.InsertProvideRepInfo(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
#endregion
///
/// 打印完成
///
/// 移位单
/// 是否成功
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 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 model)
{
DataProvider.Instance.ProvideRep.DeleteProvideRepInfo(model);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
#endregion
}
}