/// <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(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(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);
}
}
/// <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;
}
}
/// <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 < 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("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 <= 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);
}
}
/// <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("FACILITY_NAME");
dtrf.Columns.Add("GUEST_TYPE_NAME");
dtrf.Columns.Add("MENU_ITEM1_NAME");
dtrf.Columns.Add("MENU_ITEM2_NAME");
dtrf.Columns.Add("ROWSUM");
string facility = popFacilitycode.Text.Split(' ').Length < 2 ? "*전체" : popFacilitycode.Text.Split(' ')[1].ToString();
string guestType = lupGuestType.EditValue.ToString() == "" ? "*전체" : lupGuestType.Text.Trim();
string menuItem1 = lupMenu_Item1.EditValue.ToString() == "" ? "*전체" : lupMenu_Item1.Text.Trim();
string menuItem2 = lupMenu_Item2.EditValue.ToString() == "" ? "*전체" : lupMenu_Item2.Text.Trim();
string RowSum = dt.Rows.Count.ToString();
dtrf.Rows.Add(facility, guestType, menuItem1, menuItem2, RowSum);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_JDARS02");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Facility.JARA.Report.JDRAP02());
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 <= 1)
{
Basic.ShowMessage(3, "출력할 내용이 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("FACILITY_NAME");
dtrf.Columns.Add("INSERTDATE_FROM");
dtrf.Columns.Add("INSERTDATE_TO");
dtrf.Columns.Add("ROOMNO");
dtrf.Columns.Add("JOB_CODE_NAME");
string strfacility = this.lupFacilityCode.EditValue.ToString() == "0" ? "*전체" : this.lupFacilityCode.Text;
string strInsertDate_From = this.dtpI_DateFrom.Text;
string strInsertDate_To = this.dtpI_DateTo.Text;
string strRoomNo = this.txtRoomNo.Text == "" ? "*전체" : this.txtRoomNo.Text;
string strJobCode_Name = this.lupJob_Code.EditValue.ToString() == "0" ? "*전체" : this.lupJob_Code.Text;
dtrf.Rows.Add(strfacility, strInsertDate_From, strInsertDate_To, strRoomNo, strJobCode_Name);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_DGRAS04");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DGRAP04());
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 dtvar = new DataTable("dtvar");
dtvar.Columns.Add("DTFROM");
dtvar.Columns.Add("DTTO");
dtvar.Columns.Add("FACILIYCODE");
dtvar.Columns.Add("ROOMTYPE");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
string strFacilityCode = this.lupFacilitycode.EditValue.ToString() == "" ? "*전체" : this.lupFacilitycode.EditValue.ToString();
string strRoomType = this.lupRoomtype.EditValue.ToString() == "" ? "*전체" : this.lupRoomtype.EditValue.ToString();
dtvar.Rows.Add(strDtFrom, strDtTo, strFacilityCode, strRoomType);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_CARAS04");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtvar });
ds.WriteXmlSchema(@"c:\xsd_CARAS04.xsd");
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Reservation.CARA.Report.CARAP04());
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("DTFROM");
dtrf.Columns.Add("DTTO");
//dtrf.Columns.Add("FACILITYCODE");
dtrf.Columns.Add("ROOMTYPE");
dtrf.Columns.Add("EXCUTECODE");
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
//string strFacilityCode = this.lupFacilitycode.EditValue.ToString() == "" ? "*전체" : this.lupFacilitycode.EditValue.ToString();
string strRoomType = this.lupRoomtype.EditValue.ToString() == "" ? "*전체" : this.lupRoomtype.Text;
string strExcute = this.lupExcute.EditValue.ToString() == "" ? "*전체" : this.lupExcute.Text;
dtrf.Rows.Add(strDtFrom, strDtTo, strRoomType, strExcute);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_DBRAS02");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DBRAP02());
f.ShowDialog();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dtUse.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("COINNO");
dtrf.Columns.Add("CHARGEAMT");
dtrf.Columns.Add("USEAMT");
dtrf.Columns.Add("DEPOSITBALANCE");
dtrf.Rows.Add(txtCoinno.Text, txtChargeamt.Text, txtUseamt.Text, txtDepositbalance.Text);
DataSet ds = new DataSet("xsd_JNRAS02");
ds.Tables.AddRange(new DataTable[] { dtCharge.Copy(), dtUse.Copy(), dtrf });
//ds.WriteXmlSchema(@"c:\xsd_JNRAS02.xsd");
//return;
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Facility.JNRA.Report.JNRAP02());
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("CHNO");
dtrf.Columns.Add("CHCODE");
dtrf.Columns.Add("DTFROM");
dtrf.Columns.Add("DTTO");
string strChNo = this.txtChNo.Text.Trim() == "" ? "*전체" : this.txtChNo.Text;
string strChCode = this.lupChCode.EditValue.ToString() == "" ? "*전체" : this.lupChCode.EditValue.ToString();
string strDtFrom = this.dtpFrom.Text;
string strDtTo = this.dtpTo.Text;
dtrf.Rows.Add(strChNo, strChCode, strDtFrom, strDtTo);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_AHRAS02");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.SubdivisionSale.AHRA.Report.AHRAP02());
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("DTPFROM");
dtrf.Columns.Add("DTPTO");
dtrf.Columns.Add("FACI");
dtrf.Columns.Add("ROOMTYPE");
dtrf.Rows.Add(this.dtpFrom.Text,
this.dtpTo.Text,
this.lupFaci.EditValue.ToString() == "" ? "*전체" : this.lupFaci.Text,
this.lupRoomType.EditValue.ToString() == "" ? "*전체" : this.lupRoomType.Text);
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
DataSet ds = new DataSet("xsd_DCRAS03");
ds.Tables.AddRange(new DataTable[] { dtFilter, dtrf });
ds.WriteXmlSchema(@"c:\xsd_DCRAS03.xsd");
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DCRAP03());
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("DATE_FROM");
string strDate = "";
if (int.Parse(Basic.MaskReplace(this.dtpFrom.Text).Substring(4, 2)) >= 10)
{
strDate = Basic.MaskReplace(this.dtpFrom.Text).Substring(4, 2);
}
else
{
strDate = Basic.MaskReplace(this.dtpFrom.Text).Substring(5, 1);
}
dtrf.Rows.Add(strDate);
DataSet ds = new DataSet("xsd_DHRAS06");
ds.Tables.AddRange(new DataTable[] { dt.Copy(), dtrf });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.DHRAP06());
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 (dtVoid.Rows.Count <= 0 && dtRefund.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");
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;
dtrf.Rows.Add(strDtFrom, strDtTo, strFacilitytype, strFacilitycode);
//DataSet ds = new DataSet("xsd_JERAS05");
//ds.Tables.AddRange(new DataTable[] { dtVoid.Copy(), dtRefund.Copy(), dtrf });
//필터링된 데이터를 담는다.
DataTable dtFilterVoid = Cls.Grid.Options.GetGridData(this.gridVoid);
DataSet ds = new DataSet("xsd_JERAS05_01");
ds.Tables.AddRange(new DataTable[] { dtFilterVoid, dtrf });
//ds.WriteXmlSchema(@"c:\xsd_JERAS05_01.xsd");
//필터링된 데이터를 담는다.
DataTable dtFilterRefund = Cls.Grid.Options.GetGridData(this.gridRefund);
DataSet ds2 = new DataSet("xsd_JERAS05_02");
ds2.Tables.AddRange(new DataTable[] { dtFilterRefund, dtrf.Copy() });
//ds2.WriteXmlSchema(@"c:\xsd_JERAS05_02.xsd");
////return;
if (dtVoid.Rows.Count >= 0)
{
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.Room.DARA.Report.JERAP05_01());
f.ShowDialog();
}
if (dtRefund.Rows.Count >= 0)
{
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds2, new Erp.Room.DARA.Report.JERAP05_02());
f.ShowDialog();
}
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnContractPrint_Click(object sender, EventArgs e)
{
//Basic.ShowMessage(1, "해당 기능은 협의 후 진행예정 입니다. 빠른 시일내에 완료하도록 하겠습니다.");
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "DM 출력할 데이터가 없습니다.");
return;
}
DataTable dtrf = new DataTable("dtrf");
dtrf.Columns.Add("Col");
for (int nCnt = 0; nCnt < dt.Rows.Count; nCnt++)
{
if (dt.Rows[nCnt]["CHK"].ToString() == "N")
{
continue;
}
//string strCol = string.Format("{0}\n{1} 님 귀하\n{2}",
string strCol = string.Format("{0}\n{1} \n{2}",
dt.Rows[nCnt]["ADDRESS"].ToString(),
dt.Rows[nCnt]["MEMBER_NAME_KOR"].ToString(),
dt.Rows[nCnt]["POST"].ToString());
dtrf.Rows.Add(strCol);
}
DataTable dtPrint = new DataTable("dtPrint");
dtPrint.Columns.Add("Col_Addr1");
dtPrint.Columns.Add("Col_NameKor1");
dtPrint.Columns.Add("Col_Post1");
dtPrint.Columns.Add("Col_Addr2");
dtPrint.Columns.Add("Col_NameKor2");
dtPrint.Columns.Add("Col_Post2");
for (int nCnt = 0; nCnt < dtrf.Rows.Count; nCnt++)
{
string strCol_Addr1 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[0].ToString();
string strCol_NameKor1 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[1].ToString();
string strCol_Post1 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[2].ToString();
nCnt++;
if (nCnt > dtrf.Rows.Count - 1)
{
dtPrint.Rows.Add(strCol_Addr1, strCol_NameKor1, strCol_Post1);
break;
}
string strCol_Addr2 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[0].ToString();
string strCol_NameKor2 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[1].ToString();
string strCol_Post2 = dtrf.Rows[nCnt][0].ToString().Split(new string[] { "\n" }, StringSplitOptions.None)[2].ToString();
dtPrint.Rows.Add(strCol_Addr1, strCol_NameKor1, strCol_Post1, strCol_Addr2, strCol_NameKor2, strCol_Post2);
}
if (dtPrint.Rows.Count == 0)
{
Basic.ShowMessage(1, "DM 출력할 선택한 데이터가 없습니다.");
}
else
{
DataSet ds = new DataSet("xsd_AHAAI02");
ds.Tables.AddRange(new DataTable[] { dtPrint });
XtraReportsBase.DxReport.XtraPreviewForm f = new XtraReportsBase.DxReport.XtraPreviewForm();
f.ShowReport(ds, new Erp.SubdivisionSale.AHAA.Report.AHAAP02());
f.ShowDialog();
Basic.ShowMessage(1, "정상적으로 DM 출력 하였습니다.");
}
}
catch (Exception ex)
{
throw ex;
}
}