private void frmInphieu_Load(object sender, System.EventArgs e)
{
link = ttb.dbLink;
user = ttb.user; xxx = user;// +s_mmyy;
f_ngay = ttb.f_ngay;
bInngang = ttb.bPhieulinh_ngang(i_nhom);
bDoituong_phieulinh = ttb.bDoituong_Phieulinh(i_nhom);
xem.Checked = ttb.bPreview;
banin.Enabled = !xem.Checked;
s_doc = "";
if (ttb.bHoten_docGN(i_nhom) != 0)
{
s_doc += ttb.bHoten_docGN(i_nhom).ToString() + ",";
}
if (ttb.bHoten_docHTT(i_nhom) != 0)
{
s_doc += ttb.bHoten_docHTT(i_nhom).ToString() + ",";
}
if (ttb.bHoten_docAB(i_nhom) != 0)
{
s_doc += ttb.bHoten_docAB(i_nhom).ToString() + ",";
}
s_doc = (s_doc != "")?s_doc.Substring(0, s_doc.Length - 1):"";
bNhomin_mabd = ttb.bNhomin_mabd(i_nhom);
xuatcstt.Enabled = i_loai == 2 || bBuhaophi;
i_songay = ttb.Ngay_in_phieu(i_nhom);
ds.ReadXml("..\\..\\..\\xml\\ttb_inphieu.xml");
dsxml.ReadXml("..\\..\\..\\xml\\ttb_inphieu.xml");
sql = "select a.id,a.ma,trim(a.ten)||' '||a.hamluong as ten,a.dang,a.tenhc,c.ten as tennhom,c.stt as manhom,c.stt,d.ten as tenhang from " + user + ".ttb_dmbd a," + user + ".ttb_dmnhom b," + user + ".ttb_nhomin c," + user + ".ttb_dmhang d";
sql += " where a.manhom=b.id ";
if (bNhomin_mabd)
{
sql += " and a.nhomin=c.id ";
}
else
{
sql += " and b.nhomin=c.id ";
}
sql += " and a.mahang=d.id and a.nhom=" + i_nhom;
dt = ttb.get_data(sql).Tables[0];
tu.Value = new DateTime(int.Parse(s_ngay.Substring(6, 4)), int.Parse(s_ngay.Substring(3, 2)), int.Parse(s_ngay.Substring(0, 2)), 0, 0, 0);
den.Value = tu.Value;
phieu.DisplayMember = "TEN";
phieu.ValueMember = "ID";
phieu.DataSource = dtphieu;
if (i_phieu != -1)
{
phieu.SelectedValue = i_phieu.ToString();
}
else
{
phieu.SelectedIndex = 0;
}
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
makp.DataSource = dtkp;
if (i_makp != -1)
{
makp.SelectedValue = i_makp.ToString();
}
else
{
makp.SelectedIndex = 0;
}
if (ttb.bQuanlynguon(i_nhom))
{
dtnguon = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by id").Tables[0];
}
else
{
dtnguon = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by id").Tables[0];
}
manguon.DataSource = dtnguon;
manguon.DisplayMember = "TEN";
manguon.ValueMember = "ID";
dtdt = d.get_data("select * from " + d.user + ".d_doituong order by madoituong").Tables[0];
madoituong.DataSource = dtdt;
madoituong.DisplayMember = "DOITUONG";
madoituong.ValueMember = "MADOITUONG";
if (bDoituong_phieulinh)
{
foreach (DataRow r in dtdt.Rows)
{
dc = new DataColumn();
dc.ColumnName = "c_" + r["madoituong"].ToString().Trim();
dc.DataType = Type.GetType("System.Decimal");
ds.Tables[0].Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "c_" + r["madoituong"].ToString().Trim();
dc.DataType = Type.GetType("System.Decimal");
dsxml.Tables[0].Columns.Add(dc);
}
}
load_makho();
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
if (bBuhaophi)
{
file1 = "ttb_haophill"; file2 = "ttb_haophict";
}
else
{
switch (i_loai)
{
case 1: file1 = "ttb_dutrull"; file2 = "ttb_dutruct";
break;
case 2: file1 = "ttb_xtutrucll"; file2 = "ttb_xtutrucct";
break;
case 3: file1 = "ttb_hoantrall"; file2 = "ttb_hoantract";
break;
default: file1 = "ttb_haophill"; file2 = "ttb_haophict";
break;
}
}
}
