/// <summary>
/// Thêm
/// </summary>
private void OnAddNew(List <DataRowView> lstDataRowView)
{
List <BC_MATK_MAPPING> lstObj = new List <BC_MATK_MAPPING>();
Mouse.OverrideCursor = Cursors.Wait;
try
{
KhaiThacDuLieuProcess processKTDL = new KhaiThacDuLieuProcess();
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
bool ret = false;
string maTK = getSeletedRowCTieu()["MATK"].ToString();
string maLoaiTK = getSeletedRowLoaiTK()["MA_LOAITK"].ToString();
string loaiBCTK = getSeletedRowLoaiTK()["LOAI_BCTK"].ToString();
string maDviQly = ClientInformation.MaDonVi;
string maDviTao = ClientInformation.MaDonViGiaoDich;
string ngayNhap = Convert.ToDateTime(DateTime.Today).ToString("yyyyMMdd");
string nguoiNhap = ClientInformation.TenDangNhap;
string ttBGhi = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri();
string ttNVu = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri();
if (lstDataRowView.Count > 0)
{
foreach (DataRowView drv in lstDataRowView)
{
BC_MATK_MAPPING obj = new BC_MATK_MAPPING();
obj.MA_MAPPING = drv["MA_DKIEN"].ToString();
obj.MATK = maTK;
obj.MA_LOAITK = maLoaiTK;
obj.LOAI_BCTK = loaiBCTK;
obj.MA_DVI_QLY = maDviQly;
obj.MA_DVI_TAO = maDviTao;
obj.NGAY_NHAP = ngayNhap;
obj.NGUOI_NHAP = nguoiNhap;
obj.TTHAI_BGHI = ttBGhi;
obj.TTHAI_NVU = ttNVu;
lstObj.Add(obj);
}
}
else
{
BC_MATK_MAPPING obj = new BC_MATK_MAPPING();
obj.MATK = maTK;
obj.MA_LOAITK = maLoaiTK;
obj.TTHAI_LY_DO = "UncheckAll";
lstObj.Add(obj);
}
ret = processKTDL.Mapping(DatabaseConstant.Action.THEM, ref lstObj, ref listClientResponseDetail);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void ShowData()
{
try
{
// Lấy dữ liệu từ form điều kiện
List <HT_BAOCAO_TSO> listHtBaoCaoTso = new List <HT_BAOCAO_TSO>();
DatabaseConstant.Action action = DatabaseConstant.Action.TRUY_VAN;
DataSet ds = null;
// Lấy báo cáo được chọn từ grid
DataRowView dr = (DataRowView)grDSBaoCao.SelectedItem;
int idBaoCao = int.Parse(dr[0].ToString());
int idBaoCaoCha = int.Parse(dr[4].ToString());
string maBaoCao = dr[2].ToString();
string responseMessage = "";
if (idBaoCao > 0)
{
MethodInfo mi = uc.GetType().GetMethod("GetParameters");
Delegate dieuKienBaoCao = Delegate.CreateDelegate(typeof(DieuKienBaoCao), uc, mi);
if (!LObject.IsNullOrEmpty(dieuKienBaoCao))
{
KhaiThacDuLieuProcess process = new KhaiThacDuLieuProcess();
DieuKienBaoCao dlgdieukienBaoCao = (DieuKienBaoCao)dieuKienBaoCao;
List <Tuple <string, string> > dsDieuKienBC;
dlgdieukienBaoCao(out dsDieuKienBC);
foreach (Tuple <string, string> tuple in dsDieuKienBC)
{
HT_BAOCAO_TSO tso = new HT_BAOCAO_TSO();
tso.MA_TSO = tuple.Item2;
tso.LOAI_TSO = ApplicationConstant.LoaiThamSoBaoCao.SQL.layGiaTri();
tso.GTRI_TSO = tuple.Item1;
listHtBaoCaoTso.Add(tso);
}
if (process.DuLieuChiTieu(action, idBaoCao, ref htBaoCao, ref listHtBaoCaoTso, ref ds, ref responseMessage) == ApplicationConstant.ResponseStatus.THANH_CONG)
{
mi = uc.GetType().GetMethod("BuildData");
Delegate buildDLBaoCao = Delegate.CreateDelegate(typeof(BuildDuLieuBaoCao), uc, mi);
if (!LObject.IsNullOrEmpty(buildDLBaoCao))
{
BuildDuLieuBaoCao dlgbuildDLBaoCao = (BuildDuLieuBaoCao)buildDLBaoCao;
dlgbuildDLBaoCao(ds);
}
}
}
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
private void BuildFormDieuKien()
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
if (grDSBaoCao.SelectedItems.Count > 0)
{
// Lấy báo cáo được chọn từ grid
DataRowView dr = (DataRowView)grDSBaoCao.SelectedItem;
int idBaoCao = int.Parse(dr[0].ToString());
int idBaoCaoCha = int.Parse(dr[4].ToString());
string maBaoCao = dr[2].ToString();
// Lấy thông tin báo cáo và tham số
if (idBaoCaoCha != 0)
{
KhaiThacDuLieuProcess process = new KhaiThacDuLieuProcess();
ApplicationConstant.ResponseStatus ret = ApplicationConstant.ResponseStatus.KHONG_THANH_CONG;
List <HT_BAOCAO_TSO> lstBaoCaoTso = new List <HT_BAOCAO_TSO>();
DatabaseConstant.Action action = DatabaseConstant.Action.TRUY_VAN;
string responseMessage = "";
process.DuLieuChiTieu(action, idBaoCao, ref htBaoCao, ref lstBaoCaoTso, ref responseMessage);
string uriBaoCaoDieuKien = "/" + htBaoCao.NHOM_DIEUKIEN + ";component/" + htBaoCao.FILE_DIEUKIEN;
uc = (UserControl)System.Windows.Application.LoadComponent(new Uri(uriBaoCaoDieuKien, System.UriKind.RelativeOrAbsolute));
if (!LObject.IsNullOrEmpty(uc.GetType().GetProperty("MaBaoCao")))
{
uc.GetType().GetProperty("MaBaoCao").SetValue(uc, maBaoCao, null);
}
frFormInput.Content = uc;
}
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
Mouse.OverrideCursor = Cursors.Arrow;
}
private void grvDanhSachHDV_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
DataRowView drv = (DataRowView)grvDanhSachHDV.SelectedItem;
DataSet ds = new KhaiThacDuLieuProcess().GetThongTinGiaoDichTietKiem(Convert.ToInt32(drv["ID"]), drv["SO_SO_TG"].ToString());
if (!LObject.IsNullOrEmpty(ds.Tables) && ds.Tables.Count > 0)
{
grvHuyDongGD.ItemsSource = ds.Tables["DANHSACH.GIAODICH"].DefaultView;
}
}
catch (System.Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
public void OnModify(BC_MATK obj)
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
KhaiThacDuLieuProcess processKTDL = new KhaiThacDuLieuProcess();
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
bool ret = false;
ret = processKTDL.MaTK(DatabaseConstant.Action.SUA, ref obj, ref listClientResponseDetail);
AfterModify(ret, obj, listClientResponseDetail);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
public void OnDelete()
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
bool ret = false;
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
KhaiThacDuLieuProcess processKTDL = new KhaiThacDuLieuProcess();
obj.ID = ID;
obj.MA_LOAITK = MA_LOAITK;
ret = processKTDL.LoaiTK(DatabaseConstant.Action.XOA, ref obj, ref listClientResponseDetail);
AfterDelete(ret, listClientResponseDetail);
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
/// <summary>
/// Sự kiện double click trên data grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grKhachHangDS_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
DataRowView drv = (DataRowView)grKhachHangDS.SelectedItem;
DataSet ds = new KhaiThacDuLieuProcess().GetThongTinCoBanKhachHang(Convert.ToInt32(drv["ID"]), drv["MA_KHANG"].ToString());
txtMaKhachHangGD.Text = drv["MA_KHANG"].ToString();
txtTenKhachHangGD.Text = drv["TEN_KHANG"].ToString();
txtMaKhachHangTD.Text = drv["MA_KHANG"].ToString();
txtTenKhachHangTD.Text = drv["TEN_KHANG"].ToString();
txtMaKhachHangHDV.Text = drv["MA_KHANG"].ToString();
txtTenKhachHangHDV.Text = drv["TEN_KHANG"].ToString();
if (!LObject.IsNullOrEmpty(ds.Tables) && ds.Tables.Count > 0)
{
grKhachHangGD.ItemsSource = ds.Tables["DANHSACH.GIAODICH"].DefaultView;
grvDanhSachHDTD.ItemsSource = ds.Tables["DANHSACH.HDTDVM"].DefaultView;
grvDanhSachHDV.ItemsSource = ds.Tables["DANHSACH.SOTK"].DefaultView;
tiTinDung.IsSelected = true;
}
}
catch (System.Exception ex)
{
grKhachHangGD.ItemsSource = null;
grvDanhSachHDTD.ItemsSource = null;
grvDanhSachHDV.ItemsSource = null;
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
LMessage.ShowMessage("M.DungChung.LoiChung", LMessage.MessageBoxType.Error);
}
finally
{
grvKheUocGD.ItemsSource = null;
grvDanhSachKUVM.ItemsSource = null;
grvHuyDongGD.ItemsSource = null;
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void BuildGridBaoCao()
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
DataTable dtBaoCao = new DataTable();
dtBaoCao.Columns.Add("ID", typeof(int));
dtBaoCao.Columns.Add("STT", typeof(string));
dtBaoCao.Columns.Add("Mã chỉ tiêu", typeof(string));
dtBaoCao.Columns.Add("Tên chỉ tiêu", typeof(string));
dtBaoCao.Columns.Add("ID_CHA", typeof(int));
int sttCha = 0;
int sttCon = 0;
//string maPhanHeBaoCao = ClientInformation.FormCase;
string maPhanHeBaoCao = "KTDL_DM";
KhaiThacDuLieuProcess process = new KhaiThacDuLieuProcess();
ApplicationConstant.ResponseStatus ret = ApplicationConstant.ResponseStatus.KHONG_THANH_CONG;
List <HT_BAOCAO> lstBaoCaoTheoPhanHe = new List <HT_BAOCAO>();
DatabaseConstant.Action action = DatabaseConstant.Action.TRUY_VAN;
string responseMessage = "";
ret = process.DanhSachChiTieu(action, maPhanHeBaoCao, ref lstBaoCaoTheoPhanHe, ref responseMessage);
if (ret == ApplicationConstant.ResponseStatus.THANH_CONG && lstBaoCaoTheoPhanHe.Count > 0)
{
List <HT_BAOCAO> lstBaoCaoCha = lstBaoCaoTheoPhanHe.Where(e => e.ID_BAOCAO_CHA == null).ToList();
foreach (var itemCha in lstBaoCaoCha)
{
DataRow rCha = dtBaoCao.NewRow();
sttCha = sttCha + 1;
rCha[0] = itemCha.ID_BAOCAO;
rCha[1] = sttCha.ToString();
rCha[2] = itemCha.MA_BAOCAO;
rCha[3] = itemCha.TEN_BAOCAO;
rCha[4] = 0;
dtBaoCao.Rows.Add(rCha);
sttCon = 0;
foreach (var item in lstBaoCaoTheoPhanHe)
{
if (item.ID_BAOCAO_CHA == itemCha.ID_BAOCAO)
{
DataRow rCon = dtBaoCao.NewRow();
sttCon = sttCon + 1;
rCon[0] = item.ID_BAOCAO;
rCon[1] = sttCha.ToString() + "." + sttCon.ToString();
rCon[2] = item.MA_BAOCAO;
rCon[3] = " " + item.TEN_BAOCAO;
rCon[4] = item.ID_BAOCAO_CHA;
dtBaoCao.Rows.Add(rCon);
}
else
{
}
}
// đổ source lên lưới
grDSBaoCao.ItemsSource = dtBaoCao.DefaultView;
}
}
}
catch (System.Exception ex)
{
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
Mouse.OverrideCursor = Cursors.Arrow;
}
private void SetFormData()
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
KhaiThacDuLieuProcess processKTDL = new KhaiThacDuLieuProcess();
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
bool ret = false;
obj = new BC_MATK();
obj.ID = ID;
ret = processKTDL.MaTK(DatabaseConstant.Action.LOAD, ref obj, ref listClientResponseDetail);
if (ret == true)
{
ID = obj.ID;
#region Thông tin chung
lblTrangThai.Content = BusinessConstant.layNgonNguNghiepVu(obj.TTHAI_NVU);
cmbLoaiTK.SelectedIndex = lstSourceLoaiTK.IndexOf(lstSourceLoaiTK.FirstOrDefault(i => i.KeywordStrings[0].ToString().Equals(obj.MA_LOAITK.ToString())));
txtMaTK.Text = obj.MA_LOAITK;
txtTenTK.Text = obj.TEN_MATK;
#endregion
#region Thông tin kiểm soát
txtTrangThaiBanGhi.Text = BusinessConstant.layNgonNguSuDung(obj.TTHAI_BGHI);
raddtNgayLap.Value = LDateTime.StringToDate(obj.NGAY_NHAP, "yyyyMMdd");
txtNguoiLap.Text = obj.NGUOI_NHAP;
if (LDateTime.IsDate(obj.NGAY_CNHAT, "yyyyMMdd") == true)
{
raddtNgayCapNhat.Value = LDateTime.StringToDate(obj.NGAY_CNHAT, "yyyyMMdd");
}
else
{
raddtNgayCapNhat.Value = null;
}
txtNguoiCapNhat.Text = obj.NGUOI_CNHAT;
#endregion
#region Lưu thông tin chung
TTHAI_BGHI = obj.TTHAI_BGHI;
TTHAI_NVU = obj.TTHAI_NVU;
MA_DVI_QLY = obj.MA_DVI_QLY;
MA_DVI_TAO = obj.MA_DVI_TAO;
NGAY_NHAP = obj.NGAY_NHAP;
NGUOI_NHAP = obj.NGUOI_NHAP;
#endregion
}
else
{
CommonFunction.ThongBaoKetQua(listClientResponseDetail);
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
