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(); }