public virtual void Import_Excel(bool CheckAPI)
{
bool bIsImport = DataTool.SQLCheckExist("sys.procedures", "Name", "OM_Import_PromotionBudget");
if (bIsImport)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "OM_Import_PJP";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TablePJP",
TypeName = "TVP_OMPJP",
Value = dtImport
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
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);
}
}
EpointProcessBox.AddMessage("Kết thúc");
}
private static void LoadDoanhThu()
{
DataTable dtDoanhThu;
SqlConnection newSQLConnection = SQLExec.GetNewSQLConnection();
SqlCommand selectCommand = new SqlCommand
{
Connection = newSQLConnection
};
DateTime time = Library.StrToDate("01/01/" + DateTime.Now.Year);
DateTime now = DateTime.Now;
selectCommand.CommandText = string.Concat(new object[] { "SET DATEFORMAT DMY EXEC sp_rptDKTHANG01 '01/01/", DateTime.Now.Year, "','", now.Day, "/", now.Month, "/", now.Year, "', 1, 'V', ", Element.sysMa_DvCs });
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
dtDoanhThu = new DataTable();
adapter.Fill(dtDoanhThu);
rptDoanhThu.fHeight = viewDoanhThuHeight;
rptDoanhThu.fWidth = viewDoanhThuWidth;
rptDoanhThu.SetLicense("RGN,RGN Warez Group,DD-APN-30-C01339,W44SSM949SWJ449HSHMF");
rptDoanhThu.Load(dtDoanhThu);
try
{
rptDoanhThu.Run();
}
catch (Exception)
{
rptDoanhThu.Run();
}
}
private void Save_PXKDetail(DataTable dtEditCt)
{
if (true)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_Update_PXKDetail";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_PX", txtMa_Px.Text);
command.Parameters.AddWithValue("@Ma_CBNV_GH", txtMa_CBNV_GH.Text);
command.Parameters.AddWithValue("@LOAI_PX", txtMa_Ct.Text);
command.Parameters.AddWithValue("@IS_UPDATE", "0");
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TVP_PXKDETAIL",
TypeName = "TVP_PXKDETAIL",
Value = this.dtImport,
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.ExecuteNonQuery();
MessageBox.Show("Có lỗi xảy ra :" + exception.Message);
}
}
}
private DataTable GetStockDetail()
{
DataTable dtReturn = new DataTable();
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "sp_GetPXKDetail";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_PX", txtMa_Px.Text);
command.Parameters.AddWithValue("@Ngay_Ct", Library.StrToDate(dteNgay_Ct.Text));
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
command.Parameters.AddWithValue("@Is_NotAvail", true);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TVP_PXKDETAIL",
TypeName = "TVP_PXKDETAIL",
Value = this.dtImport,
};
command.Parameters.Add(parameter);
try
{
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dtReturn);
return(dtReturn);
}
catch (Exception exception)
{
return(null);
}
}
private void Save_PXKDetail(DataTable dtEditCt)
{
if (true)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "SP_M1_ImportOrder";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserID", Element.sysUser_Id);
//command.Parameters.AddWithValue("@IS_UPDATE", "1");
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TP_Ord",
TypeName = "TVP_OM_SalesOrd",
Value = dtEditCt,
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.ExecuteNonQuery();
MessageBox.Show("Có lỗi xảy ra :" + exception.Message);
}
}
}
private static void LoadCongNo()
{
SqlConnection newSQLConnection = SQLExec.GetNewSQLConnection();
SqlCommand selectCommand = new SqlCommand
{
Connection = newSQLConnection,
CommandText = "sp_ViewReminderHanTt 'V'," + Element.sysMa_DvCs
};
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
dtCongNo = new DataTable();
adapter.Fill(dtCongNo);
Is_LoadCongNo = true;
threadCongNo.Abort();
}
private static void LoadTaiKhoan()
{
SqlConnection newSQLConnection = SQLExec.GetNewSQLConnection();
SqlCommand selectCommand = new SqlCommand
{
Connection = newSQLConnection,
CommandText = "sp_ViewReminderTaiKhoan " + Element.sysMa_DvCs
};
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
dtTaiKhoan = new DataTable();
adapter.Fill(dtTaiKhoan);
Is_LoadTaiKhoan = true;
threadTaiKhoan.Abort();
}
public virtual void Import_Excel(DataTable dt)
{
OpenFileDialog ofdlg = new OpenFileDialog();
ofdlg.Filter = "xls files (*.xls;*.xlsx)|*.xls;*.xlsx";
ofdlg.RestoreDirectory = true;
if (ofdlg.ShowDialog() != DialogResult.OK)
{
return;
}
DataTable dtImport = Common.ReadExcel(ofdlg.FileName);
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 bIs_Overide = Common.MsgYes_No(strMsg);
SaveData(dtImport, null, bIs_Overide);
System.Data.SqlClient.SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "AR_Import_GIABAN";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserId", Element.sysUser_Id);
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@ARGIABAN",
TypeName = "TVP_ARGIABAN",
Value = dtImport
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
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);
}
}
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 = "Sp_IF_KPICampaign";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserId", Element.sysUser_Id);
command.Parameters.AddWithValue("@Is_OverWrite", chkIsOverride.Checked);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@KPICAMPAIGN",
TypeName = "TVP_KPICAMPAIGN",
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;
}
EpointProcessBox.AddMessage("Kết thúc");
}
private DataTable GetDiscountDetail()
{
DataTable dtReturn = new DataTable();
DataTable dtImport = SQLExec.ExecuteReturnDt("DECLARE @TVP_PXKDETAIL AS TVP_PXKDETAIL SELECT * FROM @TVP_PXKDETAIL");
foreach (DataRow drEdit in this.dtListInvoice.Rows)
{
DataRow drNew = dtImport.NewRow();
Common.CopyDataRow(drEdit, drNew);
dtImport.Rows.Add(drNew);
}
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "sp_GetPXKDetail";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_PX", this.strMa_Px);
command.Parameters.AddWithValue("@Ngay_Ct", this.Ngay_Ct);
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TVP_PXKDETAIL",
TypeName = "TVP_PXKDETAIL",
Value = dtImport,
};
command.Parameters.Add(parameter);
try
{
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dtReturn);
return(dtReturn);
}
catch (Exception exception)
{
return(dtReturn);
}
}
private void Save_HanTt0(string Stt_PTT, DataTable dtTableSource)
{
//DataRow rowCtThanhtoan;
//DataRow CurrRow = ((DataRowView)this.bdsThanhToan.Current).Row;
//double dbTien_PT = Convert.ToDouble(CurrRow["Tien_PT"]);
//double dbTien_Pt_Nt = Convert.ToDouble(CurrRow["Tien_PT_Nt"]);
if (true)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_Update_CtHanTt";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Stt", "");
command.Parameters.AddWithValue("@Ma_Ct", "PT");
command.Parameters.AddWithValue("@Tk", "1311");
command.Parameters.AddWithValue("@Ma_Dt", "");
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@CtHanTt",
TypeName = "TVP_CtHanTt",
Value = Voucher.GetTVPValue("GLTHANHTOANCT", "TVP_CtHanTt", dtTableSource)
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.ExecuteNonQuery();
MessageBox.Show("Có lỗi xảy ra :" + exception.Message);
}
this.btSave.Enabled = false;
}
}
void GetInfoPXK()
{
if (this.strMa_Ct != "IN")
{
return;
}
if (this.dtStt != null)
{
DataTable dtReturn = new DataTable();
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "IN_GetPXKInfo";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@SttList",
TypeName = "TVP_STTLIST",
Value = this.dtStt
};
command.Parameters.Add(parameter);
try
{
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dtReturn);
lbtStt.Text = dtReturn.Rows[0][0].ToString();
}
catch
{
lbtStt.Text = string.Empty;
}
//Hashtable htPara = new Hashtable();
//htPara.Add("STTLIST", strStt_List);
//htPara.Add("MA_DVCS", Element.sysMa_DvCs);
//lbtStt.Text = SQLExec.ExecuteReturnValue("sp_GetPXKInfo", htPara, CommandType.StoredProcedure).ToString();
}
}
private static void LoadDoanhThuChiPhi()
{
//Library.StrToDate("01/01/" + DateTime.Now.Year);
//DateTime now = DateTime.Now;
//dtDoanhThuChiPhi = SQLExec.ExecuteReturnDt(string.Concat(new object[] { "SET DATEFORMAT DMY EXEC sp_rptDKST01 '01/01/", DateTime.Now.Year, "','", now.Day, "/", now.Month, "/", now.Year, "', 1, 'V', ", Element.sysMa_DvCs }));
//dtDoanhThuChiPhi = new DataTable();
SqlConnection newSQLConnection = SQLExec.GetNewSQLConnection();
SqlCommand selectCommand = new SqlCommand
{
Connection = newSQLConnection
};
Library.StrToDate("01/01/" + DateTime.Now.Year);
DateTime now = DateTime.Now;
selectCommand.CommandText = string.Concat(new object[] { "SET DATEFORMAT DMY EXEC sp_rptDKST01 '01/01/", DateTime.Now.Year, "','", now.Day, "/", now.Month, "/", now.Year, "', 1, 'V', ", Element.sysMa_DvCs });
SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
dtDoanhThuChiPhi = new DataTable();
adapter.Fill(dtDoanhThuChiPhi);
rptDoanhThuChiPhi.fHeight = viewDoanhThuChiPhiHeight;
rptDoanhThuChiPhi.fWidth = viewDoanhThuChiPhiWidth;
rptDoanhThuChiPhi.SetLicense("RGN,RGN Warez Group,DD-APN-30-C01339,W44SSM949SWJ449HSHMF");
rptDoanhThuChiPhi.Load(dtDoanhThuChiPhi);
try
{
rptDoanhThuChiPhi.Run();
}
catch (Exception)
{
rptDoanhThuChiPhi.Run();
}
Is_LoadDoanhThuChiPhi = true;
threadDoanhThuChiPhi.Abort();
}
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 bIsImport = DataTool.SQLCheckExist("sys.procedures", "Name", "OM_Import_PJP");
if (bIsImport)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "OM_Import_PJP";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
command.Parameters.AddWithValue("@UserId", Element.sysUser_Id);
command.Parameters.AddWithValue("@IsDelete", chkIs_Delete.Checked);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TablePJP",
TypeName = "TVP_OMPJP",
Value = dtImport
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
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);
}
}
EpointProcessBox.AddMessage("Kết thúc");
}
void btImport_Click(object sender, EventArgs e)
{
OptionProcess = "KPIRANK";
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "xls files (*.xls;*.xlsx)|*.xls;*.xlsx";
ofd.RestoreDirectory = true;
if (Common.GetBufferValue("ImportExcelPathHRM") != string.Empty)
{
ofd.InitialDirectory = Common.GetBufferValue("ImportExcelPathHRM");
}
else
{
ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
}
if (ofd.ShowDialog() == DialogResult.OK)
{
try
{
Common.SetBufferValue("ImportExcelPathHRM", System.IO.Path.GetDirectoryName(ofd.FileName));
strFileName = ofd.FileName;
}
catch { }
try
{
DataTable dtStruct = new DataTable();
dtStruct = SQLExec.ExecuteReturnDt("DECLARE @TVP_Table AS TVP_HRSALARYRANK SELECT * FROM @TVP_Table");
dtImport = Common.ReadExcel(strFileName);
foreach (DataRow dr in dtImport.Rows)
{
DataRow drStruct = dtStruct.NewRow();
Common.CopyDataRow(dr, drStruct);
dtStruct.Rows.Add(drStruct);
}
if (dtStruct != null)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_IF_HRSALARYRANK";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@TableName", "HRSalaryRank");
command.Parameters.AddWithValue("@UserId", Element.sysUser_Id);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@TVP_Table",
TypeName = "TVP_HRSALARYRANK",
Value = dtStruct
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
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);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Không mở được bảng dữ liệu " + strFileName + "Error :" + ex.Message);
}
}
}
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");
}
void btImport_Click(object sender, EventArgs e)
{
OptionProcess = "IMPORT";
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "xls files (*.xls;*.xlsx)|*.xls;*.xlsx";
ofd.RestoreDirectory = true;
if (Common.GetBufferValue("ImportExcelPathHRM") != string.Empty)
{
ofd.InitialDirectory = Common.GetBufferValue("ImportExcelPathHRM");
}
else
{
ofd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
}
if (ofd.ShowDialog() == DialogResult.OK)
{
try
{
Common.SetBufferValue("ImportExcelPathHRM", System.IO.Path.GetDirectoryName(ofd.FileName));
strFileName = ofd.FileName;
}
catch { }
try
{
DataSet dsImport = Common.ReadExcelToDataSet(strFileName);
DataTable dtResult = SQLExec.ExecuteReturnDt("DECLARE @KPICAMPAIGN AS TVP_KPICAMPAIGN SELECT * FROM @KPICAMPAIGN");
DataTable dtRatio = SQLExec.ExecuteReturnDt("DECLARE @KPICAMPAIGN AS TVP_KPICAMPAIGN SELECT * FROM @KPICAMPAIGN");
foreach (DataTable table in dsImport.Tables)
{
if (table.Columns.Contains("Ma_Cbnv") && table.Columns.Contains("Segment")) // Import ket qua KPI
{
foreach (DataColumn cl in table.Columns)
{
string sColumnName = cl.ColumnName;
if (this.CheckItemId(sColumnName))// Nếu là chỉ tiêu KPI
{
foreach (DataRow row in table.Rows)
{
DataRow drResult = dtResult.NewRow();
drResult["KPIID"] = row["Month"];
drResult["ObjectID"] = row["Ma_CbNv"];
drResult["Type"] = row["Segment"];
drResult["ItemID"] = sColumnName;
double amt = 0;
double.TryParse(row[sColumnName].ToString().Replace("%", ""), out amt);
drResult["Amt"] = amt;
dtResult.Rows.Add(drResult);
}
}
}
}
else if (table.Columns.Contains("Segment"))// Import Trong So KPI
{
foreach (DataColumn cl in table.Columns)
{
string sColumnName = cl.ColumnName;
if (this.CheckItemId(sColumnName))// Nếu là chỉ tiêu KPI
{
foreach (DataRow row in table.Rows)
{
DataRow drRatio = dtRatio.NewRow();
drRatio["KPIID"] = row["Month"];
drRatio["ObjectID"] = row["Segment"];
drRatio["ItemID"] = sColumnName;
double amt = 0;
double.TryParse(row[sColumnName].ToString().Replace("%", ""), out amt);
drRatio["Amt"] = amt;
dtRatio.Rows.Add(drRatio);
}
}
}
}
}
bool Is_Avail = true;
if (true)
{
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_IF_KPIResult";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserId", Element.sysUser_Id);
command.Parameters.AddWithValue("@Is_OverWrite", Is_Avail);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@KPICAMPAIGN",
TypeName = "TVP_KPICAMPAIGN",
Value = dtResult
};
command.Parameters.Add(parameter);
SqlParameter parameter1 = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@KPIRATIO",
TypeName = "TVP_KPICAMPAIGN",
Value = dtRatio
};
command.Parameters.Add(parameter1);
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);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Không mở được bảng dữ liệu " + strFileName + "Error :" + ex.Message);
}
}
}
private void Save_HanTt0(string Stt_PT)
{
DataRow rowCtThanhtoan;
//DataRow CurrRow = ((DataRowView)this.bdsThanhToan.Current).Row;
//double dbTien_PT = Convert.ToDouble(CurrRow["Tien_PT"]);
//double dbTien_Pt_Nt = Convert.ToDouble(CurrRow["Tien_PT_Nt"]);
if (true)
{
DataTable dtTableSource = SQLExec.ExecuteReturnDt("SELECT *, CAST(0 AS BIT) AS Thanh_Toan FROM GLTHANHTOANCT WHERE 0 = 1");
foreach (DataRow row2 in this.dtCtHanTt.Select(this.bdsHanTt.Filter))
{
if (!(bool)row2["Thanh_Toan"])
{
continue;
}
rowCtThanhtoan = dtTableSource.NewRow();
Common.CopyDataRow(row2, rowCtThanhtoan);
if ((rowCtThanhtoan["Ngay_Ct_TT"] == DBNull.Value) && (((DateTime)rowCtThanhtoan["Ngay_Ct_TT"]) == Element.sysNgay_Min))
{
rowCtThanhtoan["Ngay_Ct_TT"] = Library.StrToDate(this.dteNgay_Ct_TT.Text);
}
rowCtThanhtoan["Stt_PT"] = Stt_PT;
rowCtThanhtoan["Tk"] = row2["Tk"];
rowCtThanhtoan["Ma_Dt"] = row2["Ma_Dt"];
rowCtThanhtoan["Stt_HD"] = row2["Stt_HD"];
rowCtThanhtoan["Tien_Tt"] = row2["Tien_Tt1"];
rowCtThanhtoan["Tien_Tt_Nt"] = row2["Tien_Tt_Nt1"];
rowCtThanhtoan["Tien_CLTG"] = row2["Tien_CLTG"];
rowCtThanhtoan["LastModify_Log"] = row2["LastModify_Log"];
dtTableSource.Rows.Add(rowCtThanhtoan);
}
dtTableSource.AcceptChanges();
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_Update_CtHanTt";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Stt", "");
command.Parameters.AddWithValue("@Ma_Ct", "PTT");
command.Parameters.AddWithValue("@Tk", "1311");
command.Parameters.AddWithValue("@Ma_Dt", "");
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@CtHanTt",
TypeName = "TVP_CtHanTt",
Value = Voucher.GetTVPValue("GLTHANHTOANCT", "TVP_CtHanTt", dtTableSource)
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.ExecuteNonQuery();
MessageBox.Show("Có lỗi xảy ra :" + exception.Message);
}
this.btSave.Enabled = false;
}
}
public bool UpdateCt(DataTable dtEditCt)
{
#region UpdateCt: Cap nhat tung dong trong dtEditCt
SqlConnection sqlCon = SQLExec.GetNewSQLConnection();
SqlCommand sqlCom = sqlCon.CreateCommand();
SqlTransaction sqlTran = sqlCom.Connection.BeginTransaction("Update_Voucher_Tran");
sqlCom.Transaction = sqlTran;
int iSave_Ct_Success = 0;
sqlCom.Parameters.Clear();
//Xoa du lieu cu trong Chung tu
if (this.enuNew_Edit == enuEdit.Edit)
{
sqlCom.CommandType = CommandType.Text;
sqlCom.CommandText = "DELETE FROM OM_PXKDetail WHERE MA_PX = @MA_PX";
sqlCom.Parameters.AddWithValue("@MA_PX", (string)drEdit["MA_PX"]);
try
{
sqlCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Có lỗi xảy ra :" + ex.Message);
sqlCom.Transaction.Rollback();
return(false);
}
}
//Luu du lieu vao Ct
sqlCom.CommandText = "sp_UpdatePXK";
sqlCom.CommandType = CommandType.StoredProcedure;
string strKey = "Object_id = Object_id('sp_UpdatePXK')";
DataTable dtUpdateCt_Para = DataTool.SQLGetDataTable("Sys.Parameters", "Name", strKey, null);
foreach (DataRow dr in dtEditCt.Rows)
{
//Khong luu nhung dong danh dau xoa
if (dr.Table.Columns.Contains("Deleted") && (bool)dr["Deleted"])
{
continue;
}
sqlCom.Parameters.Clear();
DataRow drEditCt = dr;
Common.SetDefaultDataRow(ref drEditCt);
foreach (DataRow drPara in dtUpdateCt_Para.Rows)
{
string strColumnName = ((string)drPara["Name"]).Replace("@", "");
if (!drEditCt.Table.Columns.Contains(strColumnName))
{
continue;
}
sqlCom.Parameters.AddWithValue("@" + strColumnName, drEditCt[strColumnName]);
}
try
{
sqlCom.ExecuteNonQuery();
SQLExec.Execute("Update GLVoucher SET Ma_CBNV_GH = '" + txtMa_CBNV_GH.Text + "' , So_Ct_Lap = '" + txtMa_Px.Text + "'" +
"WHERE Stt = '" + dr["Stt"].ToString() + "'");
SQLExec.Execute("Update ARBan SET Ma_CBNV_GH = '" + txtMa_CBNV_GH.Text + "' " +
"WHERE Stt = '" + dr["Stt"].ToString() + "'");
iSave_Ct_Success += 1;
}
catch (Exception ex)
{
MessageBox.Show("Có lỗi xảy ra :" + ex.Message);
sqlCom.Transaction.Rollback();
return(false);
}
}
#endregion
sqlTran.Commit();
return(true);
}
private void Save_HanTt0()
{
DataRow row3;
DataRow CurrRow = ((DataRowView)this.bdsThanhToan.Current).Row;
double dbTien_PT = Convert.ToDouble(CurrRow["Tien_PT"]);
double dbTien_Pt_Nt = Convert.ToDouble(CurrRow["Tien_PT_Nt"]);
if (dbTien_PT != this.numTTien_Tt.Value)
{
if (!Common.MsgYes_No("Giá trị trên chứng từ thanh toán khác với tổng giá trị thanh toán. Bạn có muốn tiếp tục hay không?"))
{
return;
}
}
else if (!(dbTien_Pt_Nt == this.numTTien_Tt_Nt.Value) && !Common.MsgYes_No("Giá trị Nt trên chứng từ thanh toán khác với tổng giá trị Nt thanh toán. Bạn có muốn tiếp tục hay không?"))
{
return;
}
if (this.frmEditCt != null)
{
string strTk = CurrRow["Tk"].ToString();
string strMa_Dt = CurrRow["Ma_Dt"].ToString();
if (this.frmEditCt.dtHanTt0 != null)
{
foreach (DataRow row2 in this.frmEditCt.dtHanTt0.Select("Tk = '" + strTk + "' AND Ma_Dt = '" + strMa_Dt + "'"))
{
this.frmEditCt.dtHanTt0.Rows.Remove(row2);
}
}
else
{
this.frmEditCt.dtHanTt0 = this.dtHanTt0.Clone();
}
foreach (DataRow row2 in this.dtHanTt0.Select("Tk = '" + strTk + "' AND Ma_Dt = '" + strMa_Dt + "'"))
{
row3 = this.frmEditCt.dtHanTt0.NewRow();
Common.CopyDataRow(row2, row3);
this.frmEditCt.dtHanTt0.Rows.Add(row3);
}
this.frmEditCt.dtHanTt0.AcceptChanges();
this.btSave.Enabled = false;
}
else
{
DataTable dtTableSource = SQLExec.ExecuteReturnDt("SELECT *, CAST(0 AS BIT) AS Thanh_Toan FROM GLTHANHTOANCT WHERE 0 = 1");
foreach (DataRow row2 in this.dtHanTt0.Select(this.bdsHanTt.Filter))
{
row3 = dtTableSource.NewRow();
Common.CopyDataRow(row2, row3);
if ((row3["Ngay_Ct_TT"] == DBNull.Value) && (((DateTime)row3["Ngay_Ct_TT"]) == Element.sysNgay_Min))
{
row3["Ngay_Ct_TT"] = Library.StrToDate(this.dteNgay_Ct.Text);
}
row3["Stt_PT"] = CurrRow["Stt_PT"];
row3["Tk"] = row2["Tk"];
row3["Ma_Dt"] = row2["Ma_Dt"];
row3["Stt_HD"] = row2["Stt_HD"];
row3["Tien_Tt"] = row2["Tien_Tt1"];
row3["Tien_Tt_Nt"] = row2["Tien_Tt_Nt1"];
row3["Tien_CLTG"] = row2["Tien_CLTG"];
row3["LastModify_Log"] = row2["LastModify_Log"];
dtTableSource.Rows.Add(row3);
}
dtTableSource.AcceptChanges();
SqlCommand command = SQLExec.GetNewSQLConnection().CreateCommand();
command.CommandText = "Sp_Update_CtHanTt";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Stt", "");
command.Parameters.AddWithValue("@Ma_Ct", CurrRow["Ma_Ct_PT"]);
command.Parameters.AddWithValue("@Tk", CurrRow["Tk"]);
command.Parameters.AddWithValue("@Ma_Dt", CurrRow["Ma_Dt"]);
command.Parameters.AddWithValue("@Ma_DvCs", Element.sysMa_DvCs);
SqlParameter parameter = new SqlParameter
{
SqlDbType = SqlDbType.Structured,
ParameterName = "@CtHanTt",
TypeName = "TVP_CtHanTt",
Value = Voucher.GetTVPValue("GLTHANHTOANCT", "TVP_CtHanTt", dtTableSource)
};
command.Parameters.Add(parameter);
try
{
command.ExecuteNonQuery();
}
catch (Exception exception)
{
command.CommandText = "WHILE @@TRANCOUNT > 0 ROLLBACK TRANSACTION";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.ExecuteNonQuery();
MessageBox.Show("Có lỗi xảy ra :" + exception.Message);
}
this.btSave.Enabled = false;
}
}
