public static InvoiceEntity ConfirmInvoiceDetail(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("ConfirmInvoiceDetail"); cmd.SetParameterValue("@SLID", dbParm.SLID); cmd.SetParameterValue("@INVOICENM", dbParm.InvoiceName); cmd.SetParameterValue("@INVOICEPROJECT", dbParm.InvoiceProject); cmd.SetParameterValue("@INVOICEAMOUNT", dbParm.InvoiceAmount); cmd.SetParameterValue("@ZIPADDRESS", dbParm.ZipAddress); cmd.SetParameterValue("@INVOICENUM", dbParm.InvoiceNum); cmd.SetParameterValue("@ZIPNUM", dbParm.ZipNum); cmd.SetParameterValue("@CREATEUSER", invoiceEntity.LogMessages.Userid); invoiceEntity.Result = cmd.ExecuteNonQuery(); int invoiceID = (int)cmd.GetParameterValue("@InvoiceID"); DataCommand slCmd = DataCommandManager.GetDataCommand("UpdateSLInvoiceNum"); slCmd.SetParameterValue("@SLID", dbParm.SLID); slCmd.SetParameterValue("@INVOICEID", invoiceID); slCmd.SetParameterValue("@INVOICESTATUS", "1"); slCmd.SetParameterValue("@OPEUSER", invoiceEntity.LogMessages.Userid); slCmd.ExecuteNonQuery(); // 更新清结算表内的发票ID和发票状态 return invoiceEntity; }
public static InvoiceEntity GetConfirmInvoiceDetail(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetConfirmInvoiceDetail"); cmd.SetParameterValue("@SLID", dbParm.SLID); cmd.SetParameterValue("@INVOICEID", dbParm.InvoiceID); invoiceEntity.InvoiceDBEntity[0].InvoiceDetail = cmd.ExecuteDataSet(); return invoiceEntity; }
public static InvoiceEntity GetInvoiceDetail(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); if ("0".Equals(dbParm.InvoiceDataType)) { return GetUnitInvoiceDetail(invoiceEntity); } else { return GetConfirmInvoiceDetail(invoiceEntity); } }
/// <summary> /// 发票详情取得 /// </summary> /// <param name="invoiceEntity"></param> /// <returns></returns> public static InvoiceEntity GetInvoiceDetail(InvoiceEntity invoiceEntity) { //liquidateEntity.LogMessages.MsgType = MessageType.INFO; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select"; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); try { return InvoiceDA.GetInvoiceDetail(invoiceEntity); } catch (Exception ex) { //liquidateEntity.LogMessages.MsgType = MessageType.ERROR; //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select Error: " + ex.Message; //LoggerHelper.LogWriter(liquidateEntity.LogMessages); throw ex; } }
public static InvoiceEntity ExportUnOpenInvoiceList(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("ExportUnOpenInvoiceList"); cmd.SetParameterValue("@UnitName", dbParm.UnitName); cmd.SetParameterValue("@HotelID", dbParm.HotelID); cmd.SetParameterValue("@HotelGroup", dbParm.HotelGroup); cmd.SetParameterValue("@CityID", dbParm.CityID); cmd.SetParameterValue("@UnitCharge", dbParm.UnitCharge); cmd.SetParameterValue("@OrderID", dbParm.OrderID); cmd.SetParameterValue("@SlMonth", dbParm.SlMonth); cmd.SetParameterValue("@InvoiceStatus", dbParm.InvoiceStatus); invoiceEntity.InvoiceDBEntity[0].InvoiceExportList = cmd.ExecuteDataSet(); return invoiceEntity; }
public static InvoiceEntity GetInvoiceList(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetInvoiceList"); cmd.SetParameterValue("@UnitName", dbParm.UnitName); cmd.SetParameterValue("@HotelID", dbParm.HotelID); cmd.SetParameterValue("@HotelGroup", dbParm.HotelGroup); cmd.SetParameterValue("@CityID", dbParm.CityID); cmd.SetParameterValue("@UnitCharge", dbParm.UnitCharge); cmd.SetParameterValue("@OrderID", dbParm.OrderID); cmd.SetParameterValue("@SlMonth", dbParm.SlMonth); cmd.SetParameterValue("@InvoiceStatus", dbParm.InvoiceStatus); cmd.SetParameterValue("@PageCurrent", invoiceEntity.PageCurrent); cmd.SetParameterValue("@PageSize", invoiceEntity.PageSize); cmd.SetParameterValue("@SortField", invoiceEntity.SortField); cmd.SetParameterValue("@SortType", invoiceEntity.SortType); invoiceEntity.InvoiceDBEntity[0].InvoiceList = cmd.ExecuteDataSet(); invoiceEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return invoiceEntity; }
public static InvoiceEntity ImportOpenInvoiceList(InvoiceEntity invoiceEntity) { InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("ImportOpenInvoiceList"); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); //cmd.SetParameterValue("@", dbParm.); invoiceEntity.Result = cmd.ExecuteNonQuery(); return invoiceEntity; }
public static InvoiceEntity GetUnitInvoiceDetail(InvoiceEntity invoiceEntity) { //InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); //OracleParameter[] parm ={ // new OracleParameter("UnitID",OracleType.VarChar) // }; //parm[0].Value = dbParm.UnitID; //DataSet dsResult = DbManager.Query("SettleInfo", "t_lm_settlement_unit_detail_select", true, parm); //invoiceEntity.InvoiceDBEntity[0].InvoiceDetail = dsResult; //return invoiceEntity; InvoiceDBEntity dbParm = (invoiceEntity.InvoiceDBEntity.Count > 0) ? invoiceEntity.InvoiceDBEntity[0] : new InvoiceDBEntity(); DataCommand slCmd = DataCommandManager.GetDataCommand("GetSLDetial"); slCmd.SetParameterValue("@SLID", dbParm.SLID); invoiceEntity.InvoiceDBEntity[0].InvoiceDetail = slCmd.ExecuteDataSet(); return invoiceEntity; }