/// <summary> /// 从界面获取药房盘点表头信息 /// </summary> /// <returns>药房盘点表头信息</returns> public DS_CheckHead GetInHeadInfoDS() { DS_CheckHead inHead = new DS_CheckHead(); frmFormInHead.GetValue <DS_CheckHead>(inHead); return(inHead); }
public ServiceResponseData SaveBill() { string belongSys = requestData.GetData <string>(0); string busiType = requestData.GetData <string>(1); IDGBill iProcess = NewObject <DGBillFactory>().GetBillProcess(busiType); if (belongSys == DGConstant.OP_DW_SYSTEM) { DW_CheckHead head = requestData.GetData <DW_CheckHead>(2); List <DW_CheckDetail> details = requestData.GetData <List <DW_CheckDetail> >(3); List <int> deleteDetails = requestData.GetData <List <int> >(4); oleDb.BeginTransaction(); try { foreach (int detailID in deleteDetails) { NewObject <DW_CheckDetail>().delete(detailID); } iProcess.SaveBill(head, details); oleDb.CommitTransaction(); responseData.AddData(true); } catch (Exception error) { oleDb.RollbackTransaction(); responseData.AddData(false); responseData.AddData(error.Message); } } else { DS_CheckHead head = requestData.GetData <DS_CheckHead>(2); List <DS_CheckDetail> details = requestData.GetData <List <DS_CheckDetail> >(3); List <int> deleteDetails = requestData.GetData <List <int> >(4); oleDb.BeginTransaction(); try { foreach (int detailID in deleteDetails) { NewObject <DS_CheckDetail>().delete(detailID); } iProcess.SaveBill(head, details); oleDb.CommitTransaction(); responseData.AddData(true); } catch (Exception error) { oleDb.RollbackTransaction(); responseData.AddData(false); responseData.AddData(error.Message); } } return(responseData); }
/// <summary> /// 删除药房盘点单 /// </summary> /// <param name="billID">药房盘点单头ID</param> public override void DeleteBill(int billID) { DS_CheckHead inHead = (DS_CheckHead)NewObject <DS_CheckHead>().getmodel(billID); if (inHead.AuditFlag == 1) { throw new Exception("当前单据已经审核,无法删除"); } else { inHead.DelFlag = 1; inHead.save(); } }
public ServiceResponseData GetEditBillHead() { string belongSys = requestData.GetData <string>(0); int billID = requestData.GetData <int>(1); if (belongSys == DGConstant.OP_DW_SYSTEM) { DW_CheckHead head = (DW_CheckHead)NewObject <DW_CheckHead>().getmodel(billID); responseData.AddData(head); } else { DS_CheckHead head = (DS_CheckHead)NewObject <DS_CheckHead>().getmodel(billID); responseData.AddData(head); } return(responseData); }
/// <summary> /// 保存药房盘点录入单 /// </summary> /// <typeparam name="THead">药房盘点单表头模板</typeparam> /// <typeparam name="TDetail">药房盘点单明细模板</typeparam> /// <param name="billHead">药房盘点单头</param> /// <param name="billDetails">药房盘点单明细</param> public override void SaveBill <THead, TDetail>(THead billHead, List <TDetail> billDetails) { DS_CheckHead inHead = billHead as DS_CheckHead; List <DS_CheckDetail> inDetals = billDetails as List <DS_CheckDetail>; inHead.RegTime = System.DateTime.Now; string serialNO = NewObject <SerialNumberSource>().GetSerialNumber(SnType.药品, inHead.DeptID, inHead.BusiType); inHead.BillNO = Convert.ToInt64(serialNO); BindDb(inHead); inHead.save(); if (inHead.CheckHeadID > 0) { foreach (DS_CheckDetail detail in inDetals) { detail.CheckHeadID = inHead.CheckHeadID; BindDb(detail); detail.save(); } } //设置盘点状态:将库房的盘点状态修改成1 NewDao <IDGDao>().SetCheckStatus(inHead.DeptID, 1, 0); }
/// <summary> /// 审核单据 /// </summary> /// <param name="deptId">科室Id</param> /// <param name="auditEmpID">审核人ID</param> /// <param name="auditEmpName">审核人姓名</param> /// <returns>处理结果</returns> public override DGBillResult AuditBill(int deptId, int auditEmpID, string auditEmpName) { string serialNO = string.Empty;//审核单据号 //1.检查库房状态是否处于盘点状态 int checkStatus = NewDao <SqlDSDao>().GetStoreRoomStatus(deptId); if (checkStatus == 0) { throw new Exception("药房系统没有进入盘点状态,请启用盘点状态"); } //2.提取所有未审核的单据返回DataTable; Dictionary <string, string> queryCondition = new Dictionary <string, string>(); queryCondition.Add("a.DeptID", deptId.ToString()); DataTable dtNotAuditDetail = LoadAllNotAuditDetail(queryCondition, true); //3.创建盘点审核单据头 DS_AuditHead auditHead = NewObject <DS_AuditHead>(); decimal profitRetailFee = 0, profitStockFee = 0, lossRetailFee = 0, lossStockFee = 0; decimal checkStockFee = 0, actStockFee = 0, checkRetailFee = 0, actRetailFee = 0; checkStockFee = Convert.ToDecimal(dtNotAuditDetail.Compute("sum(FactStockFee)", "true")); //盘存进货金额 actStockFee = Convert.ToDecimal(dtNotAuditDetail.Compute("sum(ActStockFee)", "true")); //账存进货金额 checkRetailFee = Convert.ToDecimal(dtNotAuditDetail.Compute("sum(FactRetailFee)", "true")); //盘存零售金额 actRetailFee = Convert.ToDecimal(dtNotAuditDetail.Compute("sum(ActRetailFee)", "true")); //账存零售金额 profitRetailFee = checkRetailFee - actRetailFee > 0 ? checkRetailFee - actRetailFee : 0; //盘盈零售金额 profitStockFee = checkStockFee - actStockFee > 0 ? checkStockFee - actStockFee : 0; //盘盈进货金额 lossRetailFee = checkRetailFee - actRetailFee < 0 ? Math.Abs(checkRetailFee - actRetailFee) : 0; //盘亏零售金额 lossStockFee = checkStockFee - actStockFee < 0 ? Math.Abs(checkStockFee - actStockFee) : 0; //盘亏进货金额 serialNO = NewObject <SerialNumberSource>().GetSerialNumber(SnType.药品, deptId, DGConstant.OP_DS_AUDITCHECK); auditHead.BillNO = Convert.ToInt64(serialNO); auditHead.EmpID = auditEmpID; auditHead.EmpName = auditEmpName; auditHead.AuditTime = System.DateTime.Now; auditHead.Remark = string.Empty; auditHead.DelFlag = 0; auditHead.AuditFlag = 1; auditHead.BusiType = DGConstant.OP_DS_AUDITCHECK; auditHead.DeptID = deptId; auditHead.ProfitRetailFee = profitRetailFee; auditHead.ProfitStockFee = profitStockFee; auditHead.LossRetailFee = lossRetailFee; auditHead.LossStockFee = lossStockFee; auditHead.CheckStockFee = checkStockFee; auditHead.ActStockFee = actStockFee; auditHead.CheckRetailFee = checkRetailFee; auditHead.ActRetailFee = actRetailFee; BindDb(auditHead); auditHead.save(); //循环DataTable,根据DataTable的每一行的值去构建盘点审核单明细和盘点审核单头; //4.保存盘点审核单表头和明细 //5、按盘点审核单内容更新药库库存 DGBillResult result = new DGBillResult(); foreach (DataRow drNotAuditRow in dtNotAuditDetail.Rows) { StoreParam storeParam = new StoreParam(); storeParam.DeptID = auditHead.DeptID; storeParam.DrugID = Convert.ToInt32(drNotAuditRow["DrugID"]); storeParam.RetailPrice = Convert.ToDecimal(drNotAuditRow["RetailPrice"]); storeParam.StockPrice = Convert.ToDecimal(drNotAuditRow["StockPrice"]); storeParam.FactAmount = Convert.ToDecimal(drNotAuditRow["FactAmount"]); storeParam.ActAmount = Convert.ToDecimal(drNotAuditRow["ActAmount"]); DGStoreResult storeRtn = NewObject <DSStore>().AddStoreAuto(storeParam, true); if (storeRtn.Result != 0) { result.Result = 1; if (storeRtn.Result == 1) { result.LstNotEnough = new List <DGNotEnough>(); DGNotEnough notEnough = new DGNotEnough(); notEnough.DeptID = Convert.ToInt32(drNotAuditRow["DeptID"]); notEnough.DrugID = Convert.ToInt32(drNotAuditRow["DrugID"]); notEnough.DrugInfo = "药品名称:" + drNotAuditRow["ChemName"].ToString(); result.LstNotEnough.Add(notEnough); result.ErrMsg = "【" + notEnough.DrugInfo + "】保存错误"; } else { result.ErrMsg = "药品更新库存出错"; } return(result); } else { foreach (DGBatchAllot batchAllot in storeRtn.BatchAllotList) { DS_AuditDetail auditdetail = NewObject <DS_AuditDetail>(); auditdetail.StorageID = Convert.ToInt32(drNotAuditRow["StorageID"]); auditdetail.CTypeID = Convert.ToInt32(drNotAuditRow["CTypeID"]); auditdetail.DrugID = Convert.ToInt32(drNotAuditRow["DrugID"]); auditdetail.Place = drNotAuditRow["Place"].ToString(); auditdetail.DeptID = auditHead.DeptID; auditdetail.BillNO = auditHead.BillNO; auditdetail.UnitID = Convert.ToInt32(drNotAuditRow["UnitID"]); auditdetail.UnitName = drNotAuditRow["UnitName"].ToString(); auditdetail.PackUnit = drNotAuditRow["PackUnit"].ToString(); auditdetail.UnitAmount = Convert.ToInt32(drNotAuditRow["UnitAmount"].ToString()); auditdetail.AuditHeadID = auditHead.AuditHeadID; auditdetail.BatchNO = batchAllot.BatchNO; auditdetail.ValidityDate = batchAllot.ValidityDate; auditdetail.RetailPrice = batchAllot.RetailPrice; auditdetail.StockPrice = batchAllot.StockPrice; auditdetail.FactAmount = batchAllot.FactAmount; auditdetail.FactStockFee = batchAllot.FactStockFee; auditdetail.FactRetailFee = batchAllot.FactRetailFee; auditdetail.ActAmount = batchAllot.ActAmount; auditdetail.ActStockFee = batchAllot.ActStockFee; auditdetail.ActRetailFee = batchAllot.ActRetailFee; BindDb(auditdetail); auditdetail.save(); //写台账表 WriteAccount(auditHead, auditdetail, batchAllot); } } } //7、更新所有未审核的盘点录入单状态 DS_CheckHead checkHead = NewObject <DS_CheckHead>(); checkHead.AuditEmpID = auditEmpID; checkHead.AuditEmpName = auditEmpName; checkHead.AuditHeadID = auditHead.AuditHeadID; checkHead.AuditNO = (int)auditHead.BillNO; checkHead.DeptID = deptId; int ret = NewDao <IDSDao>().UpdateCheckHeadStatus(checkHead); if (ret > 0) { //8、设置库房盘点状态为运营状态 NewDao <IDGDao>().SetCheckStatus(deptId, 0, 0); result.Result = 0; } else { result.Result = 1; } return(result); }