/// <summary>
/// 赋值账务信息
/// </summary>
/// <param name="dataContxt">数据上下文</param>
/// <param name="bill">单据信息</param>
/// <param name="item">明细信息</param>
/// <returns>返回账务信息</returns>
S_FetchGoodsDetailBill AssignDetailInfo(DepotManagementDataContext dataContxt, S_ScrapBill bill, S_ScrapGoods item)
{
Service_Manufacture_WorkShop.IWorkShopStock serverWSStock =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopStock>();
Service_Manufacture_WorkShop.IWorkShopBasic serverWSBasic =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopBasic>();
WS_WorkShopCode tempWSCode = serverWSBasic.GetPersonnelWorkShop(dataContxt, bill.FillInPersonnelCode);
S_FetchGoodsDetailBill detailBill = new S_FetchGoodsDetailBill();
string error = "";
if (!m_serverProductCode.UpdateProductStock(dataContxt, bill.Bill_ID, "报废", "05", false, item.GoodsID, out error))
{
throw new Exception(error);
}
detailBill.ID = Guid.NewGuid();
detailBill.FetchBIllID = bill.Bill_ID;
detailBill.BillTime = ServerTime.Time;
detailBill.FetchCount = -(decimal)item.Quantity;
detailBill.GoodsID = item.GoodsID;
detailBill.BatchNo = item.BatchNo == "无批次" ? "" : item.BatchNo;
WS_WorkShopStock tempWSStock = new WS_WorkShopStock();
if (tempWSCode != null)
{
tempWSStock = serverWSStock.GetStockSingleInfo(dataContxt, tempWSCode.WSCode, item.GoodsID, item.BatchNo);
}
detailBill.UnitPrice = tempWSStock == null ? 0 : tempWSStock.UnitPrice;
detailBill.Price = detailBill.UnitPrice * (decimal)detailBill.FetchCount;
detailBill.Provider = item.Provider;
detailBill.FillInPersonnel = bill.FillInPersonnel;
detailBill.FinanceSignatory = null;
detailBill.DepartDirector = bill.DepartmentDirector;
detailBill.DepotManager = bill.DepotManager;
detailBill.OperationType = (int)CE_SubsidiaryOperationType.报废;
detailBill.Remark = "【报废】";
detailBill.FillInDate = bill.Bill_Time;
return(detailBill);
}
/// <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_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);
}
}
/// <summary>
/// 检测有关数据项内容是否正确
/// </summary>
/// <returns>返回检测结果</returns>
bool CheckDataItem()
{
if (txtName.Text.Length == 0)
{
MessageDialog.ShowPromptMessage("请选择物品信息");
return(false);
}
//检测是否为售后库房的总成并且要求必须选择产品状态
if (Convert.ToBoolean(UniversalFunction.GetGoodsAttributeInfo(Convert.ToInt32(txtCode.Tag), CE_GoodsAttributeName.CVT)) &&
cmbProductStatus.Text.Trim() == "" && m_strStorage == "05")
{
cmbProductStatus.Focus();
MessageDialog.ShowPromptMessage("请选择产品状态");
return(false);
}
if (numReturnedCount.Value == 0)
{
numReturnedCount.Focus();
MessageDialog.ShowPromptMessage("领料退库数量必须 > 0");
return(false);
}
if (Convert.ToBoolean(BasicInfo.BaseSwitchInfo[(int)GlobalObject.CE_SwitchName.开启车间管理模块]) && txtBatchNo.Text.Trim().Length == 0 && m_lnqWSCode != null)
{
Service_Manufacture_WorkShop.IWorkShopStock serverStock =
Service_Manufacture_WorkShop.ServerModuleFactory.GetServerModule <Service_Manufacture_WorkShop.IWorkShopStock>();
WS_WorkShopStock tempLnq = serverStock.GetStockSingleInfo(m_lnqWSCode.WSCode, (int)txtCode.Tag, "");
if (tempLnq == null)
{
btnBatchNo.Focus();
MessageDialog.ShowPromptMessage("批次号不能为空");
return(false);
}
}
if (m_promptBatchNo)
{
if (MessageDialog.ShowEnquiryMessage("批次号通常的表示方式为4位年、2位月、6位流水码，您确定您输入的批次号是正确的吗？") == DialogResult.No)
{
txtBatchNo.Focus();
return(false);
}
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (txtBatchNo.Text.Trim() == dataGridView1.Rows[i].Cells["批次号"].Value.ToString() &&
(int)txtCode.Tag == Convert.ToInt32(dataGridView1.Rows[i].Cells["物品ID"].Value) &&
i != dataGridView1.CurrentRow.Index)
{
MessageDialog.ShowPromptMessage("不可重复添加同批次同一种物品");
return(false);
}
}
return(true);
}
