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