public void Load_cmbDonVi_TheoQuyen(VSCM.Base.Controls.ucSearchLookupEdit cmb, bool p)
{
cmb.Tag = 0;
clsDM_DonVi cls = new clsDM_DonVi();
DataTable dt = cls.SelectAll();
dt = GlobalMethod.CheckQuyenDonVi(dt);
if (dt.Rows.Count > 1)
{
DataRow row;
row = dt.NewRow();
row["ID_DonVi"] = "0";
row["Ten_DonVi"] = "Tất cả";
row["SuDung"] = 1;
row["TonTai"] = 1;
dt.Rows.Add(row);
}
dt.DefaultView.RowFilter = "SuDung = 1 AND TonTai = 1 AND ID_DonVi <> " + iID_DonVi;
dt.DefaultView.Sort = "STT_DonVi ASC";
cmb.Properties.DataSource = dt.DefaultView.ToTable();
cmb.Properties.ValueMember = "ID_DonVi";
cmb.Properties.DisplayMember = "Ten_DonVi";
cmb.Tag = 1;
if (dt.DefaultView.ToTable().Rows.Count == 1)
{
cmb.EditValue = dt.DefaultView.ToTable().Rows[0]["ID_DonVi"];
}
}
private void LoadcmbCapDuoi()
{
var cmb = cmbCapDuoi;
cmb.Tag = 0;
clsDM_DonVi cls = new clsDM_DonVi();
//DataTable dt = cls.SelectAllNVCapDuoi(Convert.ToInt32(cmbCapTren.EditValue));
DataTable dt = cls.SelectAll();
dt.DefaultView.RowFilter = "ID_DonVi <> " + cmbCapTren.EditValue + " AND TonTai = 1 AND SuDung = 1";
dt.DefaultView.Sort = "STT_DonVi ASC";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_DonVi";
cmb.Properties.ValueMember = "ID_DonVi";
cmb.Tag = 1;
}
public void LoadCombo_DSDonVi_TrucThuoc(int id_DonVi)
{
var cmb = cmbDonViTrucThuoc;
cmb.Tag = 0;
clsDM_DonVi cls = new clsDM_DonVi();
DataTable dt = cls.SelectAll();
dt.DefaultView.Sort = "ID_DonVi ASC";
dt.DefaultView.RowFilter = "TonTai = 1 and ID_DonVi <> " + id_DonVi + "";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_DonVi";
cmb.Properties.ValueMember = "ID_DonVi";
if (dt.DefaultView.ToTable().Rows.Count == 1)
{
cmb.EditValue = dt.DefaultView.ToTable().Rows[0]["ID_DonVi"];
}
else
{
cmb.EditValue = null;
}
cmb.Tag = 1;
}
private void LoadcmbDonVi()
{
var cmb = cmbDonVi;
cmb.Tag = 0;
var cls = new clsDM_DonVi();
var dt = cls.SelectAll();
dt.DefaultView.Sort = "STT_DonVi ASC";
dt.DefaultView.RowFilter = "TonTai = 1 AND SuDung = 1";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_DonVi";
cmb.Properties.ValueMember = "ID_DonVi";
if (dt.DefaultView.ToTable().Rows.Count == 1)
{
cmb.EditValue = dt.DefaultView.ToTable().Rows[0]["ID_DonVi"];
}
else
{
cmb.EditValue = null;
}
cmb.Tag = 1;
}