/*บันทึกข้อมูลการขายสินค้าฝากลงในฐานข้อมูล*/ private void saveDataSale() { frmEarnestMain frm = new frmEarnestMain(); List<String> listq; String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(COSaleHeadId) from CO_SALE_HEAD where COSaleHeadId = '" + txtCSHeadId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_SALE_WEIGHT WHERE COSaleHeadId = '" + txtCSHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_SALE_DETAIL WHERE COSaleHeadId = '" + txtCSHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_SALE_HEAD WHERE COSaleHeadId = '" + txtCSHeadId.Text + "' "; ListSql.Add(sql); if (Convert.ToDecimal(txtPledge.Text) > 0) { listq = frm.EarnestRemove(txtCSHeadId.Text); ListSql.AddRange(listq); } } //Delete payment sql = "select count(PaymentId) from PAYMENT where SaleHeadId = '" + txtCSHeadId.Text + "'"; dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count > 0) { sql = "DELETE PAYMENT WHERE SaleHeadId = '" + txtCSHeadId.Text + "' "; ListSql.Add(sql); } //End delete payment //Delete paycheck sql = "select count(PayCheckId) from PAYCHECK where SaleHeadId = '" + txtCSHeadId.Text + "'"; dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count > 0) { sql = "DELETE PAYCHECK WHERE SaleHeadId = '" + txtCSHeadId.Text + "' "; ListSql.Add(sql); } //End delete paycheck String CQNew = ""; String strCreditStatus, strCashStatus, strPaymentStatus, strCheckStatus, strPledgeStatus; if (txtCredit.Text == "0.00") { strCreditStatus = "0"; } else { strCreditStatus = "1"; } if (txtCash.Text == "0.00") { strCashStatus = "0"; } else { strCashStatus = "1"; } if (txtSumPayment.Text == "0.00") { strPaymentStatus = "0"; } else { strPaymentStatus = "1"; } if (txtSumCheck.Text == "0.00") { strCheckStatus = "0"; } else { strCheckStatus = "1"; } if (txtPledge.Text == "0.00") { strPledgeStatus = "0"; } else { strPledgeStatus = "1"; } String strBookCode; if (txtBookCode.Text != "") { strBookCode = Class.Function.GetTextId(txtBookCode.Text); } else { strBookCode = ""; } Double Discount = Convert.ToDouble(TxtDiscount.Text); String cust = Class.Function.GetTextId(txtCustomer.Text); String stock = Class.Function.GetTextId(txtStock.Text); String rdate = Class.Function.GetDate(dateTimePicker1.Value); String strCheckDate = Class .Function .GetDate (dateTimePicker2 .Value ); String UserName = clsCash.sUserIdLogin; Double Credit = Convert.ToDouble(txtCredit.Text); Double Cash = Convert.ToDouble(txtCash.Text); Double Payment = Convert.ToDouble(txtSumPayment.Text); Double PayCehck = Convert.ToDouble(txtSumCheck.Text); Double PayDis = Convert.ToDouble(txtPayDis.Text); Double Pledge = Convert.ToDouble(txtPledge.Text); String pricetotal = TxtPriceTotal.Text.Replace(",",""); if (Convert.ToDecimal(txtPledge.Text) > 0) { listq = frm.EarnestSet(cust, txtCSHeadId.Text, Convert.ToDecimal(txtPledge.Text)); ListSql.AddRange(listq); } if (CmboxVat.SelectedIndex == 0) { strVat = "1"; } else if (CmboxVat.SelectedIndex == 1) { strVat = "7"; } else if (CmboxVat.SelectedIndex == 2) { strVat = "8"; } sql = "INSERT INTO CO_SALE_HEAD([COSaleHeadId],[COSaleHeadDate],[COSaleHeadDateTime],[CustomerId],[COSaleHeadStatusId]," + "[COSaleHeadConfirmStatus],[CreditStatus],[CashStatus],[PaymentStatus],[CheckStatus]," + "[COTotalPrice],[CODiscount],[COBaseVat],[Tax_auto_id],[CORateVat]," + "[COSaleVat],[COSaleShipping],[COSumPrice],[CODescription],[UserName]," + "[CODiscountText],[Shipper],[GrStockDetailId],[Credit],[Cash]," + "[Payment],[PayCehck],[PayDis],[PledgeStatus],[Pledge]," + "[PayTotal])" + "VALUES('" + txtCSHeadId.Text + "','" + rdate + "',GETDATE(),'" + cust + "','1'," + "'1','" + strCreditStatus + "','" + strCashStatus + "','" + strPaymentStatus + "','" + strCheckStatus + "'," + "" + pricetotal.ToDecimal().ToString() + "," + Discount + "," + TxtBaseVat.Text.ToDecimal().ToString() + "," + strVat + "," + TxtPercentVat.Text + "," + "" + TxtVat.Text + ",'" + textBox1.Text + "','" + TxtAmountTotal.Text.ToDecimal().ToString() + "','" + TxtDescription.Text + "','" + UserName + "'," + "'" + TxtDiscountText.Text + "','','" + stock + "','" + Credit.ToDecimal().ToString() + "','" + Cash.ToDecimal().ToString() + "'," + "'" + Payment + "','" + PayCehck + "','" + PayDis + "','" + strPledgeStatus + "','" + Pledge + "'," + "'" + txtPayTotal.Text.ToDecimal().ToString() + "'" + ")"; ListSql.Add(sql); //Insert Payment if (Convert.ToDouble(txtSumPayment.Text) > 0) { foreach (DataGridViewRow row in dgvPayment.Rows) { try { String strBankBookCode = row.Cells[0].Value.ToString(); String strPay = row.Cells[6].Value.ToString(); sql = "INSERT INTO PAYMENT(SaleHeadId,BankBookCode,Pay)VALUES('" + txtCSHeadId.Text + "','" + strBankBookCode + "','" + strPay + "')"; ListSql.Add(sql); } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } } //End insert payment //Insert PayCheck if (Convert.ToDouble(txtSumCheck.Text) > 0) { foreach (DataGridViewRow row in dgvPayCheck.Rows) { try { String strPayCheckDate = row.Cells[3].Value.ToString(); DateTime date1 = DateTime.Parse(strPayCheckDate); String strDay = date1.Day.ToString(); String strMonth = date1.Month.ToString(); String strYear = (Convert.ToInt16(date1.Year.ToString())).ToString(); String strDate = strYear + "-" + strMonth + "-" + strDay; String strBankAccountId = row.Cells[0].Value.ToString(); String strBankBranch = row.Cells[2].Value.ToString(); String strCheckId = row.Cells[4].Value.ToString(); String strPay = row.Cells[5].Value.ToString(); sql = "INSERT INTO PAYCHECK(PayCheckDate,SaleHeadId,BankAccountId,BankBranch,CheckId,Pay)VALUES(" + "'" + strDate + "','" + txtCSHeadId.Text + "','" + strBankAccountId + "','" + strBankBranch + "'," + "'" + strCheckId + "','" + strPay + "')"; ListSql.Add(sql); } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } } //End insert PayCheck List<string> iProductId = new List<string>(); foreach (DataGridViewRow row in dgvDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); iProductId.Add(ProductId); Double QuantityPack = Convert .ToDouble ( row.Cells[2].Value.ToString()); Double QuantitySale = Convert .ToDouble ( row.Cells[4].Value.ToString()); String QuantityWeight = row.Cells[6].Value.ToString(); Double PricePerUnit = Convert.ToDouble ( row.Cells[8].Value.ToString()); String strDisText = row.Cells[9].Value.ToString(); String strDisPerUnit = row.Cells[10].Value.ToString(); String strDiscountBth = row.Cells[11].Value.ToString(); String data = row.Cells[12].Value.ToString(); String type = row.Cells[13].Value.ToString(); Double PriceQuantity = Convert .ToDouble ( row.Cells[14].Value.ToString()); //String strCQHeadId = row.Cells[15].Value.ToString(); sql = "INSERT INTO CO_SALE_DETAIL(COSaleHeadId,ProductId,COSaleDetailQuantityPack,COSaleDetailQuantity,COSaleDetailWeight,COSaleDetailPriceUnit," + "PriceQuantity,DisText,DisPerUnit,DiscountBth,DetailType,CQHeadId) " + "VALUES ('" + txtCSHeadId.Text + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale.ToDecimal().ToString() + "','" + QuantityWeight + "','" + PricePerUnit.ToDecimal().ToString() + "'," + "'" + PriceQuantity.ToDecimal().ToString() + "','" + strDisText + "','" + strDisPerUnit + "','" + strDiscountBth + "','" + type + "','')"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO CO_SALE_WEIGHT(COSaleHeadId,ProductId,COSalePackId,COSalePack,COSaleWeight,CQHeadId) " + "VALUES ('" + txtCSHeadId.Text + "','" + ProductId + "','" + Pack + "','" + Quantity.ToDecimal().ToString() + "','" + Weight + "','')"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtCSHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } SalePos7CSK.frmSaleOrderMatch frmcut = new SalePos7CSK.frmSaleOrderMatch(cust, txtCSHeadId.Text.Trim(), SalePos7CSK.CaseSrc.SaleDeposit); frmcut.showMsg = false; DataTable saleMath = frmcut.CustBalance(cust, iProductId); if (saleMath.Rows.Count > 0 || head != null) { if (MessageBox.Show("พบสินค้าในใบสั่งขายสำหรับลูกค้านี้ ต้องการตัดใบสั่งขายหรือไหม", "", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { if (head != null) { frmcut.CancelMatching(txtCSHeadId.Text.Trim()); frmcut.Reload(); frmcut.Match(); } else { frmcut.Reload(); frmcut.Match(); } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCSHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 8, 0); rpt.ShowDialog(); } if (CheckFrom == 0) { setNewForm(); } else if (CheckFrom == 1) { this.Close(); } } }
private void toolStripButton6_Click(object sender, EventArgs e) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataSale(), 8, 0); rpt.ShowDialog(); }
/*บันทึกข้อมูลของใบโอนสินค้าส่งไปฝากขายลงในฐานข้อมูล*/ private void InsertValue() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvHead.Rows.Count > 0) { arraydetailid += dgvHead.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvHead.Rows.Count; i++) { arraydetailid += "," + dgvHead.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(COHeadId) from COSIGNMENT_STOCK_HEAD where COHeadId = '" + txtCOSentId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE CO_STOCK_DETAIL WHERE COHeadId = '" + txtCOSentId.Text + "' "; ListSql.Add(sql); sql = "DELETE COSIGNMENT_STOCK_HEAD WHERE COHeadId = '" + txtCOSentId.Text + "' "; ListSql.Add(sql); sql = "DELETE RECEIVE_SHIP WHERE ReceiveHeadId = '" + txtCOSentId.Text + "' and shipType = '" + shipType + "' "; ListSql.Add(sql); } String CQNew = ""; String CQ; for (int nbRow = 0; nbRow < dgvHead.Rows.Count; nbRow++) { CQ = dgvHead.Rows[nbRow].Cells[0].Value.ToString(); if (CQNew != CQ) { CQNew = CQ; String sqldeleteR = "update CO_REQ_HEAD set COStatusId='1' where CQHeadId='" + CQNew + "'"; SqlDataReader readerUpdateHead1 = DBConnString.clsDB.QueryDataReader(sqldeleteR); } } String rdate = Class.Function.GetDate(dateTimePicker1.Value); String stock = Class.Function.GetTextId(txtStock.Text); String shipper = Class.Function.GetTextId(txtShipper.Text); String UserName = clsCash.sUserIdLogin; Double Summary = Convert.ToDouble(txtSummary.Text); sql = "INSERT INTO COSIGNMENT_STOCK_HEAD([COHeadId],[COHeadDate],[COHeadDateTime],[ShipperId],[UserName],[COTypeId],[COStatusId],[ConfirmId]," + "[PriceTotal],[DisText],[Dis],[VatBase],[VatType],[VatPer],[Vat],[TotalPrice],[Description],[GrStockDetailId],[Shipping],[Shipper],[ShipDate])" + "VALUES('" + txtCOSentId.Text + "','" + rdate + "',GETDATE(),'" + shipper + "','" + UserName + "','','1','1'," + "'','','','','','','','" + Summary.ToString("N2") + "','" + TxtDescription.Text + "','" + stock + "','','" + txtShippNumber.Text + "','" + Class.Function.GetDate(dtpShip.Value) + "')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvHead.Rows) { try { String strCQHeadId = row.Cells[0].Value.ToString(); sql = "INSERT INTO CO_STOCK_DETAIL([COHeadId],[CQHeadId],[Price])" + "VALUES ('" + txtCOSentId.Text + "','" + strCQHeadId + "','')"; ListSql.Add(sql); } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (dgvship.Rows.Count > 0) { foreach (DataGridViewRow row in dgvship.Rows) { String shipnum = Convert.ToDouble(row.Cells[0].Value.ToString()).ToString(); String shipproduct = row.Cells[1].Value.ToString(); String shipunit = Convert.ToDouble(row.Cells[3].Value.ToString()).ToString(); String shipsum = Convert.ToDouble(row.Cells[4].Value.ToString()).ToString(); String strunit = row.Cells[2].Value.ToString(); sql = "INSERT INTO RECEIVE_SHIP(Shipnum,ShipProduct,ShipUnit,ShipSum,ReceiveHeadId,unit,shipType)" + "VALUES (" + shipnum + ",'" + shipproduct + "'," + shipunit + "," + shipsum + ",'" + txtCOSentId.Text + "','" + strunit + "','" + shipType + "')"; ListSql.Add(sql); } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtCOSentId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCOSentId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataReport(), 1, 0, txtCOSentId.Text); rpt.ShowDialog(); } if (CheckFrom == 0) { setNewForm(); } else if (CheckFrom == 1) { this.Close(); } } }
private void insertAndUpdate() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvTRDetail.Rows.Count > 0) { arraydetailid += dgvTRDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvTRDetail.Rows.Count; i++) { arraydetailid += "," + dgvTRDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } Int32 dCount; sql = "select count(TRHeadId) as count from TR_RE_HEAD where TRHeadId = '" + txtTRID.Text + "'"; SqlDataReader reader = DBConnString.clsDB.QueryDataReader(sql); if (reader.Read()) { dCount = Convert.ToInt32(reader["count"].ToString()); if (dCount != 0) { String sql1 = "DELETE TR_RE_WEIGHT WHERE TRHeadId = '" + txtTRID.Text + "' "; ListSql.Add(sql1); String sql2 = "DELETE TR_RE_DETAIL WHERE TRHeadId = '" + txtTRID.Text + "' "; ListSql.Add(sql2); String sql3 = "DELETE TR_RE_HEAD WHERE TRHeadId = '" + txtTRID.Text + "' "; ListSql.Add(sql3); } } String cusid = Class.Function.GetTextId(txtBra.Text); String rdate = Class.Function.GetDate(dateTimePicker1.Value); String UserName = clsCash.sUserIdLogin; String PriceTotal = Convert.ToDouble(TxtPriceTotal.Text.Trim()) + ""; String DisText = TxtDiscountText.Text.Trim().ToString(); String Dis = Convert.ToDouble(TxtDiscount.Text.Trim()) + ""; String VatBase = Convert.ToDouble(TxtBaseVat.Text.Trim()) + ""; String VatPer = Convert.ToDouble(TxtPercentVat.Text.Trim()) + ""; String Vat = Convert.ToDouble(TxtVat.Text.Trim()) + ""; String TotalPrice = Convert.ToDouble(TxtAmountTotal.Text.Trim()) + ""; String Description = txtDesc.Text.Trim(); if (CmboxVat.SelectedIndex == 0) { VatType = "1"; } else if (CmboxVat.SelectedIndex == 1) { VatType = "7"; } else if (CmboxVat.SelectedIndex == 2) { VatType = "8"; } sql = "INSERT INTO TR_RE_HEAD([TRHeadId],[TRHeadDate],[TRHeadDateTime],[TRRound],[TRHeadStatusId],[TRHeadConfirmStatus],[TRTotalPrice],[TRDiscountText]," + "[TRDiscount],[TRBaseVat],[Tax_auto_id],[TRRateVat],[TRVat],[TRShipping],[TRSumPrice],[Description],[UserName],[CustomerId],[Reqs])" + "VALUES('" + txtTRID.Text + "','" + rdate + "',GETDATE(),'" + txtRou.Text + "','1','1','" + PriceTotal + "','" + DisText + "','" + Dis + "'," + "'" + VatBase + "','" + VatType + "','" + VatPer + "','" + Vat + "','" + textBox1.Text + "','" + TotalPrice + "','" + Description + "','" + UserName + "'," + "'" + cusid + "','')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvTRDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); String QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()).ToString(); String QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()).ToString(); String QuantityWeight = Convert.ToDouble(row.Cells[6].Value.ToString()).ToString(); String PricePerUnit = Convert.ToDouble(row.Cells[8].Value.ToString()).ToString(); String strDisText = row.Cells[9].Value.ToString().ToString(); String strDisPerUnit = Convert.ToDouble(row.Cells[10].Value.ToString()).ToString(); String strDiscountBth = Convert.ToDouble(row.Cells[11].Value.ToString()).ToString(); String data = row.Cells[12].Value.ToString(); String type = row.Cells[13].Value.ToString(); String PriceQuantity = Convert.ToDouble(row.Cells[14].Value.ToString()).ToString(); sql = "INSERT INTO TR_RE_DETAIL([TRHeadId],[ProductId],[TRDetailQuantityPack],[TRDetailQuantity],[TRDetailWeight]," + "[TRDetailPriceUnit],[DiscountBth],[DisText],[PriceQuantity],[DetailType],[DisPerUnit]) " + "VALUES ('" + txtTRID.Text + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale + "','" + QuantityWeight + "','" + PricePerUnit + "'," + "'" + strDiscountBth + "','" + strDisText + "','" + PriceQuantity + "','" + type + "','" + strDisPerUnit + "')"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO TR_RE_WEIGHT([TRWeight],[ProductId],[TRHeadId],[TRPackId],[TRPack]) " + "VALUES ('" + Weight + "','" + ProductId + "','" + txtTRID.Text + "','" + Pack + "','" + Quantity + "')"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ตรงรูปแบบ"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลใบโอนสินค้าใหม่เลขที่ " + txtTRID.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtTRID.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 5, 0); rpt.ShowDialog(); } if (CheckForm == 0) { setNewForm(); } else if (CheckForm == 1) { this.Close(); } } }
private void toolStripButton6_Click(object sender, EventArgs e) { if (CheckSearch == 1) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataSE(), 6, 0); rpt.ShowDialog(); } else if (CheckSearch == 2) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataRE(), 5, 0); rpt.ShowDialog(); } }
/*บันทึกใบเบิกสินค้าส่งไปฝากขายลงในฐานข้อมูล*/ private void insertAndUpdate() { String sql = ""; List<String> ListSql = new List<String>(); String rid = txtReq.Text; List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(CQHeadId) from CO_REQ_HEAD where CQHeadId = '" + txtReq.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_REQ_WEIGHT WHERE CQHeadId = '" + rid + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_REQ_DETAIL WHERE CQHeadId = '" + rid + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_REQ_HEAD WHERE CQHeadId = '" + rid + "' "; ListSql.Add(sql); } String cust = Class.Function.GetTextId(txtTotal.Text); String stock = Class.Function.GetTextId(txtStock.Text); String rdate = Class.Function.GetDate(dateTimePicker1.Value); String UserName = clsCash.sUserIdLogin; String Desc = txtDesc.Text.Trim(); Double Total = Convert.ToDouble(txtTotal.Text); sql = "INSERT INTO CO_REQ_HEAD([CQHeadId],[CQHeadDate],[CQHeadDateTime],[GrStockDetailId],[CustomerId],[UserName],[CQStatusId],[ConfirmId],[Description]," + "[COStatusId],[Total])" + "VALUES('" + rid + "','" + rdate + "',GETDATE(),'" + stock + "','" + cust + "','" + UserName + "','1','1','" + Desc + "','0','" + Total.ToString ("N2") + "')" + ""; ListSql.Add(sql); int j = 0; List<string> iProductId = new List<string>(); foreach (DataGridViewRow row in dgvDetail.Rows) { getNewDetailID(); j = j + 1; String strNewCQID=(strMax+j).ToString (); String ProductId = row.Cells[0].Value.ToString(); iProductId.Add(ProductId); Double QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()); Double QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()); String QuantityWeight = row.Cells[6].Value.ToString(); String PricePerUnit = Convert.ToDouble(row.Cells[8].Value.ToString()).ToString("N2"); String data = row.Cells[9].Value.ToString(); String type = row.Cells[10].Value.ToString(); Double PriceQuantity = Convert.ToDouble(row.Cells[11].Value.ToString()); sql = "INSERT INTO CO_REQ_DETAIL(CQDetailId,CQHeadId,ProductId,CQDetailQuantityPack,CQDetailQuantity,CQDetailWeight,CQDetailPriceUnit," + "PriceQuantity,DisText,DisPerUnit,DiscountBth,DetailType) " + "VALUES ('" + strNewCQID + "','" + rid + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale + "','" + QuantityWeight + "','" + PricePerUnit + "'," + "'" + PriceQuantity.ToString("N2") +"','0.00','0.00','0.00','" + type + "')"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO CO_REQ_WEIGHT(CQHeadId,ProductId,CQPackId,CQPack,CQWeight,CQDetailId) " + "VALUES ('" + rid + "','" + ProductId + "'," + Pack + "," + Quantity + "," + Weight + ",'" + strNewCQID + "')"; ListSql.Add(sql); } } } try { } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ตรงรูปแบบ"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลใบเบิกใหม่เลขที่ " + rid + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } /* */ if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + rid + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 7, 0, txtReq.Text); rpt.ShowDialog(); } if (CheckFrom == 0) { setNewForm(); } else if (CheckFrom == 1) { this.Close(); } } }
/*บันทึกข้อมูลยอดยกมาสินค้าฝากลงในฐานข้อมูล*/ private void InsertValue() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(CoBringHeadId) from CO_BRI_HEAD where CoBringHeadId = '" + txtCoBringHeadId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE CO_BRI_DETAIL WHERE CoBringHeadId = '" + txtCoBringHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE CO_BRI_HEAD WHERE CoBringHeadId = '" + txtCoBringHeadId.Text + "' "; ListSql.Add(sql); } String rdate = Class.Function.GetDate(dateTimePicker1.Value); String stock = Class.Function.GetTextId(txtStock.Text); String UserName = clsCash.sUserIdLogin; sql = "INSERT INTO [CO_BRI_HEAD] VALUES (" + "'" + txtCoBringHeadId.Text + "','" + rdate + "',GETDATE(),'" + stock + "','" + txtDesc.Text + "','" + UserName + "'" + ")"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvDetail.Rows) { try { String strPack, strQtty; String strProductId = row.Cells[0].Value.ToString(); if (row.Cells[2].Value.ToString() == "") { strPack = "0.00"; } else { strPack = Convert.ToDouble(row.Cells[2].Value.ToString()).ToString("N2"); } if (row.Cells[4].Value.ToString() == "") { strQtty = "0.00"; } else { strQtty = Convert.ToDouble(row.Cells[4].Value.ToString()).ToString("N2"); } sql = "INSERT INTO CO_BRI_DETAIL(CoBringHeadId,ProductId,Pack,Quantity)" + "VALUES ('" + txtCoBringHeadId.Text + "','" + strProductId + "','" + strPack + "','" + strQtty + "')"; ListSql.Add(sql); } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtCoBringHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCoBringHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataReport(), 12); rpt.ShowDialog(); } if (CheckFrom == 0) { setNewForm(); } else if (CheckFrom == 1) { this.Close(); } } }
private void toolStripButton3_Click(object sender, EventArgs e) { if (HeadId == null) { MessageBox.Show("กรุณาเลือกรายการเพื่อพิมพ์รายงาน"); } else { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataSent(), 12); rpt.ShowDialog(); } }
private void SaveDataSale() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvSaleDetail.Rows.Count > 0) { arraydetailid += dgvSaleDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvSaleDetail.Rows.Count; i++) { arraydetailid += "," + dgvSaleDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(COSaleHeadId) from CO_SALE_HEAD where COSaleHeadId = '" + txtSaleId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_SALE_WEIGHT WHERE COSaleHeadId = '" + txtSaleId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_SALE_DETAIL WHERE COSaleHeadId = '" + txtSaleId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_SALE_HEAD WHERE COSaleHeadId = '" + txtSaleId.Text + "' "; ListSql.Add(sql); } if (strReqId == txtRequis.Text) { String sqldeleteR = "update SALE_APP_HEAD set statusId='3',SaleHeadId=null where SdateId='" + txtRequis.Text + "'"; SqlDataReader readerUpdateHead1 = DBConnString.clsDB.QueryDataReader(sqldeleteR); } else { String sqldeleteR = "update SALE_APP_HEAD set statusId='5',SaleHeadId=null where SdateId='" + strReqId + "'"; SqlDataReader readerUpdateHead1 = DBConnString.clsDB.QueryDataReader(sqldeleteR); sqldeleteR = "update SALE_APP_HEAD set statusId='3',SaleHeadId=null where SdateId='" + txtRequis .Text + "'"; readerUpdateHead1 = DBConnString.clsDB.QueryDataReader(sqldeleteR); } String supid = Class.Function.GetTextId(txtSupplier.Text); String shipid = Class.Function.GetTextId(txtShipper.Text); String stock = Class.Function.GetTextId(txtStock.Text); String rdate = Class.Function.GetDate(dptSaleDate.Value); String UserName = clsCash.sUserIdLogin; if (CmboxVat.SelectedIndex == 0) { strVat = "1"; } else if (CmboxVat.SelectedIndex == 1) { strVat = "7"; } else if (CmboxVat.SelectedIndex == 2) { strVat = "8"; } sql = "INSERT INTO CO_SALE_HEAD([COSaleHeadId],[COSaleHeadDate],[COSaleHeadDateTime],[CustomerId],[COSaleHeadStatusId]," + "[COSaleHeadConfirmStatus],[COSaleHeadPayTypeId],[ShipperId],[SdateId],[COHeadId],[COTotalPrice],[CODiscount],[COBaseVat],[Tax_auto_id],[CORateVat]," + "[COSaleVat],[COSaleShipping],[COSumPrice],[COCash],[CODeposit],[COCredit],[CODescription],[UserName],[CODiscountText],[Shipper],[GrStockDetailId])" + "VALUES('" + txtSaleId.Text + "','" + rdate + "',GETDATE(),'" + supid + "','1','1','" + strPayType + "','" + shipid + "'," + "'" + txtRequis.Text + "','','" + TxtPriceTotal.Text + "','" + TxtDiscount.Text + "','" + TxtBaseVat.Text + "','" + strVat + "'," + "'" + TxtPercentVat.Text + "','" + TxtVat.Text + "','" + textBox1.Text + "','" + TxtAmountTotal.Text + "',''," + "'','','" + TxtDescription.Text + "','" + UserName + "','" + TxtDiscountText.Text + "','" + txtShipp.Text + "','" + stock + "')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvSaleDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); String QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()).ToString(); String QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()).ToString(); String QuantityWeight = Convert.ToDouble(row.Cells[6].Value.ToString()).ToString(); String PricePerUnit = Convert.ToDouble(row.Cells[8].Value.ToString()).ToString(); String strDisText = row.Cells[9].Value.ToString().ToString(); String strDisPerUnit = Convert.ToDouble(row.Cells[10].Value.ToString()).ToString(); String strDiscountBth = Convert.ToDouble(row.Cells[11].Value.ToString()).ToString(); String data = row.Cells[12].Value.ToString(); String type = row.Cells[13].Value.ToString(); String PriceQuantity = Convert.ToDouble(row.Cells[14].Value.ToString()).ToString(); sql = "INSERT INTO CO_SALE_DETAIL(COSaleHeadId,ProductId,COSaleDetailQuantityPack,COSaleDetailQuantity,COSaleDetailWeight,COSaleDetailPriceUnit," + "PriceQuantity,DisText,DisPerUnit,DiscountBth,DetailType) " + "VALUES ('" + txtSaleId.Text + "','" + ProductId + "'," + QuantityPack + "," + QuantitySale + "," + QuantityWeight + "," + PricePerUnit + "," + "" + PriceQuantity + ",'" + strDisText + "','" + strDisPerUnit + "','" + strDiscountBth + "'," + type + ")"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO CO_SALE_WEIGHT(COSaleHeadId,ProductId,COSalePackId,COSalePack,COSaleWeight) " + "VALUES ('" + txtSaleId.Text + "','" + ProductId + "'," + Pack + "," + Quantity + "," + Weight + ")"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtSaleId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtSaleId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 2, 0); rpt.ShowDialog(); } if (CheckForm == 0) { setNewForm(); } else if (CheckForm == 1) { this.Close(); } } }
/*บันทึกข้อมูลของใบรับคืนสินค้าฝากจากลูกค้าลงในฐานข้อมูล*/ private void saveDataSale() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(CCHeadId) from CO_RECUST_HEAD where CCHeadId = '" + txtCCHeadId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_RECUST_WEIGHT WHERE CCHeadId = '" + txtCCHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_RECUST_DETAIL WHERE CCHeadId = '" + txtCCHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_RECUST_HEAD WHERE CCHeadId = '" + txtCCHeadId.Text + "' "; ListSql.Add(sql); } String FromStatus; if (radioButton1.Checked == true) { FromStatus = "1"; } else { FromStatus = "2"; } String strDiscount = TxtDiscount.Text; String cust = Class.Function.GetTextId(txtCustomer.Text); String stock = Class.Function.GetTextId(txtStock.Text); String rdate = Class.Function.GetDate(dateTimePicker1.Value); String UserName = clsCash.sUserIdLogin; Double Ship = Convert.ToDouble(textBox1.Text); if (CmboxVat.SelectedIndex == 0) { strVat = "1"; } else if (CmboxVat.SelectedIndex == 1) { strVat = "7"; } else if (CmboxVat.SelectedIndex == 2) { strVat = "8"; } sql = "INSERT INTO [CO_RECUST_HEAD]([CCHeadId],[CCHeadDate],[CCHeadDateTime],[CustomerId],[CCHeadStatusId],[CCHeadConfirmStatus],[CCTotalPrice]," + "[CCDiscount],[CCBaseVat],[Tax_auto_id],[CCRateVat],[CCVat],[CCShipping],[CCSumPrice],[CCDescription],[UserName],[CCDiscountText],[GrStockDetailId],[CCFromStatus])" + "VALUES('" + txtCCHeadId.Text + "','" + rdate + "',GETDATE(),'" + cust + "','1','1','" + TxtPriceTotal.Text + "'," + "'" + strDiscount + "','" + TxtBaseVat.Text + "','" + strVat + "','" + TxtPercentVat.Text + "','" + TxtVat.Text + "','" + Ship .ToString ("N2") + "'," + "'" + TxtAmountTotal.Text + "','" + TxtDescription.Text + "','" + UserName + "','" + TxtDiscountText.Text + "','" + stock + "','" + FromStatus + "')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); Double QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()); Double QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()); String QuantityWeight = row.Cells[6].Value.ToString(); String PricePerUnit = row.Cells[8].Value.ToString(); String strDisText = row.Cells[9].Value.ToString(); String strDisPerUnit = row.Cells[10].Value.ToString(); String strDiscountBth = row.Cells[11].Value.ToString(); String data = row.Cells[12].Value.ToString(); String type = row.Cells[13].Value.ToString(); String PriceQuantity = row.Cells[14].Value.ToString(); String strCQHeadId = row.Cells[15].Value.ToString(); sql = "INSERT INTO [CO_RECUST_DETAIL]([CCHeadId],[ProductId],[CCDetailQuantityPack],[CCDetailQuantity],[CCDetailWeight]," + "[CDetailPriceUnit],[DiscountBth],[DisText],[PriceQuantity],[DetailType],[DisPerUnit])" + "VALUES('" + txtCCHeadId.Text + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale + "','" + QuantityWeight + "'," + "'" + PricePerUnit + "','" + strDiscountBth + "','" + strDisText + "','" + PriceQuantity + "','" + type + "','" + strDisPerUnit + "')"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO [CO_RECUST_WEIGHT]([CCHeadId],[ProductId],[CCPackId],[CCPack],[CCWeight]) " + "VALUES ('" + txtCCHeadId.Text + "','" + ProductId + "'," + Pack + "," + Quantity + "," + Weight + ")"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลใบรับคืนสินค้าใหม่เลขที่ " + txtCCHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCCHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataSale(), 9, 0); rpt.ShowDialog(); } if (CheckFrom == 0) { setNewForm(); } else if (CheckFrom == 1) { this.Close(); } } }
private void toolStripButton4_Click(object sender, EventArgs e) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataReq(), 7, 0, strCQHeadId); rpt.ShowDialog(); }
/*บันทึกใบรับคืนสินค้าฝากในฐานข้อมูล*/ private void SaveData() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(CRHeadId) from CO_RE_HEAD where CRHeadId = '" + txtCRHeadId.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_RE_WEIGHT WHERE CRHeadId = '" + txtCRHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_RE_DETAIL WHERE CRHeadId = '" + txtCRHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_RE_HEAD WHERE CRHeadId = '" + txtCRHeadId.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM RECEIVE_SHIP WHERE ReceiveHeadId = '" + txtCRHeadId.Text + "' and shipType = '" + shipType + "' "; ListSql.Add(sql); } String stock = Class.Function.GetTextId(txtStock.Text); String shipid = Class.Function.GetTextId(txtShipper.Text); String rdate = Class.Function.GetDate(dateTimePicker1.Value); String UserName = clsCash.sUserIdLogin; Double Summary = Convert.ToDouble(txtSummary.Text); sql = "INSERT INTO CO_RE_HEAD([CRHeadId],[CRHeadDate],[CRHeadDateTime],[GrStockDetailId],[CRHeadStatusId],[CRHeadConfirmStatus],[ShipperId],[COHeadId]," + "[CRTotalPrice],[CRDiscount],[CRBaseVat],[Tax_auto_id],[CRRateVat],[CRVat],[CRShipping],[CRSumPrice],[CRDescription],[UserName],[CRDiscountText]," + "[Shipper],[ShipDate])" + "VALUES('" + txtCRHeadId.Text + "','" + rdate + "',GETDATE(),'" + stock + "','1','1','" + shipid + "',''," + "'','','','',''," + "'','','" + Summary.ToString("N2") + "','" + TxtDescription.Text + "','" + UserName + "','','" + txtShippNumber.Text + "','" + Class.Function.GetDate(dtpShip.Value) + "')"; ListSql.Add(sql); foreach (DataGridViewRow row in dgvDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); Double QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()); Double QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()); String QuantityWeight = row.Cells[6].Value.ToString(); String PricePerUnit = Convert.ToDouble(row.Cells[8].Value.ToString()).ToString("N2"); String data = row.Cells[9].Value.ToString(); String type = row.Cells[10].Value.ToString(); Double PriceQuantity = Convert.ToDouble(row.Cells[11].Value.ToString()); sql = "INSERT INTO CO_RE_DETAIL([CRHeadId],[ProductId],[CRDetailQuantityPack],[CRDetailQuantity],[CRDetailWeight]," + "[CRDetailPriceUnit],[DiscountBth],[DisText],[PriceQuantity],[DetailType],[DisPerUnit])" + "VALUES ('" + txtCRHeadId.Text + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale + "','" + QuantityWeight + "'," + "'" + PricePerUnit + "','0.00','0.00','" + PriceQuantity.ToString ("N2") + "','" + type + "','0.00')"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO CO_RE_WEIGHT([CRWeight],[ProductId],[CRHeadId],[CRPackId],[CRPack])" + "VALUES ('" + Weight + "','" + ProductId + "','" + txtCRHeadId.Text + "','" + Pack + "','" + Quantity + "')"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (dgvship.Rows.Count > 0) { foreach (DataGridViewRow row in dgvship.Rows) { String shipnum = Convert.ToDouble(row.Cells[0].Value.ToString()).ToString(); String shipproduct = row.Cells[1].Value.ToString(); String shipunit = Convert.ToDouble(row.Cells[3].Value.ToString()).ToString(); String shipsum = Convert.ToDouble(row.Cells[4].Value.ToString()).ToString(); String strunit = row.Cells[2].Value.ToString(); sql = "insert into RECEIVE_SHIP (Shipnum,Shipproduct,ShipUnit,ShipSum,ReceiveHeadId,unit,shipType)" + "values(" + shipnum + ",'" + shipproduct + "'," + shipunit + "," + shipsum + ",'" + txtCRHeadId.Text + "','" + strunit + "'," + shipType + ")"; ListSql.Add(sql); } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtCRHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCRHeadId.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 3, 0); rpt.ShowDialog(); } if (CheckForm == 0) { setNewForm(); } else if (CheckForm == 1) { this.Close(); } } }
private void button3_Click(object sender, EventArgs e) { if (dgvStockKey.Rows.Count <= 0) { MessageBox.Show("กรุณาค้นหาข้อมูลก่อน"); } else { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataReport(), 10, 0); rpt.ShowDialog(); } }
private void SaveDataCD() { String sql = ""; List<String> ListSql = new List<String>(); List<String> ListSqlQtyX = new List<String>(); String arraydetailid = ""; if (dgvDetail.Rows.Count > 0) { arraydetailid += dgvDetail.Rows[0].Cells[0].Value.ToString(); for (int i = 1; i < dgvDetail.Rows.Count; i++) { arraydetailid += "," + dgvDetail.Rows[i].Cells[0].Value.ToString(); } } if (arraydetailid == "") { arraydetailid = "0"; } if (DBConnString.clsDB.ExecuteTransaction(ListSqlQtyX.ToArray())) { List<String> ListSqlstsX = new List<String>(); DBConnString.clsDB.ExecuteTransaction(ListSqlstsX.ToArray()); } sql = "select count(CDHeadId) from CO_REAM_HEAD where CDHeadId = '" + txtCDID.Text + "'"; DataTable dtc = Class.DBConnString.clsDB.QueryDataTable(sql); Int32 Count = Convert.ToInt32(dtc.Rows[0][0].ToString()); if (Count != 0) { sql = "DELETE FROM CO_REAM_WEIGHT WHERE CDHeadId = '" + txtCDID.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_REAM_DETAIL WHERE CDHeadId = '" + txtCDID.Text + "' "; ListSql.Add(sql); sql = "DELETE FROM CO_REAM_HEAD WHERE CDHeadId = '" + txtCDID.Text + "' "; ListSql.Add(sql); } String rdate = Class.Function.GetDate(dateTimePicker1.Value); String stock = Class.Function.GetTextId(txtStock.Text); String UserName = clsCash.sUserIdLogin; Double Price = Convert.ToDouble(TxtPriceTotal.Text); sql = "INSERT INTO CO_REAM_HEAD(" + "CDHeadId,CDHeadDate,CDHeadDateTime,CDTypeId,CDHeadStatusId," + "ConfirmId,CDTotalPrice,[Description],[UserName],CustomerId" + ")VALUES(" + "'" + txtCDID.Text + "','" + rdate + "',GETDATE(),'" + cmbType.SelectedValue + "','1'," + "'1','" + Price + "','" + txtDesc.Text + "','" + UserName + "','" + Class.Function.GetTextId(textBox1.Text) + "'" + ")"; ListSql.Add(sql); //Set status RO foreach (DataGridViewRow row in dgvDetail.Rows) { if (row.Cells[11].Value.ToString() != "") { String strROId = row.Cells[11].Value.ToString(); sql = "UPDATE SALE_APP_HEAD set statusId='7',SaleHeadId='" + txtCDID.Text + "' where SdateId='" + strROId + "' "; ListSql.Add(sql); } }//End set status RO foreach (DataGridViewRow row in dgvDetail.Rows) { try { String ProductId = row.Cells[0].Value.ToString(); Double QuantityPack = Convert.ToDouble(row.Cells[2].Value.ToString()); Double QuantitySale = Convert.ToDouble(row.Cells[4].Value.ToString()); Double QuantityWeight = Convert.ToDouble(row.Cells[6].Value.ToString()); Double PricePerUnit = Convert .ToDouble ( row.Cells[7].Value.ToString()); String data = row.Cells[8].Value.ToString(); String type = row.Cells[9].Value.ToString(); Double PriceQuantity = Convert.ToDouble(row.Cells[10].Value.ToString()); String SdateId = row.Cells[11].Value.ToString(); //String strSdateId = row.Cells[12].Value.ToString(); sql = "INSERT INTO CO_REAM_DETAIL(" + "CDHeadId,ProductId,CDDetailQuantityPack,CDDetailQuantity,CDDetailWeight," + "CDDetailPriceUnit,PriceQuantity,DetailType,SdateId" + ")VALUES (" + "'" + txtCDID.Text + "','" + ProductId + "','" + QuantityPack + "','" + QuantitySale + "','" + QuantityWeight + "'," + "'" + PricePerUnit + "','" + PriceQuantity + "','" + type + "','" + SdateId + "'" + ")"; ListSql.Add(sql); if (type != "3") { String[] weight = data.Split('#'); for (int i = 0; i < weight.Length - 1; i++)//1 2 3,4 5 6,7 8 9 { if (i % ((type == "1") ? 3 : 2) == 0) { String Pack = weight[i]; String Quantity = weight[i + 1]; String Weight = "0"; if (((type == "1") ? 3 : 2) == 3) { Weight = weight[i + 2]; } sql = "INSERT INTO CO_REAM_WEIGHT([CDWeight],[ProductId],[CDHeadId],[CDPackId],[CDPack])" + "VALUES ('" + Weight + "','" + ProductId + "','" + txtCDID.Text + "','" + Pack + "','" + Quantity + "')"; ListSql.Add(sql); } } } } catch { MessageBox.Show("error กรุณาป้อนข้อมูลให้ครบถ้วน"); return; } } if (MessageBox.Show("คุณต้องการบันทึกข้อมูลขายใหม่เลขที่ " + txtCDID.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DBConnString.clsDB.ExecuteTransaction(ListSql.ToArray())) { List<String> ListSqlQty = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlQty.ToArray())) { List<String> ListSqlsts = new List<String>(); if (DBConnString.clsDB.ExecuteTransaction(ListSqlsts.ToArray())) { } } } if (MessageBox.Show("บันทึกสำเร็จ คุณต้องการพิมพ์รายงาน " + txtCDID.Text + "\nใช่หรือไม่ ?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { StockAsiaDrink.COReport rpt = new StockAsiaDrink.COReport(DataPrice(), 4, 0); rpt.ShowDialog(); } if (CheckForm == 0) { setNewForm(); } else if (CheckForm == 1) { this.Close(); } } }