private void MonthlySales() { dynamic stDay = mod_system.GetFirstDate(monCal.SelectionStart); dynamic laDay = mod_system.GetLastDate(monCal.SelectionEnd); string fillData = "dsSalesDaily"; string mysql = "SELECT customer_order.ID,customer_order.ORDERNUM,customer_order.ORDERDATE, "; mysql += "customer_order.QSTATUS,customer_order.QUEUEID,customer_order.MENUID, "; mysql += "customer_order.QTY,customer_order.MENUNAME,customer_order.MENUTYPE, "; mysql += "customer_order.MENUSIZE,customer_order.PRICE,customer_order.CASH, "; mysql += "customer_order.AMOUNTDUE,customer_order.`CHANGE`, "; mysql += "DATE_FORMAT(DOCDATE,'%m/%d/%Y')as 'DOCDATE', "; mysql += "customer_order.QIID,customer_order.QIStatus,customer_order.BOStatus "; mysql += "FROM customer_order "; mysql += string.Format("where DATE_FORMAT(DOCDATE,'%m/%d/%Y') BETWEEN '" + stDay + "' AND '" + laDay + "'"); mysql += " AND BOStatus = 1 AND QIStatus = 1"; Dictionary <string, string> rptPara = new Dictionary <string, string>(); rptPara.Add("txtDate", "FOR THE MONTH OF " + stDay.ToString("MMMM") + " " + stDay.Year); rptPara.Add("IsDailyMonthly", "Monthly Sales Report"); frmReport frm = new frmReport(); frm.ReportInit(mysql, fillData, @"Report\rptSalesReport.rdlc", rptPara); frm.Show(); }
private void DailySales() { string fillData = "dsSalesDaily"; string mysql = "SELECT customer_order.ID,customer_order.ORDERNUM,customer_order.ORDERDATE, "; mysql += "customer_order.QSTATUS,customer_order.QUEUEID,customer_order.MENUID, "; mysql += "customer_order.QTY,customer_order.MENUNAME,customer_order.MENUTYPE, "; mysql += "customer_order.MENUSIZE,customer_order.PRICE,customer_order.CASH, "; mysql += "customer_order.AMOUNTDUE,customer_order.`CHANGE`, "; mysql += "DATE_FORMAT(DOCDATE,'%m/%d/%Y')as 'DOCDATE', "; mysql += "customer_order.QIID,customer_order.QIStatus,customer_order.BOStatus "; mysql += "FROM customer_order "; mysql += string.Format("where DATE_FORMAT(DOCDATE,'%m/%d/%Y')= '{0}'", monCal.SelectionStart.ToShortDateString()); mysql += " AND BOStatus = 1 AND QIStatus = 1"; Dictionary <string, string> rptPara = new Dictionary <string, string>(); rptPara.Add("txtDate", "Date: " + monCal.SelectionStart.ToString("MMM dd, yyyy")); rptPara.Add("IsDailyMonthly", "Daily Sales Report"); frmReport frm = new frmReport(); frm.ReportInit(mysql, fillData, @"Report\rptSalesReport.rdlc", rptPara); frm.Show(); }
private void button1_Click(object sender, EventArgs e) { string mysql = "Select * From tblMenu"; string rpt_Path = "Report\rpt_Menu.rdlc"; //if (Application.OpenForms["frmReport"] != null) //{ // (Application.OpenForms["frmReport"] as frmReport).ReportInit(mysql,"dsMenuItem",rpt_Path); // (Application.OpenForms["frmReport"] as frmReport).Show(); //} frmReport tmp = new frmReport(); tmp.ReportInit(mysql, "dsMenuItem", rpt_Path); tmp.Show(); }
private void PrintOR(int queueID) { System.Threading.Thread.Sleep(2000); // Check if able to print Printer = tmpMaintenance.GetValue("PrinterReciept"); IsPrint = tmpMaintenance.GetValue("IsRecieptPrint"); if (!canPrint(Printer)) { return; } string mysql = "SELECT * FROM customer_order WHERE QUEUEID = " + queueID + " and QIStatus =1"; DataSet ds = null; string fillData = "TBLQUEUE"; ds = Database.LoadSQL(mysql, fillData); string OrderNum = String.Format("ORDER # 0000{0}", ds.Tables[0].Rows[0]["ORDERNUM"].ToString()); DateTime DocDate = Convert.ToDateTime(System.DateTime.Now); // Declare AutoPrint Reporting autoPrint = null; LocalReport report = new LocalReport(); autoPrint = new Reporting(); // Initialize Auto Print report.ReportPath = @"Report\rptReciept.rdlc"; report.DataSources.Add(new ReportDataSource(fillData, ds.Tables[fillData])); // Assign Parameters Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("txtUsername", mod_system.ORuser.Username); // Importer Parameters if ((dic != null)) { foreach (KeyValuePair <string, string> param in dic) { var nPara = param; ReportParameter tmpPara = new ReportParameter(); tmpPara.Name = nPara.Key; tmpPara.Values.Add(nPara.Value); report.SetParameters(new ReportParameter[] { tmpPara }); Console.WriteLine(string.Format("{0}: {1}", nPara.Key, nPara.Value)); } } if (IsPrint == "YES") { frmReport frm = new frmReport(); frm.ReportInit(mysql, "dsORPRINT", @"Report\rptReciept.rdlc", dic); frm.Show(); } else { // Executing Auto Print autoPrint.Export(report); autoPrint.m_currentPageIndex = 0; autoPrint.Print(Printer); } }