/// <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);
}
