public PrintPO PrintDonPO(string masoPO) { var data = db.Database.SqlQuery <GetAll_ThongTinChungDonHangPO_Result>("GetAll_ThongTinChungDonHangPO @masoPO", new SqlParameter("masoPO", masoPO)); var resultdata = data.FirstOrDefault(); var query = db.Database.SqlQuery <GetAll_ChiTiet_DonHangPO_Result>("GetAll_ChiTiet_DonHangPO @masoPO", new SqlParameter("masoPO", masoPO)); var resultquery = query.ToList(); PrintPO baogia = new PrintPO(); baogia.ChungPO = resultdata; baogia.ChiTietPO = resultquery; return(baogia); }
private void Print_Click(object sender, EventArgs e) { DataSet data = new purchaseCRUD().prPONO(txtPONO.Text); Application.DoEvents(); data.WriteXml("C:\\MyGarmentReport\\pono.xml", XmlWriteMode.WriteSchema); //data.WriteXmlSchema(Application.StartupPath + "\\costing.xsd"); //data.WriteXmlSchema(Application.StartupPath + "\\costing1.xml"); Form f = new PrintPO(); //f.MdiParent = MainMenu.ActiveForm; f.Show(); }