/// <summary>
/// 赋值账务信息
/// </summary>
/// <param name="context">数据上下文</param>
/// <param name="bill">单据信息</param>
/// <param name="item">明细信息</param>
/// <returns>返回账务信息对象</returns>
public S_FetchGoodsDetailBill AssignDetailInfo(DepotManagementDataContext context, S_MaterialReturnedInTheDepot bill,
S_MaterialListReturnedInTheDepot 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);
//单价设置
decimal dcStockUnitPrice = m_serverStore.GetGoodsUnitPrice(context, item.GoodsID, item.BatchNo, bill.StorageID);
//S_FetchGoodsDetailBill用于存放每次领料、领料退库的明细信息
S_FetchGoodsDetailBill detailBill = new S_FetchGoodsDetailBill();
detailBill.ID = Guid.NewGuid();
detailBill.FetchBIllID = bill.Bill_ID;
detailBill.BillTime = ServerTime.Time;
detailBill.FetchCount = -item.ReturnedAmount;
detailBill.GoodsID = item.GoodsID;
detailBill.BatchNo = item.BatchNo;
detailBill.ProviderBatchNo = item.ProviderBatchNo;
detailBill.Provider = item.Provider;
detailBill.Price = -dcStockUnitPrice * (decimal)item.ReturnedAmount;
detailBill.UnitPrice = dcStockUnitPrice;
detailBill.Department = department.部门名称;
detailBill.FillInPersonnel = bill.FillInPersonnel;
detailBill.FinanceSignatory = null;
detailBill.DepartDirector = bill.DepartmentDirector;
detailBill.DepotManager = bill.DepotManager;
detailBill.OperationType = (int)CE_SubsidiaryOperationType.领料退库;
detailBill.StorageID = bill.StorageID;
detailBill.Remark = "退库原因：" + bill.ReturnReason + ";备注：" + item.Remark;
detailBill.FillInDate = bill.Bill_Time;
IMaterialRequisitionPurposeServer purposeServer =
ServerModuleFactory.GetServerModule <IMaterialRequisitionPurposeServer>();
detailBill.Using = string.Format("领料退库，初始用途：{0}", purposeServer.GetBillPurpose(context, bill.PurposeCode).Purpose);
return(detailBill);
}
/// <summary>
/// 显示信息
/// </summary>
void ShowInfo()
{
if (m_lnqBill == null)
{
return;
}
txtBillNo.Text = m_lnqBill.BillNo;
txtBillRemark.Text = m_lnqBill.Remark;
BASE_MaterialRequisitionPurpose temp = m_serverPurpose.GetBillPurpose(m_lnqBill.PurposeCode);
if (temp != null)
{
txtPurposeCode.Text = temp.Purpose;
txtPurposeCode.Tag = temp.Code;
}
txtDepartment.Text = UniversalFunction.GetDeptName(m_lnqBill.DeptCode);
txtDepartment.Tag = m_lnqBill.DeptCode;
lbBillStatus.Text = m_lnqBill.BillStatus;
lbAffirm.Text = m_lnqBill.Affirm == null ? "" : m_lnqBill.Affirm;
lbAffirmDate.Text = m_lnqBill.AffirmDate == null ? "" : m_lnqBill.AffirmDate.ToString();
lbAudit.Text = m_lnqBill.Audit == null ? "" : m_lnqBill.Audit;
lbAuditDate.Text = m_lnqBill.AuditDate == null ? "" : m_lnqBill.AuditDate.ToString();
lbPropose.Text = m_lnqBill.Proposer == null ? "" : m_lnqBill.Proposer;
lbProposerDate.Text = m_lnqBill.ProposerDate == null ? "" : m_lnqBill.ProposerDate.ToString();
if (m_lnqBill.StorageID != null)
{
cmbStorage.Tag = m_lnqBill.StorageID;
cmbStorage.Text = UniversalFunction.GetStorageName(m_lnqBill.StorageID);
}
dataGridView1.DataSource = m_serverLend.GetListInfo(m_lnqBill.BillNo);
dataGridView1.Columns["单据号"].Visible = false;
}
/// <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);
}
