private void print() { try { dtct.AcceptChanges(); frmReport f = new frmReport(d, dtct, i_userid, d.f_getten_chinhanh(i_id_chinhanh), "d_duyetdutrukho.rpt"); f.ShowDialog(); } catch (Exception er) { MessageBox.Show(er.Message, "d_duyetdutrukho.rpt"); } }
private void butIn_Click(object sender, EventArgs e) { try { sql = "select f.sophieu,b.ma,b.id as mabd1 ,trim(b.ten)||' '||b.hamluong as ten,b.dang,c.stt as sttnhom,c.ten as tennhom,d.ten as tenhang,"; sql += "b.sltoithieu, b.tenhc,a.*,0 as slduyet,b.vtyt,h.ten as tennuoc "; sql += " from " + user + ".d_dutrukhoct a," + user + ".d_dutrukholl f," + user + ".d_dmbd b," + user + ".d_dmnhom c," + user + ".d_dmhang d," + user + ".d_dmkho e, " + user + ".d_dmnuoc h "; sql += " where a.mabd=b.id and b.manhom=c.id and b.mahang=d.id and e.id=f.makho and b.manuoc=h.id and a.id=f.id and f.makho=" + i_makho; sql += " and to_char(f.ngay,'dd/mm/yyyy')='" + s_ngaydangnhap + "'"; sql += " and a.id=" + l_iddutru + " and sophieu=" + cmbSophieu.Text; sql += " and a.soluong >0 "; sql += " and f.done =2 "; sql += " order by c.stt,b.ma"; DataSet ds = d.get_data(sql); foreach (DataRow row in d.get_data("select * from " + user + ".d_duyetdutrukhoct where id=" + l_id).Tables[0].Rows) { DataRow[] dr = ds.Tables[0].Select("mabd1=" + row["mabd"].ToString()); if (dr.Length > 0) { dr[0]["slduyet"] = decimal.Parse(row["soluong"].ToString()); } } // ds.Tables.Add(dv.Table.Copy()); if (chkXem.Checked) { ds.WriteXml("..//..//dataxml//d_duyetdutrukho.xml", XmlWriteMode.WriteSchema); } frmReport f = new frmReport(d, ds, i_userid, d.f_getten_chinhanh(i_id_chinhanh), "d_duyetdutrukho.rpt"); f.ShowDialog(); } catch (Exception er) { MessageBox.Show(lan.Change_language_MessageText("Lỗi :") + er.Message, "d_duyetdutrukho.rpt"); } }