private void Selltoday_Click(object sender, RoutedEventArgs e) { Selltoday go = new Selltoday(); go.Show(); }
private void Insert2DB() { try { using (con) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = con; for (int i = 0; i < dataGrid.Items.Count; i++) { count += 1; object item = dataGrid.Items[i]; string showidProduct = (dataGrid.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text; string shownameProduct = (dataGrid.SelectedCells[1].Column.GetCellContent(item) as TextBlock).Text; string showtotalProduct = (dataGrid.SelectedCells[2].Column.GetCellContent(item) as TextBlock).Text; string showdeleteProduct = (dataGrid.SelectedCells[3].Column.GetCellContent(item) as TextBlock).Text; string showallTotal = (dataGrid.SelectedCells[4].Column.GetCellContent(item) as TextBlock).Text; string showPrice = (dataGrid.SelectedCells[5].Column.GetCellContent(item) as TextBlock).Text; string showType = (dataGrid.SelectedCells[6].Column.GetCellContent(item) as TextBlock).Text; string showPriceall = (dataGrid.SelectedCells[7].Column.GetCellContent(item) as TextBlock).Text; string showNote = (dataGrid.SelectedCells[8].Column.GetCellContent(item) as TextBlock).Text; con.Open(); string sqlproID = "SELECT proID FROM product WHERE proCode='" + showidProduct + "'"; MySqlCommand cmdproID = new MySqlCommand(sqlproID, con); MySqlDataReader readproID = cmdproID.ExecuteReader(); while (readproID.Read()) { getproID = readproID["proID"].ToString(); } con.Close(); con.Open(); string getValue = "SELECT stockTotal FROM stock WHERE proID='" + getproID + "'"; MySqlCommand getCommand = new MySqlCommand(getValue, con); MySqlDataReader getReader = getCommand.ExecuteReader(); getTotal = Double.Parse(showallTotal); while (getReader.Read()) { getStockTotal = Convert.ToDouble(getReader["stockTotal"]); Totalall = getStockTotal - getTotal; } con.Close(); con.Open(); MySqlCommand cmdgettype = new MySqlCommand("SELECT typepID FROM typeproduct WHERE typepName='" + showType + "'", con); MySqlDataReader readtype = cmdgettype.ExecuteReader(); while (readtype.Read()) { getTypeid = readtype.GetString(readtype.GetOrdinal("typepID")); } con.Close(); if (count >= 1) { con.Open(); cmd.CommandText = @"INSERT INTO selltoday(docID,sellDate,cusID,cusName,cusLastname,cusPlate,sellCode,sellName,sellTotal,sellDtotal,sellTotalall,sellPrice,typepID,sellAllprice,sellInfo) VALUES (@Bill,@DATE,@cusID,@nameCus,@lastnameCus,@plateCus,@buyCode,@buyName,@buyTotal,@buyDtotal,@buyTotalall,@buyPrice,@buyType,@buyAllprice,@buyInfo); UPDATE stock SET stockTotal='" + Totalall + "' WHERE proID='" + getproID + "'"; cmd.Parameters.AddWithValue("@Bill", ShowBill.Text); cmd.Parameters.AddWithValue("@DATE", Convert.ToDateTime(txtDate.Text).ToString("yyyy/MM/dd")); cmd.Parameters.AddWithValue("@nameCus", txtName.Text); cmd.Parameters.AddWithValue("@lastnameCus", txtLname.Text); cmd.Parameters.AddWithValue("@plateCus", txtPlate.Text); cmd.Parameters.AddWithValue("@buyCode", showidProduct); cmd.Parameters.AddWithValue("@buyName", shownameProduct); cmd.Parameters.AddWithValue("@buyTotal", showtotalProduct); cmd.Parameters.AddWithValue("@buyDtotal", showdeleteProduct); cmd.Parameters.AddWithValue("@buyTotalall", showallTotal); cmd.Parameters.AddWithValue("@buyPrice", showPrice); cmd.Parameters.AddWithValue("@buyType", getTypeid); cmd.Parameters.AddWithValue("@buyAllprice", showPriceall); cmd.Parameters.AddWithValue("@buyInfo", showNote); if (calcusID == 1) { cmd.Parameters.AddWithValue("@cusID", txtID.Text); } else if (calcusID == 2) { cmd.Parameters.AddWithValue("@cusID", varcusID); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); con.Close(); } else { con.Open(); cmd.CommandText = @"INSERT INTO selltoday(docID,sellDate,cusID,cusName,cusLastname,cusPlate,sellCode,sellName,sellTotal,sellDtotal,sellTotalall,sellPrice,typepID,sellAllprice,sellInfo) VALUES (@Bill,@DATE,@cusID,@nameCus,@lastnameCus,@plateCus,@buyCode,@buyName,@buyTotal,@buyDtotal,@buyTotalall,@buyPrice,@buyType,@buyAllprice,@buyInfo); INSERT INTO receiptsell(receiptDate,receiptCode,cusID,cusName,cusLastname,cusPlate,receiptInfo,receiptPriceall) VALUES(@DATE,@Bill,@cusID,@nameCus,@lastnameCus,@plateCus,@buyInfo,@buyAllprice); UPDATE stock SET stockTotal='" + Totalall + "' WHERE proID='" + getproID + "'"; cmd.Parameters.AddWithValue("@Bill", ShowBill.Text); cmd.Parameters.AddWithValue("@DATE", Convert.ToDateTime(txtDate.Text).ToString("yyyy/MM/dd")); cmd.Parameters.AddWithValue("@nameCus", txtName.Text); cmd.Parameters.AddWithValue("@lastnameCus", txtLname.Text); cmd.Parameters.AddWithValue("@plateCus", txtPlate.Text); cmd.Parameters.AddWithValue("@buyCode", showidProduct); cmd.Parameters.AddWithValue("@buyName", shownameProduct); cmd.Parameters.AddWithValue("@buyTotal", showtotalProduct); cmd.Parameters.AddWithValue("@buyDtotal", showdeleteProduct); cmd.Parameters.AddWithValue("@buyTotalall", showallTotal); cmd.Parameters.AddWithValue("@buyPrice", showPrice); cmd.Parameters.AddWithValue("@buyType", getTypeid); cmd.Parameters.AddWithValue("@buyAllprice", showPriceall); cmd.Parameters.AddWithValue("@buyInfo", showNote); if (calcusID == 1) { cmd.Parameters.AddWithValue("@cusID", txtID.Text); } else if (calcusID == 2) { cmd.Parameters.AddWithValue("@cusID", varcusID); } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); con.Close(); } } // ปิด LOOP } // ปิด Using } } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("บันทึกเรียบร้อยแล้ว", "สำเร็จ"); Selltoday go = new Selltoday(); this.Close(); go.Show(); }