private void btnOK_Click(object sender, EventArgs e) { string[] st = MtbNgayTT.Text.Split('/'); Connect.ThaoTac("Delete * From TblDC"); appdc(); updc(); DataSet dts = new DataSet(); Connect.Loadds(dts, "Select * From TblDC", "TblDC"); Forms.frmHienThi frm = new Forms.frmHienThi(); Reports.SoCHO rpt = new KPBT.Reports.SoCHO(); rpt.NTN.Value = "Ngày " + st[0] + " tháng " + st[1] + " năm " + st[2]; rpt.TenDV.Value = Thongtinketxuat.Default.TenDV.ToString(); rpt.SoXAn.Value = "Số xuất ăn: " + string.Format("{0:#" + decimalChar + "#}", (xuatanS() + xuatanT() + xuatanC())); rpt.SoXuat.Value = xuatanS() + xuatanT() + xuatanC(); rpt.SoDuDN.Value = ""; rpt.MuAn.Value = mucan(); rpt.SoDChi.Value = (xuatanS() + xuatanT() + xuatanC()) * mucan(); rpt.TBSang.Value = string.Format("{0:#" + decimalChar + "#}", xuatanS() * mucan()); rpt.TBTrua.Value = string.Format("{0:#" + decimalChar + "#}", xuatanT() * mucan()); rpt.TBToi.Value = string.Format("{0:#" + decimalChar + "#}", xuatanC() * mucan()); rpt.DataSource = dts; frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(); frm.ShowDialog(); this.Close(); }
private void sổChợToolStripMenuItem_Click(object sender, EventArgs e) { string[] st = txtntnx.Text.Split('/'); Connect.ThaoTac("Delete * From TblDC"); clsocho.appdc(txtntnx.Text); clsocho.updc(txtntnx.Text); DataSet dts = new DataSet(); Connect.Loadds(dts, "Select * From TblDC order by TEN1", "TblDC"); Forms.frmHienThi frm = new Forms.frmHienThi(); Reports.SoCHO rpt = new KPBT.Reports.SoCHO(); rpt.NTN.Value = "Ngày " + st[0] + " tháng " + st[1] + " năm " + st[2]; rpt.TenDV.Value = thongtinketxuat.Default.tendv.ToString(); rpt.SoXAn.Value = "Số xuất ăn: " + string.Format("{0:#" + decimalChar + "#}", (clsocho.xuatanS(txtntnx.Text) + clsocho.xuatanT(txtntnx.Text) + clsocho.xuatanC(txtntnx.Text))); rpt.SoXuat.Value = clsocho.xuatanS(txtntnx.Text) + clsocho.xuatanT(txtntnx.Text) + clsocho.xuatanC(txtntnx.Text); rpt.SoDuDN.Value = ""; rpt.MuAn.Value = string.Format("{0:#" + decimalChar + "#}", clsocho.mucansang(txtntnx.Text)) + "/" + string.Format("{0:#" + decimalChar + "#}", clsocho.mucantrua(txtntnx.Text)) + "/" + string.Format("{0:#" + decimalChar + "#}", clsocho.mucantoi(txtntnx.Text)); rpt.SoDChi.Value = clsocho.xuatanS(txtntnx.Text) * clsocho.mucansang(txtntnx.Text) + clsocho.xuatanT(txtntnx.Text) * clsocho.mucantrua(txtntnx.Text) + clsocho.xuatanC(txtntnx.Text) * clsocho.mucantoi(txtntnx.Text); rpt.TBSang.Value = string.Format("{0:#" + decimalChar + "#}", clsocho.xuatanS(txtntnx.Text) * clsocho.mucansang(txtntnx.Text)); rpt.TBTrua.Value = string.Format("{0:#" + decimalChar + "#}", clsocho.xuatanT(txtntnx.Text) * clsocho.mucantrua(txtntnx.Text)); rpt.TBToi.Value = string.Format("{0:#" + decimalChar + "#}", clsocho.xuatanC(txtntnx.Text) * clsocho.mucantoi(txtntnx.Text)); rpt.DataSource = dts; frm.printControl1.PrintingSystem = rpt.PrintingSystem; rpt.CreateDocument(); frm.ShowDialog(); }