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