/// <summary> /// 获取票据领用记录 /// </summary> /// <returns>返回DataTable</returns> public static System.Data.DataTable GetInvoiceRecord() { Iinvoice itD = DaoFactory.GetObject <Iinvoice>(typeof(InvoiceDao)); itD.oleDb = oleDb; return(itD.GetInvoiceRecord()); }
public static void UpdateDeliveryNoteNumber(Iinvoice invoice) { SqlParameter[] _parameters = { new SqlParameter("@ID", invoice.Id) , new SqlParameter("@InvoiceNumber", invoice.InvoiceNumber) , new SqlParameter("@CustomerCode", invoice.CustomerCode) , new SqlParameter("@DeliveryNoteNumber", invoice.DeliveryNoteNumber) , new SqlParameter("@Processed", invoice.Processed) , new SqlParameter("@SysCreator", invoice.SysCreator) }; SqlHelper.ExecuteNonQuery(ConnectionString, "sp_Invoices_UpdateDeliveryNoteNumber", _parameters); }
/// <summary> /// 根据结算ID得到发票内容 /// </summary> /// <param name="invoice">发票内容</param> /// <param name="CostMasterID">结算ID</param> protected void GetInvoiceInfo(AbstractInvoice invoice, int CostMasterID) { zyCM = BindEntity <ZY_CostMaster> .CreateInstanceDAL(oleDb).GetModel(CostMasterID); zyPL = BindEntity <ZY_PatList> .CreateInstanceDAL(oleDb).GetModel(zyCM.PatListID); invoice.病人姓名 = zyPL.patientInfo.PatName; invoice.发票号 = zyCM.TicketCode; invoice.住院号 = zyPL.CureNo; invoice.科室 = zyPL.CurrDeptCode.Trim() == "" ? BaseNameFactory.GetName(baseNameType.科室名称, zyPL.CureDeptCode) : BaseNameFactory.GetName(baseNameType.科室名称, zyPL.CurrDeptCode);// HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetDeptName(zyPL.CureDeptCode); invoice.床位号 = zyPL.BedCode; invoice.入院日期 = zyPL.CureDate; invoice.出院日期 = zyPL.OutDate; invoice.住院天数 = zyPL.ReaLiveNum; DateTime PrintDate = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime; invoice.年 = PrintDate.Date.Year.ToString(); invoice.月 = PrintDate.Date.Month.ToString(); invoice.日 = PrintDate.Date.Day.ToString(); if (zyCM.Ticket_Flag == 1) { invoice.总费用 = zyCM.Total_Fee.ToString("0.00"); } else if (zyCM.Ticket_Flag == 2) { invoice.总费用 = zyCM.Self_Fee.ToString("0.00"); } else { invoice.总费用 = zyCM.Total_Fee.ToString("0.00"); } invoice.预交金 = zyCM.Deptosit_Fee.ToString(); if (zyCM.Ntype == 1) { invoice.补收 = "0"; invoice.应退 = "0"; invoice.费 = "0"; //zyT.出院日期 = null; } else if (zyCM.Ntype == 2) { if (zyCM.Reality_Fee <= 0) { invoice.应退 = Convert.ToString(0 - zyCM.Reality_Fee); invoice.补收 = "0"; } else { invoice.补收 = zyCM.Reality_Fee.ToString(); invoice.应退 = "0"; } invoice.费 = "0"; } else if (zyCM.Ntype == 3) { invoice.补收 = zyCM.Reality_Fee.ToString(); invoice.应退 = "0"; invoice.费 = Convert.ToString(zyCM.Self_Fee - zyCM.Deptosit_Fee - zyCM.Reality_Fee); } invoice.收费员 = BaseNameFactory.GetName(baseNameType.用户名称, zyCM.ChargeCode);//HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetUserName(zyCM.ChargeCode); invoice.发票流水号 = zyCM.TicketNum; Iinvoice itD = DaoFactory.GetObject <Iinvoice>(typeof(InvoiceDao)); itD.oleDb = oleDb; invoice.发票项目费用 = itD.GetInvoiceInfo(CostMasterID); }