private void frmInphieuxuat_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
loai.Enabled = d.bChonloaiphieu_xuat(i_nhom);
phieu.Enabled = loai.Enabled;
imp.Visible = m.Mabv_so == 701424;
ds.ReadXml("..\\..\\..\\xml\\d_xuatkho.xml");
ds.Tables[0].Columns.Add("manhom", typeof(decimal)).DefaultValue = 0;
ds.Tables[0].Columns.Add("tennhom");
//dsxml.ReadXml("..\\..\\..\\xml\\d_xuatkho.xml");
dsxml = ds.Copy();
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
dtloai = d.get_data("select * from " + user + ".d_dmphieu where id<5 order by stt").Tables[0];
loai.DataSource = dtloai;
loai.DisplayMember = "TEN";
loai.ValueMember = "ID";
phieu.DisplayMember = "TEN";
phieu.ValueMember = "ID";
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
nhom.DisplayMember = "TEN";
nhom.ValueMember = "ID";
load_nhom();
load_makp();
load_makho();
load_dmnhom();
dmnhom.DisplayMember = "TEN";
dmnhom.ValueMember = "ID";
}
private void load_nhom()
{
sql = "select * from " + user + ".d_dmnhomkho ";
if (s_nhomkho != "")
{
sql += " where id in (" + s_nhomkho.Substring(0, s_nhomkho.Length - 1) + ")";
}
sql += " order by stt";
nhom.DataSource = d.get_data(sql).Tables[0];
i_nhom = (nhom.SelectedIndex != -1)?int.Parse(nhom.SelectedValue.ToString()):0;
loai.Enabled = d.bChonloaiphieu_xuat(i_nhom);
phieu.Enabled = loai.Enabled;
}