/// <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);
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);
////컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("MONTHS");
dtTemp.Columns.Add("TASK_DATE");
dtTemp.Columns.Add("FACILITY_NAME");
DateTime dtimeTask = DateTime.ParseExact(Parm.CurrentUserInformation.roomTask.gsTaskDate, "yyyyMMdd", null);
//필드명
dtTemp.Rows.Add(new object[] { this.dtpMonths.Text.Trim()
, dtimeTask.ToString("yyyy-MM-dd")
, Parm.CurrentUserInformation.roomTask.gsDFacilityName });
///*
////프린터 데이터추가
//for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
//{
// dsTemp.Tables[0].Rows[i]["FACILITY_NAME"] = " " + dsTemp.Tables[0].Rows[i]["FACILITY_NAME"].ToString();
//}
//*/
////필터링된 데이터를 담는다.
DataTable dtFilter = Cls.Grid.Options.GetGridData(this.grid);
////테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dtFilter, dtTemp });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Room.DARA.Report.DCRAP18();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 프린터버튼을 눌렀을 경우
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string giftname = this.txtGiftName.Text.Trim();
string giftpart = this.lupGiftPart.Text.Trim();
if (this.txtGiftName.Text.ToString().Trim() == "")
{
giftname = "*전체";
}
if (this.lupGiftPart.EditValue.ToString().Trim() == "")
{
giftpart = "*전체";
}
DataTable dtTemp = new DataTable("dtVar");
dtTemp.Columns.Add("GIFT_PART_CODE");
dtTemp.Columns.Add("GIFT_NAME");
dtTemp.Rows.Add(new object[] { giftname, giftpart });
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dtTemp });
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.ALRA.Report.ALRAP03();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
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);
}
}
/// <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(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);
}
}
/// <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 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 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("yyyyMMdd");
string dateTo = ((DateTime)this.dtpTo.EditValue).ToString("yyyyMMdd");
//string facilityCode = lupFacilityCode.EditValue.ToString();
string lossCode = lupLossCode.Text;
string roomPart = lupRoomPart.Text;
string roomCode = txtRoomCode.Text;
//모두일경우
if (this.lupLossCode.EditValue.ToString() == "")
{
lossCode = "*전체";
}
if (this.lupRoomPart.EditValue.ToString() == "")
{
roomPart = "*전체";
}
if (this.txtRoomCode.Text == "")
{
roomCode = "*전체";
}
//컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("DATEFROM");
dtTemp.Columns.Add("DATETO");
dtTemp.Columns.Add("LOSSCODE");
dtTemp.Columns.Add("ROOMPART");
dtTemp.Columns.Add("ROOMCODE");
//필드명
dtTemp.Rows.Add(new object[] { dateFrom, dateTo, lossCode, roomPart, roomCode });
//필터링된 데이터를 담는다.
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.DHRAP03();
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 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();
string FacilityName = txtFacilityType.Text.Trim();
//모두일경우
if (this.txtFacilityType.Text.Trim() == "")
{
FacilityName = "*전체";
}
//컬러명
DataTable dth = new DataTable("dth");
dth.Columns.Add("DATE_FROM");
dth.Columns.Add("DATE_TO");
dth.Columns.Add("Week1");
dth.Columns.Add("Week2");
dth.Columns.Add("FacilityName");
//필드명
dth.Rows.Add(new object[] { p_dateFrom, p_dateTo, week1, week2, FacilityName });
//테이블 추가
DataSet dsTemp = new DataSet();
dsTemp.Tables.AddRange(new DataTable[] { dt.Copy(), dth });
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.Facility.JARA.Report.JJRAP02();
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 btnAmtPrint_Click(object sender, EventArgs e)
{
try
{
if (dt.Rows.Count <= 0 || this.gridView.FocusedRowHandle < 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다.");
return;
}
if (Basic.ShowMessageQuestion("출력하시겠습니까?") == DialogResult.No)
{
return;
}
Basic.SetCursor(this, false);
if (f != null && f.IsHandleCreated)
{
f.Activate();
return;
}
string appno = this.gridView.GetRowCellValue(this.gridView.FocusedRowHandle, "APPLICATION_NO").ToString().Trim();
DataTable dtparam = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtparam.Rows.Add(new object[] { "V_APPLICATION_NO", appno });
dtparam.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
DataSet ds = DataLayer.ExecuteSpDataset("PKG_AARBS02_01.PR_01", dtparam, DataLayer.MessageEncoding.Default);
if (ds.Tables[0].Rows.Count <= 0)
{
Basic.ShowMessage(1, "출력할 데이터가 없습니다");
return;
}
ds.Tables[0].TableName = "Amt1";
ds.Tables[1].TableName = "Amt2";
ds.Tables[2].TableName = "Amt3";
ds.Tables[1].Columns["AMT_TOT"].DataType = typeof(decimal);
ds.Tables[2].Columns["AMT"].DataType = typeof(decimal);
for (int j = 1; j <= 10; j++)
{
ds.Tables[1].Columns.Add("P" + j.ToString());
}
string[] AmtPosion = new string[] { "-", "-", "-", "-", "-", "-", "-", "-", "-", "-" };
string strPosion = ds.Tables[1].Rows[0]["AMT_TOT"].ToString().Trim();
int arryindex = 9;
for (int i = strPosion.Length - 1; i >= 0; i--)
{
string stremp = strPosion.Substring(i, 1);
AmtPosion[arryindex] = stremp;
arryindex--;
}
for (int u = 0; u < 10; u++)
{
ds.Tables[1].Rows[0]["P" + (u + 1).ToString()] = AmtPosion[u];
}
ds.DataSetName = "xsd_AARBS02_01";
ds.Tables[2].Columns.Add("SIGN");
ds.Tables[2].Columns.Add("WON");
for (int w = 0; w < ds.Tables[2].Rows.Count; w++)
{
ds.Tables[2].Rows[w]["WON"] = " 원";
ds.Tables[2].Rows[w]["SIGN"] = @"\";
}
int cnt = ds.Tables[2].Rows.Count <= 7 ? 7 - ds.Tables[2].Rows.Count : 7 - (ds.Tables[2].Rows.Count % 7);
for (int i = 0; i < cnt; i++)
{
DataRow r = ds.Tables[2].NewRow();
ds.Tables[2].Rows.Add(r);
}
//DxReport 추가
f = new XtraReportsBase.DxReport.XtraPreviewForm();
DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.AARA.Report.AARBP02_01();
//DevExpress.XtraReports.UI.XtraReport rpt = new Erp.SubdivisionSale.AARA.Report.test();
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(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;
}
// 업장타입별 세부 내역 프린트 여부 확인
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 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);
}
}
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);
//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");
string dateFrom2 = ((DateTime)this.dtpFrom2.EditValue).ToString("yyyy-MM-dd");
string dateTo2 = ((DateTime)this.dtpTo.EditValue).ToString("yyyy-MM-dd");
string marketCode = lupMarketCode.Text;
string contract = txtContractEmpName.Text;
string memberName = txtMemberName.Text;
string Cancel = chkCancel.EditValue.ToString();
string Confirm = chkConfirm.EditValue.ToString();
string Finsh = chkFinsh.EditValue.ToString();
if (Cancel == "True")
{
Cancel = "Y";
}
else
{
Cancel = "N";
}
if (Confirm == "True")
{
Confirm = "Y";
}
else
{
Confirm = "N";
}
if (Finsh == "True")
{
Finsh = "Y";
}
else
{
Finsh = "N";
}
//모두일경우
if (this.lupMarketCode.EditValue.ToString() == "")
{
marketCode = "*전체";
}
if (this.txtContractEmpName.Text == "")
{
contract = "*전체";
}
if (this.txtMemberName.Text == "")
{
memberName = "*전체";
}
//컬러명
DataTable dtTemp = new DataTable("dtReport");
dtTemp.Columns.Add("dateFrom");
dtTemp.Columns.Add("dateTo");
dtTemp.Columns.Add("dateFrom2");
dtTemp.Columns.Add("dateTo2");
dtTemp.Columns.Add("marketCode");
dtTemp.Columns.Add("contract");
dtTemp.Columns.Add("memberName");
dtTemp.Columns.Add("Cancel");
dtTemp.Columns.Add("Confirm");
dtTemp.Columns.Add("Finsh");
//필드명
dtTemp.Rows.Add(new object[] { dateFrom, dateTo, dateFrom2, dateTo2, marketCode, contract, memberName, Cancel, Confirm, Finsh });
//필터링된 데이터를 담는다.
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.FARAP01();
f.ShowReport(dsTemp, rpt);
f.Show();
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
finally
{
Basic.SetCursor(this, true);
}
}
