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