private void btn_pgop_Click(object sender, EventArgs e)
{
Print print = new Print();
List <CheckBoxEx> lcb = new List <CheckBoxEx>();
List <CheckBoxEx> tcb = new List <CheckBoxEx>();
for (int i = 0; i < time.Length; i++)
{
CheckBoxEx cb = time[i];
if (cb.Checked == true)
{
lcb.Add(cb);
}
}
for (int i = 0; i < typelist.Length; i++)
{
CheckBoxEx cb = typelist[i];
if (cb.Checked == true)
{
tcb.Add(cb);
}
}
if (lcb.Count == 1)
{
String cmdText = "";
if (lcb.Count > 0)
{
cmdText = "select f.shortName,o.oTakeTime ,COUNT(*) AS COUNT FROM orders O, orderFood OF, food F WHERE O.orderDate=OF.orderDate AND O.orderId=OF.orderId AND OF.foodId=F.foodId and o.status = 'processing'";
cmdText += "AND O.oTakeTime in(";
for (int i = 0; i < lcb.Count; i++)
{
if (i != 0)
{
cmdText += ",";
}
cmdText += "'" + lcb[i].Text + ":00'";
}
cmdText += ")";
}
if (tcb.Count > 0)
{
cmdText += "AND F.fTypeId IN (";
for (int i = 0; i < tcb.Count; i++)
{
if (i != 0)
{
cmdText += ",";
}
cmdText += "'" + tcb[i].Tag + "'";
}
cmdText += ")";
}
cmdText += "GROUP BY f.foodId";
DataTable dt = db.printGrp(cmdText);
String s = "Asia Pacific";
for (int j = 0; j < dt.Rows.Count; j++)
{
s += "\r" + dt.Rows[j]["shortname"] + "-Qty:" + dt.Rows[j]["count"];
}
s += "\rTake Time:" + dt.Rows[0]["otaketime"];
String[] context = s.Split('\r');
if (!Directory.Exists(@"C:\\My Documents\\" + todayString + "\\"))
{
DirectoryInfo di = Directory.CreateDirectory(@"C:\\My Documents\\" + todayString + "\\");
}
String path = @"C:\\My Documents\\" + todayString + "\\O99999999_99-99-99_(1@1).txt";
System.IO.File.WriteAllLines(path, context);
print.print("O99999999_99-99-99_(1@1).txt");
}
else
{
MessageBox.Show("Please choose one time only.");
}
}
private void PrintMessage_click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Do you want to print these time group order?", "Confirmation", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
Print print = new Print();
String nowTime = DateTime.Now.ToString("HH-mm-ss");
String nowTime2 = nowTime.Substring(0, 2) + ":" + nowTime.Substring(3, 2) + ":" + nowTime.Substring(6, 2);
List <CheckBoxEx> lcb = new List <CheckBoxEx>();
List <CheckBoxEx> tcb = new List <CheckBoxEx>();
int printcount = 0;
for (int i = 0; i < time.Length; i++)
{
CheckBoxEx cb = time[i];
if (cb.Checked == true)
{
lcb.Add(cb);
}
}
for (int i = 0; i < typelist.Length; i++)
{
CheckBoxEx cb = typelist[i];
if (cb.Checked == true)
{
tcb.Add(cb);
}
}
if (lcb.Count > 0)
{
String cmdText = "";
if (lcb.Count > 0)
{
cmdText = "select * FROM orders O, orderFood OF, food F WHERE O.orderDate=OF.orderDate AND O.orderId=OF.orderId AND OF.foodId=F.foodId and o.status = 'processing'";
cmdText += "AND O.oTakeTime in(";
for (int i = 0; i < lcb.Count; i++)
{
if (i != 0)
{
cmdText += ",";
}
cmdText += "'" + lcb[i].Text + ":00'";
}
cmdText += ")";
}
if (tcb.Count > 0)
{
cmdText += "AND F.fTypeId IN (";
for (int i = 0; i < tcb.Count; i++)
{
if (i != 0)
{
cmdText += ",";
}
cmdText += "'" + tcb[i].Tag + "'";
}
cmdText += ")";
}
cmdText += "GROUP BY o.orderid";
DataTable dt = db.printGrp(cmdText);
for (int j = 0; j < dt.Rows.Count; j++)
{
printcount++;
String counter = "(" + printcount + "/" + dt.Rows.Count + ")";
String s = "Asia Pacific";
s += "\r" + dt.Rows[j]["orderid"];
DataTable orderDt = db.getDb2(dt.Rows[j]["orderid"].ToString());
for (int k = 0; k < orderDt.Rows.Count; k++)
{
s += "\r" + orderDt.Rows[k]["shortname"];
}
s += "\rTake Time:" + dt.Rows[j]["otaketime"]; //get order string end
s += "\r" + nowTime2;
s += "\r" + counter;
String[] context = s.Split('\r');
if (!Directory.Exists(@"C:\\My Documents\\" + todayString + "\\"))
{
DirectoryInfo di = Directory.CreateDirectory(@"C:\\My Documents\\" + todayString + "\\");
}
String path = @"C:\\My Documents\\" + todayString + "\\" + context[1] + "_" + nowTime + "_(" + printcount + "@" + dt.Rows.Count + ").txt";
System.IO.File.WriteAllLines(path, context);
String filename = (context[1] + "_" + nowTime + "_(" + printcount + "@" + dt.Rows.Count + ").txt");
print.print(filename);
db.update(context[1], nowTime2);
}
}
if (lcb.Count == 0)
{
MessageBox.Show("Plesae choose time first!");
}
}
else
{
MessageBox.Show("Printing is Canelled");
}
}