private void THANHTOAN_HOADON_BANLE_TRALAI()
{
bool success = false;
string TONGTIEN_BANGCHU = ConvertSoThanhChu.ChuyenDoiSoThanhChu(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.THANHTIEN);
try
{
LUU_DULIEU(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL);
}
catch
{
MessageBox.Show("CẢNH BÁO ! XẢY RA LỖI KHI LƯU HÓA ĐƠN NÀY, HÃY LƯU LẠI HÓA ĐƠN ĐỂ KIỂM TRA ! XIN CẢM ƠN ");
}
try
{
string MA_TEN_KHACHHANG = "";
if (Config.CheckConnectToServer())
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_ORACLE(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
else
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
using (frmPrintBill_TraLai frmBanTraLai = new frmPrintBill_TraLai())
{
try
{
BILL_DTO infoBill = new BILL_DTO()
{
ADDRESS = Session.Session.CurrentAddress,
CONLAI = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIEN_TRALAI_KHACH,
PHONE = Session.Session.CurrentPhone,
MAKH = MA_TEN_KHACHHANG,
DIEM = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.SODIEM,
INFOTHUNGAN = "THU NGÂN: " + Session.Session.CurrentTenNhanVien,
MA_GIAODICH = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MA_GIAODICH,
THANHTIENCHU = TONGTIEN_BANGCHU,
TIENKHACHTRA = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIENKHACH_TRA,
TENCUAHANG = Session.Session.CurrentNameStore
};
frmBanTraLai.PrintInvoice_BanLeTraLai(infoBill, _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL);
}
catch
{
}
finally
{
this.handler(true);
this.Dispose();
frmBanTraLai.Dispose();
frmBanTraLai.Refresh();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
public async Task <IHttpActionResult> Delete(string id)
{
NvVatTuChungTu instance = await _service.Repository.FindAsync(id);
List <NvVatTuChungTuChiTiet> chitietinstance = _service.UnitOfWork.Repository <NvVatTuChungTuChiTiet>().DbSet.Where(o => o.MaChungTuPk == instance.MaChungTuPk).ToList();
if (instance == null)
{
return(NotFound());
}
try
{
if (_service.DeletePhieu(id))
{
_service.Delete(instance.Id);
_service.UnitOfWork.Save();
return(Ok(instance));
}
return(InternalServerError());
}
catch (Exception e)
{
WriteLogs.LogError(e);
return(InternalServerError());
}
}
private void LUU_DULIEU(NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_DTO)
{
try
{
int countSave = 0;
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
if (result)
{
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);
}
}
public async Task <IHttpActionResult> Put(string id, NvCongNoVm.Dto instance)
{
TransferObj <NvCongNo> result = new TransferObj <NvCongNo>();
NvCongNo check = _service.FindById(instance.Id);
if (id != instance.Id || check.TrangThai == (int)ApprovalState.IsComplete)
{
result.Status = false;
result.Message = "Dữ liệu không đúng!";
return(Ok(result));
}
try
{
NvCongNo item = _service.UpdatePhieu(instance);
await _service.UnitOfWork.SaveAsync();
result.Status = true;
result.Message = "Update thành công!";
result.Data = item;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Status = false;
result.Message = e.Message.ToString();
}
return(Ok(result));
}
public async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
TransferObj <PagedObj <NvCongNoVm.Dto> > result = new TransferObj <PagedObj <NvCongNoVm.Dto> >();
dynamic postData = ((dynamic)jsonData);
FilterObj <NvCongNoVm.Search> filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvCongNoVm.Search> >();
PagedObj <NvCongNo> paged = ((JObject)postData.paged).ToObject <PagedObj <NvCongNo> >();
string unitCode = _service.GetCurrentUnitCode();
QueryBuilder query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().LoaiChungTu),
Method = FilterMethod.EqualTo,
Value = filtered.AdvanceData.LoaiChungTu
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvCongNo().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
}
},
Method = FilterMethod.And
},
Orders = new List <IQueryOrder>()
{
new QueryOrder()
{
Field = ClassHelper.GetPropertyName(() => new NvCongNo().ICreateDate),
Method = OrderMethod.DESC
}
}
};
try
{
ResultObj <PagedObj <NvCongNo> > filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvCongNo>, PagedObj <NvCongNoVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Status = false;
result.Message = e.Message.ToString();
return(Ok(result));
}
}
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 async Task <IHttpActionResult> PostQuery(JObject jsonData)
{
var result = new TransferObj <PagedObj <NvPhieuDatHangNCCVm.Dto> >();
var postData = ((dynamic)jsonData);
var filtered = ((JObject)postData.filtered).ToObject <FilterObj <NvPhieuDatHangNCCVm.Search> >();
filtered.OrderType = "DESC";
filtered.OrderBy = "Ngay";
var paged = ((JObject)postData.paged).ToObject <PagedObj <NvDatHang> >();
var unitCode = _service.GetCurrentUnitCode();
var query = new QueryBuilder
{
Take = paged.ItemsPerPage,
Skip = paged.FromItem - 1,
Filter = new QueryFilterLinQ()
{
SubFilters = new List <IQueryFilter>()
{
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().Loai),
Method = FilterMethod.EqualTo,
Value = (int)LoaiDatHang.NHACUNGCAP
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvVatTuChungTu().UnitCode),
Method = FilterMethod.EqualTo,
Value = unitCode
},
new QueryFilterLinQ()
{
Property = ClassHelper.GetProperty(() => new NvDatHang().SoPhieuCon),
Method = FilterMethod.Null,
}
},
Method = FilterMethod.And
},
};
try
{
var filterResult = _service.Filter(filtered, query);
if (!filterResult.WasSuccessful)
{
return(NotFound());
}
result.Data = Mapper.Map <PagedObj <NvDatHang>, PagedObj <NvPhieuDatHangNCCVm.Dto> >(filterResult.Value);
result.Status = true;
return(Ok(result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
return(InternalServerError());
}
}
protected void Application_Error(Object sender, EventArgs e)
{
Exception ex = Server.GetLastError();
if (ex is ThreadAbortException)
{
return;
}
WriteLogs.LogError(ex);
}
public static string LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(string MAKHACHHANG)
{
string RESULT = "";
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT CONCAT (DM_KHACHHANG.MAKH,' - ',DM_KHACHHANG.TENKH) AS KHACHHANG FROM dbo.DM_KHACHHANG WHERE DM_KHACHHANG.MAKH = '" + MAKHACHHANG + "'";
cmd.CommandType = CommandType.Text;
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["KHACHHANG"] != null)
{
RESULT = dataReader["KHACHHANG"].ToString();
}
else
{
RESULT = "";
}
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
public static string LAY_MA_TEN_KHACHHANG_FROM_ORACLE(string MAKHACHHANG)
{
string RESULT = "";
try
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT MAKHACHHANG || ' - ' || TENKHACHHANG AS KHACHHANG FROM KHACHHANG WHERE MAKHACHHANG = '" + MAKHACHHANG + "'";
cmd.CommandType = CommandType.Text;
OracleDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
if (dataReader["KHACHHANG"] != null)
{
RESULT = dataReader["KHACHHANG"].ToString();
}
else
{
RESULT = "";
}
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
public async Task <IHttpActionResult> GetCountExportTransactionNotApproved()
{
var result = new TransferObj <decimal>();
try
{
var data = _service.GetCountExportTransactionNotApproved();
result.Data = data;
result.Status = true;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
public async Task <IHttpActionResult> PostKiemTraTonHang(DashboardVm.Parameter code)
{
var result = new TransferObj <List <DashboardVm.InventoryMerchandise> >();
try
{
var data = _service.GetTonMatHang(code.MaVatTu);
result.Data = data;
result.Status = true;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetRetailRevenue()
{
var result = new TransferObj <List <RetailRevenue> >();
try
{
var data = _service.GetRevenue();
result.Data = data;
result.Status = true;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetBestOfFiveMerchandiseSelled()
{
var result = new TransferObj <List <DashboardVm.BestMerchandise> >();
try
{
var data = _service.GetBestOfFiveMerchandiseSelled();
result.Data = data;
result.Status = true;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetAmmountSupplierLend(string code)
{
if (string.IsNullOrEmpty(code))
{
return(BadRequest());
}
var result = new TransferObj <NvCongNoVm.Dto>();
try
{
var data = _service.GetAmmountSupplierLend(code);
result.Data = data;
result.Status = true;
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
public IHttpActionResult GetMenu(string username)
{
var result = new TransferObj <List <ChoiceObj> >();
try
{
var _unitCode = _service.GetCurrentUnitCode();
List <AU_MENU> lstMenu = new List <AU_MENU>();
if (username.Equals("admin"))
{
lstMenu = _service.Repository.DbSet.Where(x => x.TrangThai == 10 && x.UnitCode == _unitCode).OrderBy(x => x.Sort).ToList();
}
else
{
lstMenu = _service.GetAllForStarting(username, _unitCode);
}
result.Data = new List <ChoiceObj>();
if (lstMenu != null)
{
lstMenu.ForEach(x =>
{
ChoiceObj obj = new ChoiceObj()
{
Id = x.Id,
Text = x.Title,
Parent = x.MenuIdCha,
Value = x.MenuId,
};
result.Data.Add(obj);
});
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
return(Ok(result));
}
public async Task <IHttpActionResult> Post(NvCongNoVm.Dto instance)
{
TransferObj <NvCongNo> result = new TransferObj <NvCongNo>();
try
{
NvCongNo item = _service.InsertPhieu(instance);
await _service.UnitOfWork.SaveAsync();
result.Data = item;
result.Message = "Thêm mới thành công";
result.Status = true;
return(CreatedAtRoute("DefaultApi", new { controller = this, id = instance.Id }, result));
}
catch (Exception e)
{
WriteLogs.LogError(e);
result.Message = e.Message.ToString();
result.Status = false;
}
return(Ok(result));
}
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);
}
}
public async Task <IHttpActionResult> Delete(string id)
{
NvDatHang instance = await _service.Repository.FindAsync(id);
if (instance == null)
{
return(NotFound());
}
try
{
if (_service.DeletePhieu(id))
{
_service.Delete(instance.Id);
_service.UnitOfWork.Save();
return(Ok(instance));
}
return(InternalServerError());
}
catch (Exception e)
{
WriteLogs.LogError(e);
return(InternalServerError());
}
}
private void INSERT_DATA_HANG_GIAODICHQUAY_SQL(NVGDQUAY_ASYNCCLIENT_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
{
foreach (NVHANGGDQUAY_ASYNCCLIENT ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS)
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO [dbo].[NVHANGGDQUAY_ASYNCCLIENT]([ID],[MAGDQUAYPK],[MAKHOHANG],[MADONVI],[MAVATTU],[MANGUOITAO],[NGUOITAO],[MABOPK],[NGAYTAO],[NGAYPHATSINH],[SOLUONG],[TTIENCOVAT],[GIABANLECOVAT],[TYLECHIETKHAU],[TIENCHIETKHAU],[TYLEKHUYENMAI],[TIENKHUYENMAI],[TYLEVOUCHER],[TIENVOUCHER],[TYLELAILE],[GIAVON],[MAVAT],[VATBAN],[MACHUONGTRINHKM],[UNITCODE])
VALUES (@ID,@MAGDQUAYPK,@MAKHOHANG,@MADONVI,@MAVATTU,@MANGUOITAO,@NGUOITAO,@MABOPK,@NGAYTAO,@NGAYPHATSINH,@SOLUONG,@TTIENCOVAT,@GIABANLECOVAT,@TYLECHIETKHAU,@TIENCHIETKHAU,@TYLEKHUYENMAI,@TIENKHUYENMAI,@TYLEVOUCHER,@TIENVOUCHER,@TYLELAILE,@GIAVON,@MAVAT,@VATBAN,@MACHUONGTRINHKM,@UNITCODE)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = ITEM.ID;
command.Parameters.Add("MAGDQUAYPK", SqlDbType.NVarChar, 50).Value = ITEM.MAGDQUAYPK;
command.Parameters.Add("MAKHOHANG", SqlDbType.NVarChar, 50).Value = ITEM.MAKHOHANG;
command.Parameters.Add("MADONVI", SqlDbType.NVarChar, 50).Value = ITEM.MADONVI;
command.Parameters.Add("MAVATTU", SqlDbType.NVarChar, 50).Value = ITEM.MAVATTU;
command.Parameters.Add("MANGUOITAO", SqlDbType.NVarChar, 50).Value = Session.Session.CurrentMaNhanVien;
command.Parameters.Add("NGUOITAO", SqlDbType.NVarChar, 50).Value = ITEM.NGUOITAO;
command.Parameters.Add("MABOPK", SqlDbType.NVarChar, 50).Value = ITEM.MABOPK;
command.Parameters.Add("NGAYTAO", SqlDbType.Date).Value = ITEM.NGAYTAO;
command.Parameters.Add("NGAYPHATSINH", SqlDbType.Date).Value = ITEM.NGAYPHATSINH;
command.Parameters.Add("SOLUONG", SqlDbType.Decimal).Value = ITEM.SOLUONG;
command.Parameters.Add("TTIENCOVAT", SqlDbType.Decimal).Value = ITEM.TTIENCOVAT;
command.Parameters.Add("GIABANLECOVAT", SqlDbType.Decimal).Value = ITEM.GIABANLECOVAT;
command.Parameters.Add("TIENCHIETKHAU", SqlDbType.Decimal).Value = ITEM.TIENCHIETKHAU;
command.Parameters.Add("TYLECHIETKHAU", SqlDbType.Decimal).Value = ITEM.TYLECHIETKHAU;
command.Parameters.Add("TYLEKHUYENMAI", SqlDbType.Decimal).Value = ITEM.TYLEKHUYENMAI;
command.Parameters.Add("TIENKHUYENMAI", SqlDbType.Decimal).Value = ITEM.TIENKHUYENMAI;
command.Parameters.Add("TYLEVOUCHER", SqlDbType.Decimal).Value = ITEM.TYLEVOUCHER;
command.Parameters.Add("TIENVOUCHER", SqlDbType.Decimal).Value = ITEM.TIENVOUCHER;
command.Parameters.Add("TYLELAILE", SqlDbType.Decimal).Value = ITEM.TYLELAILE;
command.Parameters.Add("GIAVON", SqlDbType.Decimal).Value = ITEM.GIAVON;
command.Parameters.Add("MAVAT", SqlDbType.NVarChar, 50).Value = ITEM.MAVAT;
command.Parameters.Add("VATBAN", SqlDbType.Decimal).Value = ITEM.VATBAN;
command.Parameters.Add("MACHUONGTRINHKM", SqlDbType.NVarChar, 50).Value = ITEM.MACHUONGTRINHKM;
command.Parameters.Add("UNITCODE", SqlDbType.NVarChar, 50).Value = ITEM.UNITCODE != null ? ITEM.UNITCODE : Session.Session.CurrentUnitCode;
try
{
if (command.ExecuteNonQuery() > 0)
{
countCheckInsertSuccess++;
}
}
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ế nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal");
}
}
}
}
public async Task <IHttpActionResult> ReceiveDataKiemKe(string MaKho)
{
string UNITCODE_GLOBAL = "";
NvKiemKeVm.Dto returnList = new NvKiemKeVm.Dto();
if (!string.IsNullOrEmpty(MaKho))
{
UNITCODE_GLOBAL = MaKho.Substring(0, MaKho.LastIndexOf('-'));
NvKiemKeVm.Dto lst = new NvKiemKeVm.Dto();
List <string> vatTu = new List <string>();
string path = HttpContext.Current.Server.MapPath("/Upload/KiemKe/");
HttpRequest request = HttpContext.Current.Request;
if (request.Files.Count > 0)
{
try
{
HttpPostedFile file = request.Files[0];
file.SaveAs(path + file.FileName);
//kiem tra ton tai file
if (File.Exists(path + file.FileName))
{
if (file.FileName.Contains(".txt"))
{
//doc du lieu tu file text
string[] lines = File.ReadAllLines(path + file.FileName);
foreach (string line in lines)
{
string[] data = line.Split(',');
string MaVatTu = data[0].ToString();
string SoTonKiemKe = data[1].ToString();
vatTu.Add(MaVatTu);
}
string[] arrayVatTu = vatTu.ToArray();
string paraVatTu = String.Join(",", arrayVatTu);
lst.DataDetails = ProcedureCollection.GetInventoryForActionInventoryByOne(UNITCODE_GLOBAL, MaKho, paraVatTu);
foreach (var value in lst.DataDetails)
{
foreach (string line in lines)
{
string[] data = line.Split(',');
if (data[0].ToString() == value.MaVatTu)
{
decimal SoLuongKiemKe = 0;
decimal.TryParse(data[1].ToString(), out SoLuongKiemKe);
value.SoLuongKiemKe = SoLuongKiemKe;
returnList.DataDetails.Add(value);
}
}
}
returnList.KhoKiemKe = MaKho;
returnList.NgayKiemKe = DateTime.Now.Date;
returnList.NgayIn = DateTime.Now.Date;
int number = 0;
string maKe = "";
if (lst.DataDetails.Count > 10)
{
for (int i = 0; i < 10; i++)
{
if (lst.DataDetails[i].KeKiemKe == lst.DataDetails[i + 1].KeKiemKe)
{
number++;
maKe = lst.DataDetails[i].KeKiemKe;
}
}
}
if (number > 5)
{
returnList.KeKiemKe = maKe;
}
else
{
returnList.KeKiemKe = lst.DataDetails[0].KeKiemKe;
}
returnList.MaPhieuKiemKe = _serviceKK.BuildCode();
}
}
else
{
return(NotFound());
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
return(InternalServerError());
}
}
//lấy những mã không kiểm kê nhưng nằm trong kệ
string maKeHangHoa = returnList.KeKiemKe;
var hangTrongKe = ProcedureCollection.LayThongTinHangThuocKe(UNITCODE_GLOBAL, returnList.KhoKiemKe, maKeHangHoa);
try
{
if (hangTrongKe != null && hangTrongKe.Count > 0)
{
for (int i = 0; i < hangTrongKe.Count; i++)
{
var data = returnList.DataDetails.Find(x => x.MaVatTu == hangTrongKe[i].MaVatTu);
if (data == null)
{
hangTrongKe[i].SoLuongKiemKe = 0;
returnList.DataDetails.Add(hangTrongKe[i]);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
else
{
return(NotFound());
}
return(Ok(returnList));
}
private void THANHTOAN_HOADON_BANLE_TRALAI()
{
string TONGTIEN_BANGCHU = ConvertSoThanhChu.ChuyenDoiSoThanhChu(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL.TTIENCOVAT);
try
{
LUU_DULIEU(_NVGDQUAY_ASYNCCLIENT_DTO_GLOBAL);
}
catch
{
MessageBox.Show("CẢNH BÁO ! XẢY RA LỖI KHI LƯU HÓA ĐƠN NÀY, HÃY LƯU LẠI HÓA ĐƠN ĐỂ KIỂM TRA ! XIN CẢM ƠN ");
}
try
{
string MA_TEN_KHACHHANG = "";
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
if (result)
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_ORACLE(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
else
{
MA_TEN_KHACHHANG = FrmThanhToanService.LAY_MA_TEN_KHACHHANG_FROM_SQLSERVER(_NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAKHACHHANG);
}
using (frmPrintBill_TraLai frmBanTraLai = new frmPrintBill_TraLai())
{
try
{
BILL_DTO infoBill = new BILL_DTO()
{
ADDRESS = Session.Session.CurrentAddress,
CONLAI = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIENTRALAI,
PHONE = Session.Session.CurrentPhone,
MAKH = MA_TEN_KHACHHANG,
DIEM = 0,
INFOTHUNGAN = "THU NGÂN: " + _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.NGUOITAO + "\t QUẦY: " + _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAQUAYBAN,
MAGIAODICH = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAGIAODICH,
THANHTIENCHU = TONGTIEN_BANGCHU,
TIENKHACHTRA = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.TIENKHACHDUA,
QUAYHANG = _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL.MAQUAYBAN,
};
frmBanTraLai.PrintInvoice_BanLeTraLai(infoBill, _NVGDQUAY_ASYNCCLIENT_BILL_GLOBAL);
}
catch
{
}
finally
{
this.handler(true);
this.Dispose();
frmBanTraLai.Dispose();
frmBanTraLai.Refresh();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
private void INSERT_DATA_HANG_GIAODICHQUAY(NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_DTO, ref int countCheckInsertSuccess)
{
if (_NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS.Count > 0)
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
foreach (NVHANGGDQUAY_ASYNCCLIENT ITEM in _NVGDQUAY_ASYNCCLIENT_DTO.LST_DETAILS)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO NVHANGGDQUAY_ASYNCCLIENT (ID,MAGDQUAYPK,MAKHOHANG,MADONVI,MAVATTU,BARCODE,TENDAYDU,NGUOITAO,MABOPK,NGAYTAO,NGAYPHATSINH,
SOLUONG,TTIENCOVAT,VATBAN,GIABANLECOVAT,MAKHACHHANG,MAKEHANG,MACHUONGTRINHKM,LOAIKHUYENMAI,TIENCHIETKHAU,TYLECHIETKHAU,TYLEKHUYENMAI,TIENKHUYENMAI,TYLEVOUCHER,
TIENVOUCHER,TYLELAILE,GIAVON,ISBANAM,MAVAT) VALUES (:ID,:MAGDQUAYPK,:MAKHOHANG,:MADONVI,:MAVATTU,:BARCODE,:TENDAYDU,:NGUOITAO,:MABOPK,:NGAYTAO,:NGAYPHATSINH,
:SOLUONG,:TTIENCOVAT,:VATBAN,:GIABANLECOVAT,:MAKHACHHANG,:MAKEHANG,:MACHUONGTRINHKM,:LOAIKHUYENMAI,:TIENCHIETKHAU,:TYLECHIETKHAU,:TYLEKHUYENMAI,:TIENKHUYENMAI,:TYLEVOUCHER,
:TIENVOUCHER,:TYLELAILE,:GIAVON,:ISBANAM,:MAVAT)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ITEM.ID;
command.Parameters.Add("MAGDQUAYPK", OracleDbType.NVarchar2, 50).Value = ITEM.MAGDQUAYPK;
command.Parameters.Add("MAKHOHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKHOHANG;
command.Parameters.Add("MADONVI", OracleDbType.NVarchar2, 50).Value = ITEM.MADONVI;
command.Parameters.Add("MAVATTU", OracleDbType.NVarchar2, 50).Value = ITEM.MAVATTU;
command.Parameters.Add("BARCODE", OracleDbType.NVarchar2, 2000).Value = ITEM.BARCODE;
command.Parameters.Add("TENDAYDU", OracleDbType.NVarchar2, 300).Value = ITEM.TENDAYDU;
command.Parameters.Add("NGUOITAO", OracleDbType.NVarchar2, 300).Value = ITEM.NGUOITAO;
command.Parameters.Add("MABOPK", OracleDbType.NVarchar2, 50).Value = ITEM.MABOPK;
command.Parameters.Add("NGAYTAO", OracleDbType.Date).Value = ITEM.NGAYTAO;
command.Parameters.Add("NGAYPHATSINH", OracleDbType.Date).Value = ITEM.NGAYPHATSINH;
command.Parameters.Add("SOLUONG", OracleDbType.Int32).Value = ITEM.SOLUONG;
command.Parameters.Add("TTIENCOVAT", OracleDbType.Decimal).Value = ITEM.TTIENCOVAT;
command.Parameters.Add("VATBAN", OracleDbType.Decimal).Value = ITEM.VATBAN;
command.Parameters.Add("GIABANLECOVAT", OracleDbType.Decimal).Value = ITEM.GIABANLECOVAT;
command.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKHACHHANG;
command.Parameters.Add("MAKEHANG", OracleDbType.NVarchar2, 50).Value = ITEM.MAKEHANG;
command.Parameters.Add("MACHUONGTRINHKM", OracleDbType.NVarchar2, 50).Value = ITEM.MACHUONGTRINHKM;
command.Parameters.Add("LOAIKHUYENMAI", OracleDbType.NVarchar2, 50).Value = ITEM.LOAIKHUYENMAI;
command.Parameters.Add("TIENCHIETKHAU", OracleDbType.Decimal).Value = ITEM.TIENCHIETKHAU;
command.Parameters.Add("TYLECHIETKHAU", OracleDbType.Decimal).Value = ITEM.TYLECHIETKHAU;
command.Parameters.Add("TYLEKHUYENMAI", OracleDbType.Decimal).Value = ITEM.TYLEKHUYENMAI;
command.Parameters.Add("TIENKHUYENMAI", OracleDbType.Decimal).Value = ITEM.TIENKHUYENMAI;
command.Parameters.Add("TYLEVOUCHER", OracleDbType.Decimal).Value = ITEM.TYLEVOUCHER;
command.Parameters.Add("TIENVOUCHER", OracleDbType.Decimal).Value = ITEM.TIENVOUCHER;
command.Parameters.Add("TYLELAILE", OracleDbType.Decimal).Value = ITEM.TYLELAILE;
command.Parameters.Add("GIAVON", OracleDbType.Decimal).Value = ITEM.GIAVON;
command.Parameters.Add("ISBANAM", OracleDbType.Decimal).Value = ITEM.ISBANAM;
command.Parameters.Add("MAVAT", OracleDbType.NVarchar2, 50).Value = ITEM.MAVAT;
try
{
if (command.ExecuteNonQuery() > 0)
{
countCheckInsertSuccess++;
}
}
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");
}
}
}
}
public string SAVE_MAKHACHHANG_TO_ORACLE()
{
string RESULT = "";
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
int CURRENT = 0;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string querySelectItem = "SELECT \"TYPE\",CODE,\"CURRENT\" FROM MD_ID_BUILDER WHERE CODE = 'KH'";
command.CommandText = querySelectItem;
command.CommandType = CommandType.Text;
OracleDataReader dataReaderBuildCode = command.ExecuteReader();
if (dataReaderBuildCode.HasRows)
{
while (dataReaderBuildCode.Read())
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
int CURRENT_NUMBER = 0;
int.TryParse(dataReaderBuildCode["CURRENT"].ToString(), out CURRENT_NUMBER);
string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString());
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandUpdate = new OracleCommand();
commandUpdate.Connection = connection;
string queryUpdateItem = "UPDATE MD_ID_BUILDER SET \"CURRENT\" = '" + _MD_ID_BUILDER.CURRENT + "' WHERE \"TYPE\" = '" + _MD_ID_BUILDER.TYPE + "' AND \"CODE\" = '" + _MD_ID_BUILDER.CODE + "' ";
commandUpdate.CommandText = queryUpdateItem;
commandUpdate.CommandType = CommandType.Text;
commandUpdate.ExecuteNonQuery();
RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.CODE, SO_MA);
}
}
else
{
MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER();
_MD_ID_BUILDER.ID = Guid.NewGuid().ToString();
_MD_ID_BUILDER.TYPE = "KH";
_MD_ID_BUILDER.CODE = "KH";
_MD_ID_BUILDER.CURRENT = "0000";
_MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode;
string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.CURRENT);
_MD_ID_BUILDER.CURRENT = SO_MA;
OracleCommand commandInsert = new OracleCommand();
commandInsert.Connection = connection;
string queryInsertItem = "INSERT INTO MD_ID_BUILDER(ID,\"TYPE\",CODE,\"CURRENT\",\"UNITCODE\",NGAYTAO) VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.CURRENT + "','" + _MD_ID_BUILDER.UNITCODE + "','" + DateTime.Now + "')";
commandInsert.CommandText = queryInsertItem;
commandInsert.CommandType = CommandType.Text;
commandInsert.ExecuteNonQuery();
}
}
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");
}
}
return(RESULT);
}
public static void DongBoTatCaDuLieuBan()
{
int totalParent = 0;
int totalChildren = 0;
try
{
SplashScreenManager.ShowForm(typeof(WaitForm1));
using (OracleConnection connectionOracle = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
connectionOracle.Open();
if (connectionOracle.State == ConnectionState.Open)
{
try
{
using (SqlConnection connectionClient = new SqlConnection(ConfigurationManager.ConnectionStrings["ERBusCashier"].ConnectionString))
{
connectionClient.Open();
try
{
if (connectionClient.State == ConnectionState.Open)
{
//bảng cha
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = connectionClient;
cmdSql.CommandText = @"SELECT [ID],[MA_GIAODICH],[LOAI_GIAODICH],[NGAY_GIAODICH],[MAKHACHHANG],[THOIGIAN_TAO],[TIENKHACH_TRA],[TIEN_TRALAI_KHACH],[MAKHO_XUAT],[MA_VOUCHER],[DIENGIAI],[I_CREATE_DATE],[I_CREATE_BY],[I_UPDATE_DATE],[I_UPDATE_BY],[I_STATE],[UNITCODE] FROM [ERBUS_CASHIER].[dbo].[GIAODICH]";
cmdSql.CommandType = CommandType.Text;
SqlDataReader dataReaderClient = cmdSql.ExecuteReader();
if (dataReaderClient.HasRows)
{
while (dataReaderClient.Read())
{
OracleCommand cmdOracleSelect = new OracleCommand();
cmdOracleSelect.Connection = connectionOracle;
cmdOracleSelect.CommandText = @"SELECT ID,MA_GIAODICH,UNITCODE FROM GIAODICH WHERE ID = :ID AND MA_GIAODICH = :MA_GIAODICH AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'";
cmdOracleSelect.CommandType = CommandType.Text;
cmdOracleSelect.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = dataReaderClient["ID"].ToString();
cmdOracleSelect.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70).Value = dataReaderClient["MA_GIAODICH"].ToString();
OracleDataReader dataReaderOracle = cmdOracleSelect.ExecuteReader();
if (!dataReaderOracle.HasRows)
{
DateTime NGAY_GIAODICH;
DateTime I_CREATE_DATE = DateTime.Now;
DateTime I_UPDATE_DATE = DateTime.Now;
decimal TIENKHACH_TRA = 0;
decimal TIEN_TRALAI_KHACH = 0;
string ID = dataReaderClient["ID"] != null
? dataReaderClient["ID"].ToString()
: Guid.NewGuid().ToString();
string MA_GIAODICH = dataReaderClient["MA_GIAODICH"] != null
? dataReaderClient["MA_GIAODICH"].ToString()
: "";
string LOAI_GIAODICH = dataReaderClient["LOAI_GIAODICH"] != null
? dataReaderClient["LOAI_GIAODICH"].ToString()
: "";
DateTime.TryParse(
dataReaderClient["NGAY_GIAODICH"] != null
? dataReaderClient["NGAY_GIAODICH"].ToString()
: "", out NGAY_GIAODICH);
string MAKHACHHANG = dataReaderClient["MAKHACHHANG"] != null
? dataReaderClient["MAKHACHHANG"].ToString()
: "";
string THOIGIAN_TAO = dataReaderClient["THOIGIAN_TAO"] != null
? dataReaderClient["THOIGIAN_TAO"].ToString()
: "";
decimal.TryParse(
dataReaderClient["TIENKHACH_TRA"] != null
? dataReaderClient["TIENKHACH_TRA"].ToString()
: "", out TIENKHACH_TRA);
decimal.TryParse(
dataReaderClient["TIEN_TRALAI_KHACH"] != null
? dataReaderClient["TIEN_TRALAI_KHACH"].ToString()
: "", out TIEN_TRALAI_KHACH);
string MAKHO_XUAT = dataReaderClient["MAKHO_XUAT"] != null
? dataReaderClient["MAKHO_XUAT"].ToString()
: "";
string MA_VOUCHER = dataReaderClient["MA_VOUCHER"] != null
? dataReaderClient["MA_VOUCHER"].ToString()
: "";
string DIENGIAI = dataReaderClient["DIENGIAI"] != null
? dataReaderClient["DIENGIAI"].ToString()
: "";
DateTime.TryParse(
dataReaderClient["I_CREATE_DATE"] != null
? dataReaderClient["I_CREATE_DATE"].ToString()
: "", out I_CREATE_DATE);
string I_CREATE_BY = dataReaderClient["I_CREATE_BY"] != null
? dataReaderClient["I_CREATE_BY"].ToString()
: "";
DateTime.TryParse(
dataReaderClient["I_UPDATE_DATE"] != null
? dataReaderClient["I_UPDATE_DATE"].ToString()
: "", out I_UPDATE_DATE);
string I_UPDATE_BY = dataReaderClient["I_UPDATE_BY"] != null
? dataReaderClient["I_UPDATE_BY"].ToString()
: "";
string I_STATE = dataReaderClient["I_STATE"] != null
? dataReaderClient["I_STATE"].ToString()
: "";
string UNITCODE = dataReaderClient["UNITCODE"] != null
? dataReaderClient["UNITCODE"].ToString()
: "";
OracleCommand cmdOracleInsert = new OracleCommand();
cmdOracleInsert.Connection = connectionOracle;
cmdOracleInsert.CommandText = string.Format(@"INSERT INTO GIAODICH(ID,MA_GIAODICH,LOAI_GIAODICH,NGAY_GIAODICH,MAKHACHHANG,THOIGIAN_TAO,TIENKHACH_TRA,TIEN_TRALAI_KHACH,MAKHO_XUAT,MA_VOUCHER,DIENGIAI,I_CREATE_DATE,I_CREATE_BY,I_UPDATE_DATE,I_UPDATE_BY,I_STATE,UNITCODE) VALUES (:ID,:MA_GIAODICH,:LOAI_GIAODICH,:NGAY_GIAODICH,:MAKHACHHANG,:THOIGIAN_TAO,:TIENKHACH_TRA,:TIEN_TRALAI_KHACH,:MAKHO_XUAT,:MA_VOUCHER,:DIENGIAI,:I_CREATE_DATE,:I_CREATE_BY,:I_UPDATE_DATE,:I_UPDATE_BY,:I_STATE,:UNITCODE)");
cmdOracleInsert.CommandType = CommandType.Text;
cmdOracleInsert.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ID;
cmdOracleInsert.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70).Value = MA_GIAODICH;
cmdOracleInsert.Parameters
.Add("LOAI_GIAODICH", OracleDbType.NVarchar2, 15).Value =
LOAI_GIAODICH;
cmdOracleInsert.Parameters.Add("NGAY_GIAODICH", OracleDbType.Date).Value =
NGAY_GIAODICH;
cmdOracleInsert.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50)
.Value = MAKHACHHANG;
cmdOracleInsert.Parameters.Add("THOIGIAN_TAO", OracleDbType.NVarchar2, 12)
.Value = THOIGIAN_TAO;
cmdOracleInsert.Parameters.Add("TIENKHACH_TRA", OracleDbType.Decimal).Value =
TIENKHACH_TRA;
cmdOracleInsert.Parameters.Add("TIEN_TRALAI_KHACH", OracleDbType.Decimal).Value =
TIEN_TRALAI_KHACH;
cmdOracleInsert.Parameters.Add("MAKHO_XUAT", OracleDbType.NVarchar2, 50)
.Value = MAKHO_XUAT;
cmdOracleInsert.Parameters.Add("MA_VOUCHER", OracleDbType.NVarchar2, 50)
.Value = MA_VOUCHER;
cmdOracleInsert.Parameters.Add("DIENGIAI", OracleDbType.NVarchar2, 50)
.Value = DIENGIAI;
cmdOracleInsert.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = I_CREATE_DATE;
cmdOracleInsert.Parameters.Add("I_CREATE_BY", OracleDbType.NVarchar2, 25).Value = I_CREATE_BY;
cmdOracleInsert.Parameters.Add("I_UPDATE_DATE", OracleDbType.Date).Value = I_UPDATE_DATE;
cmdOracleInsert.Parameters.Add("I_UPDATE_BY", OracleDbType.NVarchar2, 25).Value = I_UPDATE_BY;
cmdOracleInsert.Parameters.Add("I_STATE", OracleDbType.NVarchar2, 1).Value = I_STATE;
cmdOracleInsert.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 10).Value = UNITCODE;
int rowCount = cmdOracleInsert.ExecuteNonQuery();
if (rowCount > 0)
{
totalParent += rowCount;
}
}
}
}
//bảng con
SqlCommand cmdSqlDetails = new SqlCommand();
cmdSqlDetails.Connection = connectionClient;
cmdSqlDetails.CommandText = string.Format(@"SELECT [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] FROM [ERBUS_CASHIER].[dbo].[GIAODICH_CHITIET]");
cmdSqlDetails.CommandType = CommandType.Text;
SqlDataReader dataReaderClientDetails = cmdSqlDetails.ExecuteReader();
if (dataReaderClientDetails.HasRows)
{
while (dataReaderClientDetails.Read())
{
OracleCommand cmdOracleSelect = new OracleCommand();
cmdOracleSelect.Connection = connectionOracle;
cmdOracleSelect.CommandText = string.Format(@"SELECT ID,MA_GIAODICH FROM GIAODICH_CHITIET WHERE ID=:ID AND MA_GIAODICH=:MA_GIAODICH");
cmdOracleSelect.CommandType = CommandType.Text;
cmdOracleSelect.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = dataReaderClientDetails["ID"].ToString();
cmdOracleSelect.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70).Value = dataReaderClientDetails["MA_GIAODICH"].ToString();
OracleDataReader dataReaderOracleDetails = cmdOracleSelect.ExecuteReader();
if (!dataReaderOracleDetails.HasRows)
{
decimal SOLUONG = 0;
decimal GIABANLE_VAT = 0;
decimal TYLE_KHUYENMAI = 0;
decimal TIEN_KHUYENMAI = 0;
decimal TYLE_CHIETKHAU = 0;
decimal TIEN_CHIETKHAU = 0;
decimal TIENTHE_VIP = 0;
decimal TIEN_VOUCHER = 0;
decimal THANHTIEN = 0;
int SAPXEP = 0;
string ID = dataReaderClientDetails["ID"] != null
? dataReaderClientDetails["ID"].ToString()
: Guid.NewGuid().ToString();
string MA_GIAODICH = dataReaderClientDetails["MA_GIAODICH"] != null
? dataReaderClientDetails["MA_GIAODICH"].ToString()
: "";
string MAHANG = dataReaderClientDetails["MAHANG"] != null
? dataReaderClientDetails["MAHANG"].ToString()
: "";
string MATHUE_RA = dataReaderClientDetails["MATHUE_RA"] != null
? dataReaderClientDetails["MATHUE_RA"].ToString()
: "";
decimal.TryParse(
dataReaderClientDetails["SOLUONG"] != null
? dataReaderClientDetails["SOLUONG"].ToString()
: "", out SOLUONG);
decimal.TryParse(
dataReaderClientDetails["GIABANLE_VAT"] != null
? dataReaderClientDetails["GIABANLE_VAT"].ToString()
: "", out GIABANLE_VAT);
string MA_KHUYENMAI = dataReaderClientDetails["MA_KHUYENMAI"] != null
? dataReaderClientDetails["MA_KHUYENMAI"].ToString()
: "";
decimal.TryParse(
dataReaderClientDetails["TYLE_KHUYENMAI"] != null
? dataReaderClientDetails["TYLE_KHUYENMAI"].ToString()
: "", out TYLE_KHUYENMAI);
decimal.TryParse(
dataReaderClientDetails["TIEN_KHUYENMAI"] != null
? dataReaderClientDetails["TIEN_KHUYENMAI"].ToString()
: "", out TIEN_KHUYENMAI);
decimal.TryParse(
dataReaderClientDetails["TYLE_CHIETKHAU"] != null
? dataReaderClientDetails["TYLE_CHIETKHAU"].ToString()
: "", out TYLE_CHIETKHAU);
decimal.TryParse(
dataReaderClientDetails["TIEN_CHIETKHAU"] != null
? dataReaderClientDetails["TIEN_CHIETKHAU"].ToString()
: "", out TIEN_CHIETKHAU);
decimal.TryParse(
dataReaderClientDetails["TIENTHE_VIP"] != null
? dataReaderClientDetails["TIENTHE_VIP"].ToString()
: "", out TIENTHE_VIP);
decimal.TryParse(
dataReaderClientDetails["TIEN_VOUCHER"] != null
? dataReaderClientDetails["TIEN_VOUCHER"].ToString()
: "", out TIEN_VOUCHER);
decimal.TryParse(
dataReaderClientDetails["THANHTIEN"] != null
? dataReaderClientDetails["THANHTIEN"].ToString()
: "", out THANHTIEN);
decimal.TryParse(
dataReaderClientDetails["TIEN_VOUCHER"] != null
? dataReaderClientDetails["TIEN_VOUCHER"].ToString()
: "", out TIEN_VOUCHER);
int.TryParse(
dataReaderClientDetails["SAPXEP"] != null
? dataReaderClientDetails["SAPXEP"].ToString()
: "", out SAPXEP);
OracleCommand cmdOracleInsert = new OracleCommand();
cmdOracleInsert.Connection = connectionOracle;
cmdOracleInsert.CommandText = 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)");
cmdOracleInsert.CommandType = CommandType.Text;
cmdOracleInsert.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = ID;
cmdOracleInsert.Parameters.Add("MA_GIAODICH", OracleDbType.NVarchar2, 70)
.Value = MA_GIAODICH;
cmdOracleInsert.Parameters.Add("MAHANG", OracleDbType.NVarchar2, 50)
.Value = MAHANG;
cmdOracleInsert.Parameters.Add("MATHUE_RA", OracleDbType.NVarchar2, 50)
.Value = MATHUE_RA;
cmdOracleInsert.Parameters.Add("SOLUONG", OracleDbType.Decimal).Value =
SOLUONG;
cmdOracleInsert.Parameters.Add("GIABANLE_VAT", OracleDbType.Decimal).Value =
GIABANLE_VAT;
cmdOracleInsert.Parameters.Add("MA_KHUYENMAI", OracleDbType.NVarchar2, 30)
.Value = MA_KHUYENMAI;
cmdOracleInsert.Parameters.Add("TYLE_KHUYENMAI", OracleDbType.Decimal)
.Value = TYLE_KHUYENMAI;
cmdOracleInsert.Parameters.Add("TIEN_KHUYENMAI", OracleDbType.Decimal)
.Value = TIEN_KHUYENMAI;
cmdOracleInsert.Parameters.Add("TYLE_CHIETKHAU", OracleDbType.Decimal)
.Value = TYLE_CHIETKHAU;
cmdOracleInsert.Parameters.Add("TIEN_CHIETKHAU", OracleDbType.Decimal)
.Value = TIEN_CHIETKHAU;
cmdOracleInsert.Parameters.Add("TIENTHE_VIP", OracleDbType.Decimal).Value =
TIENTHE_VIP;
cmdOracleInsert.Parameters.Add("TIEN_VOUCHER", OracleDbType.Decimal).Value =
TIEN_VOUCHER;
cmdOracleInsert.Parameters.Add("THANHTIEN", OracleDbType.Decimal).Value =
THANHTIEN;
cmdOracleInsert.Parameters.Add("SAPXEP", OracleDbType.Int32).Value =
SAPXEP;
int rowCount = cmdOracleInsert.ExecuteNonQuery();
if (rowCount > 0)
{
totalChildren += rowCount;
}
}
}
}
}
}
catch
{
}
finally
{
connectionClient.Close();
}
}
}
catch
{
}
finally
{
connectionOracle.Close();
SplashScreenManager.CloseForm();
}
}
MessageBox.Show("Đồng bộ thành công " + totalParent + " bản ghi ");
MessageBox.Show("Đồng bộ thành công " + totalChildren + " bản ghi giao dịch con");
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
MessageBox.Show("Xảy ra lỗi khi đồng bộ dữ liệu");
SplashScreenManager.CloseForm();
}
}
public List <TIMKIEM_VATTU_DTO> TIMKIEM_DULIEU_HANGHOA_DATABASE_ORACLE(string DIEUKIENLOC, int SUDUNG_TIMKIEM_ALL, int DIEUKIENCHON, string UNITCODE)
{
List <TIMKIEM_VATTU_DTO> LST_TIMKIEM_VATTU_DTO = new List <TIMKIEM_VATTU_DTO>();
if (!string.IsNullOrEmpty(DIEUKIENLOC))
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"BANLE_TIMKIEM_BOHANG_MAHANG";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = UNITCODE;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 50).Value = DIEUKIENLOC.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_SUDUNG_TIMKIEM_ALL", OracleDbType.Int32).Value = SUDUNG_TIMKIEM_ALL;
command.Parameters.Add(@"P_DIEUKIENCHON", OracleDbType.Int32).Value = DIEUKIENCHON;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
TIMKIEM_VATTU_DTO TIMKIEM_VATTU_DTO = new TIMKIEM_VATTU_DTO();
if (dataReader["MAVATTU"] != null)
{
TIMKIEM_VATTU_DTO.MAVATTU = dataReader["MAVATTU"].ToString();
}
if (dataReader["MAKHAC"] != null)
{
TIMKIEM_VATTU_DTO.MAKHAC = dataReader["MAKHAC"].ToString();
}
if (dataReader["TENVATTU"] != null)
{
TIMKIEM_VATTU_DTO.TENVATTU = dataReader["TENVATTU"].ToString();
}
if (dataReader["MALOAIVATTU"] != null)
{
TIMKIEM_VATTU_DTO.MALOAIVATTU = dataReader["MALOAIVATTU"].ToString();
}
if (dataReader["MANHOMVATTU"] != null)
{
TIMKIEM_VATTU_DTO.MANHOMVATTU = dataReader["MANHOMVATTU"].ToString();
}
if (dataReader["DONVITINH"] != null)
{
TIMKIEM_VATTU_DTO.DONVITINH = dataReader["DONVITINH"].ToString();
}
if (dataReader["MANHACUNGCAP"] != null)
{
TIMKIEM_VATTU_DTO.MANHACUNGCAP = dataReader["MANHACUNGCAP"].ToString();
}
if (dataReader["TENNHACUNGCAP"] != null)
{
TIMKIEM_VATTU_DTO.TENNHACUNGCAP = dataReader["TENNHACUNGCAP"].ToString();
}
if (dataReader["MAKEHANG"] != null)
{
TIMKIEM_VATTU_DTO.MAKEHANG = dataReader["MAKEHANG"].ToString();
}
if (dataReader["GIABANLEVAT"] != null)
{
decimal GIABANLECOVAT = 0;
decimal.TryParse(dataReader["GIABANLEVAT"].ToString(), out GIABANLECOVAT);
TIMKIEM_VATTU_DTO.GIABANLECOVAT = GIABANLECOVAT;
}
if (dataReader["ITEMCODE"] != null)
{
TIMKIEM_VATTU_DTO.ITEMCODE = dataReader["ITEMCODE"].ToString();
}
if (dataReader["BARCODE"] != null)
{
TIMKIEM_VATTU_DTO.BARCODE = dataReader["BARCODE"].ToString();
}
LST_TIMKIEM_VATTU_DTO.Add(TIMKIEM_VATTU_DTO);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
return(LST_TIMKIEM_VATTU_DTO);
}
public int SAVE_DATA_KHACHHANG_TO_ORACLE()
{
int RESULT = 0;
//SAVE ORACLE
string MAKHACHHANG = SAVE_MAKHACHHANG_TO_ORACLE();
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO();
_KHACHHANG_DTO.MAKH = MAKHACHHANG;
_KHACHHANG_DTO.TENKH = txtTenKhachHang.Text;
_KHACHHANG_DTO.DIACHI = txtDiaChi.Text;
_KHACHHANG_DTO.DIENTHOAI = txtDienThoai.Text;
_KHACHHANG_DTO.CMTND = txtChungMinhThu.Text;
_KHACHHANG_DTO.EMAIL = "";
_KHACHHANG_DTO.SODIEM = 0;
_KHACHHANG_DTO.TONGTIEN = 0;
_KHACHHANG_DTO.NGAYCAPTHE = DateTime.Now;
_KHACHHANG_DTO.NGAYHETHAN = DateTime.Now.AddYears(1);
_KHACHHANG_DTO.NGAYSINH = dateNgaySinh.Value;
_KHACHHANG_DTO.UNITCODE = Session.Session.CurrentUnitCode;
_KHACHHANG_DTO.MATHE = txtMaThe.Text;
OracleCommand command = new OracleCommand();
command.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO DM_KHACHHANG (ID,MAKH,TENKH,DIACHI,DIENTHOAI,CMTND,SODIEM,TONGTIEN,NGAYCAPTHE,NGAYHETHAN,NGAYSINH,UNITCODE,TRANGTHAI,MATHE) VALUES (:ID,:MAKH,:TENKH,:DIACHI,:DIENTHOAI,:CMTND,:SODIEM,:TONGTIEN,:NGAYCAPTHE,:NGAYHETHAN,:NGAYSINH,:UNITCODE,:TRANGTHAI,:MATHE)");
command.CommandText = queryInsertItem;
command.CommandType = CommandType.Text;
command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid();
command.Parameters.Add("MAKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MAKH;
command.Parameters.Add("TENKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.TENKH;
command.Parameters.Add("DIACHI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIACHI;
command.Parameters.Add("DIENTHOAI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIENTHOAI;
command.Parameters.Add("CMTND", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.CMTND;
command.Parameters.Add("SODIEM", OracleDbType.Decimal).Value = _KHACHHANG_DTO.SODIEM;
command.Parameters.Add("TONGTIEN", OracleDbType.Decimal).Value = _KHACHHANG_DTO.TONGTIEN;
command.Parameters.Add("NGAYCAPTHE", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYCAPTHE;
command.Parameters.Add("NGAYHETHAN", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYHETHAN;
command.Parameters.Add("NGAYSINH", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYSINH;
command.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.UNITCODE;
command.Parameters.Add("TRANGTHAI", OracleDbType.Int32).Value = 10;
command.Parameters.Add("MATHE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MATHE;
try
{
if (command.ExecuteNonQuery() > 0)
{
RESULT++;
}
_STATUS_THEMMOI_KHACHHANG(_KHACHHANG_DTO);
}
catch (Exception e)
{
WriteLogs.LogError(e);
NotificationLauncher.ShowNotificationError("THÔNG BÁO", "XẢY RA LỖI KHI LƯU THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
}
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 TỚI ORACLE", 1, "0x1", "0x8", "normal");
}
}
return(RESULT);
}
/// <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(NVGDQUAY_ASYNCCLIENT_DTO _NVGDQUAY_ASYNCCLIENT_DTO)
{
int countCheckInsertSuccess = 0;
if (_NVGDQUAY_ASYNCCLIENT_DTO != null)
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
string queryInsert = "";
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
queryInsert =
string.Format(
@"INSERT INTO NVGDQUAY_ASYNCCLIENT (ID,MAGIAODICH,MAGIAODICHQUAYPK,MADONVI,LOAIGIAODICH,NGAYTAO,MANGUOITAO,
NGUOITAO,MAQUAYBAN,NGAYPHATSINH,HINHTHUCTHANHTOAN,MAVOUCHER,TIENKHACHDUA,TIENVOUCHER,TIENTHEVIP,TIENTRALAI,TIENTHE,TIENCOD,TIENMAT,TTIENCOVAT,
THOIGIAN,MAKHACHHANG,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES (
:ID,:MAGIAODICH,:MAGIAODICHQUAYPK,:MADONVI,:LOAIGIAODICH,:NGAYTAO,:MANGUOITAO,
:NGUOITAO,:MAQUAYBAN,:NGAYPHATSINH,:HINHTHUCTHANHTOAN,:MAVOUCHER,:TIENKHACHDUA,:TIENVOUCHER,:TIENTHEVIP,:TIENTRALAI,:TIENTHE,:TIENCOD,:TIENMAT,:TTIENCOVAT,
:THOIGIAN,:MAKHACHHANG,: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("MAGIAODICH", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MAGIAODICH;
cmd.Parameters.Add("MAGIAODICHQUAYPK", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MAGIAODICHQUAYPK;
cmd.Parameters.Add("MADONVI", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MADONVI;
cmd.Parameters.Add("LOAIGIAODICH", OracleDbType.Int32).Value = _NVGDQUAY_ASYNCCLIENT_DTO.LOAIGIAODICH;
cmd.Parameters.Add("NGAYTAO", OracleDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.NGAYTAO;
cmd.Parameters.Add("MANGUOITAO", OracleDbType.NVarchar2, 300).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MANGUOITAO;
cmd.Parameters.Add("NGUOITAO", OracleDbType.NVarchar2, 300).Value = _NVGDQUAY_ASYNCCLIENT_DTO.NGUOITAO;
cmd.Parameters.Add("MAQUAYBAN", OracleDbType.NVarchar2, 300).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MAQUAYBAN;
cmd.Parameters.Add("NGAYPHATSINH", OracleDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.NGAYPHATSINH;
cmd.Parameters.Add("HINHTHUCTHANHTOAN", OracleDbType.NVarchar2, 200).Value = _NVGDQUAY_ASYNCCLIENT_DTO.HINHTHUCTHANHTOAN;
cmd.Parameters.Add("MAVOUCHER", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MAVOUCHER;
cmd.Parameters.Add("TIENKHACHDUA", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENKHACHDUA;
cmd.Parameters.Add("TIENVOUCHER", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENVOUCHER;
cmd.Parameters.Add("TIENTHEVIP", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENTHEVIP;
cmd.Parameters.Add("TIENTRALAI", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENTRALAI;
cmd.Parameters.Add("TIENTHE ", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENTHE >= _NVGDQUAY_ASYNCCLIENT_DTO.TTIENCOVAT ? _NVGDQUAY_ASYNCCLIENT_DTO.TTIENCOVAT : _NVGDQUAY_ASYNCCLIENT_DTO.TIENTHE;
cmd.Parameters.Add("TIENCOD", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENCOD;
cmd.Parameters.Add("TIENMAT", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TIENMAT >= _NVGDQUAY_ASYNCCLIENT_DTO.TTIENCOVAT ? _NVGDQUAY_ASYNCCLIENT_DTO.TTIENCOVAT : _NVGDQUAY_ASYNCCLIENT_DTO.TIENMAT;
cmd.Parameters.Add("TTIENCOVAT", OracleDbType.Decimal).Value = _NVGDQUAY_ASYNCCLIENT_DTO.TTIENCOVAT;
cmd.Parameters.Add("THOIGIAN", OracleDbType.NVarchar2, 150).Value = _NVGDQUAY_ASYNCCLIENT_DTO.THOIGIAN;
cmd.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = _NVGDQUAY_ASYNCCLIENT_DTO.MAKHACHHANG;
cmd.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = _NVGDQUAY_ASYNCCLIENT_DTO.I_CREATE_DATE;
cmd.Parameters.Add("I_CREATE_BY", OracleDbType.NVarchar2, 50).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 = @"TBNETERP.XNT.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 LOGIN()
{
string Username = txtUserName.Text.Trim();
string passWord = txtPassWord.Text.Trim();
string passMd5 = MD5Encrypt.MD5Hash(passWord).Trim();
//check true false login
try
{
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
//BEGIN LOGIN
if (result) // nếu có mạng lan
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
try
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format(@"SELECT * FROM AU_NGUOIDUNG WHERE USERNAME = '******' AND PASSWORD = '******'");
OracleDataReader dataReader = null;
dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Session.Session.CurrentMaNhanVien = dataReader["MANHANVIEN"].ToString();
Session.Session.CurrentTenNhanVien = dataReader["TENNHANVIEN"].ToString();
Session.Session.CurrentUnitCode = dataReader["UNITCODE"].ToString();
if (!string.IsNullOrEmpty(Session.Session.CurrentUnitCode))
{
Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode.Split('-')[1];
}
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandText = string.Format(@"SELECT * FROM AU_DONVI WHERE MADONVI = '" + Session.Session.CurrentUnitCode + "'");
OracleDataReader dataReaderDonVi = null;
dataReaderDonVi = command.ExecuteReader();
if (dataReaderDonVi.HasRows)
{
while (dataReaderDonVi.Read())
{
Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString();
Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString();
Session.Session.CurrentNameStore = dataReaderDonVi["TENCUAHANG"].ToString();
}
}
Session.Session.CurrentUserName = dataReader["USERNAME"].ToString();
Session.Session.CurrentNgayPhatSinh = FrmXuatBanLeService.GET_NGAYHACHTOAN_CSDL_ORACLE();
Session.Session.CurrentTableNamePeriod = FrmXuatBanLeService.GET_TABLE_NAME_NGAYHACHTOAN_CSDL_ORACLE();
Session.Session.CurrentWareHouse = (Session.Session.CurrentUnitCode + "-K2").ToUpper().Trim();
SplashScreenManager.ShowForm(typeof(WaitForm1));
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_NGUOIDUNG();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_BOHANG();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_BOHANGCHITIET();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_KHACHHANG();
SYNCHRONIZE_DATA.SYNCHRONIZE_KHUYENMAI();
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_THAMSOHETHONG();
SYNCHRONIZE_DATA.SYNCHRONIZE_AU_DONVI();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_VATTU();
SYNCHRONIZE_DATA.SYNCHRONIZE_DM_HANGKHACHHANG();
SplashScreenManager.CloseForm();
FrmMain frmMain = new FrmMain();
frmMain.ShowDialog();
break;
}
}
else
{
NotificationLauncher.ShowNotificationWarning("Thông báo", "Thông tin đăng nhập không đúng", 1, "0x1", "0x8", "normal");
txtPassWord.Text = "";
txtPassWord.Focus();
}
}
catch (Exception ex)
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có kết nối với cơ sở dữ liệu máy chủ", 1, "0x1", "0x8", "normal");
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
else
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có kế nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal");
}
}
}
else
{
//Kết nối với SQL
using (SqlConnection connectionSa = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString))
{
connectionSa.Open();
if (connectionSa.State == ConnectionState.Open)
{
try
{
SqlCommand cmdSelectSa = new SqlCommand();
cmdSelectSa.Connection = connectionSa;
cmdSelectSa.CommandText = string.Format(@"SELECT [ID],[USERNAME],[PASSWORD],[MANHANVIEN],[TENNHANVIEN],[SODIENTHOAI],[SOCHUNGMINHTHU],[GIOITINH],[TRANGTHAI],[LEVEL],[UNITCODE],[PARENT_UNITCODE] FROM [dbo].[AU_NGUOIDUNG] WHERE USERNAME = '******' AND PASSWORD = '******'");
SqlDataReader dataReader = null;
dataReader = cmdSelectSa.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Session.Session.CurrentMaNhanVien = dataReader["MANHANVIEN"].ToString();
Session.Session.CurrentTenNhanVien = dataReader["TENNHANVIEN"].ToString();
Session.Session.CurrentUnitCode = dataReader["UNITCODE"].ToString();
if (!string.IsNullOrEmpty(Session.Session.CurrentUnitCode))
{
Session.Session.CurrentCodeStore = Session.Session.CurrentUnitCode.Split('-')[1];
}
SqlCommand commandDonVi = new SqlCommand();
commandDonVi.Connection = connectionSa;
commandDonVi.CommandText = string.Format(@"SELECT [ID],[MADONVI],[MADONVICHA],[TENDONVI],[SODIENTHOAI],[DIACHI],[TRANGTHAI],[MACUAHANG],[TENCUAHANG],[UNITCODE] FROM [dbo].[AU_DONVI] WHERE MADONVI = '" + Session.Session.CurrentUnitCode + "'");
SqlDataReader dataReaderDonVi = null;
dataReaderDonVi = commandDonVi.ExecuteReader();
if (dataReaderDonVi.HasRows)
{
while (dataReaderDonVi.Read())
{
Session.Session.CurrentPhone = dataReaderDonVi["SODIENTHOAI"].ToString();
Session.Session.CurrentAddress = dataReaderDonVi["DIACHI"].ToString();
Session.Session.CurrentNameStore = dataReaderDonVi["TENCUAHANG"].ToString();
}
}
Session.Session.CurrentUserName = dataReader["USERNAME"].ToString();
//nếu mất mạng thì ngày phát sinh là ngày hiện tại
Session.Session.CurrentNgayPhatSinh = DateTime.Now;
Session.Session.CurrentWareHouse = (Session.Session.CurrentUnitCode + "-K2").ToUpper().Trim();
FrmMain frmMain = new FrmMain();
frmMain.ShowDialog();
break;
}
}
else
{
NotificationLauncher.ShowNotificationWarning("Thông báo", "Thông tin đăng nhập không đúng", 1, "0x1", "0x8", "normal");
txtPassWord.Text = "";
txtPassWord.Focus();
}
}
catch (Exception ex)
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có kế nối với cơ sở dữ liệu máy bán", 1, "0x1", "0x8", "normal");
WriteLogs.LogError(ex);
}
finally
{
connectionSa.Close();
connectionSa.Dispose();
}
}
else
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có kế nối với cơ sở dữ liệu", 1, "0x1", "0x8", "normal");
}
}
}
//END LOGIN
}
catch (Exception ex)
{
NotificationLauncher.ShowNotificationError("Thông báo", "Không có kế nối với cơ sở dữ liệu máy bán", 1, "0x1", "0x8", "normal");
WriteLogs.LogError(ex);
}
}
private void btnDongBo_Click(object sender, EventArgs e)
{
int hdSV = 0;
int mhSV = 0;
int hdMT = 0;
int mhMT = 0;
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString))
{
string msg = Config.CheckConnectToServer(out bool result);
if (msg.Length > 0)
{
MessageBox.Show(msg); return;
}
if (result) // nếu có mạng lan
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
foreach (NVGDQUAY_ASYNCCLIENT_DTO item in lstData)
{
try
{
OracleCommand orlCommand = new OracleCommand();
orlCommand.Connection = connection;
orlCommand.CommandText = @"SELECT * FROM NVGDQUAY_ASYNCCLIENT WHERE MAGIAODICHQUAYPK = '" + item.MAGIAODICHQUAYPK + "'";
orlCommand.CommandType = CommandType.Text;
try
{
OracleDataReader reader = orlCommand.ExecuteReader();
if (!reader.HasRows)
{
try
{
string queryInsert = "";
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
queryInsert =
string.Format(
@"INSERT INTO NVGDQUAY_ASYNCCLIENT (ID,MAGIAODICH,MAGIAODICHQUAYPK,MADONVI,LOAIGIAODICH,NGAYTAO,MANGUOITAO,
NGUOITAO,MAQUAYBAN,NGAYPHATSINH,HINHTHUCTHANHTOAN,MAVOUCHER,TIENKHACHDUA,TIENVOUCHER,TIENTHEVIP,TIENTRALAI,TIENTHE,TIENCOD,TIENMAT,TTIENCOVAT,
THOIGIAN,MAKHACHHANG,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES (
:ID,:MAGIAODICH,:MAGIAODICHQUAYPK,:MADONVI,:LOAIGIAODICH,:NGAYTAO,:MANGUOITAO,
:NGUOITAO,:MAQUAYBAN,:NGAYPHATSINH,:HINHTHUCTHANHTOAN,:MAVOUCHER,:TIENKHACHDUA,:TIENVOUCHER,:TIENTHEVIP,:TIENTRALAI,:TIENTHE,:TIENCOD,:TIENMAT,:TTIENCOVAT,
:THOIGIAN,:MAKHACHHANG,:I_CREATE_DATE,:I_CREATE_BY,:I_STATE,:UNITCODE)");
cmd.CommandText = queryInsert;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = item.ID;
cmd.Parameters.Add("MAGIAODICH", OracleDbType.NVarchar2, 50).Value = item.MAGIAODICH;
cmd.Parameters.Add("MAGIAODICHQUAYPK", OracleDbType.NVarchar2, 50).Value = item.MAGIAODICHQUAYPK;
cmd.Parameters.Add("MADONVI", OracleDbType.NVarchar2, 50).Value = item.UNITCODE;
cmd.Parameters.Add("LOAIGIAODICH", OracleDbType.Int32).Value = item.LOAIGIAODICH;
cmd.Parameters.Add("NGAYTAO", OracleDbType.Date).Value = item.NGAYTAO;
cmd.Parameters.Add("MANGUOITAO", OracleDbType.NVarchar2, 300).Value = item.MANGUOITAO;
cmd.Parameters.Add("NGUOITAO", OracleDbType.NVarchar2, 300).Value = item.NGUOITAO;
cmd.Parameters.Add("MAQUAYBAN", OracleDbType.NVarchar2, 300).Value = item.MAQUAYBAN;
cmd.Parameters.Add("NGAYPHATSINH", OracleDbType.Date).Value = item.NGAYPHATSINH;
cmd.Parameters.Add("HINHTHUCTHANHTOAN", OracleDbType.NVarchar2, 200).Value = item.HINHTHUCTHANHTOAN;
cmd.Parameters.Add("MAVOUCHER", OracleDbType.NVarchar2, 50).Value = item.MAVOUCHER;
cmd.Parameters.Add("TIENKHACHDUA", OracleDbType.Decimal).Value = item.TIENKHACHDUA;
cmd.Parameters.Add("TIENVOUCHER", OracleDbType.Decimal).Value = item.TIENVOUCHER;
cmd.Parameters.Add("TIENTHEVIP", OracleDbType.Decimal).Value = item.TIENTHEVIP;
cmd.Parameters.Add("TIENTRALAI", OracleDbType.Decimal).Value = item.TIENTRALAI;
cmd.Parameters.Add("TIENTHE ", OracleDbType.Decimal).Value = item.TIENTHE;
cmd.Parameters.Add("TIENCOD", OracleDbType.Decimal).Value = item.TIENCOD;
cmd.Parameters.Add("TIENMAT", OracleDbType.Decimal).Value = item.TIENMAT;
cmd.Parameters.Add("TTIENCOVAT", OracleDbType.Decimal).Value = item.TTIENCOVAT;
cmd.Parameters.Add("THOIGIAN", OracleDbType.NVarchar2, 150).Value = item.THOIGIAN;
cmd.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = item.MAKHACHHANG;
cmd.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = item.NGAYTAO;
cmd.Parameters.Add("I_CREATE_BY", OracleDbType.NVarchar2, 50).Value = item.MANGUOITAO;
cmd.Parameters.Add("I_STATE", OracleDbType.NVarchar2, 50).Value = "40";
cmd.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = item.UNITCODE;
if (cmd.ExecuteNonQuery() > 0)
{
hdSV++;
int tempId = 0;
foreach (NVHANGGDQUAY_ASYNCCLIENT itemData in item.LST_DETAILS)
{
tempId++;
OracleCommand command2 = new OracleCommand();
command2.Connection = connection;
string queryInsertItem =
string.Format(
@"INSERT INTO NVHANGGDQUAY_ASYNCCLIENT (ID,MAGDQUAYPK,MAKHOHANG,MADONVI,MAVATTU,BARCODE,TENDAYDU,NGUOITAO,MABOPK,NGAYTAO,NGAYPHATSINH,
SOLUONG,TTIENCOVAT,VATBAN,GIABANLECOVAT,MAKHACHHANG,MAKEHANG,MACHUONGTRINHKM,LOAIKHUYENMAI,TIENCHIETKHAU,TYLECHIETKHAU,TYLEKHUYENMAI,TIENKHUYENMAI,TYLEVOUCHER,
TIENVOUCHER,TYLELAILE,GIAVON,ISBANAM,MAVAT) VALUES (:ID,:MAGDQUAYPK,:MAKHOHANG,:MADONVI,:MAVATTU,:BARCODE,:TENDAYDU,:NGUOITAO,:MABOPK,:NGAYTAO,:NGAYPHATSINH,
:SOLUONG,:TTIENCOVAT,:VATBAN,:GIABANLECOVAT,:MAKHACHHANG,:MAKEHANG,:MACHUONGTRINHKM,:LOAIKHUYENMAI,:TIENCHIETKHAU,:TYLECHIETKHAU,:TYLEKHUYENMAI,:TIENKHUYENMAI,:TYLEVOUCHER,
:TIENVOUCHER,:TYLELAILE,:GIAVON,:ISBANAM,:MAVAT)");
command2.CommandText = queryInsertItem;
command2.CommandType = CommandType.Text;
command2.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid().ToString();
command2.Parameters.Add("MAGDQUAYPK", OracleDbType.NVarchar2, 50).Value = itemData.MAGDQUAYPK;
command2.Parameters.Add("MAKHOHANG", OracleDbType.NVarchar2, 50).Value = itemData.MAKHOHANG;
command2.Parameters.Add("MADONVI", OracleDbType.NVarchar2, 50).Value = itemData.MADONVI;
command2.Parameters.Add("MAVATTU", OracleDbType.NVarchar2, 50).Value = itemData.MAVATTU;
command2.Parameters.Add("BARCODE", OracleDbType.NVarchar2, 2000).Value = itemData.BARCODE;
command2.Parameters.Add("TENDAYDU", OracleDbType.NVarchar2, 300).Value = itemData.TENDAYDU;
command2.Parameters.Add("NGUOITAO", OracleDbType.NVarchar2, 300).Value = item.MANGUOITAO;
command2.Parameters.Add("MABOPK", OracleDbType.NVarchar2, 50).Value = itemData.MABOPK;
command2.Parameters.Add("NGAYTAO", OracleDbType.Date).Value = itemData.NGAYTAO;
command2.Parameters.Add("NGAYPHATSINH", OracleDbType.Date).Value = itemData.NGAYPHATSINH;
command2.Parameters.Add("SOLUONG", OracleDbType.Int32).Value =
itemData.SOLUONG;
command2.Parameters.Add("TTIENCOVAT", OracleDbType.Decimal).Value =
itemData.TTIENCOVAT;
command2.Parameters.Add("VATBAN", OracleDbType.Decimal).Value =
itemData.VATBAN;
command2.Parameters.Add("GIABANLECOVAT", OracleDbType.Decimal).Value =
itemData.GIABANLECOVAT;
command2.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value =
itemData.MAKHACHHANG;
command2.Parameters.Add("MAKEHANG", OracleDbType.NVarchar2, 50).Value =
itemData.MAKEHANG;
command2.Parameters.Add("MACHUONGTRINHKM", OracleDbType.NVarchar2, 50).Value
= itemData.MACHUONGTRINHKM;
command2.Parameters.Add("LOAIKHUYENMAI", OracleDbType.NVarchar2, 50).Value =
itemData.LOAIKHUYENMAI;
command2.Parameters.Add("TIENCHIETKHAU", OracleDbType.Decimal).Value =
itemData.TIENCHIETKHAU;
command2.Parameters.Add("TYLECHIETKHAU", OracleDbType.Decimal).Value =
itemData.TYLECHIETKHAU;
command2.Parameters.Add("TYLEKHUYENMAI", OracleDbType.Decimal).Value =
itemData.TYLEKHUYENMAI;
command2.Parameters.Add("TIENKHUYENMAI", OracleDbType.Decimal).Value =
itemData.TIENKHUYENMAI;
command2.Parameters.Add("TYLEVOUCHER", OracleDbType.Decimal).Value =
itemData.TYLEVOUCHER;
command2.Parameters.Add("TIENVOUCHER", OracleDbType.Decimal).Value =
itemData.TIENVOUCHER;
command2.Parameters.Add("TYLELAILE", OracleDbType.Decimal).Value =
itemData.TYLELAILE;
command2.Parameters.Add("GIAVON", OracleDbType.Decimal).Value =
itemData.GIAVON;
command2.Parameters.Add("ISBANAM", OracleDbType.Decimal).Value = 0;
command2.Parameters.Add("MAVAT", OracleDbType.NVarchar2, 50).Value =
itemData.MAVAT;
try
{
command2.ExecuteNonQuery();
mhSV++;
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
catch (Exception x) { }
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
}
}
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
foreach (NVGDQUAY_ASYNCCLIENT_DTO item in lstDataOracle)
{
try
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = connection;
sqlCommand.CommandText = @"SELECT * FROM NVGDQUAY_ASYNCCLIENT WHERE MAGIAODICHQUAYPK = '" + item.MAGIAODICHQUAYPK + "'";
sqlCommand.CommandType = CommandType.Text;
try
{
SqlDataReader reader = sqlCommand.ExecuteReader();
if (!reader.HasRows)
{
try
{
string queryInsert = "";
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
queryInsert =
string.Format(
@"INSERT INTO NVGDQUAY_ASYNCCLIENT (ID,MAGIAODICH,MAGIAODICHQUAYPK,MADONVI,LOAIGIAODICH,NGAYTAO,MANGUOITAO,
NGUOITAO,MAQUAYBAN,NGAYPHATSINH,HINHTHUCTHANHTOAN,TIENKHACHDUA,TIENVOUCHER,TIENTHEVIP,TIENTRALAI,TIENTHE,TIENCOD,TIENMAT,TTIENCOVAT,
THOIGIAN,MAKHACHHANG,UNITCODE) VALUES (
@ID,@MAGIAODICH,@MAGIAODICHQUAYPK,@MADONVI,@LOAIGIAODICH,@NGAYTAO,@MANGUOITAO,
@NGUOITAO,@MAQUAYBAN,@NGAYPHATSINH,@HINHTHUCTHANHTOAN,@TIENKHACHDUA,@TIENVOUCHER,@TIENTHEVIP,@TIENTRALAI,@TIENTHE,@TIENCOD,@TIENMAT,@TTIENCOVAT,
@THOIGIAN,@MAKHACHHANG,@UNITCODE)");
cmd.CommandText = queryInsert;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("ID", SqlDbType.VarChar, 50).Value = item.ID;
cmd.Parameters.Add("MAGIAODICH", SqlDbType.VarChar, 50).Value = item.MAGIAODICH;
cmd.Parameters.Add("MAGIAODICHQUAYPK", SqlDbType.VarChar, 50).Value = item.MAGIAODICHQUAYPK;
cmd.Parameters.Add("MADONVI", SqlDbType.NVarChar, 50).Value = item.UNITCODE;
cmd.Parameters.Add("LOAIGIAODICH", SqlDbType.Int).Value = item.LOAIGIAODICH;
cmd.Parameters.Add("NGAYTAO", SqlDbType.Date).Value = item.NGAYTAO;
cmd.Parameters.Add("MANGUOITAO", SqlDbType.NVarChar, 300).Value = item.MANGUOITAO;
cmd.Parameters.Add("NGUOITAO", SqlDbType.NVarChar, 300).Value = item.NGUOITAO;
cmd.Parameters.Add("MAQUAYBAN", SqlDbType.NVarChar, 300).Value = item.MAQUAYBAN;
cmd.Parameters.Add("NGAYPHATSINH", SqlDbType.Date).Value = item.NGAYPHATSINH;
cmd.Parameters.Add("HINHTHUCTHANHTOAN", SqlDbType.NVarChar, 200).Value = item.HINHTHUCTHANHTOAN;
cmd.Parameters.Add("TIENKHACHDUA", SqlDbType.Decimal).Value = item.TIENKHACHDUA;
cmd.Parameters.Add("TIENVOUCHER", SqlDbType.Decimal).Value = item.TIENVOUCHER;
cmd.Parameters.Add("TIENTHEVIP", SqlDbType.Decimal).Value = item.TIENTHEVIP;
cmd.Parameters.Add("TIENTRALAI", SqlDbType.Decimal).Value = item.TIENTRALAI;
cmd.Parameters.Add("TIENTHE ", SqlDbType.Decimal).Value = item.TIENTHE;
cmd.Parameters.Add("TIENCOD", SqlDbType.Decimal).Value = item.TIENCOD;
cmd.Parameters.Add("TIENMAT", SqlDbType.Decimal).Value = item.TIENMAT;
cmd.Parameters.Add("TTIENCOVAT", SqlDbType.Decimal).Value = item.TTIENCOVAT;
cmd.Parameters.Add("THOIGIAN", SqlDbType.NVarChar, 150).Value = item.THOIGIAN;
cmd.Parameters.Add("MAKHACHHANG", SqlDbType.NVarChar, 50).Value = item.MAKHACHHANG;
cmd.Parameters.Add("UNITCODE", SqlDbType.NVarChar, 50).Value = item.UNITCODE;
if (cmd.ExecuteNonQuery() > 0)
{
hdMT++;
int tempId = 0;
foreach (NVHANGGDQUAY_ASYNCCLIENT itemData in item.LST_DETAILS)
{
tempId++;
SqlCommand command2 = new SqlCommand();
command2.Connection = connection;
string queryInsertItem = string.Format(@"INSERT INTO [dbo].[NVHANGGDQUAY_ASYNCCLIENT]([ID],[MAGDQUAYPK],[MAKHOHANG],[MADONVI],[MAVATTU],[MANGUOITAO],[NGUOITAO],[MABOPK],[NGAYTAO],[NGAYPHATSINH],[SOLUONG],[TTIENCOVAT],[GIABANLECOVAT],[TYLECHIETKHAU],[TIENCHIETKHAU],[TYLEKHUYENMAI],[TIENKHUYENMAI],[TYLEVOUCHER],[TIENVOUCHER],[TYLELAILE],[GIAVON],[MAVAT],[VATBAN],[MACHUONGTRINHKM],[UNITCODE])
VALUES (@ID,@MAGDQUAYPK,@MAKHOHANG,@MADONVI,@MAVATTU,@MANGUOITAO,@NGUOITAO,@MABOPK,@NGAYTAO,@NGAYPHATSINH,@SOLUONG,@TTIENCOVAT,@GIABANLECOVAT,@TYLECHIETKHAU,@TIENCHIETKHAU,@TYLEKHUYENMAI,@TIENKHUYENMAI,@TYLEVOUCHER,@TIENVOUCHER,@TYLELAILE,@GIAVON,@MAVAT,@VATBAN,@MACHUONGTRINHKM,@UNITCODE)");
command2.CommandText = queryInsertItem;
command2.CommandType = CommandType.Text;
command2.Parameters.Add("ID", SqlDbType.NVarChar, 50).Value = itemData.ID;
command2.Parameters.Add("MAGDQUAYPK", SqlDbType.NVarChar, 50).Value = itemData.MAGDQUAYPK;
command2.Parameters.Add("MAKHOHANG", SqlDbType.NVarChar, 50).Value = itemData.MAKHOHANG;
command2.Parameters.Add("MADONVI", SqlDbType.NVarChar, 50).Value = itemData.MADONVI;
command2.Parameters.Add("MAVATTU", SqlDbType.NVarChar, 50).Value = itemData.MAVATTU;
command2.Parameters.Add("MANGUOITAO", SqlDbType.NVarChar, 50).Value = Session.Session.CurrentMaNhanVien;
command2.Parameters.Add("NGUOITAO", SqlDbType.NVarChar, 50).Value = itemData.NGUOITAO;
command2.Parameters.Add("MABOPK", SqlDbType.NVarChar, 50).Value = itemData.MABOPK;
command2.Parameters.Add("NGAYTAO", SqlDbType.Date).Value = itemData.NGAYTAO;
command2.Parameters.Add("NGAYPHATSINH", SqlDbType.Date).Value = itemData.NGAYPHATSINH;
command2.Parameters.Add("SOLUONG", SqlDbType.Decimal).Value = itemData.SOLUONG;
command2.Parameters.Add("TTIENCOVAT", SqlDbType.Decimal).Value = itemData.TTIENCOVAT;
command2.Parameters.Add("GIABANLECOVAT", SqlDbType.Decimal).Value = itemData.GIABANLECOVAT;
command2.Parameters.Add("TIENCHIETKHAU", SqlDbType.Decimal).Value = itemData.TIENCHIETKHAU;
command2.Parameters.Add("TYLECHIETKHAU", SqlDbType.Decimal).Value = itemData.TYLECHIETKHAU;
command2.Parameters.Add("TYLEKHUYENMAI", SqlDbType.Decimal).Value = itemData.TYLEKHUYENMAI;
command2.Parameters.Add("TIENKHUYENMAI", SqlDbType.Decimal).Value = itemData.TIENKHUYENMAI;
command2.Parameters.Add("TYLEVOUCHER", SqlDbType.Decimal).Value = itemData.TYLEVOUCHER;
command2.Parameters.Add("TIENVOUCHER", SqlDbType.Decimal).Value = itemData.TIENVOUCHER;
command2.Parameters.Add("TYLELAILE", SqlDbType.Decimal).Value = itemData.TYLELAILE;
command2.Parameters.Add("GIAVON", SqlDbType.Decimal).Value = itemData.GIAVON;
command2.Parameters.Add("MAVAT", SqlDbType.NVarChar, 50).Value = itemData.MAVAT;
command2.Parameters.Add("VATBAN", SqlDbType.Decimal).Value = itemData.VATBAN;
command2.Parameters.Add("MACHUONGTRINHKM", SqlDbType.NVarChar, 50).Value = itemData.MACHUONGTRINHKM;
command2.Parameters.Add("UNITCODE", SqlDbType.NVarChar, 50).Value = itemData.UNITCODE != null ? itemData.UNITCODE : ";";
try
{
command2.ExecuteNonQuery();
mhMT++;
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
catch (Exception x) { }
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
}
}
}
MessageBox.Show("Đã đồng bộ " + hdSV + " hóa đơn trên server với " + mhSV + " mặt hàng \n " + hdMT + " hóa đơn sql với " + mhMT + "mặt hàng");
}
