/// <summary>
/// 프린터 버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
//string MemberType = this.lupMemberType.Text.Trim();
string ContracDate = this.dtpContractDateFrom.Text.Trim() + " ~ " + this.dtpContractDateTo.Text.Trim();
string MemberNameKor = this.txtMemberNameKor.Text.Trim() == "" ? "전체" : this.txtMemberNameKor.Text.Trim();
string SrchSaleEmpNo = this.txtSrchSaleEmpNo.Text.Trim() == "" ? "전체" : this.txtSrchSaleEmpNo.Text.Trim();
string CommodityCode = this.lupCommodityCode.EditValue.ToString().Trim() == "" ? "전체" : this.lupCommodityCode.EditValue.ToString().Trim();
string MemberYn = this.lupMemberYn.EditValue.ToString().Trim() == "" ? "전체" : this.lupMemberYn.EditValue.ToString().Trim();
string CancelYn = this.lupCancelYn.EditValue.ToString().Trim() == "" ? "전체" : this.lupCancelYn.EditValue.ToString().Trim();
DataTable dtTmp = new DataTable("dtWhere");
dtTmp.Columns.Add("CONTRAC_DATE_FR_TO");
dtTmp.Columns.Add("MEMBER_NAME_KOR");
dtTmp.Columns.Add("SALE_EMP_NO");
dtTmp.Columns.Add("COMMODITY_CODE");
dtTmp.Columns.Add("MEMBER_YN");
dtTmp.Columns.Add("CANCEL_YN");
dtTmp.Rows.Add(new object[] { ContracDate, MemberNameKor, SrchSaleEmpNo, CommodityCode, MemberYn, CancelYn });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ADRA.Report.ADRAP03();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트 버튼 클릭 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
//if (dt.Rows.Count <= 0)
//{
// Basic.ShowMessage(3, "출력할 내용이 없습니다.");
// return;
//}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("NO");
string strNo = this.txtNo.Text.Trim() == "" ? "*전체" : this.txtNo.Text;
dtrf.Rows.Add(strNo);
DataSet ds = new DataSet("xsd_FARAS02");
ds.Tables.AddRange(new DataTable[] { dt.Copy(), dt1.Copy(), dt2.Copy(), dt3.Copy(), dt4.Copy(), dt5.Copy(), dttot.Copy(), dtrf });
//ds.WriteXmlSchema(@"c:\xsd_FARAS02.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Event.FARA.Report.FARAP02());
f.ShowDialog();
}
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 (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
//if (f != null && f.IsHandleCreated)
//{
// f.Activate();
// return;
//}
//찾는값
string dateFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string dateTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
//if (this.txtEventNameNo.Text.ToString().Trim() == "") eventName = "*전체";
//컬러명
DataTable dtTemp = new DataTable("dtVar");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
//필드명
dtTemp.Rows.Add(new object[] { dateFrom, dateTo });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
//테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Event.FARA.Report.FCRAP07();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 출력버튼 클릭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
////컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("MONTHS");
dtTemp.Columns.Add("TASK_DATE");
dtTemp.Columns.Add("FACILITY_NAME");
DateTime dtimeTask = DateTime.ParseExact(Parm.CurrentUserInformation.roomTask.gsTaskDate, "yyyyMMdd", null);
//필드명
dtTemp.Rows.Add(new object[] { this.dtpMonths.Text.Trim()
, dtimeTask.ToString("yyyy-MM-dd")
, Parm.CurrentUserInformation.roomTask.gsDFacilityName });
///*
////프린터 데이터추가
//for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
//{
// dsTemp.Tables[0].Rows[i]["FACILITY_NAME"] = " " + dsTemp.Tables[0].Rows[i]["FACILITY_NAME"].ToString();
//}
//*/
////필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
////테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DARA.Report.DCRAP18();
f.ShowReport(dsTemp, rpt);
f.Show();
}
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 (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string giftname = this.txtGiftName.Text.Trim();
string giftpart = this.lupGiftPart.Text.Trim();
if (this.txtGiftName.Text.ToString().Trim() == "")
{
giftname = "*전체";
}
if (this.lupGiftPart.EditValue.ToString().Trim() == "")
{
giftpart = "*전체";
}
DataTable dtTemp = new DataTable("dtVar");
dtTemp.Columns.Add("GIFT_PART_CODE");
dtTemp.Columns.Add("GIFT_NAME");
dtTemp.Rows.Add(new object[] { giftname, giftpart });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ALRA.Report.ALRAP03();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
//if (dt.Rows.Count <= 0)
//{
// Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
// return;
//}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
DataTable MergedTable = new DataTable("dt");
DtMerge(dtCondo.Copy(), ref MergedTable);
string sFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy년 M월 d일 dddd");
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE");
dtTemp.Rows.Add(new object[] { sFrom });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { MergedTable.Copy()
, dtTemp
, dtTotal.Copy()
, dtWp1.Copy()
, dtWp2.Copy()
, dtWp3.Copy()
, dtOther.Copy() });
//dsTemp.WriteXmlSchema(@"c:\xsd_JMRAS07.xsd");
//return;
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JARA.Report.JMRAP07();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string sdate = ((DateTime)this.dtptaskDate.EditValue).ToString("yyyy-MM-dd");
string searchkind = this.cboSearch.SelectedItem.ToString();
string searchword = this.txtSearch.Text.Trim();
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("DATE_FROM");
dtTmp.Columns.Add("SEARCH_KIND");
dtTmp.Columns.Add("SEARCH_WORD");
dtTmp.Rows.Add(new object[] { sdate, searchkind, searchword });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DARA.Report.DBRAP01();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터 버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string date = this.dtpDateFrom.Text.Trim() + " ~ " + this.dtpDateTo.Text.Trim();
string saleinlotcnt = (this.lupSaleinlotCntFrom.EditValue.ToString().Trim() == "" ? "전체" : this.lupSaleinlotCntFrom.Text.ToString().Trim()) + " ~ " +
(this.lupSaleinlotCntTo.EditValue.ToString().Trim() == "" ? "전체" : this.lupSaleinlotCntTo.Text.ToString().Trim());
string commoditycode = this.lupCommodityCode.EditValue.ToString().Trim() == "" ? "전체" : this.lupCommodityCode.Text.ToString().Trim();
string partitioncode = this.lupPartitionCode.EditValue.ToString().Trim() == "" ? "전체" : this.lupPartitionCode.Text.ToString().Trim();
string contractno = this.txtContractNo.Text.ToString().Trim() == "" ? "전체" : this.txtContractNo.Text.ToString().Trim();
DataTable dtTmp = new DataTable("dtWhere");
dtTmp.Columns.Add("DATE");
dtTmp.Columns.Add("SALEINLOT_CNT");
dtTmp.Columns.Add("COMMODITY_CODE");
dtTmp.Columns.Add("PARTITION_CODE");
dtTmp.Columns.Add("CONTRACT_NO");
dtTmp.Rows.Add(new object[] { date, saleinlotcnt, commoditycode, partitioncode, contractno });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ADRA.Report.ADRAP07();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string srchSaleEmpNo = txtSrchSaleEmpNo.Text.ToString().Trim();
if (this.txtSrchSaleEmpNo.Text.ToString().Trim() == "")
{
srchSaleEmpNo = "*전체";
}
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("SEARCH_TEXT");
dtTemp.Rows.Add(new object[] { srchSaleEmpNo });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ADRA.Report.ADRAP01();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트 출력
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
//찾는값
string dateFrom = dtpFrom.Text.Trim();
string dateTo = dtpTo.Text.Trim();
//모두일경우
//if (this.txtName.Text.Trim() == "") p_grouprName = "*전체";
//컬러명
DataTable dtTemp = new DataTable("dtTitle");
dtTemp.Columns.Add("dateFrom");
dtTemp.Columns.Add("dateTo");
//필드명
dtTemp.Rows.Add(new object[] { dateFrom, dateTo });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
//테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JARA.Report.JMRAP23();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dtRoomType.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string rsvno = this.txtRsvNo.Text.Trim();
if (this.txtRsvNo.Text.Trim() == "")
{
rsvno = "*전체";
}
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("RSV_NO");
dtTmp.Rows.Add(new object[] { rsvno });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtRoomAssign.Copy(), dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DARA.Report.DBRAP09();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터 버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string FacilityCode = this.lupFacilityCode.EditValue.ToString().Trim() == "" ? "*전체" : this.lupFacilityCode.EditValue.ToString().Trim();
string RoomStat = this.lupRoomStat.EditValue.ToString().Trim() == "" ? "*전체" : this.lupRoomStat.EditValue.ToString().Trim();
string RoomType = this.lupRoomType.EditValue.ToString().Trim() == "" ? "*전체" : this.lupRoomType.EditValue.ToString().Trim();
string RoomView = this.lupRoomView.EditValue.ToString().Trim() == "" ? "*전체" : this.lupRoomView.EditValue.ToString().Trim();
string CleanStat = this.lupCleanStat.EditValue.ToString().Trim() == "" ? "*전체" : this.lupCleanStat.EditValue.ToString().Trim();
DataTable dtTmp = new DataTable("dtWhere");
dtTmp.Columns.Add("FACILITY_CODE");
dtTmp.Columns.Add("ROOM_STAT");
dtTmp.Columns.Add("ROOM_TYPE");
dtTmp.Columns.Add("ROOM_VIES");
dtTmp.Columns.Add("CLEAN_STAT");
dtTmp.Rows.Add(new object[] { FacilityCode, RoomStat, RoomType, RoomView, CleanStat });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DAAA.Report.DAAAP09();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt1.Rows.Count <= 0 && dt2.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string sFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string sTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Rows.Add(new object[] { sFrom, sTo });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
//필터링된 데이터를 담는다.
DataTable dtFilter2 = Cls.Grid.Options.GetGridData(this.grid2);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtFilter2, dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ADRA.Report.ADRAP02();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnInfoPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
for (int nCnt = 0; nCnt < dt.Rows.Count; nCnt++)
{
if (dt.Rows[nCnt]["CHK"].ToString() == "N")
{
continue;
}
string appno = dt.Rows[nCnt]["APPLICATION_NO"].ToString();
DataTable dtparam = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparam.Rows.Add(new object[] { "V_APPLICATION_NO", appno });
DataSet ds = DataLayer.ExecuteSpDataset("PKG_AARDS14.PR_02", dtparam, DataLayer.MessageEncoding.Default);
if (ds.Tables[0].Rows.Count <= 0)
{
continue;
}
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rptSale = new Erp.SubdivisionSale.AARA.Report.AARDP14();
f.ShowReportPrint(ds, rptSale, 1);
}
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트 출력
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
//찾는값
string dateFrom = dtpFrom.Text.Trim();
string dateTo = dtpTo.Text.Trim();
//컬러명
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
//필드명
dtTemp.Rows.Add(new object[] { dateFrom, dateTo });
DataSet ds = new DataSet("xsd_JMRAS01");
ds.Tables.AddRange(new DataTable[] { dt.Copy(),
dt2.Copy(),
dtTemp });
//테이블 추가
//DataSet dsTemp = new DataSet();
//dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dt2.Copy(), dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JARA.Report.JMRAP23();
f.ShowReport(ds, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트 버튼 클릭 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
dtrf.Columns.Add("FACILIYCODE");
//dtrf.Columns.Add("ROOMTYPE");
dtrf.Columns.Add("MEMBERCODE");
dtrf.Columns.Add("RSVWAY");
dtrf.Columns.Add("MEMBER");
dtrf.Columns.Add("GUESTNAME");
dtrf.Columns.Add("RSVNO");
dtrf.Columns.Add("STATUSCODE");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
string strFacilityCode = this.lupFacilitycode.EditValue.ToString() == "" ? "*전체" : this.lupFacilitycode.Text.ToString();
//string strRoomType = this.lupRoomtype.EditValue.ToString() == "" ? "*전체" : this.lupRoomtype.Text.ToString();
string strMemberCode = this.lupMemberCode.EditValue.ToString() == "" ? "*전체" : this.lupMemberCode.Text.ToString();
string strRsvWay = this.lupRsvWay.EditValue.ToString() == "" ? "*전체" : this.lupRsvWay.Text.ToString();
string strMember = this.txtMember.Text == "" ? "*전체" : this.txtMember.Text;
string strGuestName = this.txtGuestName.Text == "" ? "*전체" : this.txtGuestName.Text;
string strRsvNo = this.txtRsvNo.Text == "" ? "*전체" : this.txtRsvNo.Text;
string strStatusCode = this.lupStatusCode.EditValue.ToString() == "" ? "*전체" : this.lupStatusCode.Text.ToString();
//dtrf.Rows.Add(strDtFrom, strDtTo, strFacilityCode, strRoomType, strMemberCode, strRsvWay, strMember, strGuestName, strRsvNo, strStatusCode);
dtrf.Rows.Add(strDtFrom, strDtTo, strFacilityCode, strMemberCode, strRsvWay, strMember, strGuestName, strRsvNo, strStatusCode);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_CBRAS11");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
ds.WriteXmlSchema(@"c:\xsd_CBRAP11.xsd");
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Reservation.CBRA.Report.CBRAP11());
f.ShowDialog();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 프린터 버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string MemberType = this.lupMemberType.Text.Trim();
DataTable dtTmp = new DataTable("dtWhere");
dtTmp.Columns.Add("MEMBER_TYPE");
dtTmp.Rows.Add(new object[] { MemberType });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.APRA.Report.APRAP05();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트 버튼 클릭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
dtrf.Columns.Add("FACILITYTYPE");
dtrf.Columns.Add("FACILITYCODE");
dtrf.Columns.Add("TYPEL");
dtrf.Columns.Add("TYPEM");
dtrf.Columns.Add("TYPES");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
string strFacilitytype = this.lupFacilitytype.EditValue.ToString() == "" ? "*전체" : this.lupFacilitytype.EditValue.ToString();
string strFacilitycode = this.txtFacilitycode.Text.Trim() == "" ? "*전체" : this.txtFacilitycode.Text;
string strTypeL = this.txtTypecodeL.Text.Trim() == "" ? "*전체" : this.txtTypecodeL.Text;
string strTypeM = this.txtTypecodeM.Text.Trim() == "" ? "*전체" : this.txtTypecodeM.Text;
string strTypeS = this.txtTypecodeS.Text.Trim() == "" ? "*전체" : this.txtTypecodeS.Text;
dtrf.Rows.Add(strDtFrom, strDtTo, strFacilitytype, strFacilitycode, strTypeL, strTypeM, strTypeS);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_JERAS06");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
//ds.WriteXmlSchema(@"c:\xsd_JERAS06.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.JERAP06());
f.ShowDialog();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
private void BalanceBillPrint()
{
try
{
if (dt.Rows.Count <= 0)
{
return;
}
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
//DataTable dtHead = new DataTable();
//DataTable dtMae = new DataTable();
//int iRow =
//조회함수를 구현합니다.
//만약 변수가 필요없다면 아래 코드를 삭제 하세요
DataTable dtparmSelect = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelect.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtparmSelect.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString().Trim() });
dtparmSelect.Rows.Add(new object[] { "V_MNG_NO", dt.Rows[0]["MNG_NO"].ToString().Trim() });
dtparmSelect.Rows.Add(new object[] { "V_MNG_SEQ", dt.Rows[0]["MNG_SEQ"].ToString().Trim() });
//파라메터가 있을때
DataSet ds = DataLayer.ExecuteSpDataset("PKG_DCAAI01.PR_04", dtparmSelect, DataLayer.MessageEncoding.Default);
ds.Tables[0].TableName = "dtMae";
ds.Tables[1].TableName = "dtHead";
ds.DataSetName = "xsd_DCAAI01";
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DBAA.Report.DCAAP01();
f.ShowReport(ds, rpt); // FREEVIEW
f.Show();
//rpt.PrinterName = "CardPrinter";
//f.ShowReportPrint(dsTemp, rpt, 1);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
DataTable dtReport = new DataTable("dtReport");
string s1 = this.txtDccouponno.Text.Trim() == "" ? "*전체" :this.lblDccouponnoName.Text.Trim();
string s2 = this.txtMemberno.Text.Trim() == "" ? "*전체" :this.lblMemberno.Text.Trim();
string s3 = this.txtReqempname.Text.Trim() == "" ? "*전체" :this.lblReqempname.Text.Trim();
dtReport.Columns.Add("DCCOUPONNONAME");
dtReport.Columns.Add("MEMBERNO");
dtReport.Columns.Add("REQEMPNAME");
dtReport.Rows.Add(s1, s2, s3);
//필터링된 데이터를 담는다.
DataTable dtFilter1 = Cls.Grid.Options.GetGridData(this.grid);
//필터링된 데이터를 담는다.
DataTable dtFilter2 = Cls.Grid.Options.GetGridData(this.grid2);
//필터링된 데이터를 담는다.
DataTable dtFilter3 = Cls.Grid.Options.GetGridData(this.grid3);
DataSet ds = new DataSet("xsd_JDRAS01");
dt1.TableName = "dt1";
dt2_All.TableName = "dt2_All";
dt3_All.TableName = "dt3_All";
ds.Tables.AddRange(new DataTable[] { dtFilter1, dtFilter2, dtFilter3, dtReport });
//ds.WriteXmlSchema("c:\\xsd_JDRAS01.xsd");
if (ds.Tables[0].Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Facility.JARA.Report.JDRAP01());
f.ShowDialog();
}
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 (dt.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
//Basic.SetCursor(this, false);
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
dtrf.Columns.Add("FACILITYTYPE");
dtrf.Columns.Add("FACILITYCODE");
dtrf.Columns.Add("POSNO");
//dtrf.Columns.Add("FACILITYCODE");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpFrom.Text;
string strFacilitytype = this.lupFacilitytype.EditValue.ToString() == "" ? "*전체" : this.lupFacilitytype.EditValue.ToString();
string strFacilitycode = this.txtFacilitycode.Text.Trim() == "" ? "*전체" : this.txtFacilitycode.Text;
string strPosno = this.txtPosno.Text.Trim() == "" ? "*전체" : this.txtPosno.Text;
dtrf.Rows.Add(strDtFrom, strDtTo, strFacilitytype, strFacilitycode, strPosno);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_JHRAS04");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.JHRAP04());
f.ShowDialog();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
//Basic.SetCursor(this, false);
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
dtrf.Columns.Add("PAY_YN");
dtrf.Columns.Add("SID_BAR_CODE");
dtrf.Columns.Add("CHECK_YN");
//dtrf.Columns.Add("FACILITYCODE");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpFrom.Text;
string strPaycode = this.cboCalc.EditValue.ToString();
string strCoinno = this.txtBarcode.Text.Trim() == "" ? "*전체" : this.txtBarcode.Text;
dtrf.Rows.Add(strDtFrom, strDtTo, strPaycode, strCoinno, strCheckYn);
DataSet ds = new DataSet("xsd_JNRAS01");
ds.Tables.AddRange(new DataTable[] { dt.Copy(), dtrf });
//ds.WriteXmlSchema(@"c:\xsd_JNRAS01.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Facility.JNRA.Report.JNRAP01());
f.ShowDialog();
}
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 (dt.Rows.Count < 1)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("GUBUN");
dtrf.Columns.Add("DATE_FROM");
dtrf.Columns.Add("DATE_TO");
dtrf.Columns.Add("MEMBER");
string strGubun = this.lupGubun.EditValue.ToString() == "" ? "*전체" : this.lupGubun.Text;
string strDate_From = this.dtpFrom.Text == "" ? "*전체" : this.dtpFrom.Text;
string strDate_To = this.dtpTo.Text == "" ? "*전체" : this.dtpTo.Text;
string strMember = this.txtMember.Text == "" ? "*전체" : this.txtMember.Text;
dtrf.Rows.Add(strGubun, strDate_From, strDate_To, strMember);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_AERAS10");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
//ds.WriteXmlSchema(@"c:\xsd_AERAS10.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.SubdivisionSale.AERA.Report.AERAP10());
f.ShowDialog();
}
catch (Exception ex)
{
throw ex;
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
DataTable dtTmp = Cls.Grid.Options.GetGridData(this.gridData);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JBAA.Report.JIAAP08();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
/// <summary>
/// 프린트버튼 클릭 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dtM.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("ANNUAL");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
dtrf.Columns.Add("MEMBERNO");
dtrf.Columns.Add("MEMBERNAME");
string strAnual = this.lupYear.Text;
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
string strMemberno = dtM.Rows[this.gridViewM.GetDataSourceRowIndex(this.gridViewM.FocusedRowHandle)]["MEMBER_NO"].ToString();
string strMembername = dtM.Rows[this.gridViewM.GetDataSourceRowIndex(this.gridViewM.FocusedRowHandle)]["MEMBER_NAME_KOR"].ToString();
dtrf.Rows.Add(strAnual, strDtFrom, strDtTo, strMemberno, strMembername);
DataTable dtTemp = new DataTable();
int iRow = this.gridViewM.GetDataSourceRowIndex(this.gridViewM.FocusedRowHandle);
string filter = "CAP_MEMBER_NO = '" + this.dtM.Rows[iRow]["CAP_MEMBER_NO"].ToString() + "'";
dtTemp = Basic.GetdtSelect(dtD, filter, "SEQ ASC");
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.gridD);
DataSet ds = new DataSet("xsd_CERAS01");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Reservation.CARA.Report.CERAP01());
f.ShowDialog();
}
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 (dt.Rows.Count <= 0)
//{
// Basic.ShowMessage(3, "출력할 내용이 없습니다.");
// return;
//}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("NO");
string strNo = this.txtNo.Text.Trim() == "" ? "*전체" : this.txtNo.Text;
dtrf.Rows.Add(strNo);
DataTable dtparmSelect = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparmSelect.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
//파라메터가 있을때
DataSet dsBiz = DataLayer.ExecuteSpDataset("PKG_FCRAS03.PR_07", dtparmSelect, DataLayer.MessageEncoding.Default);
DataTable dtBiz = new DataTable("dtBiz");
dtBiz.Load(dsBiz.Tables[0].CreateDataReader());
DataSet ds = new DataSet("xsd_FCRAP03");
ds.Tables.AddRange(new DataTable[] { dt.Copy(), dt1.Copy(), dt2.Copy(), dt3.Copy(), dt4.Copy(), dt5.Copy(), dtrf, dtBiz.Copy() });
//ds.WriteXmlSchema(@"c:\xsd_FCRAS02.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Event.FARA.Report.FCRAP03());
f.ShowDialog();
}
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 (dt.Rows.Count <= 1)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
string date = string.Format("{0}년 {1}월 {2}일 [{3}요일]",
((DateTime)this.dtpCheckdateFrom.EditValue).ToString("yyyy"),
((DateTime)this.dtpCheckdateFrom.EditValue).ToString("MM"),
((DateTime)this.dtpCheckdateFrom.EditValue).ToString("dd"),
Cls.Common.uDate.GetStrDayOfWeek(this.dtpCheckdateFrom.DateTime));
DataTable Date = new DataTable("Date");
Date.Columns.Add("DATE");
Date.Rows.Add(new object[] { date });
DataSet ds = new DataSet("xsd_JMRAS03");
ds.Tables.AddRange(new DataTable[] { dt.Copy(),
dt2.Copy(),
dt3.Copy(),
dt4.Copy(),
dt5.Copy(),
dt6.Copy(),
dt7.Copy(),
dt8.Copy(),
Date });
//ds.WriteXmlSchema(@"c:\xsd_JMRAS03.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Facility.JARA.Report.JMRAP03());
f.ShowDialog();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 프린터 버튼을 눌렀을경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
DataTable dtReport = new DataTable("dtReport");
string s1 = this.lupFacilitySelect.EditValue.ToString().Trim() == "" ? "*전체" : this.lupFacilitySelect.EditValue.ToString().Trim(); // 룹
string s2 = ((DateTime)dtpFrom.EditValue).ToString("yyyyMMdd") == "" ? "*전체" : ((DateTime)dtpFrom.EditValue).ToString("yyyyMMdd"); //from
string s3 = ((DateTime)dtpTo.EditValue).ToString("yyyyMMdd") == "" ? "*전체" : ((DateTime)dtpTo.EditValue).ToString("yyyyMMdd"); //to
string s4 = this.txtSelectLfName.Text.Trim() == "" ? "*전체" : this.txtSelectLfName.Text.Trim(); //name
dtReport.Columns.Add("FACILITY_NAME");
dtReport.Columns.Add("V_FROM");
dtReport.Columns.Add("V_TO");
dtReport.Columns.Add("V_LF_NAME");
dtReport.Rows.Add(s1, s2, s3, s4);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_DARAS01");
dt.TableName = "dt";
ds.Tables.AddRange(new DataTable[] { dtFilter, dtReport });
//ds.WriteXmlSchema("c:\\xsd_DGRAS03.xsd");
if (ds.Tables[0].Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DGRAP03());
f.ShowDialog();
}
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 (dt.Rows.Count <= 0)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("FROM");
dtrf.Columns.Add("TO");
dtrf.Columns.Add("ROOMNO");
dtrf.Columns.Add("RSVNO");
dtrf.Columns.Add("GUESTNAME");
dtrf.Columns.Add("CARNO");
dtrf.Columns.Add("SERCHCONDITION");
dtrf.Rows.Add(((DateTime)dtpFrom.EditValue).ToString("yyyy-MM-dd"),
((DateTime)dtpTo.EditValue).ToString("yyyy-MM-dd"),
this.txtRoomno.Text == "" ? "*전체" : this.txtRoomno.Text,
this.txtRsvno.Text == "" ? "*전체" : this.txtRsvno.Text,
this.txtGuestname.Text == "" ? "*전체" : this.txtGuestname.Text,
this.txtCarno.Text == "" ? "*전체" : this.txtCarno.Text,
this.lupSearchCondition.EditValue.ToString() == "0" ? "*전체" : this.lupSearchCondition.Text);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_DBRAS04");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DBRAP04());
f.ShowDialog();
}
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 (dt.Rows.Count < 1)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("ROOMITEMPARTNAME");
dtrf.Columns.Add("FACILITYCODESELECT");
dtrf.Columns.Add("DATE_FROM");
dtrf.Columns.Add("DATE_TO");
dtrf.Columns.Add("DEPT_CODE");
string strDateFrom = DateTime.Now.AddDays(-(Convert.ToDouble(DateTime.Today.ToString("dd"))) + 1).ToString("yyyy-MM-dd");
string strFacilityCodeSelect = this.lupFacilityCodeSelect.EditValue.ToString() == "" ? "*전체" : this.lupFacilityCodeSelect.Text;
string strRoomItemPartName = this.lupRoomItemPartName.EditValue.ToString() == "" ? "*전체" : this.lupRoomItemPartName.Text;
string strDate_From = strDateFrom;
string strDate_To = this.dtpFrom.Text;
string strDeptCode = this.txtDeptCodeSelect.Text.Trim() == "" ? "*전체" : this.txtDeptCodeSelect.Text.Trim();
dtrf.Rows.Add(strFacilityCodeSelect, strRoomItemPartName, strDate_From, strDate_To, strDeptCode);
DataSet ds = new DataSet("xsd_DHRAS05");
ds.Tables.AddRange(new DataTable[] { dt.Copy(), dtrf });
//ds.WriteXmlSchema(@"c:\xsd_DHRAS05.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DHRAP05());
f.ShowDialog();
}
catch (Exception ex)
{
throw ex;
}
}
