private void frmPhieuxuat_ng_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
i_dongiale = d.d_dongia_le(i_nhom);
sql = "select * from " + user + ".d_duockp ";
sql += " where nhom like '%" + i_nhom.ToString() + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
sql += " order by stt";
dtkp = d.get_data(sql).Tables[0];
makp.DataSource = dtkp;
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
sql = "select * from " + user + ".d_dmloaint where nhom=" + i_nhom;
if (s_loaint != "")
{
sql += " and id in (" + s_loaint.Substring(0, s_loaint.Length - 1) + ")";
}
sql += " order by stt";
dtloai = d.get_data(sql).Tables[0];
loai.DataSource = dtloai;
loai.DisplayMember = "TEN";
loai.ValueMember = "ID";
sql = "select a.*,b.stt as sttnhom,b.ten as tennhom,c.ten as tenhang ";
sql += " from " + user + ".d_dmbd a," + user + ".d_dmnhom b," + user + ".d_dmhang c where a.manhom=b.id and a.mahang=c.id and a.nhom=" + i_nhom;
dt = d.get_data(sql).Tables[0];
s_makho = d.get_dmkho(7).Trim();
s_makho = (s_makho == "") ? "" : s_makho.Substring(0, s_makho.Length - 1);
sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho + ")";
}
sql += " order by stt";
dtdmkho = d.get_data(sql).Tables[0];
kho.DataSource = dtdmkho;
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
ds.ReadXml("..//..//..//xml//d_thkhoa.xml");
dsxml.ReadXml("..//..//..//xml//d_thkhoa.xml");
}
private void mnuDuyetdonBanle_Click(object sender, EventArgs e)
{
if (IsLoaded("frmXuatban"))
{
return;
}
LibDuoc.AccessData d = new LibDuoc.AccessData();
intsert_uservp_duoc(int.Parse(m_userid));
int d_userid = int.Parse(m_userid) * -1;
int i_loai = 7;
int i_nhomkho = m_v.nhom_nhathuoc;
string s_ngay = m_v.Ngaygio_hienhanh.Substring(0, 10), s_kho = d.get_dmkho(i_loai), s_loaint = "";
string s_mmyy = m_v.mmyy(s_ngay);
frmChonkhoxb f = new frmChonkhoxb(d, i_nhomkho, s_kho, s_kho + ",", s_mmyy, s_ngay, "Quầy", true, s_loaint);
f.ShowDialog(this);
if (f.i_makho > 0)
{
frmDuyetdon f1 = new frmDuyetdon(d, i_nhomkho, s_kho, s_ngay, d_userid, s_mmyy, f.i_quaythu, s_kho, "", m_userid, "", "");
f1.MdiParent = this;
f1.Show();
}
}
