void DetailCheck(DepotManagementDataContext ctx, S_MaterialReturnedInTheDepot billInfo)
{
IStoreServer serviceStore = ServerModule.ServerModuleFactory.GetServerModule <IStoreServer>();
var varData = from a in ctx.S_MaterialListReturnedInTheDepot
where a.Bill_ID == billInfo.Bill_ID
select a;
foreach (S_MaterialListReturnedInTheDepot item in varData)
{
StoreQueryCondition storeQuery = new StoreQueryCondition();
storeQuery.BatchNo = item.BatchNo;
storeQuery.GoodsID = item.GoodsID;
storeQuery.Provider = item.Provider;
storeQuery.StorageID = billInfo.StorageID;
if (serviceStore.GetStockInfoOverLoad(ctx, storeQuery) == null)
{
throw new Exception(UniversalFunction.GetGoodsMessage(item.GoodsID)
+ "供应商：【" + item.Provider + "】, 批次号：【" + item.BatchNo + "】, 库房ID：【"
+ billInfo.StorageID + "】 无库存记录,无法进行退库");
}
}
}
public void InsertInfoExcel(string billNo, DataTable infoTable)
{
IMaterialRequisitionServer billServer = ServerModuleFactory.GetServerModule <IMaterialRequisitionServer>();
BillNumberControl billNoControl = new BillNumberControl("领料单", billServer);
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
IStoreServer storeService = ServerModuleFactory.GetServerModule <IStoreServer>();
try
{
List <string> lstStorage = new List <string>();
if (infoTable.Columns.Contains("库房"))
{
lstStorage = DataSetHelper.ColumnsToList_Distinct(infoTable, "库房");
foreach (string storage in lstStorage)
{
string temp = UniversalFunction.GetStorageID(storage);
if (temp.Trim().Length == 0)
{
throw new Exception("【库房名称】：" + storage + "有误， 无法匹配到库房ID");
}
}
}
if (!infoTable.Columns.Contains("物品ID"))
{
infoTable.Columns.Add("物品ID");
foreach (DataRow dr in infoTable.Rows)
{
int goodsID = UniversalFunction.GetGoodsID(dr["图号型号"] == null ? "" : dr["图号型号"].ToString(),
dr["物品名称"] == null ? "" : dr["物品名称"].ToString(),
dr["规格"] == null ? "" : dr["规格"].ToString());
if (goodsID == 0)
{
throw new Exception(string.Format("【图号型号】：{0} 【物品名称】：{1} 【规格】：{2}有误，" +
" 无法匹配到物品ID", dr["图号型号"], dr["物品名称"], dr["规格"]));
}
dr["物品ID"] = goodsID;
}
}
var varData = from a in ctx.S_MaterialRequisition
where a.Bill_ID == billNo
select a;
if (varData.Count() != 1)
{
throw new Exception("无法获取【单据号】： " + billNo + " 的基本信息");
}
S_MaterialRequisition requisition = varData.Single();
if (BillIsFinish(ctx, requisition.Bill_ID))
{
throw new Exception("单据已完成，无法进行操作");
}
if (lstStorage.Count == 0)
{
lstStorage.Add(UniversalFunction.GetStorageName(requisition.StorageID));
}
foreach (string storage in lstStorage)
{
DataTable tempTable = infoTable;
if (lstStorage.Count > 1)
{
tempTable = DataSetHelper.SiftDataTable(infoTable, "库房 = '" + storage + "'");
}
string tempBillNo = "";
string storageID = UniversalFunction.GetStorageID(storage);
if (requisition.StorageID != storageID)
{
S_MaterialRequisition tempRequisition = new S_MaterialRequisition();
tempBillNo = billNoControl.GetNewBillNo(ctx);
tempRequisition.Bill_ID = tempBillNo;
tempRequisition.AssociatedBillNo = requisition.AssociatedBillNo;
tempRequisition.AssociatedBillType = requisition.AssociatedBillType;
tempRequisition.AuthorizeDate = requisition.AuthorizeDate;
tempRequisition.AuthorizePersonnel = requisition.AuthorizePersonnel;
tempRequisition.Bill_Time = requisition.Bill_Time;
tempRequisition.BillStatus = requisition.BillStatus;
tempRequisition.Department = requisition.Department;
tempRequisition.DepartmentDirector = requisition.DepartmentDirector;
tempRequisition.DepotManager = requisition.DepotManager;
tempRequisition.FetchCount = requisition.FetchCount;
tempRequisition.FetchType = requisition.FetchType;
tempRequisition.FillInPersonnel = requisition.FillInPersonnel;
tempRequisition.FillInPersonnelCode = requisition.FillInPersonnelCode;
tempRequisition.OutDepotDate = requisition.OutDepotDate;
tempRequisition.ProductType = requisition.ProductType;
tempRequisition.PurposeCode = requisition.PurposeCode;
tempRequisition.Remark = requisition.Remark;
tempRequisition.StorageID = storageID;
tempRequisition.TechnologistDate = requisition.TechnologistDate;
tempRequisition.TechnologistPersonnel = requisition.TechnologistPersonnel;
ctx.S_MaterialRequisition.InsertOnSubmit(tempRequisition);
ctx.SubmitChanges();
}
else
{
tempBillNo = billNo;
}
foreach (DataRow dr in tempTable.Rows)
{
S_MaterialRequisitionGoods goodsInfo = new S_MaterialRequisitionGoods();
goodsInfo.RequestCount = dr["数量"] == null ? 0 : Convert.ToDecimal(dr["数量"]);
goodsInfo.BatchNo = dr["批次号"] == null ? "" : dr["批次号"].ToString();
if (dr["物品ID"] == null || Convert.ToInt32(dr["物品ID"]) == 0)
{
throw new Exception("【物品ID】无效");
}
goodsInfo.GoodsID = Convert.ToInt32(dr["物品ID"]);
goodsInfo.Bill_ID = tempBillNo;
StoreQueryCondition condition = new StoreQueryCondition();
condition.BatchNo = goodsInfo.BatchNo;
condition.GoodsID = goodsInfo.GoodsID;
condition.StorageID = storageID;
S_Stock stockInfo = storeService.GetStockInfo(condition);
if (stockInfo == null)
{
throw new Exception(string.Format("【物品ID】：{0} 【批次号】：{1} 【库房】：{2} 未找到匹配的库存记录",
goodsInfo.GoodsID, goodsInfo.BatchNo, storage));
}
goodsInfo.ProviderCode = stockInfo.Provider;
goodsInfo.BasicCount = 0;
goodsInfo.Remark = "由Excel导入";
goodsInfo.RepairStatus = null;
goodsInfo.RealCount = goodsInfo.RequestCount;
goodsInfo.ShowPosition = 1;
ctx.S_MaterialRequisitionGoods.InsertOnSubmit(goodsInfo);
ctx.SubmitChanges();
}
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
throw new Exception(ex.Message);
}
}
/// <summary>
/// 赋值账务信息
/// </summary>
/// <param name="context">数据上下文</param>
/// <param name="bill">单据信息</param>
/// <param name="item">明细信息</param>
/// <returns>返回账务信息对象</returns>
public S_FetchGoodsDetailBill AssignDetailInfo(DepotManagementDataContext context, S_MaterialRequisition bill,
S_MaterialRequisitionGoods item)
{
IBillTypeServer server = ServerModuleFactory.GetServerModule <IBillTypeServer>();
BASE_BillType billType = server.GetBillTypeFromName("领料单");
if (billType == null)
{
throw new Exception("获取不到单据类型信息");
}
View_Department department = UniversalFunction.GetDeptInfo(context, bill.Department);
IStoreServer storeServer = ServerModuleFactory.GetServerModule <IStoreServer>();
IProductLendReturnService serverLendReturn = ServerModuleFactory.GetServerModule <IProductLendReturnService>();
F_GoodsPlanCost basicGoods = m_basicGoodsServer.GetGoodsInfo(context, item.GoodsID);
if (basicGoods == null)
{
throw new Exception(string.Format("物品ID [{0}] 的物品在基础物品表中没有查到，请与系统管理员联系！", item.GoodsID));
}
StoreQueryCondition condition = new StoreQueryCondition();
condition.GoodsID = item.GoodsID;
condition.Provider = item.ProviderCode;
condition.BatchNo = item.BatchNo;
condition.StorageID = bill.StorageID;
S_Stock stock = storeServer.GetStockInfoOverLoad(context, condition);
if (stock == null && GlobalObject.GeneralFunction.IsNullOrEmpty(basicGoods.GoodsType))
{
throw new Exception(string.Format("图号：{0}, 名称：{1}, 规格：{2}, 供应商：{3}, 批次号：{4} 的物品在库存中没有查到相关物品，请仓管员核实！",
basicGoods.GoodsCode, basicGoods.GoodsName, basicGoods.Spec, item.ProviderCode, item.BatchNo));
}
//S_FetchGoodsDetailBill用于存放每次领料、领料退库的明细信息
decimal dcRealCount = item.RealCount;
decimal dcSumCount = 0;
var varData = from a in context.View_S_MaterialRequisitionProductReturnList
where a.单据号 == item.Bill_ID &&
a.还账物品ID == item.GoodsID &&
a.还账物品批次号 == item.BatchNo &&
a.还账物品供应商 == item.ProviderCode
select a;
if (varData.Count() > 0)
{
dcSumCount = varData.Sum(a => a.还账数量);
if (dcRealCount < dcSumCount)
{
throw new Exception("实际领用数量不能大于还货数量，请重新核对");
}
}
S_FetchGoodsDetailBill detailBill = new S_FetchGoodsDetailBill();
detailBill.ID = Guid.NewGuid();
detailBill.FetchBIllID = bill.Bill_ID;
detailBill.BillTime = (DateTime)bill.OutDepotDate;
detailBill.AssociatedBillType = bill.AssociatedBillType;
detailBill.AssociatedBillNo = bill.AssociatedBillNo;
detailBill.Department = department.部门名称;
detailBill.FetchCount = item.RealCount;
detailBill.GoodsID = item.GoodsID;
detailBill.StorageID = bill.StorageID;
detailBill.Price = dcSumCount;
detailBill.UnitPrice = stock == null ? 0 : stock.UnitPrice;
detailBill.OperationType = (int)CE_SubsidiaryOperationType.领料;
detailBill.Provider = item.ProviderCode;
if (stock != null)
{
detailBill.ProviderBatchNo = stock.ProviderBatchNo;
}
else
{
detailBill.ProviderBatchNo = "";
}
detailBill.BatchNo = item.BatchNo;
detailBill.FillInPersonnel = bill.FillInPersonnel;
detailBill.FinanceSignatory = null;
detailBill.DepartDirector = bill.DepartmentDirector;
detailBill.DepotManager = bill.DepotManager;
detailBill.Remark = (bill.Remark == null ? "" : bill.Remark.Trim()) + (item.Remark == null ? "" : item.Remark.Trim());
detailBill.FillInDate = bill.Bill_Time;
IMaterialRequisitionPurposeServer purposeServer =
ServerModuleFactory.GetServerModule <IMaterialRequisitionPurposeServer>();
detailBill.Using = purposeServer.GetBillPurpose(context, bill.PurposeCode).Purpose;
return(detailBill);
}
