private void frmDutrukho_Load(object sender, System.EventArgs e)
{
//if (Screen.PrimaryScreen.WorkingArea.Width > 800) this.WindowState = System.Windows.Forms.FormWindowState.Normal;
tieude.Text = this.Text.ToUpper();
Cursor = Cursors.WaitCursor;
user = ttb.user; xxx = user;// +s_mmyy;
bNam = s_mmyy.Substring(0, 2) == "20";
s_dutrunam = (bNam) ? ttb.dutrunam_nhomin(i_nhom) : "";
if (bNam)
{
foreach (DataRow r in ttb.get_data("select * from " + user + ".ttb_tables where substr(mmyy,3,2)='" + s_mmyy.Substring(2) + "' order by mmyy").Tables[0].Rows)
{
s_mmyyt = r["mmyy"].ToString();
xxxt = user;// +s_mmyyt;
break;
}
}
else
{
if (ttb.bDutrumua_thangtruoc(i_nhom))
{
s_mmyyt = ttb.Mmyy_truoc(s_mmyy); xxxt = user;// +s_mmyyt;
}
else
{
s_mmyyt = s_mmyy; xxxt = xxx;
}
}
bFound = ttb.bMmyy(s_mmyyt);
if (bFound)
{
tmp = ttb.get_data("select * from " + xxxt + ".ttb_theodoi order by id desc").Tables[0];
}
format_soluong = ttb.format_soluong(i_nhom);
format_dongia = ttb.format_dongia(i_nhom);
dstt.ReadXml("..\\..\\..\\xml\\ttb_sttmua.xml");
sql = "select a.*,b.stt as sttnhom,b.ten as tennhom,c.ten as tenhang,d.ten as nhacc ";
sql += " from " + user + ".ttb_dmbd a inner join ";
if (i_nhom == 1)
{
sql += user + ".ttb_dmnhom b ";
}
else
{
sql += user + ".ttb_dmloai b ";
}
if (i_nhom == 1)
{
sql += " on a.manhom=b.id ";
}
else
{
sql += "on a.maloai=b.id ";
}
sql += " inner join " + user + ".ttb_dmhang c on a.mahang=c.id ";
sql += " left join " + user + ".ttb_dmnx d on a.madv=d.id ";
sql += " where a.nhom=" + i_nhom;
if (s_dutrunam != "")
{
sql += " and b.nhomin in (" + s_dutrunam + ")";
}
dt = ttb.get_data(sql).Tables[0];
load();
dataGrid1.ReadOnly = false;
CurrencyManager cm = (CurrencyManager)BindingContext[dataGrid1.DataSource, dataGrid1.DataMember];
DataView dv = (DataView)cm.List;
dv.AllowNew = false;
AddGridTableStyle();
Cursor = Cursors.Default;
}
