private void get_nhomkho(int i_userid)
{
string sql = "select nhomkho from " + d.user + ".d_dlogin where id='" + i_userid + "'";
DataSet lds = d.get_data(sql);
lds.WriteXml("..\\..\\..\\xml\\d_nhomkholog.xml", XmlWriteMode.WriteSchema);
}
private void rptCongno_Load(object sender, EventArgs e)
{
cbKieu.SelectedIndex = 0;
string sql = "select * from " + user + ".d_dmkho where khott=1 and nhom=" + iNhom;
if (sMakho != "")
{
sql += " and id in (" + sMakho.Substring(0, sMakho.Length - 1) + ")";
}
sql += " order by stt";
dtDmkho = lib.get_data(sql).Tables[0];
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
kho.DataSource = dtDmkho;
AddGridTableStyle();
load_dmmaubaocao(this.Name);
}