private void FillData() { Hashtable htPara = new Hashtable(); htPara["FROMDATE"] = dteNgay_BD.Text; htPara["TODATE"] = dteNgay_Kt.Text; dsKPI = SQLExec.ExecuteReturnDs("Sp_KPI_Getdata", htPara, CommandType.StoredProcedure); dtKPIHeader = dsKPI.Tables[0]; bdsKPIHeader.DataSource = dtKPIHeader; dgvKPIHeader.DataSource = bdsKPIHeader; //Uy quyen cho lop co so tim kiem bdsSearch = bdsKPIHeader; ExportControl = dgvKPIHeader; if (bdsKPIHeader.Count >= 0) { bdsKPIHeader.Position = 0; } // Điêu kiện khuyến mãi dtKPIDetail = dsKPI.Tables[1]; bdsKPIDetail.DataSource = dtKPIDetail; dgvKPIDetail.DataSource = bdsKPIDetail; }
private void FillData() { Hashtable htDisc = new Hashtable(); htDisc["NGAY_CT1"] = Library.StrToDate(dteNgay_BD.Text); htDisc["NGAY_CT2"] = Library.StrToDate(dteNgay_Kt.Text); htDisc.Add("MA_DVCS", Element.sysMa_DvCs); dsPromotionBudget = SQLExec.ExecuteReturnDs("sp_OM_GetBudget", htDisc, CommandType.StoredProcedure); dtBudgetHeader = dsPromotionBudget.Tables[0]; bdsBudgetHeader.DataSource = dtBudgetHeader; dgvBudget.DataSource = bdsBudgetHeader; //Uy quyen cho lop co so tim kiem bdsSearch = bdsBudgetHeader; ExportControl = dgvBudget; if (bdsBudgetHeader.Count >= 0) { bdsBudgetHeader.Position = 0; } //Detail dtBudgetDetailAllocate = dsPromotionBudget.Tables[1]; bdsBudgetDetailAllocate.DataSource = dtBudgetDetailAllocate; dgvBudgetDetail.DataSource = bdsBudgetDetailAllocate; }
private void FillData() { //Lấy nội dung bảng lương Hashtable htPara = new Hashtable(); htPara.Add("KPIID", cboKPI.Text); htPara.Add("USERID", Element.sysUser_Id); dsSalary = SQLExec.ExecuteReturnDs("KPI_KPIResult_GetById", htPara, CommandType.StoredProcedure); dtRatio = SQLExec.ExecuteReturnDt("KPI_Ratio_GetById", htPara, CommandType.StoredProcedure); if (radioButton1.Checked) { dtKPISalary = dsSalary.Tables[0]; } else if (radioButton2.Checked) { dtKPISalary = dsSalary.Tables[0]; } else if (radioButton2.Checked) { dtKPISalary = dsSalary.Tables[1]; } bdsKPISalary.DataSource = dtKPISalary; dgvKPISalary.DataSource = bdsKPISalary; this.ExportControl = dgvKPISalary; bdsSearch = bdsKPISalary; bdsRatio.DataSource = dtRatio; dgvKPIRatio.DataSource = bdsRatio; }
private void FillData() { Hashtable htDisc = new Hashtable(); htDisc["NGAY_CT1"] = Library.StrToDate(dteNgay_BD.Text); htDisc["NGAY_CT2"] = Library.StrToDate(dteNgay_Kt.Text); //htDisc["NGAY_CT1"] = dteNgay_BD.Text; //htDisc["NGAY_CT2"] = dteNgay_Kt.Text; htDisc.Add("MA_DVCS", Element.sysMa_DvCs); dsPJP = SQLExec.ExecuteReturnDs("sp_GetPJP", htDisc, CommandType.StoredProcedure); dtPJP = dsPJP.Tables[0]; bdsPJP.DataSource = dtPJP; dgvPJP.DataSource = bdsPJP; //Uy quyen cho lop co so tim kiem bdsSearch = bdsPJP; ExportControl = dgvPJP; if (bdsPJP.Count >= 0) { bdsPJP.Position = 0; } //Detail dtPJPDetail = dsPJP.Tables[1]; bdsPJPDetail.DataSource = dtPJPDetail; dgvPJPDetail.DataSource = bdsPJPDetail; }
public static bool PrintListOrder(string Ma_Px, bool bPreview, bool bShowDialog, ref bool bInVisibleNextPrint, ref string strReport_File_First) { string strMa_Px = Ma_Px;// (string)drPhView["Ma_Px"]; string strReportTag = string.Empty; string strTable_Ph = string.Empty; string strTable_Ct = string.Empty; bool bIs_Vnd = true; string strReport_File = "rptPXKList"; bool bInVisibleNextPrint0 = false; DataTable dtHeader; DataTable dtDetail; Hashtable ht = new Hashtable(); ht.Add("MA_PX", strMa_Px); DataSet dsPrintVoucher = new DataSet(); dsPrintVoucher = SQLExec.ExecuteReturnDs("sp_PrintListOrder", ht, CommandType.StoredProcedure); //Upadte Gia = 0, Tien = 0, TTien = 0 khi in chung tu doi voi User cam ACCESS_PRICE DataTable dtPrinVoucherHeader = new DataTable(); DataTable dtPrinVoucherDetail = new DataTable(); dtPrinVoucherHeader = dsPrintVoucher.Tables[0]; dtPrinVoucherDetail = dsPrintVoucher.Tables[1]; dtHeader = dtPrinVoucherHeader; dtDetail = dtPrinVoucherDetail; dtHeader.Columns.Add("REPORT_FILE", typeof(string)); dtHeader.Columns.Add("TITLE", typeof(string)); dtHeader.Columns.Add("IS_VND", typeof(bool)); dtHeader.Columns.Add("DOC_TIEN", typeof(string)); dtHeader.Columns.Add("DOC_TIEN1", typeof(string)); DataRow drHeader = dtHeader.Rows[0]; drHeader["Is_Vnd"] = bIs_Vnd; drHeader["Title"] = "DANH SÁCH ĐƠN HÀNG"; if (bInVisibleNextPrint) { drHeader["Report_File"] = strReport_File_First; } else { drHeader["Report_File"] = strReport_File; strReport_File_First = strReport_File; bInVisibleNextPrint = bInVisibleNextPrint0; } Epoint.Reports.frmReportPrint frmPrint = new Epoint.Reports.frmReportPrint(); //frmPrint.MdiParent = Element.frmActiveMain; return(frmPrint.Load(dtHeader.Rows[0], dtDetail, bPreview, bShowDialog)); }
public static void PrintInvoices(string Ma_Px) { string strMa_Px = Ma_Px;// (string)drPhView["Ma_Px"]; bool bPreview = false; // bool bShowDialog; // bool bInVisibleNextPrint; // string strReport_File_First; bool bAcceptShowDialog = true; bool bInVisibleNextPrint = false; string strReport_File_First = string.Empty; DataTable dtHeader; DataTable dtDetail; Hashtable ht = new Hashtable(); ht.Add("MA_PX", strMa_Px); DataSet dsPrintVoucher = new DataSet(); dsPrintVoucher = SQLExec.ExecuteReturnDs("sp_PrintListOrder", ht, CommandType.StoredProcedure); //Upadte Gia = 0, Tien = 0, TTien = 0 khi in chung tu doi voi User cam ACCESS_PRICE DataTable dtPrinVoucherHeader = new DataTable(); DataTable dtPrinVoucherDetail = new DataTable(); dtPrinVoucherHeader = dsPrintVoucher.Tables[0]; dtPrinVoucherDetail = dsPrintVoucher.Tables[1]; dtHeader = dtPrinVoucherHeader; dtDetail = dtPrinVoucherDetail; if (dtDetail.Rows.Count > 0) { int i = 0; foreach (DataRow drCurrent in dtDetail.Rows) { if (drCurrent["Stt"].ToString() != string.Empty) { if (i == 0) { bAcceptShowDialog = PrintVoucher.Print(drCurrent, bPreview, true, ref bInVisibleNextPrint, ref strReport_File_First); } else { if (bAcceptShowDialog) { bAcceptShowDialog = PrintVoucher.Print(drCurrent, bPreview, false, ref bInVisibleNextPrint, ref strReport_File_First); } else { break; } } i++; } } } }
public static bool Print_Crytal(string Stt, string rptFileName, bool bPreview, bool bShowDialog, PrintDialog dialog) { DataTable dtDetail; DataTable dtSubDetail; string PrinterName = dialog == null ? string.Empty : dialog.PrinterSettings.PrinterName; Hashtable ht = new Hashtable(); ht.Add("STT", Stt); DataSet dsPrintVoucher = new DataSet(); dsPrintVoucher = SQLExec.ExecuteReturnDs("sp_PrintVoucher_IN", ht, CommandType.StoredProcedure); Epoint.Reports.frmReportPrint_CRP frmPrint = new Epoint.Reports.frmReportPrint_CRP(); return(frmPrint.Load(Stt, dsPrintVoucher, rptFileName, bPreview, bShowDialog, PrinterName)); }
public static void PrintInvoices(string Ma_Px, bool IsRpt, bool IsPreview) { string strMa_Px = Ma_Px; bool bPreview = IsPreview; bool bAcceptShowDialog = true; bool bInVisibleNextPrint = false; string strReport_File_First = string.Empty; string rptFileName = Application.StartupPath + @"\Reports\CT_IN_Report.rpt"; if (IsPreview) { PrintVoucher.Print_Crytal(Ma_Px, rptFileName, bPreview, true, null); } else { DataTable dtHeader; DataTable dtDetail; Hashtable ht = new Hashtable(); ht.Add("MA_PX", strMa_Px); DataSet dsPrintVoucher = new DataSet(); dsPrintVoucher = SQLExec.ExecuteReturnDs("sp_PrintListOrder", ht, CommandType.StoredProcedure); DataTable dtPrinVoucherHeader = new DataTable(); DataTable dtPrinVoucherDetail = new DataTable(); dtPrinVoucherHeader = dsPrintVoucher.Tables[0]; dtPrinVoucherDetail = dsPrintVoucher.Tables[1]; dtHeader = dtPrinVoucherHeader; dtDetail = dtPrinVoucherDetail; PrintDialog dlgPrinter = new PrintDialog(); //Khởi tạo đối tượng PrintDialog dlgPrinter.ShowDialog(); //Hiển thị hộp thoại PrintDialog string PrinterName = dlgPrinter.PrinterSettings.PrinterName; if (dtDetail.Rows.Count > 0) { foreach (DataRow drCurrent in dtDetail.Rows) { string stt = drCurrent["Stt"].ToString(); bAcceptShowDialog = PrintVoucher.Print_Crytal(stt, rptFileName, bPreview, true, dlgPrinter); } } } }
private void BtLoadData_Click(object sender, EventArgs e) { Hashtable htParameter = new Hashtable(); htParameter.Add("MA_KV", txtMa_Kv_List.Text); htParameter.Add("MA_BP", txtMa_Bp_List.Text); htParameter.Add("MA_VITRI", txtTag_List.Text); htParameter.Add("CHARTREPORT", 2); htParameter.Add("NGAY1", dteFromDate.Text); htParameter.Add("NGAY2", dteTodate.Text); dsNhanVien = SQLExec.ExecuteReturnDs("HRM_GetEmployeeCount", htParameter, CommandType.StoredProcedure); if (dsNhanVien.Tables.Count == 0) { EpointMessage.MsgOk("Không có dữ liệu"); return; } LoadChart1(dsNhanVien.Tables[0]); LoadChartHd(dsNhanVien.Tables[1]); }
private void FillData() { Hashtable ht = new Hashtable(); ht.Add("NGAY_CT1", dteNgay_Ct1.Text); ht.Add("NGAY_CT2", dteNgay_Ct2.Text); ht.Add("LOAI_PX", cboMa_Ct.SelectedValue.ToString()); ht.Add("SO_CT", txtSo_Ct.Text); ht.Add("USERID", Element.sysUser_Id); ht.Add("MA_DVCS", Element.sysMa_DvCs); DataSet dsPXK = SQLExec.ExecuteReturnDs("sp_GetPhieuXuatKho", ht, CommandType.StoredProcedure); dtPXK = dsPXK.Tables[0]; DataColumn dc = new DataColumn("Selected", typeof(bool)); dc.DefaultValue = false; dtPXK.Columns.Add(dc); bdsPXK.DataSource = dtPXK; dgvPXK.DataSource = bdsPXK; //Uy quyen cho lop co so tim kiem bdsSearch = bdsPXK; ExportControl = dgvPXK; dtPXKDetail = dsPXK.Tables.Count > 1 ? dsPXK.Tables[1] : SQLExec.ExecuteReturnDt("sp_GetPhieuXuatKhoDetail", ht, CommandType.StoredProcedure); bdsPXKDetail.DataSource = dtPXKDetail; dgvPXDetail.DataSource = bdsPXKDetail; if (bdsPXK.Count >= 0) { bdsPXK.Position = bdsPXK.Count - 1; } }
private void BtLoadData_Click(object sender, EventArgs e) { Hashtable htParameter = new Hashtable(); htParameter.Add("MA_KV", txtMa_Kv_List.Text); htParameter.Add("MA_BP", txtMa_Bp_List.Text); htParameter.Add("MA_VITRI", txtTag_List.Text); htParameter.Add("CHARTREPORT", 3); dsNhanVien = SQLExec.ExecuteReturnDs("HRM_GetEmployeeCount", htParameter, CommandType.StoredProcedure); if (dsNhanVien.Tables.Count == 0) { EpointMessage.MsgOk("Không có dữ liệu"); return; } Tab1_Chart_PhongBan(dsNhanVien.Tables[0], "Ma_Bp"); Tab1_Chart_Kv(dsNhanVien.Tables[0], "Ma_Loai2"); Tab2_Chart_Vitri(dsNhanVien.Tables[0], "Ma_Vitri"); Tab3_LoadChartGioiTinh(dsNhanVien.Tables[1], "Code"); Tab5_LoadChartHopDong(dsNhanVien.Tables[2], "Code"); Tab4_LoadTrinhDo(dsNhanVien.Tables[3], "Code"); }
public void LoadScreen() { //TreeMain //ucTreeMain = new UcTreeMain(); //ucTreeMain.LoadControl(this.iModule_ID); //ucTreeMain.Dock = DockStyle.Top; //ucTreeMain.Width = pnlLeftScreen.Width - 20; //ucTreeMain.MinimumSize = new Size(ucTreeMain.Width, pnlLeftScreen.Height / 3); //ucTreeMain.MaximumSize = new Size(ucTreeMain.Width, pnlLeftScreen.Height * 6 / 6); //ucTreeMain.SetProperlyHeight(); //ucTreeMain.Visible = false; //pnlLeftScreen.Controls.Add(ucTreeMain); ucNarvarMain = new ucNarMain(); ucNarvarMain.LoadControl(); ucNarvarMain.Anchor = AnchorStyles.Top | AnchorStyles.Left; ucNarvarMain.SetProperlyHeight(this); //ucNarvarMain.Width = pnlLeftScreen.Width; //pnlLeftScreen.Controls.Add(ucNarvarMain); //this.pnlLeftScreen.Visible = false; ///////////////////////// pnlScreen.Dock = DockStyle.Fill; this.pnlCenter.Dock = DockStyle.Fill; this.ucNarvarMain.Dock = DockStyle.Left; pnlScreen.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))); //////////////////////// tbTabPageControl tbTabPageMain = new tbTabPageControl(); tbTabPageMain.Tag = "MAIN"; //this.pnImage = new pnlControl(); //if (Element.sysLanguage == enuLanguageType.Vietnamese) // pnImage.BackgroundImage = Commons.Properties.Resources.Background_V; //else // pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; this.pnImage = new pnlControl(); if (Element.sysLanguage == enuLanguageType.Vietnamese) { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_V; if (File.Exists(Application.StartupPath + @"\Images\Background_V.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_V.png"); } } else if (Element.sysLanguage == enuLanguageType.English) { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; if (File.Exists(Application.StartupPath + @"\Images\Background_E.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_E.png"); } } else { this.pnImage.BackgroundImage = Commons.Properties.Resources.Background_E; if (File.Exists(Application.StartupPath + @"\Images\Background_O.png")) { this.pnImage.BackgroundImage = Image.FromFile(Application.StartupPath + @"\Images\Background_O.png"); } } pnImage.BackgroundImageLayout = ImageLayout.Stretch; pnImage.Dock = DockStyle.Fill; //Add chart on the main #region Chart bool bloadChart = DataTool.SQLCheckExist("sys.procedures", "Name", "SYS_LoadMainChart"); if (bloadChart) //Collection.Parameters.ContainsKey("MAINCHART") { DataSet dsChart = SQLExec.ExecuteReturnDs("SYS_LoadMainChart @Ma_Dvcs ='" + Element.sysMa_DvCs + "',@Nam = " + Element.sysWorkingYear.ToString() + ""); //DataSet dsChart = SQLExec.ExecuteReturnDs("SYS_LoadMainChart"); this.mainchart = new MainChart(); mainchart.LoadChart(dsChart); mainchart.Dock = DockStyle.Fill; this.pnImage.Controls.Add(mainchart); } #endregion this.tbTabMain.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))); tbTabMain.Dock = DockStyle.Fill; tbTabMain.Visible = false; pnlScreen.Dock = DockStyle.Fill; this.pnlScreen.Controls.Add(ucNarvarMain); this.pnlCenter.Controls.Add(tbTabMain); this.pnlCenter.Controls.Add(pnImage); this.ssMain.Dock = DockStyle.Bottom; this.pnlCenter.Controls.Add(ssMain); //ModuleManagement Nhac viet this.ucModuleManagement.Dock = DockStyle.Bottom; this.ucModuleManagement.Width = pnlLeftScreen.Width - 20; this.UcModuleHeight = this.ucModuleManagement.Height; //this.ucModuleManagement.Height = this.UcModuleHeight - this.ucModuleManagement.lvReminder.Height; this.pnImage.Controls.Add(ucModuleManagement); //ucCustomer = new ucCustomerInfo(); //ucCustomer.Anchor = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Bottom; //ucCustomer.Location = new Point(this.pnImage.Width / 2 + 200, this.pnImage.Height / 2); //this.pnImage.Controls.Add(ucCustomer); //ucModuleManagement.Width = 250; //ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, 1); //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, this.pnlCenter.Height - ucModuleManagement.Height - 20); //ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; /* * * //ModuleManagement Nhac viet * //ucModuleManagement.Dock = DockStyle.Bottom; * //ucModuleManagement.Width = pnlLeftScreen.Width - 20; * * // pnlLeftScreen.Controls.Add(ucModuleManagement); * * //ucModuleManagement.Width = 250; * //ucModuleManagement.Anchor = AnchorStyles.Top | AnchorStyles.Right; * //if (iModule_ID <= 0) * //{ * // this.pnlCenter.Controls.Add(ucModuleManagement); * // //ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, 1); * // ucModuleManagement.Location = new Point(this.pnlCenter.Width - ucModuleManagement.Width - 1, this.pnlCenter.Height - ucModuleManagement.Height - 20); * // ucModuleManagement.Anchor = AnchorStyles.Bottom | AnchorStyles.Right; * //} * * //Cac control khac * * //ucCustomer = new ucCustomerInfo(); * //this.pnlCenter.Controls.Add(ucCustomer); * * //tbTabPageMain.Controls.Add(ucCustomer); * //ucCustomer.Location = new Point(0, 0); * //ucCustomer.Anchor = AnchorStyles.Top | AnchorStyles.Left; */ //Test //ucWTable ucDesk = new ucWTable(); //ucDesk.Load(); //ucDesk.Dock = DockStyle.Fill; //pnImage.Controls.Add(ucDesk); // }
public static bool Print(DataRow drPhView, bool bPreview, bool bShowDialog, ref bool bInVisibleNextPrint, ref string strReport_File_First) { string strStt = (string)drPhView["Stt"]; string strMa_Ct = (string)drPhView["Ma_Ct"]; string strMa_Tte = "VND";// (string)drPhView["Ma_Tte"]; string strReportTag = string.Empty; string strTable_Ph = string.Empty; string strTable_Ct = string.Empty; bool bIs_Vnd = true; string strReport_File = string.Empty; bool bInVisibleNextPrint0 = false; bool bIs_Doc_Tien1 = false; int iSo_Lien = 1; DataRow drDmCt = DataTool.SQLGetDataRowByID("SYSDMCT", "Ma_Ct", strMa_Ct); DataTable dtHeader; DataTable dtDetail; strTable_Ph = (string)drDmCt["Table_Ph"]; strTable_Ct = (string)drDmCt["Table_Ct"]; strReport_File = (string)drDmCt["Report_File"]; if (strMa_Ct == "BN" && !bInVisibleNextPrint) { DataRow drCtTien = DataTool.SQLGetDataRowByID(strTable_Ct, "Stt", strStt); if (!drPhView.Table.Columns.Contains("TK_NH")) { drPhView.Table.Columns.Add("TK_NH", typeof(string)); } drPhView["Tk_Nh"] = (string)drCtTien["Tk_Co"]; frmIn_CT_UNC frm = new frmIn_CT_UNC(); if (strMa_Tte != Element.sysMa_Tte) { frm.rdbTien_Nt.Checked = true; } frm.Load(drPhView); if (!frm.isAccept) { return(false); } bInVisibleNextPrint0 = frm.chkInVisibleNextPrint.Checked; bIs_Vnd = frm.rdbTien_VND.Checked; strReport_File = frm.cboMau_In.SelectedValue.ToString(); iSo_Lien = frm.iSo_Lien; } else { //In thông tin chữ ký string strName1 = string.Empty; string strName2 = string.Empty; string strName3 = string.Empty; string strName4 = string.Empty; string strName5 = string.Empty; string strKey = "Ma_Dvcs = '" + Element.sysMa_DvCs + "'" + " AND Ma_Ct = '" + strMa_Ct + "'"; DataTable dtDmCk = DataTool.SQLGetDataTable("SYSDMCK", "*", strKey, "Ma_Ct"); if (dtDmCk != null) { foreach (DataRow drDmCk in dtDmCk.Rows) { strName1 = drDmCk["Name1"].ToString(); strName2 = drDmCk["Name2"].ToString(); strName3 = drDmCk["Name3"].ToString(); strName4 = drDmCk["Name4"].ToString(); strName5 = drDmCk["Name5"].ToString(); } } //Cập nhật thông tin chữ ký xuống GLVOUCHER string strSQLUpdate = "UPDATE " + strTable_Ph + " SET " + @"Chu_Ky_1 = @Chu_Ky_1, Chu_Ky_2 = @Chu_Ky_2, Chu_Ky_3 = @Chu_Ky_3, Chu_Ky_4 = @Chu_Ky_4, Chu_Ky_5 = @Chu_Ky_5" + " WHERE Stt = @Stt"; Hashtable htChuKy = new Hashtable(); htChuKy["CHU_KY_1"] = strName1; htChuKy["CHU_KY_2"] = strName2; htChuKy["CHU_KY_3"] = strName3; htChuKy["CHU_KY_4"] = strName4; htChuKy["CHU_KY_5"] = strName5; htChuKy["STT"] = strStt; SQLExec.Execute(strSQLUpdate, htChuKy, CommandType.Text); //In Tien_Nt if (strMa_Tte != Element.sysMa_Tte) { frmIn_CT_Tien_NT frm = new frmIn_CT_Tien_NT(); frm.Load(drPhView); if (!frm.isAccept) { return(false); } bIs_Vnd = frm.rdbTien_VND.Checked; } } //Chon nhieu mau report khi in DataTable dtDmMauIn = DataTool.SQLGetDataTable("SYSDMMAUCT", "Ma_Mau, Ten_Mau", "Ma_Ct = '" + strMa_Ct + "'", "Ma_Mau"); if (dtDmMauIn.Rows.Count == 1) { strReport_File = (string)dtDmMauIn.Rows[0]["Ma_Mau"]; } else if (strMa_Ct != "BN" && dtDmMauIn.Rows.Count > 1 && !bInVisibleNextPrint) { if (strMa_Ct == "PC" || strMa_Ct == "PT") { frmIn_Ct_Khac frmInHD = new frmIn_Ct_Khac(); frmInHD.strMa_Ct = strMa_Ct; frmInHD.Is_Design = false; frmInHD.Load(drPhView); strReport_File = frmInHD.cboMau_In.SelectedValue.ToString(); iSo_Lien = frmInHD.iSo_Lien; bInVisibleNextPrint0 = frmInHD.chkInVisibleNextPrint.Checked; bIs_Doc_Tien1 = frmInHD.chkIs_Doc_Tien1.Checked; if (!frmInHD.Is_Design) { return(false); } } else { frmIn_Ct_HD frmInHD = new frmIn_Ct_HD(); frmInHD.strMa_Ct = strMa_Ct; frmInHD.Is_Design = false; frmInHD.Load(drPhView); strReport_File = frmInHD.cboMau_In.SelectedValue.ToString(); iSo_Lien = frmInHD.iSo_Lien; bInVisibleNextPrint0 = frmInHD.chkInVisibleNextPrint.Checked; if (!frmInHD.Is_Design) { return(false); } } } string strMau_So = string.Empty; if (drPhView.Table.Columns.Contains("Mau_So")) { strMau_So = (string)drPhView["Mau_So"]; } Hashtable ht = new Hashtable(); ht.Add("STT", strStt); ht.Add("MA_CT", strMa_Ct); ht.Add("IS_VND", bIs_Vnd ? 1 : 0); ht.Add("LANGUAGE_TYPE", (char)Element.sysLanguage); DataSet dsPrintVoucher = SQLExec.ExecuteReturnDs("sp_PrintVoucher", ht, CommandType.StoredProcedure); //Upadte Gia = 0, Tien = 0, TTien = 0 khi in chung tu doi voi User cam ACCESS_PRICE DataTable dtPrinVoucherHeader = new DataTable(); DataTable dtPrinVoucherDetail = new DataTable(); dtPrinVoucherHeader = dsPrintVoucher.Tables[0]; dtPrinVoucherDetail = dsPrintVoucher.Tables[1]; if (DataTool.SQLCheckExist("SYSOBJECT", "Object_ID", "ACCESS_PRICE") && !Common.CheckPermission("ACCESS_PRICE", enuPermission_Type.Allow_Access)) { foreach (DataColumn dc in dtPrinVoucherHeader.Columns) { if (dc.ColumnName.StartsWith("GIA") || dc.ColumnName.StartsWith("TIEN") || dc.ColumnName.StartsWith("TTIEN") || dc.ColumnName.StartsWith("PS_NO") || dc.ColumnName.StartsWith("PS_CO") || dc.ColumnName.StartsWith("PS_TANG") || dc.ColumnName.StartsWith("PS_GIAM") || dc.ColumnName.StartsWith("DU_DAU") || dc.ColumnName.StartsWith("DU_CUOI") || dc.ColumnName.StartsWith("DU_NO") || dc.ColumnName.StartsWith("DU_CO")) { if (dc.DataType == typeof(double) || dc.DataType == typeof(decimal)) { //Gán cột dữ liệu về 0 foreach (DataRow dr in dtPrinVoucherHeader.Rows) { dr[dc] = 0; } } if (dc.DataType == typeof(string)) { //Gán cột dữ liệu về rổng foreach (DataRow dr in dtPrinVoucherHeader.Rows) { dr[dc] = ""; } } } } foreach (DataColumn dc in dtPrinVoucherDetail.Columns) { if (dc.ColumnName.StartsWith("GIA") || dc.ColumnName.StartsWith("TIEN") || dc.ColumnName.StartsWith("PS_NO") || dc.ColumnName.StartsWith("PS_CO") || dc.ColumnName.StartsWith("PS_TANG") || dc.ColumnName.StartsWith("PS_GIAM") || dc.ColumnName.StartsWith("DU_DAU") || dc.ColumnName.StartsWith("DU_CUOI") || dc.ColumnName.StartsWith("DU_NO") || dc.ColumnName.StartsWith("DU_CO")) { if (dc.DataType == typeof(double) || dc.DataType == typeof(decimal)) { //Gán cột dữ liệu về 0 foreach (DataRow dr in dtPrinVoucherDetail.Rows) { dr[dc] = 0; } } } } } dtHeader = dtPrinVoucherHeader; dtDetail = dtPrinVoucherDetail; dtHeader.Columns.Add("REPORT_FILE", typeof(string)); dtHeader.Columns.Add("TITLE", typeof(string)); dtHeader.Columns.Add("IS_VND", typeof(bool)); dtHeader.Columns.Add("DOC_TIEN", typeof(string)); dtHeader.Columns.Add("DOC_TIEN1", typeof(string)); dtHeader.Columns.Add("DOC_TIEN_TC", typeof(string)); DataRow drHeader = dtHeader.Rows[0]; drHeader["Is_Vnd"] = bIs_Vnd; drHeader["Title"] = ((string)drDmCt["Title"]).ToUpper(); if (bInVisibleNextPrint) { drHeader["Report_File"] = strReport_File_First; } else { drHeader["Report_File"] = strReport_File; strReport_File_First = strReport_File; bInVisibleNextPrint = bInVisibleNextPrint0; } if (Element.sysLanguage == enuLanguageType.Vietnamese) { dtHeader.Rows[0]["Doc_Tien"] = !bIs_Vnd?Common.ReadMoney(Convert.ToDouble(drHeader["TTien_Nt"]), strMa_Tte) : Common.ReadMoney(Convert.ToDouble(drHeader["TTien"]), Element.sysMa_Tte.ToString()); if (drHeader.Table.Columns.Contains("TTien_Nt00")) { dtHeader.Rows[0]["Doc_Tien_Tc"] = !bIs_Vnd?Common.ReadMoney(Convert.ToDouble(drHeader["TTien_Nt00"]), strMa_Tte) : Common.ReadMoney(Convert.ToDouble(drHeader["TTien_Nt00"]), Element.sysMa_Tte.ToString()); dtHeader.Rows[0]["Doc_Tien_Tc"] = "(" + dtHeader.Rows[0]["Doc_Tien_Tc"].ToString() + ")"; } if (bIs_Doc_Tien1) { dtHeader.Rows[0]["Doc_Tien1"] = ""; } else { dtHeader.Rows[0]["Doc_Tien1"] = !bIs_Vnd?Common.ReadMoney(Convert.ToDouble(drHeader["TTien_Nt"]), strMa_Tte) : Common.ReadMoney(Convert.ToDouble(drHeader["TTien"]), Element.sysMa_Tte.ToString()); } } else { dtHeader.Rows[0]["Doc_Tien"] = !bIs_Vnd?Common.ReadMoneyE(Convert.ToDouble(drHeader["TTien_Nt"]), strMa_Tte) : Common.ReadMoneyE(Convert.ToDouble(drHeader["TTien"]), Element.sysMa_Tte.ToString()); if (bIs_Doc_Tien1) { dtHeader.Rows[0]["Doc_Tien1"] = ""; } else { dtHeader.Rows[0]["Doc_Tien1"] = !bIs_Vnd?Common.ReadMoneyE(Convert.ToDouble(drHeader["TTien_Nt"]), strMa_Tte) : Common.ReadMoneyE(Convert.ToDouble(drHeader["TTien"]), Element.sysMa_Tte.ToString()); } } Epoint.Reports.frmReportPrint frmPrint = new Epoint.Reports.frmReportPrint(); //frmPrint.MdiParent = Element.frmActiveMain; return(frmPrint.Load(dtHeader.Rows[0], dtDetail, bPreview, bShowDialog)); }
public virtual void Import_Excel(bool CheckAPI) { //string strMsg = (Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có muốn ghi đè lên mẫu tin đã tồn tại không ?" : "Do you want to override exists data ?"); bool Is_Avail = true; if (true) { SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand(); command.CommandText = "OM_Import_DiscountProg"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs); //command.Parameters.AddWithValue("@IsImport", false); SqlParameter parameter = new SqlParameter { SqlDbType = SqlDbType.Structured, ParameterName = "@EditDisc", TypeName = "TVP_DiscoutList", Value = dtImport }; command.Parameters.Add(parameter); try { command.ExecuteNonQuery(); } catch (Exception exception) { Is_Avail = false; command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION"; command.CommandType = CommandType.Text; command.Parameters.Clear(); command.ExecuteNonQuery(); EpointProcessBox.AddMessage("Có lỗi xảy ra :" + exception.Message); } } //return; if (!Is_Avail) { return; } Hashtable htParaBreaby = new Hashtable(); htParaBreaby["MA_DVCS"] = Element.sysMa_DvCs; htParaBreaby["LOCALMACHINE"] = System.Environment.MachineName; htParaBreaby["ISOVERWRITE"] = chkIsOverride.Checked; DataSet ds = SQLExec.ExecuteReturnDs("OM_Import_DiscountProg_CheckValid", htParaBreaby, CommandType.StoredProcedure); DataTable dtCtkm = ds.Tables[0]; DataTable dtMa_vt = ds.Tables[1]; DataTable dtMa_Vt_Km = ds.Tables[2]; if (dtCtkm.Rows.Count > 0) { strError += "\n" + "Chương trình KM/CK đã tồn tại trong hệ thống : "; foreach (DataRow dr in dtCtkm.Rows) { strError += dr["Ma_CTKM"].ToString() + ","; } } if (dtMa_vt.Rows.Count > 0) { strError += "\n" + "Mã hàng bán không tồn tại : "; foreach (DataRow dr in dtMa_vt.Rows) { strError += dr["Ma_Vt"].ToString() + ","; } } if (dtMa_Vt_Km.Rows.Count > 0) { strError += "\n" + "Mã hàng khuyến mãi không tồn tại : "; foreach (DataRow dr in dtMa_Vt_Km.Rows) { strError += dr["Ma_Vt"].ToString() + ","; } } if (strError != string.Empty) { EpointProcessBox.AddMessage(strError); } else { Hashtable htPara = new Hashtable(); htPara["MA_DVCS"] = Element.sysMa_DvCs; htPara["LOCALMACHINE"] = System.Environment.MachineName; htPara["ISOVERWRITE"] = chkIsOverride.Checked; if (SQLExec.Execute("OM_Import_DiscountProg_Valid", htPara, CommandType.StoredProcedure)) { EpointProcessBox.AddMessage("Import thành công!"); } else { EpointProcessBox.AddMessage("Import thất bại!"); } } EpointProcessBox.AddMessage("Kết thúc"); }