private void KhoiTaoGiaTriComboBox(ref List <AutoCompleteEntry> lstAutoComplete, ref Telerik.Windows.Controls.RadComboBox cmbCommon, string maDanhMuc)
{
var process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
List <string> lstDieuKien = new List <string>();
lstDieuKien.Clear();
lstDieuKien.Add(maDanhMuc);
lstDieuKien.Add(ClientInformation.MaDonVi);
DanhSachResponse response = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.COMBOBOX_DMUC_NHAN_SU_THEO_BANG.getValue(), lstDieuKien);
dataSetSource = response.DataSetSource;
if (dataSetSource.Tables.Count > 0)
{
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
AutoCompleteEntry entry = new AutoCompleteEntry(row["TEN"].ToString(), row["ID"].ToString(), row["MA"].ToString());
cmbCommon.Items.Add(entry);
lstAutoComplete.Add(entry);
}
}
if (cmbCommon.Items.Count > 0)
{
cmbCommon.SelectedIndex = 0;
}
cmbCommon.IsEditable = isEditable;
}
private void KhoiTaoGiaTriComboBox(ref List <AutoCompleteEntry> lstAutoComplete, ref Telerik.Windows.Controls.RadComboBox cmbCommon, string maPhongBan)
{
var process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
List <string> lstDieuKien = new List <string>();
lstDieuKien.Clear();
lstDieuKien.Add(maPhongBan);
lstDieuKien.Add(BusinessConstant.LOAI_HO_SO.THOI_VIEC.layGiaTri());
lstDieuKien.Add(ClientInformation.MaDonVi);
DanhSachResponse response = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.COMBOBOX_NGUOI_BAN_GIAO.getValue(), lstDieuKien);
dataSetSource = response.DataSetSource;
if (dataSetSource.Tables.Count > 0)
{
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
AutoCompleteEntry entry = new AutoCompleteEntry(row["TEN_HSO"].ToString(), row["MA_HSO"].ToString(), row["CHUC_VU"].ToString());
cmbCommon.Items.Add(entry);
lstAutoComplete.Add(entry);
}
}
if (cmbCommon.Items.Count > 0)
{
cmbCommon.SelectedIndex = 0;
}
cmbCommon.IsEditable = isEditable;
}
/// <summary>
/// Load dữ liệu lên datagrid
/// </summary>
private void LoadDuLieu()
{
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add(ucTrangThaiNVu.GetItemsSelected());
lstDkLoc.Add(ucTrangThaiSDung.GetItemsSelected());
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_QUOCGIA.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
lstHeader = DanhSachResponse.ListHeader.ToList();
//dtMaster = DanhSachResponse.DataSetSource.Tables[0];
//dtDetail = DanhSachResponse.DataSetSource.Tables[1];
dtMaster = null;
dtDetail = DanhSachResponse.DataSetSource.Tables[0];
//RadTreeViewItem rootItem = new RadTreeViewItem();
//rootItem.Header = LLanguage.SearchResourceByKey(DanhSachResponse.Title);
//rootItem.Tag = string.Empty;
//rootItem.IsExpanded = true;
//tvwTree.Items.Add(rootItem);
//BuildTree(rootItem);
BuildGrid();
loadWidthColumn();
}
}
/// <summary>
/// Get ngay cuoi cung tong hop
/// </summary>
private void GetLastDate()
{
try
{
//Khởi tạo request
DataTable dt = null;
LDatatable.MakeParameterTable(ref dt);
foreach (AutoCompleteCheckBox ChiNhanh in lstSourceChiNhanh.Where(f => f.CheckedMember == true))
{
LDatatable.AddParameter(ref dt, "@MaChiNhanh", "STRING", ChiNhanh.ValueMember[INT_ZERO].ToString());
}
TruyVanProcess truyVanProcess = new TruyVanProcess();
DataSet ds = truyVanProcess.TruyVanUDTT(MAX_DATE_TRANSACTION, dt);
if (!ds.IsNullOrEmpty() && INT_ZERO < ds.Tables.Count && INT_ZERO < ds.Tables[INT_ZERO].Rows.Count)
{
raddtDenNgay.Value = LDateTime.StringToDate(ds.Tables[INT_ZERO].Rows[INT_ZERO][INT_ZERO].ToString(), ApplicationConstant.defaultDateTimeFormat);
}
else
{
raddtDenNgay.Value = DateTime.Now;
}
raddtTuNgay.Value = LDateTime.GetFirstDateOfMonth(raddtDenNgay.Value.GetValueOrDefault());
}
catch (Exception ex)
{
raddtDenNgay.Value = DateTime.Now;
raddtTuNgay.Value = LDateTime.GetFirstDateOfMonth(raddtDenNgay.Value.GetValueOrDefault());
LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
}
}
private void BuildGrid(string maDonVi)
{
Cursor = Cursors.Wait;
try
{
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add(ucTrangThaiNVu.GetItemsSelected());
lstDkLoc.Add(ucTrangThaiSDung.GetItemsSelected());
lstDkLoc.Add(maDonVi);
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_KHUVUC.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
lstHeader = DanhSachResponse.ListHeader.ToList();
//dtMaster = DanhSachResponse.DataSetSource.Tables[0];
dtDetail = DanhSachResponse.DataSetSource.Tables[0];
}
List <string> lst = new List <string>();
lst.Add(maDonVi);
DataTable grdData = new DataTable();
foreach (DataColumn col in dtDetail.Columns)
{
grdData.Columns.Add(col.ColumnName, typeof(string));
}
if (lst.Count > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
if (lst.Contains(row["KEY"].ToString()))
{
grdData.ImportRow(row);
}
}
}
if (grdData.Rows.Count > 0)
{
grKhuVucDS.ItemsSource = grdData.DefaultView;
}
else
{
grKhuVucDS.ItemsSource = null;
}
lblTongSo.Content = grdData.Rows.Count;
}
catch (System.Exception ex)
{
}
finally
{
Cursor = Cursors.Arrow;
}
}
/// <summary>
/// Khởi tạo các combobox
/// </summary>
private void LoadCombobox()
{
// Khai bao AutoComboBox
AutoComboBox auto;
// Khởi tạo điều kiện gọi danh mục
List <string> lstDieuKien = new List <string>();
//Tao combobox Chi nhanh,PGD, KVUC
auto = new AutoComboBox();
//lstSourceChiNhanh.Insert(0, new AutoCompleteEntry(LLanguage.SearchResourceByKey("U.DungChung.TatCa"), new string[2] { "%", "0" }));
auto.GenAutoComboBox(ref lstSourceChiNhanh, ref cmbChiNhanh, DatabaseConstant.DanhSachTruyVan.COMBOBOX_CNHANH.getValue(), null, ClientInformation.MaDonVi);
auto.GenAutoComboBox(ref lstSourcePhongGD, ref cmbPhongGD, DatabaseConstant.DanhSachTruyVan.COMBOBOX_PHONG_GD.getValue());
auto.GenAutoComboBox(ref lstSourceKhuVuc, ref cmbKhuVuc, DatabaseConstant.DanhSachTruyVan.COMBOBOX_KHUVUC_ALL.getValue());
LoadComboboxPhongGD();
LoadComboboxKhuVuc();
//auto.GenAutoComboBox(ref lstSourceCum, ref cmbCum, DatabaseConstant.DanhSachTruyVan.COMBOBOX_CUM_ALL.getValue());
//LoadComboboxCum();
//Tao Gridview Cum
var process = new TruyVanProcess();
DanhSachResponse response = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.COMBOBOX_CUM_ALL.getValue(), lstDieuKien);
if (!LObject.IsNullOrEmpty(response.DataSetSource) && response.DataSetSource.Tables[0].Rows.Count > 0)
{
dtSourceCum = response.DataSetSource.Tables[0];
LoadGridViewCum();
}
lstDieuKien = new List <string>();
lstDieuKien.Add(DatabaseConstant.DanhMuc.LY_DO_VAO_RA.getValue());
// khởi tạo combobox
auto = new AutoComboBox();
lstDieuKien = new List <string>();
lstDieuKien.Add(DatabaseConstant.DanhMuc.NGON_NGU.getValue());
// khởi tạo combobox
auto = new AutoComboBox();
auto.GenAutoComboBox(ref lstSourceNgonNgu, ref cmbNgonNgu, DatabaseConstant.DanhSachTruyVan.COMBOBOX_DMUC.getValue(), lstDieuKien, ApplicationConstant.LoaiNgonNguBaoCao.vi_VN.layGiaTri());
cmbNgonNgu.IsEnabled = false;
lstDieuKien.Clear();
lstDieuKien.Add(DatabaseConstant.DanhMuc.DINH_DANG_BAO_CAO.getValue());
// khởi tạo combobox
auto = new AutoComboBox();
auto.GenAutoComboBox(ref lstSourceDinhDang, ref cmbDinhDang, DatabaseConstant.DanhSachTruyVan.COMBOBOX_DMUC.getValue(), lstDieuKien, ApplicationConstant.LoaiDinhDangBaoCao.EXCEL.layGiaTri());
cmbDinhDang.IsEnabled = false;
cmbChiNhanh.SelectionChanged += cmbChiNhanh_SelectionChanged;
cmbPhongGD.SelectionChanged += cmbPhongGD_SelectionChanged;
cmbKhuVuc.SelectionChanged += cmbKhuVuc_SelectionChanged;
IsLoadForm = true;
}
public void GenAutoSoure(ref List <AutoCompleteEntry> lstSource, string maTruyVan, List <string> lstDieuKien = null, string maChon = "Default", List <string> lstMaKhoangChon = null)
{
Func <AutoCompleteEntry, bool> predicate = null;
Func <AutoCompleteEntry, bool> func2 = null;
try
{
if (!string.IsNullOrEmpty(maTruyVan))
{
TruyVanProcess process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
dataSetSource = process.getDanhSachInformation(maTruyVan, lstDieuKien).DataSetSource;
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
if (row.Table.Columns.Count > 3)
{
List <string> list = new List <string> {
row[1].ToString(),
row[0].ToString()
};
for (int i = 3; i < dataSetSource.Tables[0].Columns.Count; i++)
{
list.Add(row[i].ToString());
}
lstSource.Add(new AutoCompleteEntry(LanguageEngine.Instance().GetContent(0, row[2].ToString()), list.ToArray()));
}
else
{
string content = LanguageEngine.Instance().GetContent(0, row[2].ToString());
if (content == "")
{
content = LanguageEngine.Instance().GetContent(0, row[1].ToString());
}
lstSource.Add(new AutoCompleteEntry(content, new string[] { row[1].ToString(), row[0].ToString() }));
}
}
}
if (lstMaKhoangChon != null)
{
if (predicate == null)
{
predicate = e => lstMaKhoangChon.Contains(e.KeywordStrings.First <string>());
}
lstSource = lstSource.Where <AutoCompleteEntry>(predicate).ToList <AutoCompleteEntry>();
}
}
catch (Exception exception)
{
LLogging.WriteLog("", LLogging.LogType.ERR, exception);
}
}
/// <summary>
/// Load dữ liệu lên datagrid
/// </summary>
public void LoadDuLieu()
{
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add(ucTrangThaiNVu.GetItemsSelected());
lstDkLoc.Add(ucTrangThaiSDung.GetItemsSelected());
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_PHANHE_GD.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
lstHeader = DanhSachResponse.ListHeader.ToList();
dtMaster = new DataTable();
grdData = new DataTable();
foreach (HeaderDto item in lstHeader)
{
grdData.Columns.Add(LLanguage.SearchResourceByKey(item.LanguageKey), typeof(string));
}
lstHeader = DanhSachResponse.ListHeader.ToList();
dtMaster = DanhSachResponse.DataSetSource.Tables[0];
dtDetail = DanhSachResponse.DataSetSource.Tables[1];
while (tvwTree.Items.Count > 0)
{
tvwTree.Items.RemoveAt(0);
}
UpdateLayout();
RadTreeViewItem rootItem = new RadTreeViewItem();
rootItem.Header = "Danh mục (" + DanhSachResponse.DataSetSource.Tables[1].Rows.Count.ToString() + ")";
rootItem.Tag = string.Empty;
rootItem.IsExpanded = true;
tvwTree.Items.Add(rootItem);
BuildTree(rootItem);
BuildGrid();
loadWidthColumn();
// khởi tạo sự kiện combobox
cmbTrangThai.KeyDown += cmb_KeyDown;
cmbPhanHe.KeyDown += cmb_KeyDown;
tvwTree.SelectionChanged += tvwTree_SelectionChanged;
tvwTree.MouseDoubleClick += tvwTree_MouseDoubleClick;
grDanhSach.MouseDoubleClick += grDanhSach_MouseDoubleClick;
nudPageSize.ValueChanged += nudPageSize_ValueChanged;
}
}
/// <summary>
/// Load dữ liệu lên datagrid
/// </summary>
private void LoadDuLieu()
{
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add(ucTrangThaiNVu.GetItemsSelected().Equals("NULL") ? null : ucTrangThaiNVu.GetItemsSelected());
lstDkLoc.Add(ucTrangThaiSDung.GetItemsSelected().Equals("NULL") ? null : ucTrangThaiSDung.GetItemsSelected());
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_TAN_SUAT.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
lstHeader = DanhSachResponse.ListHeader.ToList();
dtMaster = DanhSachResponse.DataSetSource.Tables[0];
BuildGrid();
loadWidthColumn();
}
}
/// <summary>
/// Tạo AutocomboBox
/// </summary>
/// <param name="lstSource">Source cho Combobox</param>
/// <param name="comboBox">Tên control Combobox được gen</param>
/// <param name="maTruyVan">Mã truy vấn để lấy source cho combobox</param>
/// <param name="lstDieuKien">Giá trị các điều kiện tương ứng với truy vấn</param>
/// <param name="maChon">Mã Item sẽ được chọn nếu có</param>
/// <param name="lstMaKhoangChon">Danh sách các Item sẽ được gen vào Combobox nếu có.</param>
public static void GenAutoComboBox(ref List <AutoCompleteEntry> lstSource, string maTruyVan, List <string> lstDieuKien = null, string maChon = "Default", List <string> lstMaKhoangChon = null)
{
try
{
if (!string.IsNullOrEmpty(maTruyVan))
{
var process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
DanhSachResponse response = process.getDanhSachInformation(maTruyVan, lstDieuKien);
dataSetSource = response.DataSetSource;
//}
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
if (row.Table.Columns.Count > 3)
{
List <string> lst = new List <string>();
lst.Add(row[1].ToString());
lst.Add(row[0].ToString());
for (int i = 3; i < dataSetSource.Tables[0].Columns.Count; i++)
{
lst.Add(row[i].ToString());
}
lstSource.Add(new AutoCompleteEntry(LanguageNode.GetValueUILanguage(row[2].ToString()), lst.ToArray()));
}
else
{
lstSource.Add(new AutoCompleteEntry(LanguageNode.GetValueUILanguage(row[2].ToString()), row[1].ToString(), row[0].ToString()));
}
}
}
if (lstMaKhoangChon != null)
{
lstSource = lstSource.Where(e => lstMaKhoangChon.Contains(e.KeywordStrings.First())).ToList();
}
}
catch (Exception e)
{
LLogging.WriteLog("", LLogging.LogType.ERR, e);
}
}
public void GenAutoComboBoxDirectly(ref List<AutoCompleteEntry> lstSource, ref RadComboBox comboBox, string maTruyVan, List<string> lstDieuKien = null, string maChon = "Default", List<string> lstMaKhoangChon = null)
{
try
{
if (DesignerProperties.GetIsInDesignMode(new DependencyObject()))
return;
if (!string.IsNullOrEmpty(maTruyVan))
{
var process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
// Lấy kết quả trả về
DanhSachResponse response = process.getDanhSachInformation(maTruyVan, lstDieuKien);
dataSetSource = response.DataSetSource;
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
lstSource.Add(new AutoCompleteEntry(LLanguage.SearchResourceByKey(row[2].ToString()), row[1].ToString(), row[0].ToString()));
}
}
if (lstMaKhoangChon != null)
{
lstSource = lstSource.Where(e => lstMaKhoangChon.Contains(e.KeywordStrings.First())).ToList();
}
foreach (AutoCompleteEntry auto in lstSource)
{
comboBox.Items.Add(auto);
}
if (!string.IsNullOrEmpty(maChon))
{
if (maChon.Equals("Default"))
comboBox.SelectedIndex = 0;
else
comboBox.SelectedIndex = lstSource.IndexOf(lstSource.FirstOrDefault(e => e.KeywordStrings.First().Equals(maChon)));
}
}
catch (Exception e)
{
LLogging.WriteLog("", LLogging.LogType.ERR, e);
}
}
/// <summary>
/// Tạo AutocomboBox
/// </summary>
/// <param name="lstSource">Source cho Combobox</param>
/// <param name="comboBox">Tên control Combobox được gen</param>
/// <param name="maTruyVan">Mã truy vấn để lấy source cho combobox</param>
/// <param name="lstDieuKien">Giá trị các điều kiện tương ứng với truy vấn</param>
/// <param name="maChon">Mã Item sẽ được chọn nếu có</param>
/// <param name="lstMaKhoangChon">Danh sách các Item sẽ được gen vào Combobox nếu có.</param>
public void GenAutoComboBox(ref ListCheckBoxCombo lstSource, ref RadComboBox comboBox, string maTruyVan, List <string> lstDieuKien = null, string maChon = "Default", List <string> lstMaKhoangChon = null)
{
if (DesignerProperties.GetIsInDesignMode(new DependencyObject()))
{
return;
}
if (!string.IsNullOrEmpty(maTruyVan))
{
DataSet dataSetSource = new DataSet();
TruyVanProcess process = new TruyVanProcess();
DanhSachResponse response = process.getDanhSachInformation(maTruyVan, lstDieuKien);
dataSetSource = response.DataSetSource;
AutoCompleteCheckBox autocom = new AutoCompleteCheckBox();
int icount = 0;
lstSource.Add(new AutoCompleteCheckBox());
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
icount++;
string[] value = new string[row.Table.Columns.Count - 1];
if (row.Table.Columns.Count > 3)
{
value[0] = row[1].ToString();
value[1] = row[0].ToString();
for (int i = 3; i < row.Table.Columns.Count; i++)
{
value[i - 1] = row[i].ToString();
}
autocom.ValueMember = value;
}
else
{
value[0] = row[1].ToString();
value[1] = row[0].ToString();
autocom.ValueMember = value;
}
lstSource.Add(new AutoCompleteCheckBox(LLanguage.SearchResourceByKey(row[2].ToString()), value, true, icount));
}
}
comboBox.ItemsSource = lstSource;
comboBox.SelectedIndex = 0;
}
private void getData()
{
lstHeader = new List <HeaderDto>();
dsData = new DataSet();
dtMaster = new DataTable();
dtDetail = new DataTable();
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add("NULL");
lstDkLoc.Add("NULL");
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_TINHTP.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
lstHeader = DanhSachResponse.ListHeader.ToList();
dsData = DanhSachResponse.DataSetSource;
dtMaster = DanhSachResponse.DataSetSource.Tables[0];
dtDetail = DanhSachResponse.DataSetSource.Tables[1];
}
}
private void GetTaiKhoan()
{
//string MaChiNhanh = string.Empty;
//if (cmbChiNhanh.SelectedIndex >= 0 && !lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First().IsNullOrEmptyOrSpace())
// MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
//else
// MaChiNhanh = lstSourceChiNhanh.ElementAt(cmbChiNhanh.SelectedIndex).KeywordStrings.First();
//DataSet ds = new BaoCaoProcess().GetTaiKhoanTheoDonVi(MaChiNhanh);
List <string> lstString = new List <string>();
lstString.Add(DatabaseConstant.DanhMuc.DANH_MUC_DOI_TUONG.getValue());
DataSet ds = new TruyVanProcess().getDanhSachInformation("INQ.DS.DMUC_GTRI", lstString).DataSetSource;
if (ds != null && ds.Tables.Count > 0)
{
grSoTienGuiDS.ItemsSource = ds.Tables[0];
}
else
{
grSoTienGuiDS.ItemsSource = null;
}
}
void tlbThem_Click(object sender, RoutedEventArgs e)
{
DataTable dt = null;
DataSet ds = null;
LDatatable.MakeParameterTable(ref dt);
LDatatable.AddParameter(ref dt, "@IdCum", "string", idCum.ToString());
LDatatable.AddParameter(ref dt, "@MaCum", "string", maCum);
LDatatable.AddParameter(ref dt, "@IDKhachHang", "string", "");
if (!lstDanhSachKUOC.IsNullOrEmpty())
{
foreach (DANH_SACH_KHE_UOC_LAP_LICH objDSach in lstDanhSachKUOC)
{
LDatatable.AddParameter(ref dt, "@IDKhachHang", "string", objDSach.MA_KHACH_HANG);
}
}
else
{
lstDanhSachKUOC = new List <DANH_SACH_KHE_UOC_LAP_LICH>();
}
ds = new TruyVanProcess().TruyVanUDTT("_DC_LAP_LAI_LICH_THU_NO", dt);
if (!ds.IsNullOrEmpty() && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DANH_SACH_KHE_UOC_LAP_LICH objDSach = new DANH_SACH_KHE_UOC_LAP_LICH();
objDSach.ID_KUOCVM = Convert.ToInt32(dr["ID_KUOCVM"]);
objDSach.MA_KHACH_HANG = Convert.ToString(dr["MA_KHACH_HANG"]);
objDSach.MA_KUOCVM = Convert.ToString(dr["MA_KUOCVM"]);
objDSach.NGAY_BAT_DAU = Convert.ToString(dr["NGAY_BAT_DAU"]);
objDSach.NGAY_PHAT_VON = Convert.ToString(dr["NGAY_PHAT_VON"]);
objDSach.SO_DU = Convert.ToDecimal(dr["SO_DU"]);
objDSach.TEN_KHACH_HANG = Convert.ToString(dr["TEN_KHACH_HANG"]);
lstDanhSachKUOC.Add(objDSach);
}
raddgrLapKeHoach.ItemsSource = null;
raddgrLapKeHoach.ItemsSource = lstDanhSachKUOC;
}
}
/// <summary>
/// Load dữ liệu lên tree
/// </summary>
private void LoadDuLieu()
{
var process = new TruyVanProcess();
List <string> lstDkLoc = new List <string>();
lstDkLoc.Add(ucTrangThaiNVu.GetItemsSelected());
lstDkLoc.Add(ucTrangThaiSDung.GetItemsSelected());
if (ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_QTDV.layGiaTri()) ||
ClientInformation.LoaiNguoiSuDung.Equals(BusinessConstant.LoaiNguoiSuDung.CAP_NVDV.layGiaTri()))
{
lstDkLoc.Add(ClientInformation.IdDonVi.ToString());
}
else
{
lstDkLoc.Add(DatabaseConstant.ID_TOCHUC.ToString());
}
lstDkLoc.Add(ClientInformation.TenDangNhap);
lstDkLoc.Add(ClientInformation.MaDonViQuanLy);
DanhSachResponse DanhSachResponse = process.getDanhSachInformation(DatabaseConstant.DanhSachTruyVan.DM_CUM_TREE.getValue(), lstDkLoc);
if (DanhSachResponse.DataSetSource != null)
{
//lstHeader = DanhSachResponse.ListHeader.ToList();
dtMaster = DanhSachResponse.DataSetSource.Tables[0];
DataRow drRoot = dtMaster.Rows[0];
RadTreeViewItem rootItem = new RadTreeViewItem();
rootItem.Header = drRoot["NODE_NAME"].ToString();
rootItem.Tag = drRoot["NODE"].ToString();
rootItem.Uid = drRoot["NODE_TYPE"].ToString();
//rootItem.IsExpanded = true;
tvwKhuVuc.Items.Add(rootItem);
BuildTree(rootItem);
}
}
/// <summary>
/// Tạo AutocomboBox
/// </summary>
/// <param name="lstSource">Source cho Combobox</param>
/// <param name="comboBox">Tên control Combobox được gen</param>
/// <param name="maTruyVan">Mã truy vấn để lấy source cho combobox</param>
/// <param name="lstDieuKien">Giá trị các điều kiện tương ứng với truy vấn</param>
/// <param name="maChon">Mã Item sẽ được chọn nếu có</param>
/// <param name="lstMaKhoangChon">Danh sách các Item sẽ được gen vào Combobox nếu có.</param>
public void GenAutoComboBox(ref List<AutoCompleteEntry> lstSource, ref RadComboBox comboBox, string maTruyVan, List<string> lstDieuKien = null, string maChon = "Default", List<string> lstMaKhoangChon = null)
{
try
{
if (DesignerProperties.GetIsInDesignMode(new DependencyObject()))
return;
if (!string.IsNullOrEmpty(maTruyVan))
{
var process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
// Lấy kết quả trả về
//if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_DMUC.getValue()))
//{
// dataSetSource = getDataSetDmDmucGtri(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_HINHTHUCSD.getValue()))
//{
// dataSetSource = getDataSetDmDmucGtriHinhThucSd(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_KHOANG_GTRI_TAISAN.getValue()))
//{
// dataSetSource = getDataSetDmDmucGtriKhoangGiaTriTaiSan(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_LOAICHUNGTU_NGOAIBANG.getValue()))
//{
// dataSetSource = getDataSetDmDmucGtriLoaiChungTuNgoaiBang(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_QUOCGIA.getValue()))
//{
// dataSetSource = getDataSetDmQuocGia(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_TIENTE.getValue()) ||
// maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_LOAITIEN.getValue()))
//{
// dataSetSource = getDataSetDmTienTe(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_TINHTP.getValue()))
//{
// dataSetSource = getDataSetDmTinhTp(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_COSOTINHLAI.getValue()))
//{
// dataSetSource = getDataSetDcCsoTlai(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_LOAI_LSUAT.getValue()))
//{
// dataSetSource = getDataSetDcLoaiLsuat(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_TINH_CHAT_TK.getValue()))
//{
// dataSetSource = getDataSetKtNhomPloai(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_KY_HIEU.getValue()))
//{
// dataSetSource = getDataSetKtKyHieu(maTruyVan, lstDieuKien);
//}
//else if (maTruyVan.Equals(DatabaseConstant.DanhSachTruyVan.COMBOBOX_NAM_TCHINH.getValue()))
//{
// dataSetSource = getDataSetNamTaiChinh(maTruyVan, lstDieuKien);
//}
//else
//{
DanhSachResponse response = process.getDanhSachInformation(maTruyVan, lstDieuKien);
dataSetSource = response.DataSetSource;
//}
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
if (row.Table.Columns.Count > 3)
{
List<string> lst = new List<string>();
lst.Add(row[1].ToString());
lst.Add(row[0].ToString());
for (int i = 3; i < dataSetSource.Tables[0].Columns.Count; i++)
lst.Add(row[i].ToString());
lstSource.Add(new AutoCompleteEntry(LLanguage.SearchResourceByKey(row[2].ToString()), lst.ToArray()));
}
else
{
lstSource.Add(new AutoCompleteEntry(LLanguage.SearchResourceByKey(row[2].ToString()), row[1].ToString(), row[0].ToString()));
}
}
}
if (lstMaKhoangChon != null)
{
lstSource = lstSource.Where(e => lstMaKhoangChon.Contains(e.KeywordStrings.First())).ToList();
}
//while (comboBox.Items.Count > 0)
// comboBox.Items.RemoveAt(comboBox.Items.Count - 1);
foreach (AutoCompleteEntry auto in lstSource)
{
comboBox.Items.Add(auto);
}
if (!string.IsNullOrEmpty(maChon))
{
if (maChon.Equals("Default"))
comboBox.SelectedIndex = 0;
else
comboBox.SelectedIndex = lstSource.IndexOf(lstSource.FirstOrDefault(e => e.KeywordStrings.First().Equals(maChon)));
}
}
catch (Exception e)
{
LLogging.WriteLog("", LLogging.LogType.ERR, e);
}
}
/// <summary>
/// Tạo AutocomboBox
/// </summary>
/// <param name="lstSource">Source cho Combobox</param>
/// <param name="comboBox">Tên control Combobox được gen</param>
/// <param name="maTruyVan">Mã truy vấn để lấy source cho combobox</param>
/// <param name="lstDieuKien">Giá trị các điều kiện tương ứng với truy vấn</param>
/// <param name="maChon">Mã Item sẽ được chọn nếu có</param>
/// <param name="lstMaKhoangChon">Danh sách các Item sẽ được gen vào Combobox nếu có.</param>
public void GenAutoComboBox(ref List <AutoCompleteEntry> lstSource, ref DropDownList comboBox, string maTruyVan, List <string> lstDieuKien = null, string maChon = "Default", List <string> lstMaKhoangChon = null)
{
Func <AutoCompleteEntry, bool> predicate = null;
Func <AutoCompleteEntry, bool> func2 = null;
try
{
if (!string.IsNullOrEmpty(maTruyVan))
{
TruyVanProcess process = new TruyVanProcess();
DataSet dataSetSource = new DataSet();
dataSetSource = process.getDanhSachInformation(maTruyVan, lstDieuKien).DataSetSource;
foreach (DataRow row in dataSetSource.Tables[0].Rows)
{
if (row.Table.Columns.Count > 3)
{
List <string> list = new List <string> {
row[1].ToString(),
row[0].ToString()
};
for (int i = 3; i < dataSetSource.Tables[0].Columns.Count; i++)
{
list.Add(row[i].ToString());
}
lstSource.Add(new AutoCompleteEntry(LanguageEngine.Instance().GetContent(0, row[2].ToString()), list.ToArray()));
}
else
{
string content = LanguageEngine.Instance().GetContent(0, row[2].ToString());
if (content == "")
{
content = LanguageEngine.Instance().GetContent(0, row[1].ToString());
}
lstSource.Add(new AutoCompleteEntry(content, new string[] { row[1].ToString(), row[0].ToString() }));
}
}
}
if (lstMaKhoangChon != null)
{
if (predicate == null)
{
predicate = e => lstMaKhoangChon.Contains(e.KeywordStrings.First <string>());
}
lstSource = lstSource.Where <AutoCompleteEntry>(predicate).ToList <AutoCompleteEntry>();
}
foreach (AutoCompleteEntry entry in lstSource)
{
string displayName = entry.DisplayName;
string str3 = entry.KeywordStrings[0];
if (displayName == "")
{
try
{
displayName = entry.KeywordStrings[2];
}
catch
{
displayName = entry.KeywordStrings[1];
}
if (displayName == "")
{
displayName = entry.KeywordStrings[0];
}
str3 = entry.KeywordStrings[0];
}
ListItem item = new ListItem(displayName, str3);
comboBox.Items.Add(item);
}
if (!string.IsNullOrEmpty(maChon))
{
if (maChon.Equals("Default"))
{
comboBox.SelectedIndex = 0;
}
else
{
if (func2 == null)
{
func2 = e => e.KeywordStrings.First <string>().Equals(maChon);
}
comboBox.SelectedIndex = lstSource.IndexOf(lstSource.FirstOrDefault <AutoCompleteEntry>(func2));
}
}
}
catch (Exception exception)
{
LLogging.WriteLog("", LLogging.LogType.ERR, exception);
}
}
