/// <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(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);
}
}
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;
}
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);
}
}
/// <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);
}
}
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);
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);
}
}
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);
}
}
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);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
DataTable dtTitle = new DataTable("dtTitle");
dtTitle.Columns.Add("DATE");
dtTitle.Rows.Add(new Object[] { _SaleDate.Text.Trim() });
DataSet ds = new DataSet("xsd_JMRAS08.xsd");
DataTable MergedTable = new DataTable("dtUpjang");
DtMerge(dtUpjang.Copy(), ref MergedTable);
dtUpjang = MergedTable.Copy();
ds.Tables.AddRange(new DataTable[] { dtTitle.Copy()
, dtRoom.Copy()
, dtUpjang });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JARA.Report.JMRAP08();
f.ShowReport(ds, rpt); // FREEVIEW
f.Show();
//rpt.PrinterName = "CardPrinter";
//f.ShowReportPrint(dsTemp, rpt, 1);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
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 strMemNo = this.txtMemNo.Text.Trim();
string strProductGroupCode = this.lupProductGroupCode.Text.Trim();
string strCommoityCode = this.lupCommoityCode.Text.Trim();
string strSaleinlotcnt = this.lupSaleinlotcnt.Text.Trim();
string strPurchaseCode = this.lupPurchaseCode.Text.Trim();
string strCancelYn = this.lupCancelYn.Text.Trim();
string strFamilyYn = this.lupFamilyYn.Text.Trim();
if (this.txtMemNo.Text.Trim() == "")
{
strMemNo = "*전체";
}
if (this.lupProductGroupCode.EditValue.ToString().Trim() == "")
{
strProductGroupCode = "*전체";
}
if (this.lupCommoityCode.EditValue.ToString().Trim() == "")
{
strCommoityCode = "*전체";
}
if (this.lupSaleinlotcnt.EditValue.ToString().Trim() == "")
{
strSaleinlotcnt = "*전체";
}
if (this.lupPurchaseCode.EditValue.ToString().Trim() == "")
{
strPurchaseCode = "*전체";
}
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("MEMBER_NO");
dtTmp.Columns.Add("PROD_GROUP_CODE");
dtTmp.Columns.Add("COMMODITY_CODE");
dtTmp.Columns.Add("SALEINLOT_CNT");
dtTmp.Columns.Add("PURCHASE_CODE");
dtTmp.Columns.Add("CANCEL_YN");
dtTmp.Columns.Add("FAMILY_YN");
dtTmp.Rows.Add(new object[] { strMemNo, strProductGroupCode, strCommoityCode, strSaleinlotcnt, strPurchaseCode, strCancelYn, strFamilyYn });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.gridMemStat);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTmp });
//dsTemp.WriteXmlSchema(@"c:\xsd_ABRCS02.xsd");
//return;
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ABRA.Report.ABRCP02();
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 p_dateFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string p_dateTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
//모두일경우
//if (this.txtName.Text.Trim() == "") p_grouprName = "*전체";
//컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
//필드명
dtTemp.Rows.Add(new object[] { p_dateFrom, p_dateTo });
/*
* //프린터 데이터추가
* 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();
* }
*/
//테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtForPrint.Copy(), dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DARA.Report.DCRAP04();
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 sFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string sTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string groupName = this.lupProductGroupCode_Select.Text.Trim();
string cancelYn = this.lupCancelYn.Text.Trim();
string searchText = this.txtSearchText.Text.Trim();
string purchaseCode = this.lupPurchaseCode.Text.Trim();
string fullYn = this.lupFullYn.Text.Trim();
if (this.lupProductGroupCode_Select.EditValue.ToString().Trim() == "")
{
groupName = "*전체";
}
if (this.lupCancelYn.EditValue.ToString().Trim() == "")
{
cancelYn = "*전체";
}
if (this.txtSearchText.Text.ToString().Trim() == "")
{
searchText = "*전체";
}
if (this.lupPurchaseCode.EditValue.ToString().Trim() == "")
{
purchaseCode = "*전체";
}
if (this.lupFullYn.EditValue.ToString().Trim() == "")
{
fullYn = "*전체";
}
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("PROD_GROUP_CODE_NAME");
dtTemp.Columns.Add("CANCEL_YN");
dtTemp.Columns.Add("SEARCH_TEXT");
dtTemp.Columns.Add("PURCHASE_CODE");
dtTemp.Columns.Add("FULL_YN");
dtTemp.Rows.Add(new object[] { sFrom, sTo, groupName, cancelYn, searchText, purchaseCode, fullYn });
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.AARA.Report.AARAP01();
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 sfrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string sto = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string groupname = this.lupProdGroupCodeName.Text.Trim();
string cancelname = this.lupCancelCodeName.Text.Trim();
if (this.lupProdGroupCodeName.EditValue.ToString().Trim() == "")
{
groupname = "*전체";
}
if (this.lupCancelCodeName.EditValue.ToString().Trim() == "")
{
cancelname = "*전체";
}
DataTable dtTmp = new DataTable("dtDate");
dtTmp.Columns.Add("DATE_FROM");
dtTmp.Columns.Add("DATE_TO");
dtTmp.Columns.Add("PROD_GROUP_CODE_NAME");
dtTmp.Columns.Add("CANCEL_CODE_NAME");
dtTmp.Rows.Add(new object[] { sfrom, sto, groupname, cancelname });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.gridCancel);
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ABRA.Report.ABRAP07();
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 searchText = this.txtSearchText.Text.Trim();
string groupName = this.lupProductGroupCode_Select.Text.Trim();
string commoityCode = this.lupCommoityCode.Text.Trim();
string saleinlotCnt = this.lupSaleinlotcnt.Text.Trim();
string purchaseCode = this.lupPurchaseCode.Text.Trim();
string fullYn = this.lupFullYn.Text.Trim();
string sFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string sTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string partitionCode = this.lupPartitionCode.Text.Trim();
if (this.txtSearchText.Text.ToString().Trim() == "")
{
searchText = "*전체";
}
if (this.lupProductGroupCode_Select.EditValue.ToString().Trim() == "")
{
groupName = "*전체";
}
if (this.lupCommoityCode.EditValue.ToString().Trim() == "")
{
commoityCode = "*전체";
}
if (this.lupSaleinlotcnt.EditValue.ToString().Trim() == "")
{
saleinlotCnt = "*전체";
}
if (this.lupPurchaseCode.EditValue.ToString().Trim() == "")
{
purchaseCode = "*전체";
}
if (this.lupFullYn.EditValue.ToString().Trim() == "")
{
fullYn = "*전체";
}
if (this.lupPartitionCode.EditValue.ToString().Trim() == "")
{
partitionCode = "*전체";
}
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("SEARCH_TEXT");
dtTemp.Columns.Add("PROD_GROUP_CODE_NAME");
dtTemp.Columns.Add("COMMOITY_CODE");
dtTemp.Columns.Add("SALEINLOT_CNT");
dtTemp.Columns.Add("PURCHASE_CODE");
dtTemp.Columns.Add("FULL_YN");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("PARTITION_CODE");
dtTemp.Rows.Add(new object[] { searchText, groupName, commoityCode, saleinlotCnt, purchaseCode, fullYn, sFrom, sTo, partitionCode });
//필터링된 데이터를 담는다.
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.SubdivisionSale.AARA.Report.AARBP02();
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 sDateFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string sDateTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string sMaidNo = this.txtMaidNo.Text.Trim();
string sRoomStat = this.lupRoomStat.Text.ToString().Trim();
string sFacility = this.lupFacility.EditValue.ToString().Trim();
if (this.txtMaidNo.Text.ToString().Trim() == "")
{
sMaidNo = "*전체";
}
if (this.lupRoomStat.EditValue.ToString().Trim() == "")
{
sRoomStat = "*전체";
}
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("FACILITY_CODE");
dtTemp.Columns.Add("MAID_NO");
dtTemp.Columns.Add("ROOM_STAT");
dtTemp.Rows.Add(new object[] { sDateFrom, sDateTo, sFacility, sMaidNo, sRoomStat });
//필터링된 데이터를 담는다.
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.Room.DARA.Report.DGRAP01();
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;
}
// 업장타입별 세부 내역 프린트 여부 확인
DialogResult dialePrintResult;
string strPrintQuestion = "업장타입별 상세내역을 출력하시겠습니까?";
string strPrintCaption = "업장타입별 세부내역 출력";
dialePrintResult = MessageBox.Show(strPrintQuestion, strPrintCaption, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (dialePrintResult == DialogResult.Cancel)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string sFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd");
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Rows.Add(new object[] { sFrom });
//필터링된 데이터를 담는다.
//DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
//필터링된 데이터를 담는다.
//DataTable dtFilterDetail = Cls.Grid.Options.GetGridData(this.gridDetail);
DataSet dsTemp = new DataSet();
if (dialePrintResult == DialogResult.No)
{
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Event.FARA.Report.FARAP04_3();
f.ShowReport(dsTemp, rpt);
f.Show();
}
else
{
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtDetailAll.Copy(), dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Event.FARA.Report.FARAP04();
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 bizcode = Parm.CurrentUserInformation.BizInfo.BizCode;
string datefrom = ((DateTime)dtpDateFrom.EditValue).ToString("yyyy-MM-dd");
string dateto = ((DateTime)dtpDateTo.EditValue).ToString("yyyy-MM-dd");
string facilitycode = this.txtFacilityCode.Text.Trim();
string posno = this.txtPosNo.Text.Trim();
string facilitytype = this.lupFacilityType.EditValue.ToString();
if (this.txtFacilityCode.Text.Trim() == "")
{
facilitycode = "*전체";
}
if (this.txtPosNo.Text.Trim() == "")
{
posno = "*전체";
}
if (this.lupFacilityType.EditValue.ToString().Trim() == "")
{
facilitytype = "*전체";
}
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("BIZ_CODE");
dtTmp.Columns.Add("DATE_FROM");
dtTmp.Columns.Add("DATE_TO");
dtTmp.Columns.Add("FACILITY_CODE");
dtTmp.Columns.Add("POS_NO");
dtTmp.Columns.Add("FACILITY_TYPE");
dtTmp.Rows.Add(new object[] { bizcode, datefrom, dateto, facilitycode, posno, facilitytype });
//필터링된 데이터를 담는다.
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.Facility.JARA.Report.JHRAP02();
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 s_DateFrom = ((DateTime)this.dtpFrom.EditValue).ToString("yyyy-MM-dd").Trim();
string s_DateTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd").Trim();
string s_DateFromOut = ((DateTime)this.dtpFromOut.EditValue).ToString("yyyy-MM-dd").Trim();
string s_DateToOut = ((DateTime)this.dtpToOut.EditValue).ToString("yyyy-MM-dd").Trim();
string s_payCode = this.lupPayCode.Text.ToString().Trim();
//모두일경우
if (this.lupPayCode.EditValue.ToString().Trim() == "")
{
s_payCode = "*전체";
}
//컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("DATE_FROM_OUT");
dtTemp.Columns.Add("DATE_TO_OUT");
dtTemp.Columns.Add("PAY_CODE");
//필드명
dtTemp.Rows.Add(new object[] { s_DateFrom, s_DateTo, s_DateFromOut, s_DateToOut, s_payCode });
/*
* //프린터 데이터추가
* 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.DCRAP08();
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 datefrom = ((DateTime)dtpFrom.EditValue).ToString("yyyy-MM-dd");
string dateto = ((DateTime)dtpTo.EditValue).ToString("yyyy-MM-dd");
string salelotfrom = this.lupSaleLotFrom.Text.ToString().Trim();
string salelotto = this.lupSaleLotTo.Text.ToString().Trim();
string commoditycode = this.lupCommoityCode.Text.ToString().Trim();
string purchasecode = this.lupPurchaseCode.Text.ToString().Trim();
string paymentcode = this.lupPaymentCode.Text.ToString().Trim();
string accountcode = this.lupAccountCode.Text.ToString().Trim();
if (this.lupSaleLotFrom.EditValue.ToString().Trim() == "")
{
salelotfrom = "*전체";
}
if (this.lupSaleLotTo.EditValue.ToString().Trim() == "")
{
salelotto = "*전체";
}
if (this.lupCommoityCode.EditValue.ToString().Trim() == "")
{
commoditycode = "*전체";
}
if (this.lupPurchaseCode.EditValue.ToString().Trim() == "")
{
purchasecode = "*전체";
}
if (this.lupPaymentCode.EditValue.ToString().Trim() == "")
{
paymentcode = "*전체";
}
if (this.lupAccountCode.EditValue.ToString().Trim() == "")
{
accountcode = "*전체";
}
DataTable dtTemp = new DataTable("dtDate");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("SALE_LOT_FROM");
dtTemp.Columns.Add("SALE_LOT_TO");
dtTemp.Columns.Add("COMMODITY_CODE");
dtTemp.Columns.Add("PURCHARSE_CODE");
dtTemp.Columns.Add("PAYMENT_CODE");
dtTemp.Columns.Add("ACCOUNT_CODE");
dtTemp.Rows.Add(new object[] { datefrom, dateto, salelotfrom, salelotto, commoditycode, purchasecode, paymentcode, accountcode });
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.AARA.Report.AARCP14();
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 applicationno = this.txtSearchText.Text.Trim();
string prodgroupcode = this.lupProductGroupCode_Select.Text.Trim();
string purchasecode = this.lupPurchaseCode.Text.Trim();
//string cancelyn = this.lupSaleinlotcnt.EditValue.ToString().Trim();
string fullyn = this.lupFullYn.Text.Trim();
string commodity = this.lupCommoityCode.Text.Trim();
string saleinlotcnt = this.lupSaleinlotcnt.Text.Trim();
if (this.txtSearchText.ToString().Trim() == "")
{
applicationno = "*전체";
}
if (this.lupProductGroupCode_Select.EditValue.ToString().Trim() == "")
{
prodgroupcode = "*전체";
}
if (this.lupPurchaseCode.EditValue.ToString().Trim() == "")
{
purchasecode = "*전체";
}
if (this.lupFullYn.EditValue.ToString().Trim() == "")
{
fullyn = "*전체";
}
if (this.lupCommoityCode.EditValue.ToString().Trim() == "")
{
commodity = "*전체";
}
if (this.lupSaleinlotcnt.EditValue.ToString().Trim() == "")
{
saleinlotcnt = "*전체";
}
DataTable dtTmp = new DataTable("dtDate");
dtTmp.Columns.Add("MEMBER_NAME_KOR");
dtTmp.Columns.Add("PROD_GROUP_CODE_NAME");
dtTmp.Columns.Add("COMMODITY_CODE_NAME");
dtTmp.Columns.Add("PURCHASE_CODE");
dtTmp.Columns.Add("SALEINLOT_CNT");
dtTmp.Columns.Add("AMT_STATUS_NAME");
dtTmp.Rows.Add(new object[] { applicationno, prodgroupcode, commodity, purchasecode, saleinlotcnt, fullyn });
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.AARA.Report.AARAP04();
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 btnMemberPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.MaskReplace(dtpPrintDate.Text.ToString().Trim()) == "")
{
Basic.ShowMessage(1, "출력일자가 없습니다.");
dtpPrintDate.Focus();
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
DataTable dtparam = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
DataSet ds = new DataSet();
for (int nCnt = 0; nCnt < dt.Rows.Count; nCnt++)
{
if (dt.Rows[nCnt]["CHECK_YN"].ToString() == "N")
{
continue;
}
string printDate = ((DateTime)this.dtpPrintDate.EditValue).ToString("yyyyMMdd");
string memberSeq = this.dt.Rows[nCnt]["MEMBER_SEQ"].ToString();
string certIssueNo = this.dt.Rows[nCnt]["CERT_ISSUE_NO"].ToString();
string ceoName = Parm.CurrentUserInformation.BizInfo.CeoName;
dtparam.Clear();
dtparam.Rows.Add(new object[] { "V_MEMBER_SEQ", memberSeq });
dtparam.Rows.Add(new object[] { "V_PRINT_DATE", printDate });
dtparam.Rows.Add(new object[] { "V_CERT_ISSUE_NO", certIssueNo });
dtparam.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
ds = DataLayer.ExecuteSpDataset("PKG_AEAAI11.PR_01", dtparam.Copy(), DataLayer.MessageEncoding.Default);
ds.Tables[1].TableName = "MEMBERPRINT";
int ceoNameLen = ceoName.Length;
for (int i = ceoNameLen - 1; i > 0; i--)
{
ceoName = ceoName.Insert(i, " ");
}
DataTable dtTemp = new DataTable("dtVar");
dtTemp.Columns.Add("CEO_NAME");
dtTemp.Rows.Add(new object[] { ceoName });
ds.Tables.Add(dtTemp);
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rptMemberPrint = new Erp.SubdivisionSale.AEAA.Report.AEAAP11();
f.ShowReportPrint(ds, rptMemberPrint, 1);
//f = new XtraReportsBase.DxReport.XtraPreviewForm();
//DevExpress.XtraReports.UI.XtraReport rptMemberPrint = new Erp.SubdivisionSale.AEAA.Report.AEAAP11();
//f.ShowReport(ds, rptMemberPrint);
//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 p_dateFrom = ((DateTime)this.txtDatefrom.EditValue).ToString("yyyy-MM-dd");
string p_dateTo = ((DateTime)this.txtDateTo.EditValue).ToString("yyyy-MM-dd");
string week1 = txtWeek1.Text.Trim();
string week2 = txtWeek2.Text.Trim();
//모두일경우
//if (this.txtName.Text.Trim() == "") p_grouprName = "*전체";
//컬러명
DataTable dtTemp = new DataTable("dth");
dtTemp.Columns.Add("DATE_FROM");
dtTemp.Columns.Add("DATE_TO");
dtTemp.Columns.Add("Week1");
dtTemp.Columns.Add("Week2");
//필드명
dtTemp.Rows.Add(new object[] { p_dateFrom, p_dateTo, week1, week2 });
//필터링된 데이터를 담는다.
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.JERAP04();
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 refundsdate = ((DateTime)dtpRefundFrom.EditValue).ToString("yyyy-MM-dd");
string refundedate = ((DateTime)dtpRefundTo.EditValue).ToString("yyyy-MM-dd");
string guestname = this.txtGuestName.Text.Trim();
string depositor = this.txtDepositor.Text.Trim();
string rsvno = this.txtRsvNo.Text.Trim();
string bizcode = Parm.CurrentUserInformation.BizInfo.BizCode;
if (this.txtGuestName.Text.Trim() == "") guestname = "*전체";
if (this.txtDepositor.Text.Trim() == "") depositor = "*전체";
if (this.txtRsvNo.Text.Trim() == "") rsvno = "*전체";
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("REFUND_DATE_FROM");
dtTmp.Columns.Add("REFUND_DATE_TO");
dtTmp.Columns.Add("GUEST_NAME");
dtTmp.Columns.Add("DEPOSITOR");
dtTmp.Columns.Add("RSV_NO");
dtTmp.Columns.Add("ACCEPT_YN");
dtTmp.Columns.Add("REFUND_YN");
dtTmp.Columns.Add("BIZ_CODE");
dtTmp.Rows.Add(new object[] { refundsdate, refundedate, guestname, depositor, rsvno });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtDetailAll.Copy(), dtTmp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Reservation.CARA.Report.CDRAP02();
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.dtpFrom.EditValue).ToString("yyyy-MM-dd");
string edate = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string guestname = this.txtGuestName.Text.Trim();
string memberno = this.txtMemberNo.Text.Trim();
string membercode = Parm.CurrentUserInformation.BizInfo.BizCode;
string facilitycode = this.lupSrchFacilityCode.Text.Trim();
string roomtype = this.lupSrchRoomType.Text.Trim();
if (this.txtGuestName.Text.Trim() == "")
{
guestname = "*전체";
}
if (this.txtMemberNo.Text.Trim() == "")
{
memberno = "*전체";
}
if (this.lupSrchFacilityCode.EditValue.ToString().Trim() == "")
{
facilitycode = "*전체";
}
if (this.lupSrchRoomType.Text.ToString().Trim() == "")
{
roomtype = "*전체";
}
DataTable dtTmp = new DataTable("dtVar");
dtTmp.Columns.Add("DATE_FROM");
dtTmp.Columns.Add("DATE_TO");
dtTmp.Columns.Add("GUEST_NAME");
dtTmp.Columns.Add("MEMBER_NO");
dtTmp.Columns.Add("BIZ_CODE");
dtTmp.Columns.Add("FACILITY_CODE");
dtTmp.Columns.Add("ROOM_TYPE");
dtTmp.Columns.Add("RSV_NO");
dtTmp.Rows.Add(new object[] { sdate, edate, guestname, memberno, membercode, facilitycode, roomtype });
//필터링된 데이터를 담는다.
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.Reservation.CBRA.Report.CBRAP03();
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 p_lotCnt = this.txtLotno.Text.Trim();
//모두일경우
if (this.txtLotno.Text.Trim() == "")
{
p_lotCnt = "*전체";
}
//컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("LOT_CNT");
//필드명
dtTemp.Rows.Add(new object[] { p_lotCnt });
//필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
//테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
//dsTemp.WriteXmlSchema(@"c:\xsd_CFRAS05.xsd");
//return;
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Reservation.CFRA.Report.CFRAP05();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}