/// <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); 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); 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); ////컬러명 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); 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); } }
/// <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); } }
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 (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 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); } }
/// <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); } }
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"></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; } }
/// <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("FACI"); dtrf.Columns.Add("FLOOR"); dtrf.Columns.Add("ROOMTYPE"); dtrf.Columns.Add("ROOMVIEW"); dtrf.Columns.Add("ROOMSTATE"); dtrf.Columns.Add("CLEANSTATE"); string strFaci = this.lupFaci.EditValue.ToString() == "" ? "*전체" : this.lupFaci.Text; string strFloor = this.lupFloor.EditValue.ToString() == "" ? "*전체" : this.lupFloor.Text; string strRoomType = this.lupRoomType.EditValue.ToString() == "" ? "*전체" : this.lupRoomType.Text; string strRoomView = this.lupRoomView.EditValue.ToString() == "" ? "*전체" : this.lupRoomView.Text; string strRoomState = this.lupRoomStat.EditValue.ToString() == "" ? "*전체" : this.lupRoomStat.Text; string strCleanState = this.lupCleanStat.EditValue.ToString() == "" ? "*전체" : this.lupCleanStat.Text; dtrf.Rows.Add(strFaci, strFloor, strRoomType, strRoomView, strRoomState, strCleanState); //필터링된 데이터를 담는다. DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid); DataSet ds = new DataSet("xsd_DBRAS03"); ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf }); XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm(); f.ShowReport(ds, new Erp.Room.DARA.Report.DBRAP03()); f.ShowDialog(); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }