using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.Model.RK;
using System.Data;
using WMS.IData;
using WMS.Common;
using WMS.Model.Base;
namespace WMS.Business.RK
{
public class BussAcceptance : IBussFactory
{
#region 查
///
/// 查 收货验收 查询数据
///
/// 验收Model
///
public List GetAcceptanceData(AcceptanceModel model)
{
DataTable dt = DataProvider.Instance.Acceptance.GetAcceptanceData(model);
List list = null;
if (DataLogErrWrite(dt, "获取收货验收数据"))
{
list = ConvertHelper.ConvertToList(dt);
}
else
{
return list;
}
return list;
}
#endregion
///
/// 查询入库批次明细表 除去 验单表已存在的商品数据
///
///
///
public List GetStorageLotInfoDistanct(string lotid)
{
DataTable dt = DataProvider.Instance.Acceptance.GetStorageLotInfoDistanct(lotid);
List list = null;
if (DataLogErrWrite(dt, "获取收货验收数据"))
{
list = ConvertHelper.ConvertToList(dt);
}
else
{
return list;
}
return list;
}
#region 增
///
/// 增 收货验收 写入数据库
///
/// 验收Model集合
///
public string AddAcceptance(List list)
{
int i = 0;
string acceptData= IBussFactory.Instance().GetDocumentStream("收货单");
foreach (AcceptanceModel model in list)
{
model.ACCE_ID = acceptData;
model.ACC_STATUS = "1";
DataProvider.Instance.Acceptance.AddAcceptance(model);
if (i == 0)
{
Transaction = DataProvider.Instance.TranOracle;
}
logList.Add(DataProvider.Instance.logData);
i++;
}
TaCmtOrRak();
//MessageModel messModel = new MessageModel();
//messModel.ID = "YS" + DateTime.Now.ToString("yyyyMMddHHmmss") + DataProvider.Instance.Message.GetSerialNum();
//messModel.MENU_FORM = "FrmAcceptance";
//messModel.MESS_CONTENT = "新增验收单,单据编号:" + list[0].ACCE_ID;
//messModel.MESS_DATE = DateTime.Now;
//messModel.MESS_DEP = list[0].STORAGE_ID;
//messModel.MESS_FLAG = "0";
//messModel.MESS_STAR = list[0].OPERATORID;
//messModel.MESS_STATUS = "0";
//messModel.WORK_KIND = "0";
//messModel.RELATIVE_NUMBER = list[0].ACCE_ID;
//messModel.WORK_TYPE = "worktype007";
//messModel.STO_ID = list[0].OPERATORID;
//messModel.MESS_TYPE = "RK";
//DataProvider.Instance.Message.Add(messModel);
//logList.Add(DataProvider.Instance.logData);
// Transaction = DataProvider.Instance.TranOracle;
// TaCmtOrRak();
return this.ErrText;
}
#endregion
///
/// 更新收货验收 回写入库批次主表 明细表数据
///
///
///
///
///
public string UpdateAcceptanceStorageData(List list, List stolist, List infolist)
{
//DataProvider.Instance.Acceptance.UpdateAcceptanceStorageData(list, stolist, infolist);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
public string UpdateAcceptance(List listModel)
{
for(int i=0;i
/// 改 收货验收 更新数据
///
/// 验收Model集合
///
// public string UpdateAcceptance(List list)
//{
// DataProvider.Instance.Acceptance.UpdateAcceptance(list);
// Transaction = DataProvider.Instance.TranOracle;
// logList.Add(DataProvider.Instance.logData);
// TaCmtOrRak();
// return this.ErrText;
//}
#endregion
///
/// 回写入库批次 个别字段信息
///
/// 入库批次Model集合
///
public string UpdateStorage(List list)
{
//DataProvider.Instance.Acceptance.UpdateStorage(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
///
/// 回写入库批次、入库批次明细表 接收数量
///
///
///
///
public string UpdateStorageData(List list, List listinfo)
{
DataProvider.Instance.Acceptance.UpdateStorageData(list, listinfo);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
#region 删
///
/// 删 收货验收 删除数据
///
/// 验收Model集合
///
public string DeleteAcceptance(List model)
{
DataProvider.Instance.Acceptance.DeleteAcceptance(model);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
//strs 单据编号
foreach (AcceptanceModel strs in model)
{
string st = strs.ACCE_ID;
DataProvider.Instance.Message.DeleteMessByRelativeNumber(st);
logList.Add(DataProvider.Instance.logData);
}
TaCmtOrRak();
return this.ErrText;
}
#endregion
#region 删除数据添加到备份表
///
/// 删除数据添加到备份表
///
/// 验收Model集合
///
public string InsertAcceptanceBack(List list)
{
//先备份
DataProvider.Instance.Acceptance.InsertAcceptanceBack(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
//在删除
DataProvider.Instance.Acceptance.DeleteAcceptance(list);
Transaction = DataProvider.Instance.TranOracle;
logList.Add(DataProvider.Instance.logData);
TaCmtOrRak();
return this.ErrText;
}
#endregion
///
/// 获得验收流水号
///
///
public string GetNextValNum()
{
return DataProvider.Instance.Acceptance.GetNextValNum();
}
public List GetWriteBackData(AcceptanceModel model)
{
DataTable dt = DataProvider.Instance.Acceptance.GetWriteBackData(model);
List list = null;
if (DataLogErrWrite(dt, "获取入库批次验收数据"))
{
list = ConvertHelper.ConvertToList(dt);
}
else
{
return list;
}
return list;
}
}
}