public JsonResult UpdateContact(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
//var Oracle = new TM.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "1";
try
{
var qry = $"SELECT * FROM {Common.Objects.TYPE_HD.CD} WHERE KYHOADON='{obj.KYHD}'";
var data = SQLServer.Connection.Query <Models.CD>(qry);
//Get DB PTTB
qry = "SELECT a.*,a.TRANGTHAI_ AS TRANGTHAI FROM DANH_BA_CO_DINH a";
//var dbpttb = Oracle.Connection.Query<Models.DANH_BA_CO_DINH>(qry).ToList();
//
qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL})";
var dbkh = SQLServer.Connection.Query <Models.DB_THANHTOAN_BKN>(qry);
var DataInsert = new List <Models.DB_THANHTOAN_BKN>();
var DataUpdate = new List <Models.DB_THANHTOAN_BKN>();
foreach (var i in data)
{
var _tmp = dbkh.FirstOrDefault(d => d.MA_TB == i.SO_TB);
//var pttb = dbpttb.FirstOrDefault(d => d.MA_TB.Trim() == i.SO_TB);
if (_tmp != null)
{
//if (pttb != null)
//{
// if (!string.IsNullOrEmpty(pttb.MA_KH)) _tmp.MA_KH = pttb.MA_KH.Trim();
//}
_tmp.MA_TT = i.MA_TT;
_tmp.TEN_TT = i.TEN_TT;
_tmp.DIACHI_TT = i.DIACHI_TT;
_tmp.DIENTHOAI = i.SO_TB;
_tmp.MS_THUE = i.MS_THUE;
_tmp.BANKNUMBER = i.BANKNUMBER;
_tmp.MA_DVI = i.MA_DVI;
_tmp.MA_CBT = i.MA_CBT;
_tmp.MA_TUYEN = i.MA_TUYEN;
//_tmp.CUSTCATE = i.CUSTCATE;
//_tmp.STK = i.STK;
_tmp.MA_DT = (!string.IsNullOrEmpty(i.MA_DT) ? Int32.Parse(i.MA_DT) : 1);
_tmp.TH_SD = 1;
_tmp.ISNULL = 0;
_tmp.ISNULLMT = 0;
_tmp.FIX = 0;
_tmp.FLAG = 1;
DataUpdate.Add(_tmp);
}
else
{
var _d = new Models.DB_THANHTOAN_BKN();
_d.ID = Guid.NewGuid();
_d.TYPE_BILL = i.TYPE_BILL;
_d.MA_TB = i.SO_TB;
//if (pttb != null)
//{
// if (!string.IsNullOrEmpty(pttb.MA_KH)) _d.MA_KH = pttb.MA_KH.Trim();
//}
_d.MA_TT = i.MA_TT;
_d.TEN_TT = i.TEN_TT;
_d.DIACHI_TT = i.DIACHI_TT;
_d.DIENTHOAI = i.SO_TB;
_d.MS_THUE = i.MS_THUE;
_d.BANKNUMBER = i.BANKNUMBER;
_d.MA_DVI = i.MA_DVI;
_d.MA_CBT = i.MA_CBT;
_d.MA_TUYEN = i.MA_TUYEN;
//_d.CUSTCATE = i.CUSTCATE;
//_d.STK = i.STK;
_d.MA_DT = (!string.IsNullOrEmpty(i.MA_DT) ? Int32.Parse(i.MA_DT) : 1);
_d.TH_SD = 1;
_d.ISNULL = 0;
_d.ISNULLMT = 0;
_d.FIX = 0;
_d.FLAG = 1;
DataInsert.Add(_d);
}
}
//
if (DataInsert.Count > 0)
{
SQLServer.Connection.Insert(DataInsert);
}
if (DataUpdate.Count > 0)
{
SQLServer.Connection.Update(DataUpdate);
}
//
qry = $"update db set db.DONVI_ID=dv.DONVI_ID,db.DONVI_QL_ID=dv.DONVI_QL_ID from DB_THANHTOAN_BKN db,DB_DONVI_BKN dv where dv.MA_DVI=db.MA_DVI and type_bill in({TYPE_BILL})";
SQLServer.Connection.Query(qry);
//
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_CD} - Cập nhật: {DataUpdate.Count} - Thêm mới: {DataInsert.Count}" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
public JsonResult UpdateContactData(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var Oracle = new TM.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "4";
try
{
//Get DB PTTB
var qry = $"SELECT kh.KHACHHANG_ID,kh.MA_KH,a.THANHTOAN_ID,tt.MA_TT AS MA_TT,tt.MAPHO_ID,b.DICHVUVT_ID,tt.TEN_TT,tt.DIACHI_TT,tt.DIENTHOAI_TT AS DIENTHOAI,tt.MST AS MS_THUE,tt.MA_TUYENTHU AS MA_TUYEN,tt.DONVIQL_ID,a.DOITUONG_ID AS MA_DT,tttb.TRANGTHAITB_ID AS TH_SD,a.MA_TB,a.MA_TB AS MA_TB,a.DOITUONG_ID,a.GHICHU,a.LOAIHINHTB_ID,a.TRANGTHAITB_ID,a.TBDAYCHUNG_ID,a.NGAY_TRANGTHAITB AS NGAY_TTTB,a.NGAY_SUDUNG AS NGAY_SD,a.NGAY_CN,a.NGAY_HT,a.NGAY_CAT,qh.MA_QUANHUYEN AS MA_DVI,b.MA_LHTB FROM DB_THUEBAO_BKN a,DB_THANHTOAN_BKN tt,DB_KHACHHANG_BKN kh,LOAIHINH_TB_BKN b,TRANGTHAI_TB_BKN tttb, MA_PHO_BKN mp,PHUONG_XA_BKN px,QUAN_HUYEN_BKN qh WHERE a.THANHTOAN_ID=tt.THANHTOAN_ID AND tt.KHACHHANG_ID=kh.KHACHHANG_ID AND a.LOAIHINHTB_ID=b.LOAIHINHTB_ID AND tt.MAPHO_ID=mp.MAPHO_ID AND mp.PHUONGXA_ID=px.PHUONGXA_ID AND px.QUANHUYEN_ID=qh.QUANHUYEN_ID AND b.DICHVUVT_ID={TYPE_BILL} AND a.TRANGTHAITB_ID=tttb.TRANGTHAITB_ID ORDER BY qh.MA_QUANHUYEN,a.NGAY_CN,a.MA_TB";
var dbpttb = Oracle.Connection.Query <Models.DANH_BA_TSL>(qry);
//Get data DB_DUONGTHU_BKN
qry = $"SELECT * FROM DB_DUONGTHU_BKN";
var dbdt = SQLServer.Connection.Query <Models.DB_DUONGTHU_BKN>(qry);
//Get data DB KH
qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=0 AND FLAG=1";//AND TYPE_BILL IN({TYPE_BILL})
var dbkh = SQLServer.Connection.Query <Models.DB_THANHTOAN_BKN>(qry);
//Get data TSL Remove
qry = $"SELECT * FROM HD_TSL WHERE TYPE_BILL=9641 AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
var tslRemove = SQLServer.Connection.Query <Models.HD_TSL>(qry);
//
var DataInsert = new List <Models.DB_THANHTOAN_BKN>();
var DataUpdate = new List <Models.DB_THANHTOAN_BKN>();
var DataInsertHD = new List <Models.HD_TSL>();
var _dbkh_id = Guid.Empty;
//Xóa dữ liệu cũ
qry = $"DELETE HD_TSL WHERE TYPE_BILL IN({TYPE_BILL},-1) AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
SQLServer.Connection.Query(qry);
foreach (var i in dbpttb)
{
//check data TSL Remove
if (tslRemove.Any(d => d.MA_TB == i.MA_TB))
{
continue;
}
//Cập nhật hóa đơn TSL
var hdtsl = new Models.HD_TSL();
hdtsl.ID = Guid.NewGuid();
hdtsl.DBKH_ID = _dbkh_id;
hdtsl.TYPE_BILL = int.Parse(TYPE_BILL);
hdtsl.KYHOADON = obj.KYHD;
hdtsl.MAPHO_ID = i.MAPHO_ID;
hdtsl.THANHTOAN_ID = i.THANHTOAN_ID;
hdtsl.THUEBAO_ID = i.THUEBAO_ID;
hdtsl.MA_TB = i.MA_TB;
hdtsl.MA_TB = i.MA_TB;
hdtsl.DOITUONG_ID = i.DOITUONG_ID;
hdtsl.TOC_DO = "TSL";
hdtsl.GHICHU = i.GHICHU;
hdtsl.TT_THANG = 1;
hdtsl.NGAY_TB = obj.day_in_month;
hdtsl.LOAIHINHTB_ID = i.LOAIHINHTB_ID;
hdtsl.MA_LHTB = i.MA_LHTB;
hdtsl.TRANGTHAITB_ID = i.TRANGTHAITB_ID;
hdtsl.TBDAYCHUNG_ID = i.TBDAYCHUNG_ID;
hdtsl.GOICUOCID = i.GOICUOCID;
//hdtsl.ISDATMOI = 0;
//hdtsl.ISHUY = 0;
//hdtsl.ISTTT = 0;
//hdtsl.ISDATCOC = 0;
hdtsl.NGAY_TTTB = i.NGAY_TTTB;
hdtsl.NGAY_SD = i.NGAY_SD;
hdtsl.NGAY_CN = i.NGAY_CN;
hdtsl.NGAY_HT = i.NGAY_HT;
hdtsl.NGAY_CAT = i.NGAY_CAT;
DataInsertHD.Add(hdtsl);
//Cập nhật danh bạ TSL
var _tmp = dbkh.FirstOrDefault(d => d.MA_TB == i.MA_TB);
if (_tmp != null)
{
if (DataUpdate.Any(d => d.MA_TB == i.MA_TB))
{
continue;
}
if (!string.IsNullOrEmpty(i.MA_KH))
{
_tmp.MA_KH = i.MA_KH.Trim();
}
if (!string.IsNullOrEmpty(i.MA_TT))
{
_tmp.MA_TT = i.MA_TT.Trim();
}
if (!string.IsNullOrEmpty(i.TEN_TT))
{
_tmp.TEN_TT = i.TEN_TT.Trim();
}
if (!string.IsNullOrEmpty(i.DIACHI_TT))
{
_tmp.DIACHI_TT = i.DIACHI_TT.Trim();
}
if (!string.IsNullOrEmpty(i.DIENTHOAI))
{
_tmp.DIENTHOAI = i.DIENTHOAI.Trim();
}
//if (!string.IsNullOrEmpty(i.MS_THUE)) _tmp.MS_THUE = i.MS_THUE.Trim();
//_tmp.BANKNUMBER = null;
if (!string.IsNullOrEmpty(i.MA_DVI))
{
_tmp.MA_DVI = i.MA_DVI.Trim();
}
if (!string.IsNullOrEmpty(i.MA_TUYEN))
{
_tmp.MA_TUYEN = i.MA_TUYEN.Trim().ToUpper();
}
//if (!string.IsNullOrEmpty(i.MA_CBT)) _tmp.MA_CBT = i.MA_CBT.Trim();
var ma_cbt = dbdt.FirstOrDefault(d => d.MA_DT == _tmp.MA_TUYEN);
_tmp.MA_CBT = ma_cbt != null ? ma_cbt.MA_DT_GOC : null;
//if (!string.IsNullOrEmpty(i.CUSTCATE)) _tmp.CUSTCATE = i.CUSTCATE.Trim();
//_tmp.STK = null;
_tmp.DONVI_ID = i.DONVI_ID;
_tmp.KHACHHANG_ID = i.KHACHHANG_ID;
_tmp.THANHTOAN_ID = i.THANHTOAN_ID;
_tmp.MA_DT = i.MA_DT;
_tmp.TH_SD = i.TH_SD;
_tmp.ISNULL = 0;
_tmp.ISNULLMT = 0;
_tmp.FIX = 0;
_tmp.FLAG = 1;
//MA_TB Json
//var MA_TB_json = Newtonsoft.Json.JsonConvert.DeserializeObject<Models.MA_TB_JSON>(_tmp.MA_TB);
//MA_TB_json.TSL = i.MA_TB;
//_tmp.MA_TB = Newtonsoft.Json.JsonConvert.SerializeObject(MA_TB_json);
_tmp.MA_TB = i.MA_TB;
//
_dbkh_id = _tmp.ID;
DataUpdate.Add(_tmp);
//SQLServer.Connection.Update(_tmp);
}
else
{
if (DataInsert.Any(d => d.MA_TB == i.MA_TB))
{
continue;
}
var _d = new Models.DB_THANHTOAN_BKN();
_d.ID = _dbkh_id = Guid.NewGuid();
_d.TYPE_BILL = int.Parse(TYPE_BILL);
_d.MA_TB = _d.MA_TB = i.MA_TB;
if (!string.IsNullOrEmpty(i.MA_KH))
{
_d.MA_KH = i.MA_KH.Trim();
}
if (!string.IsNullOrEmpty(i.MA_TT))
{
_d.MA_TT = i.MA_TT.Trim();
}
if (!string.IsNullOrEmpty(i.TEN_TT))
{
_d.TEN_TT = i.TEN_TT.Trim();
}
if (!string.IsNullOrEmpty(i.TEN_TT))
{
_d.DIACHI_TT = i.TEN_TT.Trim();
}
if (!string.IsNullOrEmpty(i.DIENTHOAI))
{
_d.DIENTHOAI = i.DIENTHOAI.Trim();
}
//if (!string.IsNullOrEmpty(i.MA_ST)) _d.MS_THUE = i.MA_ST.Trim();
//_tmp.BANKNUMBER = null;
if (!string.IsNullOrEmpty(i.MA_DVI))
{
_d.MA_DVI = i.MA_DVI.Trim();
}
if (!string.IsNullOrEmpty(i.MA_TUYEN))
{
_d.MA_TUYEN = i.MA_TUYEN.Trim().ToUpper();
}
//if (!string.IsNullOrEmpty(i.MA_CBT)) _d.MA_CBT = i.MA_CBT.Trim();
var ma_cbt = dbdt.FirstOrDefault(d => d.MA_DT == _d.MA_TUYEN);
_d.MA_CBT = ma_cbt != null ? ma_cbt.MA_DT_GOC : null;
//if (!string.IsNullOrEmpty(i.CUSTCATE)) _d.CUSTCATE = i.CUSTCATE.Trim();
//_tmp.STK = null;
_d.DONVI_ID = i.DONVI_ID;
_d.KHACHHANG_ID = i.KHACHHANG_ID;
_d.THANHTOAN_ID = i.THANHTOAN_ID;
_d.MA_DT = i.MA_DT;
_d.TH_SD = i.TH_SD;
_d.ISNULL = 0;
_d.ISNULLMT = 0;
_d.FIX = 0;
_d.FLAG = 1;
//MA_TB Json
//var MA_TB_json = new Models.MA_TB_JSON();
//MA_TB_json.TSL = i.MA_TB;
//_d.MA_TB = Newtonsoft.Json.JsonConvert.SerializeObject(MA_TB_json);
_d.MA_TB = i.MA_TB;
DataInsert.Add(_d);
}
}
//
if (DataInsert.Count > 0)
{
SQLServer.Connection.Insert(DataInsert);
}
if (DataUpdate.Count > 0)
{
SQLServer.Connection.Update(DataUpdate);
}
//
if (DataInsertHD.Count > 0)
{
SQLServer.Connection.Insert(DataInsertHD);
}
//UPDATE NULL
qry = $@"UPDATE {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} SET ISNULLMT=1,MA_TUYEN=REPLACE(MA_TUYEN,'000','001') WHERE MA_TUYEN LIKE '%000' AND FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL});
UPDATE {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} SET MA_CBT=CAST(CAST(ma_dvi as varchar)+'01' as int) WHERE ISNULLMT=1 AND FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL});";
SQLServer.Connection.Query(qry);
//
return(Json(new { success = $"TSL - Cập nhật: {DataUpdate.Count} - Thêm mới: {DataInsert.Count}" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally
{
SQLServer.Close();
Oracle.Close();
}
}
public JsonResult UpdateContact(Common.DefaultObj obj)
{
var HNIVNPTBACKAN1 = new TM.Core.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "1";
try {
var qry = $"SELECT * FROM {Common.Objects.TYPE_HD.CD} WHERE FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
var data = _Con.Connection.Query <Models.CD>(qry);
//Get DB PTTB
qry = "SELECT a.*,a.TRANGTHAI_ AS TRANGTHAI FROM DANH_BA_CO_DINH a";
var dbpttb = HNIVNPTBACKAN1.Connection.Query <Models.DANH_BA_CO_DINH>(qry).ToList();
//
qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL})";
var dbkh = _Con.Connection.Query <Models.DB_THANHTOAN_BKN>(qry);
var DataInsert = new List <Models.DB_THANHTOAN_BKN>();
var DataUpdate = new List <Models.DB_THANHTOAN_BKN>();
foreach (var i in data)
{
var _tmp = dbkh.FirstOrDefault(d => d.ACCOUNT == i.SO_TB);
var pttb = dbpttb.FirstOrDefault(d => d.MA_TB.Trim() == i.SO_TB);
if (_tmp != null)
{
if (pttb != null)
{
if (!string.IsNullOrEmpty(pttb.MA_KH))
{
_tmp.MA_KH = pttb.MA_KH.Trim();
}
}
_tmp.MA_TT_HNI = i.MA_TT;
_tmp.TEN_TT = i.TEN_TT;
_tmp.DIACHI_TT = i.DIACHI_TT;
_tmp.DIENTHOAI = i.SO_TB;
_tmp.MS_THUE = i.MS_THUE;
_tmp.BANKNUMBER = i.BANKNUMBER;
_tmp.MA_DVI = i.MA_DVI;
_tmp.MA_CBT = i.MA_CBT;
_tmp.MA_TUYEN = i.MA_TUYEN;
//_tmp.CUSTCATE = i.CUSTCATE;
//_tmp.STK = i.STK;
_tmp.MA_DT = (!string.IsNullOrEmpty(i.MA_DT) ? Int32.Parse(i.MA_DT) : 1);
_tmp.TH_SD = 1;
_tmp.ISNULL = 0;
_tmp.ISNULLMT = 0;
_tmp.FIX = 0;
_tmp.FLAG = 1;
DataUpdate.Add(_tmp);
}
else
{
var _d = new Models.DB_THANHTOAN_BKN();
_d.ID = Guid.NewGuid();
_d.TYPE_BILL = i.TYPE_BILL;
_d.ACCOUNT = _d.MA_TB = i.SO_TB;
if (pttb != null)
{
if (!string.IsNullOrEmpty(pttb.MA_KH))
{
_d.MA_KH = pttb.MA_KH.Trim();
}
}
_d.MA_TT_HNI = i.MA_TT;
_d.TEN_TT = i.TEN_TT;
_d.DIACHI_TT = i.DIACHI_TT;
_d.DIENTHOAI = i.SO_TB;
_d.MS_THUE = i.MS_THUE;
_d.BANKNUMBER = i.BANKNUMBER;
_d.MA_DVI = i.MA_DVI;
_d.MA_CBT = i.MA_CBT;
_d.MA_TUYEN = i.MA_TUYEN;
//_d.CUSTCATE = i.CUSTCATE;
//_d.STK = i.STK;
_d.MA_DT = (!string.IsNullOrEmpty(i.MA_DT) ? Int32.Parse(i.MA_DT) : 1);
_d.TH_SD = 1;
_d.ISNULL = 0;
_d.ISNULLMT = 0;
_d.FIX = 0;
_d.FLAG = 1;
DataInsert.Add(_d);
}
}
//
if (DataInsert.Count > 0)
{
_Con.Connection.Insert(DataInsert);
}
if (DataUpdate.Count > 0)
{
_Con.Connection.Update(DataUpdate);
}
//
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_CD} - Cập nhật: {DataUpdate.Count} - Thêm mới: {DataInsert.Count}" }));
} catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index })); } finally { _Con.Close(); }
}
public JsonResult UpdateContact(Common.DefaultObj obj)
{
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "2";
try {
var qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DD} WHERE FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
var data = _Con.Connection.Query <Models.DD>(qry);
//
qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL})";
var dbkh = _Con.Connection.Query <Models.DB_THANHTOAN_BKN>(qry);
var DataInsert = new List <Models.DB_THANHTOAN_BKN>();
var DataUpdate = new List <Models.DB_THANHTOAN_BKN>();
foreach (var i in data)
{
var _tmp = dbkh.FirstOrDefault(d => d.ACCOUNT == i.SO_TB);
if (_tmp != null)
{
_tmp.MA_KH = i.MA_KH;
_tmp.MA_TT_HNI = i.MA_TT;
_tmp.TEN_TT = i.TEN_TT;
_tmp.DIACHI_TT = i.DIACHI_TT;
_tmp.DIENTHOAI = i.SO_TB;
_tmp.MS_THUE = i.MS_THUE;
_tmp.BANKNUMBER = i.BANKNUMBER;
if (i.MA_DVI.HasValue)
{
_tmp.MA_DVI = i.MA_DVI.Value.ToString();
}
if (i.MA_CBT.HasValue)
{
_tmp.MA_CBT = i.MA_CBT.Value.ToString();
}
_tmp.MA_TUYEN = i.MA_TUYEN;
//_tmp.CUSTCATE = i.CUSTCATE;
//_tmp.STK = i.STK;
_tmp.MA_DT = i.DTUONG_ID.HasValue ? i.DTUONG_ID.Value : 1;
_tmp.TH_SD = 1;
_tmp.ISNULL = 0;
_tmp.ISNULLMT = 0;
_tmp.FIX = 0;
_tmp.FLAG = 1;
DataUpdate.Add(_tmp);
}
else
{
var _d = new Models.DB_THANHTOAN_BKN();
_d.ID = Guid.NewGuid();
_d.TYPE_BILL = i.TYPE_BILL;
_d.ACCOUNT = _d.MA_TB = i.SO_TB;
_d.MA_KH = i.MA_KH;
_d.MA_TT_HNI = i.MA_TT;
_d.TEN_TT = i.TEN_TT;
_d.DIACHI_TT = i.DIACHI_TT;
_d.DIENTHOAI = i.SO_TB;
_d.MS_THUE = i.MS_THUE;
_d.BANKNUMBER = i.BANKNUMBER;
if (i.MA_DVI.HasValue)
{
_d.MA_DVI = i.MA_DVI.Value.ToString();
}
if (i.MA_CBT.HasValue)
{
_d.MA_CBT = i.MA_CBT.Value.ToString();
}
_d.MA_TUYEN = i.MA_TUYEN;
//_d.CUSTCATE = i.CUSTCATE;
//_d.STK = i.STK;
_d.MA_DT = i.DTUONG_ID.HasValue ? i.DTUONG_ID.Value : 1;
_d.TH_SD = 1;
_d.ISNULL = 0;
_d.ISNULLMT = 0;
_d.FIX = 0;
_d.FLAG = 1;
DataInsert.Add(_d);
}
}
//
if (DataInsert.Count > 0)
{
_Con.Connection.Insert(DataInsert);
}
if (DataUpdate.Count > 0)
{
_Con.Connection.Update(DataUpdate);
}
//
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_CD} - Cập nhật: {DataUpdate.Count} - Thêm mới: {DataInsert.Count}" }));
} catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index })); } finally { _Con.Close(); }
}
public JsonResult UpdateContact(Common.DefaultObj obj)
{
var SQLServer = new TM.Connection.SQLServer();
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "2";
try
{
var qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DD} WHERE KYHOADON='{obj.KYHD}'";
var data = SQLServer.Connection.Query <Models.DD>(qry);
//
qry = $"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=0 AND FLAG=1 AND TYPE_BILL IN({TYPE_BILL})";
var dbkh = SQLServer.Connection.Query <Models.DB_THANHTOAN_BKN>(qry);
var DataInsert = new List <Models.DB_THANHTOAN_BKN>();
var DataUpdate = new List <Models.DB_THANHTOAN_BKN>();
foreach (var i in data)
{
var _tmp = dbkh.FirstOrDefault(d => d.MA_TB == i.SO_TB);
if (_tmp != null)
{
_tmp.MA_KH = i.MA_KH;
_tmp.MA_TT = i.MA_TT;
_tmp.TEN_TT = i.TEN_TT;
_tmp.DIACHI_TT = i.DIACHI_TT;
_tmp.DIENTHOAI = i.SO_TB;
_tmp.MS_THUE = i.MS_THUE;
_tmp.BANKNUMBER = i.BANKNUMBER;
if (i.MA_DVI.HasValue)
{
_tmp.MA_DVI = i.MA_DVI.Value.ToString();
}
if (i.MA_CBT.HasValue)
{
_tmp.MA_CBT = i.MA_CBT.Value.ToString();
}
_tmp.MA_TUYEN = i.MA_TUYEN;
//_tmp.CUSTCATE = i.CUSTCATE;
//_tmp.STK = i.STK;
_tmp.MA_DT = i.DTUONG_ID.HasValue ? i.DTUONG_ID.Value : 1;
_tmp.TH_SD = 1;
_tmp.ISNULL = 0;
_tmp.ISNULLMT = 0;
_tmp.FIX = 0;
_tmp.FLAG = 1;
DataUpdate.Add(_tmp);
}
else
{
var _d = new Models.DB_THANHTOAN_BKN();
_d.ID = Guid.NewGuid();
_d.TYPE_BILL = i.TYPE_BILL;
_d.MA_TB = i.SO_TB;
_d.MA_KH = i.MA_KH;
_d.MA_TT = i.MA_TT;
_d.TEN_TT = i.TEN_TT;
_d.DIACHI_TT = i.DIACHI_TT;
_d.DIENTHOAI = i.SO_TB;
_d.MS_THUE = i.MS_THUE;
_d.BANKNUMBER = i.BANKNUMBER;
if (i.MA_DVI.HasValue)
{
_d.MA_DVI = i.MA_DVI.Value.ToString();
}
if (i.MA_CBT.HasValue)
{
_d.MA_CBT = i.MA_CBT.Value.ToString();
}
_d.MA_TUYEN = i.MA_TUYEN;
//_d.CUSTCATE = i.CUSTCATE;
//_d.STK = i.STK;
_d.MA_DT = i.DTUONG_ID.HasValue ? i.DTUONG_ID.Value : 1;
_d.TH_SD = 1;
_d.ISNULL = 0;
_d.ISNULLMT = 0;
_d.FIX = 0;
_d.FLAG = 1;
DataInsert.Add(_d);
}
}
//
if (DataInsert.Count > 0)
{
SQLServer.Connection.Insert(DataInsert);
}
if (DataUpdate.Count > 0)
{
SQLServer.Connection.Update(DataUpdate);
}
//
qry = $"update db set db.DONVI_ID=dv.DONVI_ID,db.DONVI_QL_ID=dv.DONVI_QL_ID from DB_THANHTOAN_BKN db,DB_DONVI_BKN dv where dv.MA_DVI=db.MA_DVI and type_bill in({TYPE_BILL})";
SQLServer.Connection.Query(qry);
//
return(Json(new { success = $"{Common.Objects.TYPE_HD.HD_CD} - Cập nhật: {DataUpdate.Count} - Thêm mới: {DataInsert.Count}" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index }, JsonRequestBehavior.AllowGet)); }
finally { SQLServer.Close(); }
}
