/// <summary>
/// Phương thức khởi tạo
/// </summary>
static UtilitiesProcess()
{
EndpointAddress endpointAddressTruyVan = Common.Utilities.getEndpointAddress(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
BasicHttpBinding basicHttpBindingTruyVan = Common.Utilities.getBasicHttpBinding(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
ClientTruyVan = new TruyVanServiceClient(basicHttpBindingTruyVan, endpointAddressTruyVan);
foreach (var operationDescription in ClientTruyVan.Endpoint.Contract.Operations)
{
DataContractSerializerOperationBehavior dcsob =
operationDescription.Behaviors.Find <DataContractSerializerOperationBehavior>();
if (dcsob != null)
{
dcsob.MaxItemsInObjectGraph = 2147483646;
}
}
//Client = new UtilitiesServiceClient();
EndpointAddress endpointAddress = Common.Utilities.getEndpointAddress(ApplicationConstant.SystemService.UtilitiesService.layGiaTri());
BasicHttpBinding basicHttpBinding = Common.Utilities.getBasicHttpBinding(ApplicationConstant.SystemService.UtilitiesService.layGiaTri());
Client = new UtilitiesServiceClient(basicHttpBinding, endpointAddress);
foreach (var operationDescription in Client.Endpoint.Contract.Operations)
{
DataContractSerializerOperationBehavior dcsob =
operationDescription.Behaviors.Find <DataContractSerializerOperationBehavior>();
if (dcsob != null)
{
dcsob.MaxItemsInObjectGraph = 2147483646;
}
}
}
public DataSet getTreeView(string maDonVi, string userName)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
//Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
//LDatatable.AddParameter(ref dt, "@TrangThaiNVU", "STRING", BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri());
//LDatatable.AddParameter(ref dt, "@TrangThaiSDU", "STRING", BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri());
LDatatable.AddParameter(ref dt, "@INP_MA_DVI", "string", maDonVi);
LDatatable.AddParameter(ref dt, "@INP_USER_NAME", "string", userName);
request.dtThamSo = dt;
request.objectName = "INQ.TREE.KHU_VUC_TDVM";
request.inquiryName = "TREE_VIEW";
// Lấy kết quả trả về
TruyVanServiceClient ClientTruyVan = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
response = ClientTruyVan.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
return(response.dsResult);
}
/// <summary>
/// Lấy thông tin giao dịch khách hàng, hợp đồng tín dụng, tiền gửi tiết kiệm
/// </summary>
/// <param name="id">ID khách hàng</param>
/// <returns></returns>
public DataSet GetThongTinGiaoDichTietKiem(int id, string maSoTG)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
//Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@ID_TIEN_GUI", "INT", id.ToString());
LDatatable.AddParameter(ref dt, "@MA_TIEN_GUI", "INT", maSoTG);
request.dtThamSo = dt;
request.inquiryName = "DANHSACH.GIAODICH";
request.objectName = "INQ.KTDL.KHTV_GDICH_TIETKIEM";
// Lấy kết quả trả về
TruyVanServiceClient client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
response = client.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
return(response.dsResult);
}
public DataSet GetTaiKhoanHachToan(string maDoiTuong, string maDonVi)
{
// Kiểm tra kết nối, server, service trước khi request
TruyVanServiceClient client = null;
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
// Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@MA_PHAN_HE", "STRING", DatabaseConstant.Module.DMDC.getValue());
LDatatable.AddParameter(ref dt, "@MA_DTUONG", "STRING", maDoiTuong);
LDatatable.AddParameter(ref dt, "@MA_DON_VI", "STRING", maDonVi);
request.dtThamSo = dt;
request.objectName = "INQ.CT.BIEU_PHI";
request.inquiryName = "TAI_KHOAN_HACH_TOAN";
// Lấy kết quả trả về
response = client.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
return(response.dsResult);
}
public DataSet GetTaiKhoanHachToan(string maDoiTuong, string maDonVi)
{
TruyVanServiceClient client = null;
TruyVanRequest request = null;
TruyVanResponse response = null;
try
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
response = new TruyVanServiceRef.TruyVanResponse();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@MA_PHAN_HE", "STRING", DatabaseConstant.Module.TDTT.getValue());
LDatatable.AddParameter(ref dt, "@MA_DTUONG", "STRING", maDoiTuong);
LDatatable.AddParameter(ref dt, "@MA_DON_VI", "STRING", maDonVi);
request.dtThamSo = dt;
request.objectName = "INQ.CT.TD_SAN_PHAM";
request.inquiryName = "TAI_KHOAN_HACH_TOAN";
// make a call to service client here
response = client.TruyVanMessage(request);
//Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
DataSet ds = response.dsResult;
return(ds);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (client.State == CommunicationState.Faulted)
{
client.Abort();
}
else
{
client.Close();
}
client = null;
request = null;
response = null;
}
}
public DataSet GetHanMucChiTiet(string maLoaiDTuong, string maDTuong, string module, string tinhNang)
{
TruyVanServiceClient client = null;
TruyVanRequest request = null;
TruyVanResponse response = null;
try
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
response = new TruyVanServiceRef.TruyVanResponse();
//Khởi tạo request
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@MA_DTUONG_LOAI", "STRING", maLoaiDTuong);
LDatatable.AddParameter(ref dt, "@MA_DTUONG", "STRING", maDTuong);
LDatatable.AddParameter(ref dt, "@MODULE", "STRING", module);
LDatatable.AddParameter(ref dt, "@TINH_NANG", "STRING", tinhNang);
request.dtThamSo = dt;
request.objectName = "INQ.DS.HAN_MUC";
request.inquiryName = "CHI_TIET";
// make a call to service client here
response = client.TruyVanMessage(request);
//Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
DataSet ds = response.dsResult;
return(ds);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (client.State == CommunicationState.Faulted)
{
client.Abort();
}
else
{
client.Close();
}
client = null;
request = null;
response = null;
}
}
public DataSet GetDanhSachHanMucKhachHangChiTiet(DataTable dt)
{
TruyVanServiceClient client = null;
TruyVanRequest request = null;
TruyVanResponse response = null;
try
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
response = new TruyVanServiceRef.TruyVanResponse();
//Khởi tạo request
//DataTable dt = null;
//LDatatable.MakeParameterTable(ref dt);
//LDatatable.AddParameter(ref dt, "@TRANG_THAI_NVU", "STRING", trangThaiNVu);
//LDatatable.AddParameter(ref dt, "@MA_DVI", "STRING", maDonVi);
request.dtThamSo = dt;
request.objectName = "INQ.DS.HMUC_KHACH_HANG_CTIET";
request.inquiryName = "DANH_SACH";
// make a call to service client here
response = client.TruyVanMessage(request);
//Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
DataSet ds = response.dsResult;
return(ds);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (client.State == CommunicationState.Faulted)
{
client.Abort();
}
else
{
client.Close();
}
client = null;
request = null;
response = null;
}
}
/// <summary>
/// Phương thức khởi tạo
/// </summary>
static LaiSuatProcess()
{
EndpointAddress endpointAddressTruyVan = Common.Utilities.getEndpointAddress(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
BasicHttpBinding basicHttpBindingTruyVan = Common.Utilities.getBasicHttpBinding(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
ClientTruyVan = new TruyVanServiceClient(basicHttpBindingTruyVan, endpointAddressTruyVan);
//Client = new LaiSuatServiceClient();
EndpointAddress endpointAddress = Common.Utilities.getEndpointAddress(ApplicationConstant.SystemService.LaiSuatService.layGiaTri());
BasicHttpBinding basicHttpBinding = Common.Utilities.getBasicHttpBinding(ApplicationConstant.SystemService.LaiSuatService.layGiaTri());
Client = new LaiSuatServiceClient(basicHttpBinding, endpointAddress);
}
public DataSet GetResultCT(DataTable dt)
{
TruyVanServiceClient client = null;
TruyVanRequest request = null;
TruyVanResponse response = null;
try
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
client = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
response = new TruyVanServiceRef.TruyVanResponse();
//Khởi tạo request
request.dtThamSo = dt;
request.objectName = "INQ.DS.COB";
request.inquiryName = "RESULT_CT";
// make a call to service client here
response = client.TruyVanMessage(request);
//Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
DataSet ds = response.dsResult;
return(ds);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (client.State == CommunicationState.Faulted)
{
client.Abort();
}
else
{
client.Close();
}
client = null;
request = null;
response = null;
}
}
public DataSet getDSKhachHangBTV(string idCum, string ngayHienTai, string ngayThu, string idKhang)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
TruyVanServiceClient ClientTruyVan = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
// Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
try
{
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@ID_CUM", "String", idCum);
LDatatable.AddParameter(ref dt, "@NGAY_HIEN_TAI", "String", ngayHienTai);
LDatatable.AddParameter(ref dt, "@NGAY_THU", "String", ngayThu);
LDatatable.AddParameter(ref dt, "@ID_KHANG", "String", idKhang);
request.dtThamSo = dt;
request.objectName = "INQ.POPUP.DS_KHACH_HANG_HDTK_BTV";
request.inquiryName = "DANH_SACH";
// Lấy kết quả trả về
response = ClientTruyVan.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (ClientTruyVan.State == CommunicationState.Faulted)
{
ClientTruyVan.Abort();
}
else
{
ClientTruyVan.Close();
}
}
return(response.dsResult);
}
public DataSet getDSSoTKBTV(string maKheUoc, string ngayGDich, string idGDich)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
TruyVanServiceClient ClientTruyVan = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
// Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
try
{
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@MA_KUOCVM", "String", maKheUoc);
LDatatable.AddParameter(ref dt, "@NGAY_GDICH", "String", ngayGDich);
LDatatable.AddParameter(ref dt, "@ID_GDICH", "String", idGDich);
request.dtThamSo = dt;
request.objectName = "INQ.DS_SO_TK_HDTK_BTV";
request.inquiryName = "POPUP";
// Lấy kết quả trả về
response = ClientTruyVan.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (ClientTruyVan.State == CommunicationState.Faulted)
{
ClientTruyVan.Abort();
}
else
{
ClientTruyVan.Close();
}
}
return(response.dsResult);
}
/// <summary>
/// Khởi tạo service TruyVanService
/// </summary>
/// <param name="service"></param>
/// <returns></returns>
private TruyVanServiceClient TruyVanServiceClient(ApplicationConstant.SystemService service)
{
EndpointAddress endpointAddress = Common.Utilities.getEndpointAddress(service.layGiaTri());
BasicHttpBinding basicHttpBinding = Common.Utilities.getBasicHttpBinding(service.layGiaTri());
TruyVanServiceClient Client = new TruyVanServiceClient(basicHttpBinding, endpointAddress);
foreach (var operationDescription in Client.Endpoint.Contract.Operations)
{
DataContractSerializerOperationBehavior dcsob =
operationDescription.Behaviors.Find <DataContractSerializerOperationBehavior>();
if (dcsob != null)
{
dcsob.MaxItemsInObjectGraph = 2147483646;
}
}
return(Client);
}
public DataSet getDSKhachHangBIDV(DataTable dt)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
TruyVanServiceClient ClientTruyVan = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
// Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
try
{
request.typePara = "UDTT";
request.type = "Multi";
request.dtThamSo = dt;
request.objectName = "INQ.POPUP.DS_KHACH_HANG_HDTK_BIDV";
request.inquiryName = "%";
// Lấy kết quả trả về
response = ClientTruyVan.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
if (ClientTruyVan.State == CommunicationState.Faulted)
{
ClientTruyVan.Abort();
}
else
{
ClientTruyVan.Close();
}
}
return(response.dsResult);
}
public DataSet GetDanhSachHanMuc(DataTable dt)
{
// Kiểm tra kết nối, server, service trước khi request
Common.Utilities.IsRequestAllow(ApplicationConstant.SystemService.TruyVanService.layGiaTri());
// Khởi tạo và gán các giá trị cho request
TruyVanServiceRef.TruyVanRequest request = Common.Utilities.PrepareRequest(new TruyVanServiceRef.TruyVanRequest());
TruyVanServiceRef.TruyVanResponse response = new TruyVanServiceRef.TruyVanResponse();
request.dtThamSo = dt;
request.objectName = "INQ.DS.HM_HAN_MUC_TONG";
request.inquiryName = "INQ.DS.HM_HAN_MUC_TONG";
// Lấy kết quả trả về
TruyVanServiceClient ClientTruyVan = TruyVanServiceClient(ApplicationConstant.SystemService.TruyVanService);
response = ClientTruyVan.TruyVanMessage(request);
// Kiểm tra kết quả trả về
Common.Utilities.ValidResponse(request, response);
return(response.dsResult);
}
