private void Form便當菜_Load(object sender, EventArgs e)
{
Form值日生端 myform值日生端 = new Form值日生端();
lbl店家名.Text = StoreName;
scsb = new SqlConnectionStringBuilder();
scsb.DataSource = @".";
scsb.InitialCatalog = "MidReport";
scsb.IntegratedSecurity = true;
SqlConnection con = new SqlConnection(scsb.ToString());
con.Open();
string strSQL = "select *From StoreFoodInfo where StoreName =@SearchStoreName";
SqlCommand cmd = new SqlCommand(strSQL, con);
cmd.Parameters.AddWithValue("@SearchStoreName", lbl店家名.Text);
SqlDataReader reader = cmd.ExecuteReader();
string strMsg = "";
string strPrice = "";
while (reader.Read() == true)
{
strMsg = string.Format("{0}", reader["StoreFood"]);
strPrice = string.Format("{0}", reader["StoreFoodPrice"]);
listBox1.Items.Add(strMsg);
listBox2.Items.Add(strPrice);
}
reader.Close();
}
private void 值輸btn登入值日生系統_Click(object sender, EventArgs e)
{
if ((tb值日生姓名.Text.Length > 0) && (tb值日生班級.Text.Length > 0) && (tb值日生電話.Text.Length > 0))
{
SqlConnection con = new SqlConnection(scsb.ToString());
con.Open();
string strSQL = "Insert Into 值日生Info(@new值日生班級,@new值日生姓名,@new值日生電話)";
SqlCommand cmd = new SqlCommand(strSQL, con);
cmd.Parameters.AddWithValue("@New值日生班級", tb值日生班級.Text);
cmd.Parameters.AddWithValue("@New值日生姓名", tb值日生姓名.Text);
cmd.Parameters.AddWithValue("@New值日生電話", tb值日生電話.Text);
Form值日生端 myform值日生端 = new Form值日生端();
Form學生端 myform學生端 = new Form學生端();
Form值日生輸入 myform值日生輸入資料 = new Form值日生輸入();
Form櫃台端 myform櫃台端 = new Form櫃台端(tb值日生姓名.Text);
myform值日生端.Show();
//myform值日生端.ShowDialog();
myform值日生輸入資料.ShowInTaskbar = false;
myform學生端.Show();
//myform學生端.ControlBox = false;
//myform學生端.WindowState = FormWindowState.Minimized;
myform學生端.Dispose();
con.Close();
}
else
{
MessageBox.Show("請輸入完整資料");
}
}
private void 學btn送出訂單_Click(object sender, EventArgs e)
{
Form值日生端 myform值日生端 = new Form值日生端();
SqlConnection con = new SqlConnection(scsb.ToString());
con.Open();
string strSQL1 = "select StudentClass, StudentName, StudentPhoneNum,StoreFood, SUM(Price) AS TotalPrice,SUM(Amount) AS TotalAmount From FormStudentChoice Group By StudentClass, StudentName, StudentPhoneNum,StoreFood";
SqlCommand cmd1 = new SqlCommand(strSQL1, con);
SqlDataReader reader1 = cmd1.ExecuteReader();
string strStoreFood = "";
int strTotalA = 0;
int strTotalP = 0;
string strClass = "";
//string strTotalStoreFood = "";
string strStudentName = "";
string strStudentPhoneNum = "";
while (reader1.Read() == true)
{
strClass = string.Format("{0}", reader1["StudentClass"]);
strStudentName = string.Format("{0}", reader1["StudentName"]);
strStudentPhoneNum = string.Format("{0}", reader1["StudentPhoneNum"]);
strStoreFood += string.Format("{0}", reader1["StoreFood"]) + " ";
strTotalP += Convert.ToInt32(string.Format("{0}", reader1["TotalPrice"]));
strTotalA += Convert.ToInt32(string.Format("{0}", reader1["TotalAmount"]));
//strTotalStoreFood += strStoreFood;
}
myform值日生端.strTotalP1 = strTotalP;
myform值日生端.strTotalA1 = strTotalA;
myform值日生端.strList = "班級:" + strClass + "," + strStudentName + ",電話:" + strStudentPhoneNum + strStoreFood + ",價錢:" + Convert.ToString(myform值日生端.strTotalP1) + ",數量:" + Convert.ToString(myform值日生端.strTotalA1);
myform值日生端.Show();
this.Close();
}
