/// <summary>
/// 操作明细账（并且操作库存）
/// </summary>
/// <param name="ctx">数据上下文</param>
/// <param name="subsidiary">明细账对象</param>
public void OperationSubsidiary(DepotManagementDataContext ctx, WS_Subsidiary subsidiary)
{
if (!Convert.ToBoolean(BasicInfo.BaseSwitchInfo[(int)GlobalObject.CE_SwitchName.开启车间管理模块]))
{
return;
}
Service_Manufacture_WorkShop.IWorkShopProductCode serverProduct =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopProductCode>();
BASE_SubsidiaryOperationType tempOperationType = UniversalFunction.GetSubsidiaryOperationType(subsidiary.OperationType);
if (tempOperationType == null)
{
throw new Exception("明细账操作类型错误，请重新确认");
}
serverProduct.OperatorProductCodeStock(ctx, subsidiary.BillNo,
subsidiary.GoodsID, subsidiary.OperationType);
ctx.WS_Subsidiary.InsertOnSubmit(subsidiary);
WS_WorkShopStock tempStock = new WS_WorkShopStock();
tempStock.BatchNo = subsidiary.BatchNo;
tempStock.GoodsID = subsidiary.GoodsID;
tempStock.StockCount = (bool)tempOperationType.DepartmentType ? subsidiary.OperationCount : -subsidiary.OperationCount;
tempStock.WSCode = subsidiary.WSCode;
PlusReductionStock(ctx, tempStock);
}
/// <summary>
/// 操作明细账（并且操作库存）
/// </summary>
/// <param name="subsidiary">明细账对象</param>
public void OperationSubsidiary(WS_Subsidiary subsidiary)
{
if (!Convert.ToBoolean(BasicInfo.BaseSwitchInfo[(int)GlobalObject.CE_SwitchName.开启车间管理模块]))
{
return;
}
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
BASE_SubsidiaryOperationType tempOperationType = UniversalFunction.GetSubsidiaryOperationType(subsidiary.OperationType);
if (tempOperationType == null)
{
throw new Exception("明细账操作类型错误，请重新确认");
}
var varData = from a in ctx.WS_Subsidiary
where a.BillNo == subsidiary.BillNo &&
a.GoodsID == subsidiary.GoodsID &&
a.WSCode == subsidiary.WSCode &&
a.BatchNo == subsidiary.BatchNo
select a;
if (varData.Count() > 0)
{
throw new Exception(UniversalFunction.GetGoodsMessage(subsidiary.GoodsID) + " 【批次号】: "
+ subsidiary.BatchNo + " 相同单据中，物品重复，请重新确认");
}
else
{
subsidiary.BillTime = ServerTime.Time;
ctx.WS_Subsidiary.InsertOnSubmit(subsidiary);
WS_WorkShopStock tempStock = new WS_WorkShopStock();
tempStock.BatchNo = subsidiary.BatchNo;
tempStock.GoodsID = subsidiary.GoodsID;
tempStock.StockCount = (bool)tempOperationType.DepartmentType ? subsidiary.OperationCount : -subsidiary.OperationCount;
tempStock.WSCode = subsidiary.WSCode;
PlusReductionStock(ctx, tempStock);
}
ctx.SubmitChanges();
}
/// <summary>
/// 车间出库业务的处理
/// </summary>
/// <param name="ctx">数据上下文</param>
/// <param name="fetchGoodsDetailInfo">出库业务对象</param>
void FetchWorkShop(DepotManagementDataContext ctx, S_FetchGoodsDetailBill fetchGoodsDetailInfo)
{
if (fetchGoodsDetailInfo == null)
{
return;
}
Service_Manufacture_WorkShop.IWorkShopBasic serverWSBasic =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopBasic>();
WS_WorkShopCode tempWSCode = serverWSBasic.GetPersonnelWorkShop(ctx, fetchGoodsDetailInfo.FillInPersonnel);
if (Convert.ToBoolean(BasicInfo.BaseSwitchInfo[(int)GlobalObject.CE_SwitchName.开启车间管理模块]) &&
tempWSCode != null)
{
WS_Subsidiary tempSubsidiary = new WS_Subsidiary();
tempSubsidiary.BillTime = ServerTime.Time;
tempSubsidiary.Applicant = UniversalFunction.GetStorageName(ctx, fetchGoodsDetailInfo.StorageID);
tempSubsidiary.Affirm = fetchGoodsDetailInfo.DepotManager;
tempSubsidiary.AffirmDate = ServerTime.Time;
tempSubsidiary.BatchNo = fetchGoodsDetailInfo.BatchNo;
tempSubsidiary.BillNo = fetchGoodsDetailInfo.FetchBIllID;
tempSubsidiary.GoodsID = fetchGoodsDetailInfo.GoodsID;
tempSubsidiary.Provider = fetchGoodsDetailInfo.Provider;
tempSubsidiary.OperationCount = (decimal)fetchGoodsDetailInfo.FetchCount < 0 ? -(decimal)fetchGoodsDetailInfo.FetchCount : (decimal)fetchGoodsDetailInfo.FetchCount;
tempSubsidiary.OperationType = fetchGoodsDetailInfo.OperationType;
tempSubsidiary.Proposer = fetchGoodsDetailInfo.FillInPersonnel;
tempSubsidiary.ProposerDate = fetchGoodsDetailInfo.FillInDate == null ? ServerTime.Time : Convert.ToDateTime(fetchGoodsDetailInfo.FillInDate);
tempSubsidiary.UnitPrice = fetchGoodsDetailInfo.UnitPrice;
tempSubsidiary.WSCode = tempWSCode.WSCode;
tempSubsidiary.Remark = fetchGoodsDetailInfo.Remark;
Service_Manufacture_WorkShop.IWorkShopStock serverWSStock =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopStock>();
serverWSStock.OperationSubsidiary(ctx, tempSubsidiary);
}
}
/// <summary>
/// 确认单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="list">明细信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool AffirmBill(string billNo, DataTable list, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
try
{
var varData = from a in ctx.WS_ConsumptionBill
where a.BillNo == billNo
select a;
WS_ConsumptionBill tempBill = new WS_ConsumptionBill();
if (varData.Count() == 1)
{
tempBill = varData.Single();
if (tempBill.BillStatus != ConsumptionBillStatus.等待确认.ToString())
{
throw new Exception("单据状态错误，请重新确认");
}
tempBill.BillStatus = ConsumptionBillStatus.单据已完成.ToString();
tempBill.Affirm = BasicInfo.LoginName;
tempBill.AffirmDate = ServerTime.Time;
}
else
{
throw new Exception("数据不唯一,请重新确认");
}
ListControl(ctx, tempBill, list);
ctx.SubmitChanges();
foreach (DataRow dr in list.Rows)
{
WS_Subsidiary tempSubsidiary = new WS_Subsidiary();
tempSubsidiary.BatchNo = dr["批次号"].ToString();
tempSubsidiary.BillNo = tempBill.BillNo;
tempSubsidiary.GoodsID = Convert.ToInt32(dr["物品ID"]);
tempSubsidiary.OperationCount = Convert.ToDecimal(dr["数量"]);
tempSubsidiary.OperationType = (int)CE_SubsidiaryOperationType.车间耗用;
tempSubsidiary.Remark = dr["备注"].ToString();
tempSubsidiary.WSCode = tempBill.WSCode;
tempSubsidiary.Proposer = tempBill.Proposer;
tempSubsidiary.ProposerDate = (DateTime)tempBill.ProposerDate;
tempSubsidiary.Affirm = BasicInfo.LoginName;
tempSubsidiary.AffirmDate = ServerTime.Time;
IWorkShopStock serverStock = ServerModuleFactory.GetServerModule <IWorkShopStock>();
WS_WorkShopStock tempWSStock = serverStock.GetStockSingleInfo(tempSubsidiary.WSCode,
tempSubsidiary.GoodsID,
tempSubsidiary.BatchNo);
tempSubsidiary.UnitPrice = tempWSStock == null ? 0 : tempWSStock.UnitPrice;
tempSubsidiary.BillTime = ServerTime.Time;
View_HR_Personnel tempHR = UniversalFunction.GetPersonnelInfo(tempSubsidiary.Proposer);
if (tempHR == null)
{
throw new Exception("申请人员不存在");
}
tempSubsidiary.Applicant = tempHR.部门名称;
serverStock.OperationSubsidiary(ctx, tempSubsidiary);
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
error = ex.Message;
return(false);
}
}
/// <summary>
/// 确认单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="list">明细信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool AffirmBill(string billNo, DataTable list, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
try
{
var varData = from a in ctx.WS_CannibalizeBill
where a.BillNo == billNo
select a;
WS_CannibalizeBill tempBill = new WS_CannibalizeBill();
if (varData.Count() == 1)
{
tempBill = varData.Single();
if (tempBill.BillStatus != CannibalizeBillStatus.等待确认.ToString())
{
throw new Exception("单据状态错误，请重新确认");
}
tempBill.BillStatus = CannibalizeBillStatus.单据已完成.ToString();
tempBill.Affirm = BasicInfo.LoginName;
tempBill.AffirmDate = ServerTime.Time;
}
else
{
throw new Exception("数据不唯一,请重新确认");
}
var varCannibalizeWSCode = from a in ctx.WS_CannibalizeWSCode
where a.BillNo == tempBill.BillNo
select a;
ListControl(ctx, tempBill, varCannibalizeWSCode.ToList <WS_CannibalizeWSCode>(), list);
ctx.SubmitChanges();
var varOperationType = from a in varCannibalizeWSCode
join b in ctx.BASE_SubsidiaryOperationType
on a.OperationType equals b.OperationType
orderby b.DepartmentType
select a;
var varGoodsList = from a in ctx.WS_CannibalizeList
where a.BillNo == tempBill.BillNo
select a;
foreach (WS_CannibalizeList tempItem in varGoodsList)
{
decimal unitPrice = 0;
foreach (WS_CannibalizeWSCode item in varOperationType)
{
WS_Subsidiary tempSubsidiary = new WS_Subsidiary();
tempSubsidiary.BatchNo = tempItem.BatchNo;
tempSubsidiary.BillNo = tempBill.BillNo;
tempSubsidiary.GoodsID = tempItem.GoodsID;
tempSubsidiary.OperationCount = tempItem.OperationCount;
tempSubsidiary.OperationType = item.OperationType;
tempSubsidiary.Remark = tempItem.Remark;
tempSubsidiary.WSCode = item.WSCode;
tempSubsidiary.Proposer = tempBill.Proposer;
tempSubsidiary.ProposerDate = (DateTime)tempBill.ProposerDate;
tempSubsidiary.Affirm = BasicInfo.LoginName;
tempSubsidiary.AffirmDate = ServerTime.Time;
tempSubsidiary.BillTime = ServerTime.Time;
WS_CannibalizeWSCode tempCanWSCode = new WS_CannibalizeWSCode();
tempCanWSCode.BillNo = tempSubsidiary.BillNo;
Service_Manufacture_WorkShop.IWorkShopStock serverStock =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopStock>();
switch (item.OperationType)
{
case (int)CE_SubsidiaryOperationType.车间调出:
tempCanWSCode.OperationType = (int)CE_SubsidiaryOperationType.车间调入;
WS_WorkShopStock tempWSStock = serverStock.GetStockSingleInfo(tempSubsidiary.WSCode,
tempSubsidiary.GoodsID,
tempSubsidiary.BatchNo);
unitPrice = tempWSStock == null ? 0 : tempWSStock.UnitPrice;
tempSubsidiary.UnitPrice = unitPrice;
break;
case (int)CE_SubsidiaryOperationType.车间调入:
tempCanWSCode.OperationType = (int)CE_SubsidiaryOperationType.车间调出;
tempSubsidiary.UnitPrice = unitPrice;
break;
default:
break;
}
tempCanWSCode = GetCannibalizeWSCode(tempCanWSCode);
if (tempCanWSCode == null)
{
throw new Exception("调运车间信息错误");
}
Service_Manufacture_WorkShop.IWorkShopBasic serverBasic =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopBasic>();
WS_WorkShopCode tempCode = serverBasic.GetWorkShopCodeInfo(tempCanWSCode.WSCode);
if (tempCode == null)
{
throw new Exception("获取车间名称失败");
}
tempSubsidiary.Applicant = tempCode.WSName;
serverStock.OperationSubsidiary(ctx, tempSubsidiary);
}
}
ctx.SubmitChanges();
ctx.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
error = ex.Message;
return(false);
}
}
