private void frmTtkcb_Load(object sender, System.EventArgs e)
{
user = m.user;
s_thetrongtinh = d.thetrongtinh(m.nhom_duoc);
s_thetunguyen = d.thetunguyen(m.nhom_duoc);
if (s_thetunguyen != "")
{
s_tunguyen = s_thetunguyen.Replace(",", "','");
}
string vitri = d.thetunguyen_vitri_ora(m.nhom_duoc);
if (vitri != "")
{
v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1));
}
dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0];
madoituong.DataSource = m.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0];
madoituong.DisplayMember = "DOITUONG";
madoituong.ValueMember = "MADOITUONG";
sql = "select * from " + user + ".btdkp_bv";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " where makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
sql += " order by loai,makp";
dtkp = m.get_data(sql).Tables[0];
makp.DataSource = dtkp;
makp.DisplayMember = "TENKP";
makp.ValueMember = "MAKP";
taotable();
loaidt.SelectedIndex = 0;
}
private void frmTtkcbngtr_Load(object sender, System.EventArgs e)
{
user = m.user;
i_nhom = m.nhom_duoc;
s_thetrongtinh = d.thetrongtinh(i_nhom);
s_thetunguyen = d.thetunguyen(i_nhom);
if (s_thetunguyen != "")
{
s_tunguyen = s_thetunguyen.Replace(",", "','");
}
string vitri = d.thetunguyen_vitri_ora(i_nhom);
if (vitri != "")
{
v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1));
}
dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0];
madoituong.DataSource = d.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0];
madoituong.DisplayMember = "DOITUONG";
madoituong.ValueMember = "MADOITUONG";
taotable();
loaidt.SelectedIndex = 0;
}
