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; } } }