public static List <GIAODICH_DTO> TIMKIEM_GIAODICHQUAY(string KeySearch, DateTime TuNgay, DateTime DenNgay, int DieuKienLoc) { List <GIAODICH_DTO> listReturn = new List <GIAODICH_DTO>(); try { using (var connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.OpenAsync(); OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "TIMKIEM_GIAODICHQUAY"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = KeySearch; cmd.Parameters.Add("P_TUNGAY", OracleDbType.Date).Value = TuNgay; cmd.Parameters.Add("P_DENNGAY", OracleDbType.Date).Value = DenNgay; cmd.Parameters.Add("P_DIEUKIENLOC", OracleDbType.Int32).Value = DieuKienLoc; cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = Session.Session.CurrentUnitCode; cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dataReader = null; dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { GIAODICH_DTO GDQUAY_DTO = new GIAODICH_DTO(); decimal TIENKHACH_TRA, TIENTHE, TIEN_TRALAI_KHACH, THANHTIEN = 0; GDQUAY_DTO.MA_GIAODICH = dataReader["MA_GIAODICH"].ToString(); GDQUAY_DTO.LOAI_GIAODICH = dataReader["LOAI_GIAODICH"].ToString(); GDQUAY_DTO.I_CREATE_DATE = DateTime.Parse(dataReader["I_CREATE_DATE"].ToString()); GDQUAY_DTO.I_CREATE_BY = dataReader["I_CREATE_BY"].ToString(); GDQUAY_DTO.NGAY_GIAODICH = DateTime.Parse(dataReader["NGAY_GIAODICH"].ToString()); GDQUAY_DTO.MA_VOUCHER = dataReader["MA_VOUCHER"].ToString(); decimal.TryParse(dataReader["TIENKHACH_TRA"].ToString(), out TIENKHACH_TRA); GDQUAY_DTO.TIENKHACH_TRA = TIENKHACH_TRA; decimal.TryParse(dataReader["TIENTHE"].ToString(), out TIENTHE); GDQUAY_DTO.TIENTHE = TIENTHE; decimal.TryParse(dataReader["TIEN_TRALAI_KHACH"].ToString(), out TIEN_TRALAI_KHACH); GDQUAY_DTO.TIEN_TRALAI_KHACH = TIEN_TRALAI_KHACH; decimal.TryParse(dataReader["TIENTHE"].ToString(), out TIENTHE); GDQUAY_DTO.TIENTHE = TIENTHE; decimal.TryParse(dataReader["THANHTIEN"].ToString(), out THANHTIEN); GDQUAY_DTO.THANHTIEN = THANHTIEN; GDQUAY_DTO.THOIGIAN_TAO = dataReader["THOIGIAN_TAO"].ToString(); GDQUAY_DTO.MAKHACHHANG = dataReader["MAKHACHHANG"].ToString(); GDQUAY_DTO.UNITCODE = dataReader["UNITCODE"].ToString(); listReturn.Add(GDQUAY_DTO); } } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotification("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(listReturn); }
public FrmThanhToanTraLai(GIAODICH_DTO GIAODICH_DTO, GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_BILL) { _NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL = GIAODICH_DTO; _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL = _NVGDQUAY_ASYNCCLIENT_BILL; InitializeComponent(); int _currentUcFrame = FrmMain._currentUcFrame; this.Text = "THANH TOÁN HÓA ĐƠN TRẢ LẠI " + (_currentUcFrame + 1); txtThanhToan_MaGiaoDich.Text = _NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.MA_GIAODICH; txtThanhToan_TienThanhToan.Text = FormatCurrency.FormatMoney(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN); txtThanhToan_TienMat.Text = FormatCurrency.FormatMoney(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN); txtThanhToan_TienMat.Focus(); this.ActiveControl = txtThanhToan_TienMat; txtThanhToan_TienMat.SelectAll(); decimal.TryParse(txtThanhToan_TienMat.Text.Trim(), out TONGTIEN_KHACHTRA); }
/// <summary> /// fill data to bill /// </summary> /// <param name="objBillDto"></param> /// <param name="data"></param> /// GIAO DỊCH BÁN LẺ public void PrintInvoice_BanLe(BILL_DTO objBillDto, GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL) { done = true; try { ReportBill report = new ReportBill(); foreach (Parameter p in report.Parameters) { p.Visible = false; } report.InitDataBillBanLe(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL, objBillDto); dcmvContent.DocumentSource = report; report.CreateDocument(); report.Print(); } catch { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG TÌM THẤY MÁY IN", 1, "0x1", "0x8", "normal"); } }
private void FrmThanhToan_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { this.Close(); _NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL = new GIAODICH_DTO(); _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL = new GIAODICH_DTO(); } if (e.KeyCode == Keys.Enter) { decimal tienThanhToan = 0; decimal.TryParse(txtThanhToan_TienTraLai.Text, out tienThanhToan); if (tienThanhToan >= 0) { THANHTOAN_HOADON_BANLE_TRALAI(); } else { NotificationLauncher.ShowNotificationError("Thông báo", "Sai tiền !", 1, "0x1", "0x8", "normal"); } } }
private void LUU_DULIEU(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO) { try { int countSave = 0; if (Config.CheckConnectToServer()) { countSave = SAVE_DATA_TO_ORACLE(_NVGDQUAY_ASYNCCLIENT_DTO); } else { countSave = SAVE_DATA_TO_SQL(_NVGDQUAY_ASYNCCLIENT_DTO); } if (countSave >= 2) { NotificationLauncher.ShowNotification("Thông báo", "Hoàn thành giao dịch", 1, "0x1", "0x8", "normal"); } } catch (Exception ex) { WriteLogs.LogError(ex); } }
// GIAO DỊCH BÁN LẺ public void InitDataBillBanLeTraLai(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL, BILL_DTO objecBillDto) { p_Phone.Value = objecBillDto.PHONE; p_Address.Value = objecBillDto.ADDRESS; p_MaGiaoDich.Value = objecBillDto.MA_GIAODICH; p_InfoThuNgan.Value = objecBillDto.INFOTHUNGAN; p_MaKH.Value = objecBillDto.MAKH; p_Diem.Value = objecBillDto.DIEM; p_ThanhTienChu.Value = objecBillDto.THANHTIENCHU; p_ConLai.Value = objecBillDto.CONLAI; p_TienKhachTra.Value = objecBillDto.TIENKHACHTRA; p_TenCuaHang.Value = objecBillDto.TENCUAHANG; if (_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.LST_DETAILS.Count > 0) { List <VATTU_DTO.OBJ_VAT> obj_Vat = new List <VATTU_DTO.OBJ_VAT>(); foreach (var rowData in _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.LST_DETAILS) { var existVat = obj_Vat.FirstOrDefault(x => x.MATHUE_RA == rowData.MATHUE_RA); if (existVat != null) { existVat.CHUACO_GTGT += rowData.THANHTIEN / (1 + (rowData.GIATRI_THUE_RA / 100)); existVat.CO_GTGT += (rowData.THANHTIEN / (1 + (rowData.GIATRI_THUE_RA / 100))) * (rowData.GIATRI_THUE_RA / 100); } else { VATTU_DTO.OBJ_VAT vat = new VATTU_DTO.OBJ_VAT(); vat.MATHUE_RA = rowData.MATHUE_RA; vat.GIATRI_THUE_RA = rowData.GIATRI_THUE_RA; vat.CHUACO_GTGT = rowData.THANHTIEN / (1 + (rowData.GIATRI_THUE_RA / 100)); vat.CO_GTGT = vat.CHUACO_GTGT * (vat.GIATRI_THUE_RA / 100); obj_Vat.Add(vat); } decimal tempKM = 0; try { tempKM = rowData.TIEN_KHUYENMAI + rowData.TIEN_CHIETKHAU; } catch (Exception) { } if (tempKM != 0) { rowData.THANHTIENFULL = string.Format(@"KM " + FormatCurrency.FormatMoney(tempKM) + " " + FormatCurrency.FormatMoney(rowData.THANHTIEN)); } else { rowData.THANHTIENFULL = FormatCurrency.FormatMoney(rowData.THANHTIEN); } int vattat = 0; int.TryParse(rowData.MATHUE_RA, out vattat); rowData.MAVATTAT = vattat.ToString(); } if (obj_Vat.Count > 0) { decimal TONGCHUAVAT = 0, TONGCOVAT = 0; foreach (VATTU_DTO.OBJ_VAT item in obj_Vat) { int vattat = 0; int.TryParse(item.MATHUE_RA, out vattat); XRTableRow row = new XRTableRow(); row.Cells.Add(new XRTableCell() { Text = vattat.ToString() + " > " + item.GIATRI_THUE_RA.ToString("#0'%'"), TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); row.Cells.Add(new XRTableCell() { Text = item.CHUACO_GTGT.ToString("##,###"), TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); row.Cells.Add(new XRTableCell() { Text = item.CO_GTGT.ToString("##,###"), TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); xtVAT.Rows.Add(row); TONGCHUAVAT += item.CHUACO_GTGT; TONGCOVAT += item.CO_GTGT; } XRTableRow rowData = new XRTableRow(); rowData.Cells.Add(new XRTableCell() { Text = "Tổng : ", TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); rowData.Cells.Add(new XRTableCell() { Text = TONGCHUAVAT.ToString("##,###"), TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); rowData.Cells.Add(new XRTableCell() { Text = TONGCOVAT.ToString("##,###"), TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter, Font = new Font(Font.FontFamily, 6, FontStyle.Regular) }); xtTong.Rows.Add(rowData); } } objectDataSource1.DataSource = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.LST_DETAILS; }
/// <summary> /// Lưu dữ liệu bán lẻ /// </summary> /// <param name="header"></param> /// <param name="details"></param> /// <returns></returns> private int SAVE_DATA_TO_ORACLE(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO) { int countCheckInsertSuccess = 0; if (_NVGDQUAY_ASYNCCLIENT_DTO != null) { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { try { string queryInsert = ""; OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; queryInsert = string.Format(@"INSERT INTO GIAODICH (ID,MA_GIAODICH,LOAI_GIAODICH,NGAY_GIAODICH,MAKHACHHANG,THOIGIAN_TAO,TIENKHACH_TRA,TIEN_TRALAI_KHACH, MAKHO_XUAT,MA_VOUCHER,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES ( :ID,:MA_GIAODICH,:LOAI_GIAODICH,:NGAY_GIAODICH,:MAKHACHHANG,:THOIGIAN_TAO, :TIENKHACH_TRA,:TIEN_TRALAI_KHACH,:MAKHO_XUAT,:MA_VOUCHER,:I_CREATE_DATE,:I_CREATE_BY,:I_STATE,:UNITCODE)"); cmd.CommandText = queryInsert; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.ID; cmd.Parameters.Add("MA_GIAODICH", OracleDbType.Varchar2, 70).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MA_GIAODICH; cmd.Parameters.Add("LOAI_GIAODICH", OracleDbType.Varchar2, 10).Value = _NVGDQUAY_ASYNCCLIENT_DTO.LOAI_GIAODICH; cmd.Parameters.Add("NGAY_GIAODICH", OracleDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.NGAY_GIAODICH; cmd.Parameters.Add("MAKHACHHANG", OracleDbType.Varchar2, 50).Value = !string.IsNullOrEmpty(_NVGDQUAY_ASYNCCLIENT_DTO.MAKHACHHANG) ? _NVGDQUAY_ASYNCCLIENT_DTO.MAKHACHHANG : "KHACHLE"; cmd.Parameters.Add("THOIGIAN_TAO", OracleDbType.Varchar2, 12).Value = _NVGDQUAY_ASYNCCLIENT_DTO.THOIGIAN_TAO; cmd.Parameters.Add("TIENKHACH_TRA", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENKHACH_TRA != 0 ? _NVGDQUAY_ASYNCCLIENT_DTO.TIENKHACH_TRA : _NVGDQUAY_ASYNCCLIENT_DTO.THANHTIEN; cmd.Parameters.Add("TIEN_TRALAI_KHACH", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIEN_TRALAI_KHACH; cmd.Parameters.Add("MAKHO_XUAT", OracleDbType.NVarchar2, 50).Value = !string.IsNullOrEmpty(_NVGDQUAY_ASYNCCLIENT_DTO.MAKHO_XUAT) ? _NVGDQUAY_ASYNCCLIENT_DTO.MAKHO_XUAT : Session.Session.CurrentWareHouse; cmd.Parameters.Add("MA_VOUCHER", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MA_VOUCHER; cmd.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_CREATE_DATE; cmd.Parameters.Add("I_CREATE_BY", OracleDbType.NVarchar2, 300).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_CREATE_BY; cmd.Parameters.Add("I_STATE", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_STATE; cmd.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.UNITCODE; if (cmd.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; INSERT_DATA_HANG_GIAODICHQUAY(_NVGDQUAY_ASYNCCLIENT_DTO, ref countCheckInsertSuccess); } //chạy store tăng xuất nhập tồn if (!string.IsNullOrEmpty(Session.Session.CurrentTableNamePeriod)) { OracleCommand cmdTruTon = new OracleCommand(); cmdTruTon.Connection = connection; cmdTruTon.CommandText = @"ERBUS.XUATNHAPTON.XNT_TANG_PHIEU"; cmdTruTon.CommandType = CommandType.StoredProcedure; cmdTruTon.Parameters.Add("P_TABLENAME", OracleDbType.Varchar2, 50).Value = Session.Session.CurrentTableNamePeriod; cmdTruTon.Parameters.Add("P_NAM", OracleDbType.Varchar2, 50).Value = Session.Session.CurrentYear; cmdTruTon.Parameters.Add("P_KY", OracleDbType.Decimal).Value = decimal.Parse(Session.Session.CurrentPeriod); cmdTruTon.Parameters.Add("P_ID", OracleDbType.Varchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.ID; cmdTruTon.ExecuteNonQuery(); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { SAVE_DATA_TO_SQL_HAVE_INTERNET(_NVGDQUAY_ASYNCCLIENT_DTO); connection.Close(); } } } catch (Exception ex) { WriteLogs.LogError(ex); } } } return(countCheckInsertSuccess); }
private void INSERT_DATA_HANG_GIAODICHQUAY_SQL(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess) { if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { int i = 1; foreach (GIAODICH_CHITIET ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS) { SqlCommand command = new SqlCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO GIAODICH_CHITIET (ID,MA_GIAODICH,MAHANG,MATHUE_RA,SOLUONG,GIABANLE_VAT,MA_KHUYENMAI,TYLE_KHUYENMAI, TIEN_KHUYENMAI,TYLE_CHIETKHAU,TIEN_CHIETKHAU,TIENTHE_VIP,TIEN_VOUCHER,THANHTIEN,SAPXEP) VALUES (@ID,@MA_GIAODICH,@MAHANG,@MATHUE_RA,@SOLUONG,@GIABANLE_VAT, @MA_KHUYENMAI,@TYLE_KHUYENMAI,@TIEN_KHUYENMAI,@TYLE_CHIETKHAU,@TIEN_CHIETKHAU,@TIENTHE_VIP,@TIEN_VOUCHER,@THANHTIEN,@SAPXEP)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = ITEM.ID; command.Parameters.Add("MA_GIAODICH", SqlDbType.VarChar, 70).Value = ITEM.MA_GIAODICH; command.Parameters.Add("MAHANG", SqlDbType.VarChar, 50).Value = ITEM.MAHANG; command.Parameters.Add("MATHUE_RA", SqlDbType.VarChar, 50).Value = ITEM.MATHUE_RA; command.Parameters.Add("SOLUONG", SqlDbType.Decimal).Value = ITEM.SOLUONG; command.Parameters.Add("GIABANLE_VAT", SqlDbType.Decimal).Value = ITEM.GIABANLE_VAT; command.Parameters.Add("MA_KHUYENMAI", SqlDbType.NVarChar, 50).Value = ITEM.MA_KHUYENMAI; command.Parameters.Add("TYLE_KHUYENMAI", SqlDbType.Decimal).Value = ITEM.TYLE_KHUYENMAI; command.Parameters.Add("TIEN_KHUYENMAI", SqlDbType.Decimal).Value = ITEM.TIEN_KHUYENMAI; command.Parameters.Add("TYLE_CHIETKHAU", SqlDbType.Decimal).Value = ITEM.TYLE_CHIETKHAU; command.Parameters.Add("TIEN_CHIETKHAU", SqlDbType.Decimal).Value = ITEM.TIEN_CHIETKHAU; command.Parameters.Add("TIENTHE_VIP", SqlDbType.Decimal).Value = ITEM.TIENTHE_VIP; command.Parameters.Add("TIEN_VOUCHER", SqlDbType.Decimal).Value = ITEM.TIEN_VOUCHER; command.Parameters.Add("THANHTIEN", SqlDbType.Decimal).Value = ITEM.THANHTIEN; command.Parameters.Add("SAPXEP", SqlDbType.Int).Value = i; try { if (command.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; i++; } } catch (Exception e) { WriteLogs.LogError(e); } } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal"); } } } }
private void btnThanhToan_Exit_Click(object sender, EventArgs e) { _NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL = new GIAODICH_DTO(); _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL = new GIAODICH_DTO(); this.Close(); }
private void INSERT_DATA_HANG_GIAODICHQUAY(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess) { if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0) { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { int i = 1; foreach (GIAODICH_CHITIET ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS) { OracleCommand command = new OracleCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO GIAODICH_CHITIET (ID,MA_GIAODICH,MAHANG,MATHUE_RA,SOLUONG,GIABANLE_VAT,MA_KHUYENMAI,TYLE_KHUYENMAI, TIEN_KHUYENMAI,TYLE_CHIETKHAU,TIEN_CHIETKHAU,TIENTHE_VIP,TIEN_VOUCHER,THANHTIEN,SAPXEP) VALUES (:ID,:MA_GIAODICH,:MAHANG,:MATHUE_RA,:SOLUONG,:GIABANLE_VAT, :MA_KHUYENMAI,:TYLE_KHUYENMAI,:TIEN_KHUYENMAI,:TYLE_CHIETKHAU,:TIEN_CHIETKHAU,:TIENTHE_VIP,:TIEN_VOUCHER,:THANHTIEN,:SAPXEP)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ITEM.ID; command.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70).Value = ITEM.MA_GIAODICH; command.Parameters.Add("MAHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAHANG; command.Parameters.Add("MATHUE_RA", OracleDbType.NVarchar2, 50).Value = ITEM.MATHUE_RA; command.Parameters.Add("SOLUONG", OracleDbType.Decimal).Value = ITEM.SOLUONG; command.Parameters.Add("GIABANLE_VAT", OracleDbType.Decimal).Value = ITEM.GIABANLE_VAT; command.Parameters.Add("MA_KHUYENMAI", OracleDbType.NVarchar2, 50).Value = ITEM.MA_KHUYENMAI; command.Parameters.Add("TYLE_KHUYENMAI", OracleDbType.Decimal).Value = ITEM.TYLE_KHUYENMAI; command.Parameters.Add("TIEN_KHUYENMAI", OracleDbType.Decimal).Value = ITEM.TIEN_KHUYENMAI; command.Parameters.Add("TYLE_CHIETKHAU", OracleDbType.Decimal).Value = ITEM.TYLE_CHIETKHAU; command.Parameters.Add("TIEN_CHIETKHAU", OracleDbType.Decimal).Value = ITEM.TIEN_CHIETKHAU; command.Parameters.Add("TIENTHE_VIP", OracleDbType.Decimal).Value = ITEM.TIENTHE_VIP; command.Parameters.Add("TIEN_VOUCHER", OracleDbType.Decimal).Value = ITEM.TIEN_VOUCHER; command.Parameters.Add("THANHTIEN", OracleDbType.Decimal).Value = ITEM.THANHTIEN; command.Parameters.Add("SAPXEP", OracleDbType.Int32).Value = i; try { if (command.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; i++; } } catch (Exception e) { WriteLogs.LogError(e); } } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal"); } } } }
private int SAVE_DATA_TO_SQL(GIAODICH_DTO _NVGDQUAY_ASYNCCLIENT_DTO) { int countCheckInsertSuccess = 0; if (_NVGDQUAY_ASYNCCLIENT_DTO != null) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { try { string queryInsert = ""; SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; queryInsert = string.Format(@"INSERT INTO GIAODICH (ID,MA_GIAODICH,LOAI_GIAODICH,NGAY_GIAODICH,MAKHACHHANG,THOIGIAN_TAO,TIENKHACH_TRA,TIEN_TRALAI_KHACH, MAKHO_XUAT,MA_VOUCHER,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES ( @ID,@MA_GIAODICH,@LOAI_GIAODICH,@NGAY_GIAODICH,@MAKHACHHANG,@THOIGIAN_TAO, @TIENKHACH_TRA,@TIEN_TRALAI_KHACH,@MAKHO_XUAT,@MA_VOUCHER,@I_CREATE_DATE,@I_CREATE_BY,@I_STATE,@UNITCODE)"); cmd.CommandText = queryInsert; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.ID; cmd.Parameters.Add("MA_GIAODICH", SqlDbType.NVarChar, 70).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MA_GIAODICH; cmd.Parameters.Add("LOAI_GIAODICH", SqlDbType.VarChar, 10).Value = _NVGDQUAY_ASYNCCLIENT_DTO.LOAI_GIAODICH; cmd.Parameters.Add("NGAY_GIAODICH", SqlDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.NGAY_GIAODICH; cmd.Parameters.Add("MAKHACHHANG", SqlDbType.VarChar, 50).Value = !string.IsNullOrEmpty(_NVGDQUAY_ASYNCCLIENT_DTO.MAKHACHHANG) ? _NVGDQUAY_ASYNCCLIENT_DTO.MAKHACHHANG : "KHACHLE"; cmd.Parameters.Add("THOIGIAN_TAO", SqlDbType.VarChar, 12).Value = _NVGDQUAY_ASYNCCLIENT_DTO.THOIGIAN_TAO; cmd.Parameters.Add("TIENKHACH_TRA", SqlDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENKHACH_TRA != 0 ? _NVGDQUAY_ASYNCCLIENT_DTO.TIENKHACH_TRA : _NVGDQUAY_ASYNCCLIENT_DTO.THANHTIEN; cmd.Parameters.Add("TIEN_TRALAI_KHACH", SqlDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIEN_TRALAI_KHACH; cmd.Parameters.Add("MAKHO_XUAT", SqlDbType.VarChar, 50).Value = !string.IsNullOrEmpty(_NVGDQUAY_ASYNCCLIENT_DTO.MAKHO_XUAT) ? _NVGDQUAY_ASYNCCLIENT_DTO.MAKHO_XUAT : Session.Session.CurrentWareHouse; cmd.Parameters.Add("MA_VOUCHER", SqlDbType.VarChar, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MA_VOUCHER; cmd.Parameters.Add("I_CREATE_DATE", SqlDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_CREATE_DATE; cmd.Parameters.Add("I_CREATE_BY", SqlDbType.VarChar, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_CREATE_BY; cmd.Parameters.Add("I_STATE", SqlDbType.VarChar, 1).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_STATE; cmd.Parameters.Add("UNITCODE", SqlDbType.VarChar, 10).Value = _NVGDQUAY_ASYNCCLIENT_DTO.UNITCODE; if (cmd.ExecuteNonQuery() > 0) { countCheckInsertSuccess++; INSERT_DATA_HANG_GIAODICHQUAY_SQL(_NVGDQUAY_ASYNCCLIENT_DTO, ref countCheckInsertSuccess); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); } } } catch (Exception ex) { WriteLogs.LogError(ex); } } } return(countCheckInsertSuccess); }