private void LoadGrid()
{
Cursor = Cursors.Wait;
try
{
#region Điều kiện tìm kiếm
RadTreeViewItem item = tvwTree.SelectedItem as RadTreeViewItem;
string loai = item.Uid.ToString();
string ma = item.Tag.ToString();
#endregion
HuyDongVonProcess HuyDongVonProcess = new HuyDongVonProcess();
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@USER_NAME", "String", ClientInformation.TenDangNhap);
LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "String", ClientInformation.MaDonViQuanLy);
LDatatable.AddParameter(ref dt, "@MA", "String", ma);
LDatatable.AddParameter(ref dt, "@LOAI", "String", loai);
DataSet ds = HuyDongVonProcess.GetDanhSachDangKyRutGocQB(dt);
if (ds != null && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ds.Tables[0].Rows[i]["TTHAI_NVU"] = BusinessConstant.layNgonNguNghiepVu(ds.Tables[0].Rows[i]["TTHAI_NVU"].ToString());
}
grDanhSach.DataContext = ds.Tables[0].DefaultView;
if (ds.Tables[0].Rows.Count > 0)
{
lblTongSo.Content = ds.Tables[0].Rows.Count;
}
else
{
lblTongSo.Content = "0";
}
}
else
{
grDanhSach.Items.Clear();
lblTongSo.Content = 0;
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
finally
{
Mouse.OverrideCursor = Cursors.Arrow;
}
}
private void SetFormData()
{
string SO_GIAO_DICH = MA_GIAO_DICH.Value;
try
{
HuyDongVonProcess processHDV = new HuyDongVonProcess();
DataSet ds = processHDV.GetThongTinGuiThemTheoDS(AppConfig.LoginedUser.MaDonViGiaoDich, SO_GIAO_DICH);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
lblTrangThai.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, BusinessConstant.layMaNgonNguNghiepVu(dr["TTHAI_NVU"].ToString()));
raddtNgay.Text = LDateTime.StringToDate(dr["NGAY_DL"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy");
txtMaGiaoDich.Text = SO_GIAO_DICH;
txtNguoiGiaoDich.Text = dr["TEN_KHANG"].ToString();
txtDiaChi.Text = dr["DIA_CHI"].ToString();
txtDienGiai.Text = dr["DIEN_GIAI"].ToString();
TRANG_THAI_BAN_GHI.Value = dr["TTHAI_BGHI"].ToString();
TRANG_THAI_NGHIEP_VU.Value = dr["TTHAI_NVU"].ToString();
#region Tab thông tin kiểm soát
txtTrangThai.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, BusinessConstant.layMaNgonNguSuDung(dr["TTHAI_BGHI"].ToString()));
teldtNgayNhap.Text = LDateTime.StringToDate(dr["NGAY_NHAP"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy");
txtNguoiLap.Text = dr["NGUOI_NHAP"].ToString();
if (LDateTime.IsDate(dr["NGAY_CNHAT"].ToString(), "yyyyMMdd") == true)
{
teldtNgayCNhat.Text = LDateTime.StringToDate(dr["NGAY_CNHAT"].ToString(), "yyyyMMdd").ToString("dd/MM/yyyy");
}
else
{
teldtNgayCNhat.Text = "";
}
txtNguoiCapNhat.Text = dr["NGUOI_CNHAT"].ToString();
#endregion
}
dsGuiThem = processHDV.GetThongTinGuiThemTheoDSCTiet(AppConfig.LoginedUser.MaDonViGiaoDich, SO_GIAO_DICH);
if (dsGuiThem != null)
{
//DataViewManager dataViewManager = new DataViewManager(dsGuiThem);
// DataView dataView = dataViewManager.CreateDataView(dsGuiThem.Tables[0]);
grGuiThemDS.DataSource = dsGuiThem;
grGuiThemDS.DataBind();
}
TinhTong();
}
catch (Exception ex)
{
}
}
private void LoadGrid()
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
DataSet ds = null;
if (DatabaseConstant.Function.TDVM_TAM_UNG == function)
{
ds = huyDongVonProcess.GetDanhSachSoRutGoc(ClientInformation.MaDonViGiaoDich, sSanPham, sIDCum, ClientInformation.NgayLamViecHienTai);
}
if (ds != null)
{
dtSoTGui = ds.Tables[0];
grSoTienGuiDS.ItemsSource = dtSoTGui;
int soSoTgui = 0;
decimal tongSoDu = 0;
decimal soDuBinhQuan = 0;
if (dtSoTGui.Rows.Count > 0)
{
soSoTgui = dtSoTGui.Rows.Count;
for (int i = 0; i < dtSoTGui.Rows.Count; i++)
{
tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]);
}
soDuBinhQuan = tongSoDu / soSoTgui;
}
lblSumSoSo.Content = String.Format("{0:#,#}", soSoTgui);
lblSumSoDu.Content = String.Format("{0:#,#}", tongSoDu);
lblSoDuBQ.Content = String.Format("{0:#,#}", soDuBinhQuan);
}
else
{
dtSoTGui.Rows.Clear();
grSoTienGuiDS.ItemsSource = dtSoTGui;
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
}
/// <summary>
/// Xóa
/// </summary>
/// <param name="listId"></param>
private void OnDelete(List <int> listId)
{
HuyDongVonProcess processHuyDongVon = new HuyDongVonProcess();
Mouse.OverrideCursor = Cursors.Wait;
try
{
List <ClientResponseDetail> listClientResponseDetail = new List <ClientResponseDetail>();
List <HDV_THONG_TIN_DKY_RUT_GOC> lstNhom = new List <HDV_THONG_TIN_DKY_RUT_GOC>();
HDV_THONG_TIN_DKY_RUT_GOC obj = null;
foreach (int id in listId)
{
obj = new HDV_THONG_TIN_DKY_RUT_GOC();
obj.ID = id;
lstNhom.Add(obj);
}
bool ret = processHuyDongVon.DanhSachDangKyRutGocQB(DatabaseConstant.Action.XOA, ref lstNhom, ref listClientResponseDetail);
AfterDelete(ret, listId, listClientResponseDetail);
}
catch (System.Exception ex)
{
// Yêu cầu unlock dữ liệu
UtilitiesProcess process = new UtilitiesProcess();
bool retUnlockData = process.UnlockData(DatabaseConstant.Module.DMDC,
DatabaseConstant.Function.DC_DM_NHOM_DS,
DatabaseConstant.Table.DM_NHOM,
DatabaseConstant.Action.XOA,
listId);
this.Cursor = Cursors.Arrow;
CommonFunction.ThongBaoLoi(ex);
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
Mouse.OverrideCursor = Cursors.Arrow;
}
/// <summary>
/// Load dữ liệu lên Treeview
/// </summary>
private void LoadTreeview()
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
string sIdDonVi = "";
string sMaDonVi = "";
string sIdDonViQLy = "";
string sMaDonViQLy = "";
if (lstSourceDonVi != null)
{
sIdDonVi = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(1);
sMaDonVi = lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0);
DM_DON_VI objDonVi = new DanhMucProcess().getDonViById(Convert.ToInt32(sIdDonVi));
if (objDonVi.LOAI_DVI.Equals(DatabaseConstant.ToChucDonVi.HSO.getValue()) || objDonVi.LOAI_DVI.Equals(DatabaseConstant.ToChucDonVi.CNH.getValue()))
{
sIdDonViQLy = objDonVi.ID.ToString();
sMaDonViQLy = objDonVi.MA_DVI;
}
else
{
sIdDonViQLy = objDonVi.ID_DVI_CHA.ToString();
sMaDonViQLy = objDonVi.MA_DVI_CHA;
}
}
dtTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonViQLy).Tables[0];
dtTreeDonVi = huyDongVonProcess.GetTreeDonViNhom(AppConfig.LoginedUser.MaDonViQuanLy, AppConfig.LoginedUser.UserName, sMaDonViQLy).Tables[0];
dtTreeCBQL = huyDongVonProcess.GetTreeCBQL(sMaDonViQLy).Tables[0];
// BuildTree(dtTreeSanPham, tvwLoaiVay, false);
DataTable mtree = new DataTable();
mtree.Columns.Add("LEVEL", Type.GetType("System.String"));
mtree.Columns.Add("NODE_PARENT", Type.GetType("System.String"));
mtree.Columns.Add("NODE", Type.GetType("System.String"));
mtree.Columns.Add("NODE_NAME", Type.GetType("System.String"));
mtree.Columns.Add("STYPE", Type.GetType("System.String"));
DataRow row = mtree.NewRow();
for (int j = 0; j < dtTreeSanPham.Rows.Count; j++)
{
row = mtree.NewRow();
row["LEVEL"] = dtTreeSanPham.Rows[j][0].ToString();
row["NODE_PARENT"] = dtTreeSanPham.Rows[j][1].ToString();
row["NODE"] = dtTreeSanPham.Rows[j][2].ToString();
row["NODE_NAME"] = dtTreeSanPham.Rows[j][3].ToString();
row["STYPE"] = "SAN_PHAM";
mtree.Rows.Add(row);
}
tvwLoaiVay.Nodes.Clear();
TreeNode rootItem = new TreeNode();
rootItem.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.NhomSanPham");
rootItem.Value = "0#SAN_PHAM";
tvwLoaiVay.Nodes.Add(rootItem);
BuildTree(rootItem, mtree, "SAN_PHAM");
mtree.Clear();
for (int j = 0; j < dtTreeDonVi.Rows.Count; j++)
{
row = mtree.NewRow();
row["LEVEL"] = dtTreeDonVi.Rows[j][0].ToString();
row["NODE_PARENT"] = dtTreeDonVi.Rows[j][1].ToString();
row["NODE"] = dtTreeDonVi.Rows[j][2].ToString();
row["NODE_NAME"] = dtTreeDonVi.Rows[j][3].ToString();
row["STYPE"] = "DON_VI";
mtree.Rows.Add(row);
}
TreeNode rootItem_dv = new TreeNode();
rootItem_dv.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.KhachHang");
rootItem_dv.Value = "0#DON_VI";
tvwLoaiVay.Nodes.Add(rootItem_dv);
BuildTree(rootItem, mtree, "DON_VI");
tvwLoaiVay.ShowCheckBoxes = TreeNodeTypes.All;
}
catch (Exception ex)
{
//LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
/// <summary>
/// Load dữ liệu lên Grid
/// </summary>
private void LoadGrid(int stype)
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
AutoComboBox auto = new AutoComboBox();
List <string> lstDieuKien = new List <string>();
lstDieuKien.Add(AppConfig.LoginedUser.UserName);
lstDieuKien.Add(AppConfig.LoginedUser.MaDonVi);
lstDieuKien.Add(DatabaseConstant.ToChucDonVi.PGD.getValue());
auto.GenAutoSoure(ref lstSourceDonVi, DatabaseConstant.DanhSachTruyVan.COMBOBOX_DONVI_THEOPVI.getValue(), lstDieuKien, AppConfig.LoginedUser.MaDonViGiaoDich);
lstDieuKien.Clear();
#region Điều kiện tìm kiếm
string sMaDonVi = "";
sMaDonVi = "(";
string maChon = cmbDonVi.SelectedItem.Value;// lstSourceDonVi.ElementAt(cmbDonVi.SelectedIndex).KeywordStrings.ElementAt(0);
string donVi = "";
foreach (AutoCompleteEntry item in lstSourceDonVi)
{
donVi = item.KeywordStrings.ElementAt(0);
if (donVi.Contains(maChon))
{
sMaDonVi += "''" + donVi + "'',";
}
}
sMaDonVi = sMaDonVi.Substring(0, sMaDonVi.Length - 1);
sMaDonVi += ")";
string sTrangThaiNVu = "";
string sSoTGui = "%";
string sTenSoTGui = "%";
string sTuNgayMoSo = "%";
string sDenNgayMoSo = "%";
string sTuNgayDHan = "%";
string sDenNgayDHan = "%";
string soDuTu = "%";
string soDuDen = "%";
string iKyHanTu = "%";
string iKyHanDen = "%";
string sKyHanDonVi = "%";
string sMaKH = "%";
string sTenKH = "%";
string sSoCMND = "%";
string sSDT = "%";
string sEmail = "%";
string sNgayDC = "%";
string sSanPham = "%", sIDNhom = "%", sCBQL = "%";
if (cbChoduyet.Checked)
{
sTrangThaiNVu = sTrangThaiNVu + "''" + cbChoduyet.Value + "'',";
}
if (cbDaduyet.Checked)
{
sTrangThaiNVu = sTrangThaiNVu + "''" + cbDaduyet.Value + "'',";
}
if (cbThoaiduyet.Checked)
{
sTrangThaiNVu = sTrangThaiNVu + "''" + cbThoaiduyet.Value + "'',";
}
if (cbTuchoi.Checked)
{
sTrangThaiNVu = sTrangThaiNVu + "''" + cbTuchoi.Value + "'',";
}
if (sTrangThaiNVu != "")
{
sTrangThaiNVu = "(" + sTrangThaiNVu.Substring(0, sTrangThaiNVu.Length - 1) + ")";
}
if (!txtSoSoTG.Text.IsNullOrEmpty())
{
sSoTGui = txtSoSoTG.Text;
}
if (!raddtNgayMoSoTu.Text.IsNullOrEmpty())
{
sTuNgayMoSo = LDateTime.StringToDate(raddtNgayMoSoTu.Text, "dd/MM/yyyy").ToString("yyyyMMdd");
}
if (!raddtNgayMoSoDen.Text.IsNullOrEmpty())
{
sDenNgayMoSo = LDateTime.StringToDate(raddtNgayMoSoDen.Text, "dd/MM/yyyy").ToString("yyyyMMdd");
}
if (!raddtNgayDaoHanTu.Text.IsNullOrEmpty())
{
sTuNgayDHan = LDateTime.StringToDate(raddtNgayDaoHanTu.Text, "dd/MM/yyyy").ToString("yyyyMMdd");
}
if (!raddtNgayDaoHanDen.Text.IsNullOrEmpty())
{
sDenNgayDHan = LDateTime.StringToDate(raddtNgayDaoHanDen.Text, "dd/MM/yyyy").ToString("yyyyMMdd");
}
if (numSoDuTu.Text != "")
{
soDuTu = numSoDuTu.Text.Replace(",", "").ToString();
}
if (numSoDuDen.Text != "")
{
soDuDen = numSoDuDen.Text.Replace(",", "").ToString();
}
if (numKyHanTu.Text != "")
{
iKyHanTu = numKyHanTu.Text.Replace(",", "").ToString();
}
if (numKyHanDen.Text != "")
{
iKyHanDen = numKyHanDen.Text.Replace(",", "").ToString();
}
if (cmbKyHanTu.SelectedIndex >= 0)
{
sKyHanDonVi = cmbKyHanTu.SelectedItem.Value;
}
if (!txtKhachHang.Text.IsNullOrEmptyOrSpace())
{
sMaKH = txtKhachHang.Text;
}
if (!txtTenKhachHang.Text.IsNullOrEmptyOrSpace())
{
sTenKH = txtTenKhachHang.Text;
}
//}
#endregion
// Phân trang
int StartRow = 1;
int EndRow = 999999999 * stype; // ClientInformation.SoLuongBanGhi;
int CurrentPagging = 1;
int PaggingSize = 999999999; // ClientInformation.SoLuongBanGhi;
DataSet ds = huyDongVonProcess.GetDanhSachSoTGuiNhom(sMaDonVi, sSanPham, sIDNhom, sCBQL, sTrangThaiNVu, sSoTGui,
sTenSoTGui, sTuNgayMoSo, sDenNgayMoSo, sTuNgayDHan, sDenNgayDHan,
soDuTu, soDuDen, iKyHanTu, iKyHanDen, sKyHanDonVi,
sMaKH, sTenKH, sSoCMND, sSDT, sEmail, sNgayDC, StartRow.ToString(), EndRow.ToString());
if (ds != null && ds.Tables.Count > 0)
{
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// dr["TTHAI_NVU"] = BusinessConstant.layNgonNguNghiepVu(dr["TTHAI_NVU"].ToString());
// if (!dr["KY_HAN_DVI_TINH"].IsNullOrEmpty() && !dr["KY_HAN_TGIAN"].IsNullOrEmpty() && !dr["KY_HAN"].IsNullOrEmpty())
// {
// if (!dr["KY_HAN_TGIAN"].ToString().Equals("0") && !dr["KY_HAN_DVI_TINH"].ToString().Equals(""))
// dr["KY_HAN"] = dr["KY_HAN_TGIAN"] + " " + BusinessConstant.layNgonNguTuGiaTri(dr["KY_HAN_DVI_TINH"].ToString(), "TAN_SUAT");
// }
//}
DataTable serverDataTable = ds.Tables[0];
int totalRecord = Int32.Parse(ds.Tables[1].Rows[0][0].ToString());
//DataTable clientDataTable = ds.Tables[0].Copy() ;// CommonFunction.BuildClientDataTable(serverDataTable, CurrentPagging, PaggingSize, totalRecord);
//dtSoTGui = ds.Tables[0];
//grSoTienGuiDS.DataContext = dtSoTGui.DefaultView;
dtSoTGui = serverDataTable;
grSoTienGuiDS.DataSource = serverDataTable;
grSoTienGuiDS.DataBind();
int soSoTgui = 0;
decimal tongSoDu = 0;
decimal soDuBinhQuan = 0;
decimal tongSoDuGoc = Decimal.Parse(ds.Tables[2].Rows[0][0].ToString());
decimal tongSoDuLai = Decimal.Parse(ds.Tables[2].Rows[0][1].ToString());
if (totalRecord > 0)
{
soSoTgui = totalRecord;
for (int i = 0; i < dtSoTGui.Rows.Count; i++)
{
tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]);
}
soDuBinhQuan = tongSoDu / soSoTgui;
}
lblSumSoSo.Text = String.Format("{0:#,#}", soSoTgui);
lblSumSoDu.Text = String.Format("{0:#,#}", tongSoDu);
lblSoDuBQ.Text = String.Format("{0:#,#}", soDuBinhQuan);
lblSumSoDuGoc.Text = String.Format("{0:#,#}", tongSoDuGoc);
lblSumSoDuLai.Text = String.Format("{0:#,#}", tongSoDuLai);
}
else
{
dtSoTGui.Rows.Clear();
grSoTienGuiDS.DataSource = dtSoTGui.DefaultView;
grSoTienGuiDS.DataBind();
}
}
catch (Exception ex)
{
// LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
/// <summary>
/// Load dữ liệu lên Treeview
/// </summary>
private void LoadTreeview()
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
string sIdDonVi = ClientInformation.IdDonVi.ToString();
string sMaDonVi = ClientInformation.MaDonVi;
DataSet dsTreeSanPham;
dtTreeDonVi = huyDongVonProcess.GetTreeDonVi(sIdDonVi).Tables[0];
#region Tree Sản phẩm
if (function == DatabaseConstant.Function.HDV_RUT_BOT_GOC || function == DatabaseConstant.Function.HDV_RUT_GOC_THEO_DANH_SACH)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamRutGoc(sMaDonVi);
}
else if (function == DatabaseConstant.Function.HDV_GUI_THEM_TIEN_THEO_SO || function == DatabaseConstant.Function.HDV_GUI_THEM_TIEN_THEO_DANH_SACH)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamGuiThem(sMaDonVi);
}
else if (function == DatabaseConstant.Function.HDV_TRA_LAI || function == DatabaseConstant.Function.HDV_TRA_LAI_THEO_DANH_SACH)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamTraLai(sMaDonVi);
}
else if (function == DatabaseConstant.Function.HDV_DU_CHI)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamDuChi(sMaDonVi);
}
else if (function == DatabaseConstant.Function.HDV_PHAN_BO)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamPhanBo(sMaDonVi);
}
else if (function == DatabaseConstant.Function.HDV_DIEU_CHINH_LS)
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamThayDoiLS(sMaDonVi);
}
else
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonVi);
}
if (dsTreeSanPham != null && dsTreeSanPham.Tables[0].Rows.Count > 0)
{
dtTreeSanPham = dsTreeSanPham.Tables[0];
}
#endregion
itemSanPham.Items.Clear();
//Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM)
itemSanPham.Tag = "0#0#SAN_PHAM";
itemSanPham.IsExpanded = false;
BuildTree(itemSanPham, dtTreeSanPham, "SAN_PHAM");
itemDonVi.Items.Clear();
//Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM)
itemDonVi.Tag = "0#0#DON_VI";
itemDonVi.IsExpanded = false;
BuildTree(itemDonVi, dtTreeDonVi, "DON_VI");
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
}
}
private void LoadGrid()
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
DataSet ds = null;
if (function == DatabaseConstant.Function.HDV_LAI_NHAP_GOC_THEO_SO || function == DatabaseConstant.Function.HDV_LAI_NHAP_GOC_THEO_DANH_SACH)
{
ds = huyDongVonProcess.GetDanhSachSoLNG(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else if (function == DatabaseConstant.Function.HDV_RUT_BOT_GOC || function == DatabaseConstant.Function.HDV_RUT_GOC_THEO_DANH_SACH)
{
ds = huyDongVonProcess.GetDanhSachSoRutGocNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else if (function == DatabaseConstant.Function.HDV_DU_CHI)
{
ds = huyDongVonProcess.GetDanhSachSoDuChi(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else if (function == DatabaseConstant.Function.HDV_TRA_LAI || function == DatabaseConstant.Function.HDV_TRA_LAI_THEO_DANH_SACH)
{
ds = huyDongVonProcess.GetDanhSachSoTraLaiNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else if (function == DatabaseConstant.Function.HDV_TAT_TOAN || function == DatabaseConstant.Function.HDV_TAT_TOAN_THEO_DANH_SACH)
{
ds = huyDongVonProcess.GetDanhSachSoTatToanNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else if (function == DatabaseConstant.Function.HDV_DIEU_CHINH_LS)
{
ds = huyDongVonProcess.GetDanhSachSoThayDoiLS(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom, ClientInformation.NgayLamViecHienTai);
}
else
{
ds = huyDongVonProcess.GetDanhSachSoTGuiNhom(ClientInformation.MaDonViGiaoDich, sSanPham, sIDNhom);
}
if (ds != null)
{
dtSoTGui = ds.Tables[0];
grSoTienGuiDS.ItemsSource = dtSoTGui;
int soSoTgui = 0;
decimal tongSoDu = 0;
decimal soDuBinhQuan = 0;
if (dtSoTGui.Rows.Count > 0)
{
soSoTgui = dtSoTGui.Rows.Count;
for (int i = 0; i < dtSoTGui.Rows.Count; i++)
{
tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]);
}
soDuBinhQuan = tongSoDu / soSoTgui;
}
lblSumSoSo.Content = String.Format("{0:#,#}", soSoTgui);
lblSumSoDu.Content = String.Format("{0:#,#}", tongSoDu);
lblSoDuBQ.Content = String.Format("{0:#,#}", soDuBinhQuan);
}
else
{
dtSoTGui.Rows.Clear();
grSoTienGuiDS.ItemsSource = dtSoTGui;
}
}
catch (Exception ex)
{
LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex);
throw ex;
}
}
/// <summary>
/// Load dữ liệu lên Treeview
/// </summary>
private void LoadTreeview()
{
try
{
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
string sIdDonVi = AppConfig.LoginedUser.IdDonVi.ToString();
if (sIdDonVi == "0")
{
sIdDonVi = "4"; // FIX TAM DE CO DU LIEU
}
string sMaDonVi = AppConfig.LoginedUser.MaDonVi;
DataSet dsTreeSanPham;
dtTreeDonVi = huyDongVonProcess.GetTreeDonVi(sIdDonVi).Tables[0];
#region Tree Sản phẩm
if (fn == "HDV_RUT_BOT_GOC" || fn == "HDV_RUT_GOC_THEO_DANH_SACH")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamRutGoc(sMaDonVi);
}
else if (fn == "HDV_GUI_THEM_TIEN_THEO_SO" || fn == "HDV_GUI_THEM_TIEN_THEO_DANH_SACH")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamGuiThem(sMaDonVi);
}
else if (fn == "HDV_TRA_LAI" || fn == "HDV_TRA_LAI_THEO_DANH_SACH")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamTraLai(sMaDonVi);
}
else if (fn == "HDV_DU_CHI")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamDuChi(sMaDonVi);
}
else if (fn == "HDV_PHAN_BO")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamPhanBo(sMaDonVi);
}
else if (fn == "HDV_DIEU_CHINH_LS")
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPhamThayDoiLS(sMaDonVi);
}
else
{
dsTreeSanPham = huyDongVonProcess.GetTreeSanPham(sMaDonVi);
}
if (dsTreeSanPham != null && dsTreeSanPham.Tables[0].Rows.Count > 0)
{
dtTreeSanPham = dsTreeSanPham.Tables[0];
}
#endregion
tvSearch.Nodes.Clear();
//Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM)
TreeNode itemSanPham = new TreeNode();
itemSanPham.Value = "0#0#SAN_PHAM";
itemSanPham.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.Popup.ucPopupSoTGui.SanPham");
itemSanPham.Expanded = true;
tvSearch.Nodes.Add(itemSanPham);
BuildTree(itemSanPham, dtTreeSanPham, "SAN_PHAM");
TreeNode itemDonVi = new TreeNode();
//Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM)
itemDonVi.Value = "0#0#DON_VI";
itemDonVi.Text = LanguageEngine.Instance().GetContent(LanguageType.TypeUI, "U.HuyDongVon.MoSo.ucMoSoDS.KhachHang");
itemDonVi.Expanded = true;
//BuildTree(itemDonVi, dtTreeDonVi, "DON_VI");
tvSearch.Nodes.Add(itemDonVi);
BuildSubTreeKhuVuc(itemDonVi, null, 0);
tvSearch.ShowCheckBoxes = TreeNodeTypes.All;
}
catch (Exception ex)
{
}
}
private void LoadGrid(int itype)
{
try
{
sSanPham = "";
sIDCum = "";
if (itype == 1)
{
//string ListPThucVay = "";
//foreach (TreeNode item in tvwLoaiVay.CheckedNodes)
//{
// ListPThucVay += ",''" + item.Value.ToString() + "''";
//}
//if (ListPThucVay.Length > 0)
// ListPThucVay = "(" + ListPThucVay.Substring(1) + ")";
foreach (TreeNode item in tvSearch.CheckedNodes)
{
///Cấu trúc của Tag: GiaTri#Level#LoaiTree ( VD: MaSP001#2#SAN_PHAM hoặc CUM001#3#DON_VI)
string sTag = item.Value.ToString();
int i1 = sTag.IndexOf("#");
int i2 = sTag.LastIndexOf("#");
string sValue = sTag.Split('#')[0]; // sTag.Substring(0, i1);
int iLevel = Convert.ToInt32(sTag.Split('#')[1]);
string sLoaiTree = sTag.Split('#')[2]; // sTag.Substring(i2 + 1);
if (sLoaiTree.Equals("SAN_PHAM"))
{
if (iLevel == 2)
{
sSanPham = sSanPham + "''" + sValue + "'',";
}
}
if (sLoaiTree.Equals("DON_VI"))
{
if (iLevel == 3)
{
sIDCum = sIDCum + "''" + sValue + "'',";
}
}
}
if (sSanPham.Length > 0)
{
sSanPham = sSanPham.Substring(0, sSanPham.Length - 1);
}
if (sIDCum.Length > 0)
{
sIDCum = sIDCum.Substring(0, sIDCum.Length - 1);
}
//if (itemDonVi.CheckState == System.Windows.Automation.ToggleState.On)
//{
// sIDCum = "%";
//}
if (sSanPham.Equals(""))
{
sSanPham = "''''";
}
if (sIDCum.Equals(""))
{
sIDCum = "''''";
}
}
else
{
sSanPham = "''%''";
sIDCum = "''%''";
}
HuyDongVonProcess huyDongVonProcess = new HuyDongVonProcess();
DataSet ds = null;
if (fn == "HDV_LAI_NHAP_GOC_THEO_SO" || fn == "HDV_LAI_NHAP_GOC_THEO_DANH_SACH")
{
ds = huyDongVonProcess.GetDanhSachSoLNG(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else if (fn == "HDV_RUT_BOT_GOC" || fn == "HDV_RUT_GOC_THEO_DANH_SACH")
{
ds = huyDongVonProcess.GetDanhSachSoRutGoc(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else if (fn == "HDV_DU_CHI")
{
ds = huyDongVonProcess.GetDanhSachSoDuChi(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else if (fn == "HDV_TRA_LAI" || fn == "HDV_TRA_LAI_THEO_DANH_SACH")
{
ds = huyDongVonProcess.GetDanhSachSoTraLai(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else if (fn == "HDV_TAT_TOAN" || fn == "HDV_TAT_TOAN_THEO_DANH_SACH")
{
ds = huyDongVonProcess.GetDanhSachSoTatToan(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else if (fn == "HDV_DIEU_CHINH_LS")
{
ds = huyDongVonProcess.GetDanhSachSoThayDoiLS(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum, AppConfig.LoginedUser.NgayLamViecHienTai);
}
else
{
ds = huyDongVonProcess.GetDanhSachSoTGui(AppConfig.LoginedUser.MaDonViGiaoDich, sSanPham, sIDCum);
}
if (ds != null)
{
dtSoTGui = ds.Tables[0];
if (itype == 0)
{
dtSoTGui = ds.Tables[0].Clone();
}
grSoTienGuiDS.DataSource = dtSoTGui;
grSoTienGuiDS.DataBind();
int soSoTgui = 0;
decimal tongSoDu = 0;
decimal soDuBinhQuan = 0;
if (dtSoTGui.Rows.Count > 0)
{
soSoTgui = dtSoTGui.Rows.Count;
for (int i = 0; i < dtSoTGui.Rows.Count; i++)
{
tongSoDu += Convert.ToDecimal(dtSoTGui.Rows[i]["SO_DU"]);
}
soDuBinhQuan = tongSoDu / soSoTgui;
}
lblSumSoSo.Text = String.Format("{0:#,#}", soSoTgui);
lblSumSoDu.Text = String.Format("{0:#,#}", tongSoDu);
lblSoDuBQ.Text = String.Format("{0:#,#}", soDuBinhQuan);
}
else
{
dtSoTGui.Rows.Clear();
grSoTienGuiDS.DataSource = dtSoTGui;
grSoTienGuiDS.DataBind();
}
}
catch (Exception ex)
{
}
}
