void LoadPopUpSanPham()
{
List <string> lstDieuKien = new List <string>();
lstDieuKien.Add(ClientInformation.MaDonVi);
lstPopup = new List <DataRow>();
PopupProcess popupProcess = new PopupProcess();
popupProcess.getPopupInformation("POPUP_DS_SANPHAM_TD", lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(false, simplePopupResponse, true);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
win.Title = LLanguage.SearchResourceByKey(simplePopupResponse.PopupTitle);
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.ShowDialog();
if (lstPopup.Count > 0)
{
foreach (DataRow dr in lstPopup)
{
if (lstDanhSachSanpham.Where(f => f.MA_SAN_PHAM.Contains(dr["MA_SAN_PHAM"].ToString())).Count() < 1)
{
SAN_PHAM_DBAN_CTIET objSanPhamCTiet = new SAN_PHAM_DBAN_CTIET();
objSanPhamCTiet.NGAY_ADUNG = ClientInformation.NgayLamViecHienTai;
objSanPhamCTiet.ID_DBAN = idDiaBan;
objSanPhamCTiet.ID_SAN_PHAM = Convert.ToInt32(dr["ID"]);
objSanPhamCTiet.LOAI_DBAN = "DM_CUM";
objSanPhamCTiet.MA_DBAN = MaDiaBan;
objSanPhamCTiet.MA_DVI_QLY = objCum.MA_DVI_QLY;
objSanPhamCTiet.MA_DVI_TAO = objCum.MA_DVI_TAO;
objSanPhamCTiet.MA_SAN_PHAM = dr["MA_SAN_PHAM"].ToString();
objSanPhamCTiet.TEN_SAN_PHAM = dr["TEN_SAN_PHAM"].ToString();
objSanPhamCTiet.NGAY_NHAP = ClientInformation.NgayLamViecHienTai;
objSanPhamCTiet.NGUOI_NHAP = ClientInformation.TenDangNhap;
objSanPhamCTiet.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri();
objSanPhamCTiet.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri();
lstDanhSachSanpham.Add(objSanPhamCTiet);
}
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
}
}
private void LayDuLieu()
{
Cursor = Cursors.Wait;
try
{
lstDanhSachSanpham.Clear();
if (LObject.IsNullOrEmpty(tvwKhuVuc.SelectedItem))
{
tvwKhuVuc.SelectedItem = tvwKhuVuc.Items[0];
}
string ListKVuc = "";
if (((RadTreeViewItem)tvwKhuVuc.SelectedItem).Tag.ToString().Substring(0, 3).Equals("CUM"))
{
ListKVuc = MaDiaBan;
}
if (ListKVuc.IsNullOrEmptyOrSpace())
{
ListKVuc = "0";
}
string MaSanPham = "0";
if (cmbSanPham.SelectedIndex > -1)
{
MaSanPham = lstSourceSanPham.ElementAt(cmbSanPham.SelectedIndex).KeywordStrings[1];
}
string LoaiSanPham = "";
if (cmbLoaiSanPham.SelectedIndex > -1)
{
LoaiSanPham = lstSourceLoaiSanPham.ElementAt(cmbLoaiSanPham.SelectedIndex).KeywordStrings.FirstOrDefault();
}
string maChiNhanh = "";
if (cmbChiNhanh.SelectedIndex > -1)
{
maChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.FirstOrDefault();
}
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@INP_CHIEU_DLIEU", "string", obj.CHIEU_DU_LIEU);
LDatatable.AddParameter(ref dt, "@INP_SAN_PHAM", "string", MaSanPham);
LDatatable.AddParameter(ref dt, "@INP_DBAN", "string", ListKVuc);
LDatatable.AddParameter(ref dt, "@INP_LOAI_SAN_PHAM", "string", LoaiSanPham);
LDatatable.AddParameter(ref dt, "@INP_MA_DVI", "string", maChiNhanh);
DataSet ds = new TinDungProcess().GetThongTinDiaBanSanPham(dt);
if (!LObject.IsNullOrEmpty(ds) && ds.Tables.Count > 0)
{
dt = ds.Tables["CHI_TIET"];
if (!LObject.IsNullOrEmpty(dt) && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM_DBAN_CTIET objSanPhamDiaBan = new SAN_PHAM_DBAN_CTIET();
objSanPhamDiaBan.ID = Convert.ToInt32(dr["ID"]);
objSanPhamDiaBan.ID_DBAN = Convert.ToInt32(dr["ID_DBAN"]);
objSanPhamDiaBan.ID_SAN_PHAM = Convert.ToInt32(dr["ID_DBAN"]);
objSanPhamDiaBan.LOAI_DBAN = dr["LOAI_DBAN"].ToString();
objSanPhamDiaBan.MA_DBAN = dr["MA_DBAN"].ToString();
objSanPhamDiaBan.MA_DVI_QLY = dr["MA_DVI_QLY"].ToString();
objSanPhamDiaBan.MA_DVI_TAO = dr["MA_DVI_TAO"].ToString();
objSanPhamDiaBan.MA_SAN_PHAM = dr["MA_SAN_PHAM"].ToString();
objSanPhamDiaBan.NGAY_ADUNG = dr["NGAY_ADUNG"].ToString();
objSanPhamDiaBan.NGAY_CNHAT = dr["NGAY_CNHAT"].ToString();
objSanPhamDiaBan.NGAY_HHAN = dr["NGAY_HHAN"].ToString();
objSanPhamDiaBan.NGAY_NHAP = dr["NGAY_NHAP"].ToString();
objSanPhamDiaBan.TEN_SAN_PHAM = dr["TEN_SAN_PHAM"].ToString();
objSanPhamDiaBan.TEN_DBAN = dr["TEN_DBAN"].ToString();
objSanPhamDiaBan.NGUOI_CNHAT = dr["NGUOI_CNHAT"].ToString();
objSanPhamDiaBan.NGUOI_NHAP = dr["NGUOI_NHAP"].ToString();
objSanPhamDiaBan.TTHAI_BGHI = dr["TTHAI_BGHI"].ToString();
objSanPhamDiaBan.TTHAI_NVU = dr["TTHAI_NVU"].ToString();
lstDanhSachSanpham.Add(objSanPhamDiaBan);
}
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
else
{
lstDanhSachSanpham.Clear();
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
}
}
catch (Exception ex)
{
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
finally
{
Cursor = Cursors.Arrow;
}
}
void LoadPopUpDiaBan()
{
List <string> lstDieuKien = new List <string>();
lstDieuKien.Add(ClientInformation.MaDonViGiaoDich);
lstPopup = new List <DataRow>();
PopupProcess popupProcess = new PopupProcess();
popupProcess.getPopupInformation("POPUP_DS_CUM", lstDieuKien);
SimplePopupResponse simplePopupResponse = ClientInformation.SimplePopup;
ucPopup popup = new ucPopup(false, simplePopupResponse, true);
popup.DuLieuTraVe = new ucPopup.LayDuLieu(LayDuLieuTuPopup);
Window win = new Window();
win.Content = popup;
win.Title = LLanguage.SearchResourceByKey(simplePopupResponse.PopupTitle);
win.WindowStartupLocation = WindowStartupLocation.CenterScreen;
win.ShowDialog();
if (lstPopup.Count > 0)
{
AutoCompleteEntry auSanPham = null;
if (cmbSanPham.SelectedIndex < 0)
{
auSanPham = lstSourceSanPham.ElementAt(cmbSanPham.SelectedIndex);
}
AutoCompleteEntry auLoaiSanPham = null;
auLoaiSanPham = lstSourceLoaiSanPham.ElementAt(cmbLoaiSanPham.SelectedIndex);
foreach (DataRow dr in lstPopup)
{
if (lstDanhSachSanpham.Where(f => f.MA_DBAN.Contains(dr["MA_CUM"].ToString())).Count() < 1)
{
SAN_PHAM_DBAN_CTIET objSanPhamCTiet = new SAN_PHAM_DBAN_CTIET();
objSanPhamCTiet.NGAY_ADUNG = ClientInformation.NgayLamViecHienTai;
objSanPhamCTiet.ID_DBAN = Convert.ToInt32(dr["ID"]);
if (obj.CHIEU_DU_LIEU == "SAN_PHAM")
{
objSanPhamCTiet.ID_SAN_PHAM = Convert.ToInt32(auSanPham.KeywordStrings[1]);
}
else
{
objSanPhamCTiet.ID_SAN_PHAM = 0;
}
objSanPhamCTiet.LOAI_DBAN = "DM_CUM";
objSanPhamCTiet.MA_DBAN = dr["MA_CUM"].ToString();
objSanPhamCTiet.TEN_DBAN = dr["TEN_CUM"].ToString();
objSanPhamCTiet.MA_DVI_QLY = ClientInformation.MaDonVi;
objSanPhamCTiet.MA_DVI_TAO = ClientInformation.MaDonViGiaoDich;
if (obj.CHIEU_DU_LIEU == "SAN_PHAM")
{
objSanPhamCTiet.MA_SAN_PHAM = auSanPham.KeywordStrings.FirstOrDefault();
}
else
{
objSanPhamCTiet.MA_SAN_PHAM = auLoaiSanPham.KeywordStrings.FirstOrDefault();
obj.LOAI_SAN_PHAM = auLoaiSanPham.KeywordStrings.FirstOrDefault();
}
objSanPhamCTiet.NGAY_NHAP = ClientInformation.NgayLamViecHienTai;
objSanPhamCTiet.NGUOI_NHAP = ClientInformation.TenDangNhap;
objSanPhamCTiet.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri();
objSanPhamCTiet.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri();
lstDanhSachSanpham.Add(objSanPhamCTiet);
}
}
radDanhSachLichPhat.ItemsSource = lstDanhSachSanpham;
radDanhSachLichPhat.Rebind();
}
}
