public int CapNhatKheUocDaTatToan(ApplicationConstant.DonViSuDung CompanyCode) { int SoLuongKheUoc = 0; try { if (CompanyCode.Equals(ApplicationConstant.DonViSuDung.BINHKHANH)) { string nativeQuery = ""; DS_TruyVan dsTruyVan = new DS_TruyVan(); DataSet ds = new DataSet(); // Lay so luong trong TD_KUOCVM nativeQuery = "SELECT COUNT(*) FROM TD_KUOCVM WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongKUOCVM = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongKUOCVM = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM: " + SoLuongKUOCVM); // Lay so luong trong TD_KUOCVM_LSU nativeQuery = "SELECT COUNT(*) FROM TD_KUOCVM_LSU WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongKUOCVM_LSU = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongKUOCVM_LSU = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM_LSU: " + SoLuongKUOCVM_LSU); if (SoLuongKUOCVM.Equals(SoLuongKUOCVM_LSU) && !SoLuongKUOCVM.Equals("0")) { SoLuongKheUoc = Int32.Parse(SoLuongKUOCVM); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM PROCESSING"); nativeQuery = "SELECT MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU FROM TD_KUOCVM WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KUOCVM = ds.Tables[0].Rows[i][0].ToString(); string SO_DU = ds.Tables[0].Rows[i][1].ToString(); string SO_TIEN_GIAI_NGAN = ds.Tables[0].Rows[i][2].ToString(); string GOC_DA_THU = ds.Tables[0].Rows[i][3].ToString(); string LAI_PHAI_THU = ds.Tables[0].Rows[i][4].ToString(); string LAI_DA_THU = ds.Tables[0].Rows[i][5].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KUOCVM + ", " + SO_DU + ", " + SO_TIEN_GIAI_NGAN + ", " + GOC_DA_THU + ", " + LAI_PHAI_THU + ", " + LAI_DA_THU); } nativeQuery = "UPDATE TD_KUOCVM SET SO_DU = 0 WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "KUOCVM_LSU PROCESSING"); nativeQuery = "SELECT MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU FROM TD_KUOCVM_LSU WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KUOCVM = ds.Tables[0].Rows[i][0].ToString(); string SO_DU = ds.Tables[0].Rows[i][1].ToString(); string SO_TIEN_GIAI_NGAN = ds.Tables[0].Rows[i][2].ToString(); string GOC_DA_THU = ds.Tables[0].Rows[i][3].ToString(); string LAI_PHAI_THU = ds.Tables[0].Rows[i][4].ToString(); string LAI_DA_THU = ds.Tables[0].Rows[i][5].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KUOCVM, SO_DU, SO_TIEN_GIAI_NGAN, GOC_DA_THU, LAI_PHAI_THU, LAI_DA_THU"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KUOCVM + ", " + SO_DU + ", " + SO_TIEN_GIAI_NGAN + ", " + GOC_DA_THU + ", " + LAI_PHAI_THU + ", " + LAI_DA_THU); } nativeQuery = "UPDATE TD_KUOCVM_LSU SET SO_DU = 0 WHERE SO_DU > 0 AND TTHAI_KUOC = 'DTT'"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } } } return(SoLuongKheUoc); } catch (System.Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }
public int CapNhatSoTietKiem(ApplicationConstant.DonViSuDung CompanyCode) { int SoLuongSoTietKiem = 0; try { if (CompanyCode.Equals(ApplicationConstant.DonViSuDung.BINHKHANH)) { string nativeQuery = ""; DS_TruyVan dsTruyVan = new DS_TruyVan(); DataSet ds = new DataSet(); // Lay so luong trong TD_KUOCVM nativeQuery = "SELECT COUNT(*) FROM BL_TIEN_GUI where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongSo = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongSo = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "SoLuongSo: " + SoLuongSo); // Lay so luong trong TD_KUOCVM_LSU nativeQuery = "SELECT COUNT(*) FROM BL_TIEN_GUI_LSU where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); string SoLuongSo_LSU = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { SoLuongSo_LSU = ds.Tables[0].Rows[0][0].ToString(); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "SoLuongSo_LSU: " + SoLuongSo_LSU); if (SoLuongSo.Equals(SoLuongSo_LSU) && !SoLuongSo.Equals("0")) { SoLuongSoTietKiem = Int32.Parse(SoLuongSo); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "BL_TIEN_GUI PROCESSING"); nativeQuery = "SELECT MA_KHANG, SO_SO_TG FROM BL_TIEN_GUI where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KHANG = ds.Tables[0].Rows[i][0].ToString(); string SO_SO_TG = ds.Tables[0].Rows[i][1].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KHANG, SO_SO_TG"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KHANG + ", " + SO_SO_TG); } nativeQuery = "UPDATE BL_TIEN_GUI SET DU_CHI_LAI = 0 WHERE DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "BL_TIEN_GUI_LSU PROCESSING"); nativeQuery = "SELECT MA_KHANG, SO_SO_TG FROM BL_TIEN_GUI_LSU where DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string MA_KHANG = ds.Tables[0].Rows[i][0].ToString(); string SO_SO_TG = ds.Tables[0].Rows[i][1].ToString(); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, "MA_KHANG, SO_SO_TG"); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, MA_KHANG + ", " + SO_SO_TG); } nativeQuery = "UPDATE BL_TIEN_GUI_LSU SET DU_CHI_LAI = 0 WHERE DU_CHI_LAI is NULL"; LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, nativeQuery); ds = dsTruyVan.GetData(nativeQuery); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.BUS, ds.ToString()); } } } return(SoLuongSoTietKiem); } catch (System.Exception ex) { LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); throw ex; } }