/// <summary>
/// 입실리포트
/// </summary>
private void GetInReport()
{
try
{
DataTable dtRoom = new DataTable("dtRoom");
DataTable dtIn = new DataTable("dtIn");
DataTable dtSale = new DataTable("dtSale");
DataTable dtFunds = new DataTable("dtFunds");
DataTable dtMae = new DataTable("dtMae");
//DataTable dtRsvMae = new DataTable("dtRsvMae");
//DataTable dtWIMae = new DataTable("dtWIMae");
//DataTable dtCondo = new DataTable("dtCondo");
//DataTable dtChain = new DataTable("dtChain");
//DataTable dtTravel = new DataTable("dtTravel");
//DataTable dtGroup = new DataTable("dtGroup");
//DataTable dtPackage = new DataTable("dtPackage");
//DataTable dtVipIn = new DataTable("dtVipIn");
//DataTable dtWiIn = new DataTable("dtWiIn");
//DataTable dtComp = new DataTable("dtComp");
//DataTable dtAmt = new DataTable("dtAmt");
//DataTable dtDayAmt = new DataTable("dtDayAmt");
DataTable dtDate = new DataTable("dtDate");
//객실현황
DataTable dtparmSelectRoom = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelectRoom.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
dtparmSelectRoom.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelectRoom.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
DataSet ds = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_02", dtparmSelectRoom, DataLayer.MessageEncoding.Default);
dtRoom.Load(ds.Tables[0].CreateDataReader());
//1-2 입실내역
DataTable dtparmSelectIn = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelectIn.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
dtparmSelectIn.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelectIn.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
DataSet dsIn = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_03", dtparmSelectIn, DataLayer.MessageEncoding.Default);
dtIn.Load(dsIn.Tables[0].CreateDataReader());
//최종 판매 현황
DataTable dtparmSelectSale = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelectSale.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
dtparmSelectSale.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelectSale.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
DataSet dsSale = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_04", dtparmSelectSale, DataLayer.MessageEncoding.Default);
dtSale.Load(dsSale.Tables[0].CreateDataReader());
//1-4 당일입금내역,1-5외상매출
DataTable dtparmSelectFunds = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelectFunds.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
dtparmSelectFunds.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelectFunds.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
DataSet dsFunds = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_16", dtparmSelectFunds, DataLayer.MessageEncoding.Default);
dtFunds.Load(dsFunds.Tables[0].CreateDataReader());
// 입실 매출 상세 내역
DataTable dtparmSelectMae = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelectMae.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
dtparmSelectMae.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelectMae.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
DataSet dsMae = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_14", dtparmSelectMae, DataLayer.MessageEncoding.Default);
dtMae.Load(dsMae.Tables[0].CreateDataReader());
////예약입실
//DataTable dtparmSelectRsvMae = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectRsvMae.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectRsvMae.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectRsvMae.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsRsvMae = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_05", dtparmSelectRsvMae, DataLayer.MessageEncoding.Default);
//dtRsvMae.Load(dsRsvMae.Tables[0].CreateDataReader());
////워크인입실
//DataTable dtparmSelectWIMae = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectWIMae.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectWIMae.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectWIMae.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsWIMae = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_06", dtparmSelectWIMae, DataLayer.MessageEncoding.Default);
//dtWIMae.Load(dsWIMae.Tables[0].CreateDataReader());
//// 2-3 콘도
//DataTable dtparmSelectCondo = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectCondo.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectCondo.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectCondo.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsCondo = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_18", dtparmSelectCondo, DataLayer.MessageEncoding.Default);
//dtCondo.Load(dsCondo.Tables[0].CreateDataReader());
//DataTable dtparmSelectChain = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectChain.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectChain.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectChain.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsChain = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_07", dtparmSelectChain, DataLayer.MessageEncoding.Default);
//dtChain.Load(dsChain.Tables[0].CreateDataReader());
//DataTable dtparmSelectTravel = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectTravel.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectTravel.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectTravel.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsTravel = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_08", dtparmSelectTravel, DataLayer.MessageEncoding.Default);
//dtTravel.Load(dsTravel.Tables[0].CreateDataReader());
////
//DataTable dtparmSelectGroup = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectGroup.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectGroup.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectGroup.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsGroup = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_09", dtparmSelectGroup, DataLayer.MessageEncoding.Default);
//dtGroup.Load(dsGroup.Tables[0].CreateDataReader());
//DataTable dtparmSelectPackage = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectPackage.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectPackage.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectPackage.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsPackage = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_10", dtparmSelectPackage, DataLayer.MessageEncoding.Default);
//dtPackage.Load(dsPackage.Tables[0].CreateDataReader());
//DataTable dtparmSelectVipIn = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectVipIn.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectVipIn.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectVipIn.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsVipIn = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_11", dtparmSelectVipIn, DataLayer.MessageEncoding.Default);
//dtVipIn.Load(dsVipIn.Tables[0].CreateDataReader());
//DataTable dtparmSelectWiIn = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectWiIn.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectWiIn.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectWiIn.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsWiIn = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_12", dtparmSelectWiIn, DataLayer.MessageEncoding.Default);
//dtWiIn.Load(dsWiIn.Tables[0].CreateDataReader());
//DataTable dtparmSelectComp = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectComp.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectComp.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectComp.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsComp = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_13", dtparmSelectComp, DataLayer.MessageEncoding.Default);
//dtComp.Load(dsComp.Tables[0].CreateDataReader());
//DataTable dtparmSelectAmt = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectAmt.Rows.Add(new object[] { "V_RAISE_CODE_DEPOSIT", Parm_Pay.RAISE_CODE_DEPOSIT });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_CASH", Parm_Pay.PAY_CODE_CASH });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_CARD", Parm_Pay.PAY_CODE_CARD });
//dtparmSelectAmt.Rows.Add(new object[] { "V_RAISE_CODE_CO_AMT", Parm_Pay.RAISE_CODE_CO_AMT });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_GOLF_DEFER", Parm_Pay.PAY_CODE_GOLF_DEFER });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_GROUP_DEFER", Parm_Pay.PAY_CODE_GROUP_DEFER });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_TICKET", Parm_Pay.PAY_CODE_TICKET });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_TRUST", Parm_Pay.PAY_CODE_TRUST });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_REFUND1", Parm_Pay.PAY_CODE_REFUND1 });
//dtparmSelectAmt.Rows.Add(new object[] { "V_PAY_CODE_REFUND2", Parm_Pay.PAY_CODE_REFUND2 });
//dtparmSelectAmt.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Replace("-", "") });
//dtparmSelectAmt.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectAmt.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue });
//DataSet dsAmt = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_15", dtparmSelectAmt, DataLayer.MessageEncoding.Default);
//dtAmt.Load(dsAmt.Tables[0].CreateDataReader());
//DataTable dtparmSelectDayAmt = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
//dtparmSelectDayAmt.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
//dtparmSelectDayAmt.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//dtparmSelectDayAmt.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString() });
//DataSet dsDayAmt = DataLayer.ExecuteSpDataset("PKG_DEAAI04.PR_17", dtparmSelectDayAmt, DataLayer.MessageEncoding.Default);
//dtDayAmt.Load(dsDayAmt.Tables[0].CreateDataReader());
string strDate = ((DateTime)this.dtpTaskDate.EditValue).ToString("yyyy년 M월 d일 dddd");
dtDate.Columns.Add("DATE");
dtDate.Rows.Add(new object[] { strDate });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtRoom.Copy()
, dtIn.Copy()
, dtSale.Copy()
//, dtRsvMae.Copy()
//, dtWIMae.Copy()
//, dtChain.Copy()
//, dtTravel.Copy()
//, dtGroup.Copy()
//, dtPackage.Copy()
//, dtVipIn.Copy()
//, dtWiIn.Copy()
//, dtComp.Copy()
, dtDate.Copy()
, dtMae.Copy()
//, dtAmt.Copy()
, dtFunds.Copy()
//, dtDayAmt.Copy()
//, dtCondo.Copy()
});
frmReport1 = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DBAA.Report.DEAAP05_01();
frmReport1.ShowReport(dsTemp, rpt); // FREEVIEW
frmReport1.Show();
//rpt.PrinterName = Parm.CurrentUserInformation.roomTask.TSP800;
//frmReport.ShowReportPrint(dsTemp, rpt, 1); // 출력
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 프린트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
DataTable dtMae = new DataTable("dtMae");
DataTable dtAmt = new DataTable("dtAmt");
DataTable dtOth = new DataTable("dtOth");
DataTable dtUse = new DataTable("dtUse");
//객실판매실적
DataTable dtparmdtMae = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmdtMae.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmdtMae.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility });
dtparmdtMae.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
DataSet dsMae = DataLayer.ExecuteSpDataset("PKG_DEAAI05.PR_01", dtparmdtMae, DataLayer.MessageEncoding.Default);
dtMae.Load(dsMae.Tables[0].CreateDataReader());
//일일객실 판매액
DataTable dtparmdtAmt = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmdtAmt.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmdtAmt.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility });
dtparmdtAmt.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
DataSet dsAmt = DataLayer.ExecuteSpDataset("PKG_DEAAI05.PR_01", dtparmdtAmt, DataLayer.MessageEncoding.Default);
dtAmt.Load(dsAmt.Tables[1].CreateDataReader());
// 기타매출
DataTable dtparmdtOth = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmdtOth.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmdtOth.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility });
dtparmdtOth.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
DataSet dsOth = DataLayer.ExecuteSpDataset("PKG_DEAAI05.PR_01", dtparmdtOth, DataLayer.MessageEncoding.Default);
dtOth.Load(dsOth.Tables[2].CreateDataReader());
// 객실사용내역
DataTable dtparmdtUse = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmdtUse.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmdtUse.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility });
dtparmdtUse.Rows.Add(new object[] { "V_TASK_DATE", this.dtpTaskDate.Text.Trim().Replace("-", "") });
DataSet dsUse = DataLayer.ExecuteSpDataset("PKG_DEAAI05.PR_01", dtparmdtUse, DataLayer.MessageEncoding.Default);
dtUse.Load(dsUse.Tables[3].CreateDataReader());
//string pBizCode = Parm.CurrentUserInformation.BizInfo.BizCode;
//string pFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility;
string pTaskDate = this.dtpTaskDate.Text.Trim();
DataTable dtTmp = new DataTable("dtReport");
dtTmp.Columns.Add("TASK_DATE");
dtTmp.Rows.Add(new object[] { pTaskDate });
//필터링된 데이터를 담는다.
//DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] {
dtTmp
, dtMae.Copy()
, dtAmt.Copy()
, dtOth.Copy()
, dtUse.Copy()
});
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DBAA.Report.DEAAP05_01();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
