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;
}
}
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)
{
}
}
