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");
}
