private void cmdExchange_Click(object sender, EventArgs e) { receive.frmCalculate frmCal = new KTCERP.receive.frmCalculate(lblCash.Text); frmCal.StartPosition = FormStartPosition.CenterParent; frmCal.ShowDialog(); double CashTotal = clsCash.sCashMoney; double Discount = clsCash.sDiscount; double DiscountPersent = clsCash.sDiscountPercent; lblNetDC.Text = Discount.ToString("#,##0.00"); if (MessageBox.Show("คุณต้องการบันทึกรายการ ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { //tr = Conn.BeginTransaction(); try { string sqlSave2; string ProductId; for (int i = 0; i <= lsvProductList.Items.Count - 1; i++) { ProductId = lsvProductList.Items[i].SubItems[4].Text; sb.Remove(0, sb.Length); sb.Append(" UPDATE OUTSIDE_STOCK_DETAIL "); sb.Append("SET OutsideStockDetail_DiscountBth=@OutsideStockDetail_DiscountBth,OutsideStockDetail_DiscountPercent=@OutsideStockDetail_DiscountPercent,OutsideStockDetail_PriceUnit=@OutsideStockDetail_PriceUnit,OutsideStockDetail_PoSupplier=@OutsideStockDetail_PoSupplier,OutsideStockDetail_PackingSupplier=@OutsideStockDetail_PackingSupplier,PoNumber=@PoNumber "); sb.Append("WHERE OutsideStockDetailId=@OutsideStockDetailId"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.CommandText = sqlSave2; com.Parameters.Add("@OutsideStockDetailId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[16].Text.Replace(",", ""); com.Parameters.Add("@OutsideStockDetail_DiscountBth", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[12].Text.Replace(",", "")).ToString("#,##0.00"); com.Parameters.Add("@OutsideStockDetail_DiscountPercent", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[13].Text.Replace(",", "")); com.Parameters.Add("@OutsideStockDetail_PriceUnit", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[10].Text.Replace(",", "")).ToString("#,##0.00"); com.Parameters.Add("@OutsideStockDetail_PoSupplier", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", ""); com.Parameters.Add("@OutsideStockDetail_PackingSupplier", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[1].Text.Replace(",", ""); com.Parameters.Add("@PoNumber", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[0].Text.Replace(",", ""); com.ExecuteNonQuery(); } // tr.Commit(); MessageBox.Show("แก้ไขราคาสำเร็จ"); Close(); } catch (Exception ex) { MessageBox.Show("ไม่สามารถแกไขรายการรับได้ เนื่องจาก " + ex.Message, "ข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning); // tr.Rollback(); } } }
private void cmdExchange_Click(object sender, EventArgs e) { receive.frmCalculate frmCal = new KTCERP.receive.frmCalculate(lblCash.Text); frmCal.StartPosition = FormStartPosition.CenterParent; frmCal.ShowDialog(); double CashTotal = clsCash.sCashMoney; double Discount = clsCash.sDiscount; double DiscountPersent = clsCash.sDiscountPercent; lblNetDC.Text = Discount.ToString("#,##0.00"); if (MessageBox.Show("คุณต้องการบันทึกรายการสั่งซื้อสินค้า ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { tr = Conn.BeginTransaction(); try { string sqlSave2; sb.Remove(0, sb.Length); sb.Append(" UPDATE RECEIVE_HEAD "); sb.Append("SET ReceiveDiscount=@ReceiveDiscount "); sb.Append("WHERE ReceiveHeadId=@ReceiveHeadId"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.Transaction = tr; com.CommandText = sqlSave2; com.Parameters.Add("@ReceiveHeadId", SqlDbType.NVarChar).Value = lblRecId.Text.Trim(); com.Parameters.Add("@ReceiveDiscount", SqlDbType.Float).Value = Discount; com.ExecuteNonQuery(); string ProductId; for (int i = 0; i <= lsvProductList.Items.Count - 1; i++) { ProductId = lsvProductList.Items[i].SubItems[3].Text; sb.Remove(0, sb.Length); sb.Append(" UPDATE RECEIVE_DETAIL "); sb.Append("SET DiscountBth=@DiscountBth,DiscountPercent=@DiscountPercent,ReceiveDetailPriceUnit=@ReceiveDetailPriceUnit "); sb.Append("WHERE ReceiveDetailId=@ReceiveDetailId"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.CommandText = sqlSave2; com.Parameters.Add("@ReceiveDetailId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[18].Text.Replace(",", ""); com.Parameters.Add("@ReceiveDetailPriceUnit", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[11].Text.Replace(",", "")).ToString("#,##0.0000"); com.Parameters.Add("@DiscountBth", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[14].Text.Replace(",", "")); com.Parameters.Add("@DiscountPercent", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[15].Text.Replace(",", "")); com.ExecuteNonQuery(); } tr.Commit(); MessageBox.Show("แก้ไขราคาสำเร็จ"); Close(); } catch (Exception ex) { MessageBox.Show("ไม่สามารถแกไขรายการรับได้ เนื่องจาก " + ex.Message, "ข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning); //cmdSave.Focus(); tr.Rollback(); } } }
private void cmdSave_Click(object sender, EventArgs e) { receive.frmCalculate frmCal = new KTCERP.receive.frmCalculate(lblNet.Text); frmCal.StartPosition = FormStartPosition.CenterParent; frmCal.ShowDialog(); double CashTotal = clsCash.sCashMoney; double Discount = clsCash.sDiscount; if (cboDrawId.Text == "") { cboDrawId.Focus(); return; } if (MessageBox.Show("คุณต้องการบันทึกรายการสั่งซื้อสินค้า ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { tr = Conn.BeginTransaction(); try { string sqlSave2; sb.Remove(0, sb.Length); sb.Append(" UPDATE RECEIVE_HEAD "); sb.Append("SET ReceiveHeadDate=@ReceiveHeadDate,ShipperId=@ShipperId,ReceiveHeadDateTime=@ReceiveHeadDateTime,ReceiveTypeId=@ReceiveTypeId,DrawId=@DrawId,LocationProductId=@LocationProductId,ReceiveDiscount=@ReceiveDiscount,EmployerId=@EmployerId,UserName=@UserName "); sb.Append("WHERE ReceiveHeadId=@ReceiveHeadId"); sb.Append(" DELETE FROM RECEIVE_DETAIL "); sb.Append("WHERE ReceiveHeadId=@ReceiveHeadId"); sb.Append(" DELETE FROM RECEIVE_WEIGHT "); sb.Append("WHERE ReceiveHeadId = @ReceiveHeadId"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.Transaction = tr; com.CommandText = sqlSave2; com.Parameters.Add("@EmployerId", SqlDbType.NVarChar).Value = intEmployerId; com.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = userId; com.Parameters.Add("@ReceiveHeadId", SqlDbType.NVarChar).Value = lblRecId.Text.Trim(); com.Parameters.Add("@ReceiveHeadDate", SqlDbType.DateTime).Value = dptRecDate.Value.ToString("dd/MM/yyyy"); com.Parameters.Add("@ReceiveHeadDateTime", SqlDbType.DateTime).Value = dptRecDate.Value.ToString("dd/MM/yyyy HH:mm:ss"); com.Parameters.Add("@ShipperId", SqlDbType.Int).Value = intShipperId; com.Parameters.Add("@ReceiveTypeId", SqlDbType.NVarChar).Value = cboReceiveType.SelectedValue.ToString(); com.Parameters.Add("@DrawId", SqlDbType.NVarChar).Value = txtDrawId.Text.Trim(); com.Parameters.Add("@LocationProductId", SqlDbType.NVarChar).Value = cboDrawId.SelectedValue.ToString(); com.Parameters.Add("@ReceiveDiscount", SqlDbType.Float).Value = Discount; com.ExecuteNonQuery(); //**/ string ProductId; for (int i = 0; i <= lsvProductList.Items.Count - 1; i++) { ProductId = lsvProductList.Items[i].SubItems[3].Text; sb.Remove(0, sb.Length); sb.Append("INSERT INTO RECEIVE_DETAIL (ReceiveHeadId,SupplierId,ProductId,ReceiveDetailQuantityPack,ReceiveDetailQuantity,ReceiveDetailPriceUnit,ReceiveDetailTotal,AmountProduct,ShippingId,Invoice,DateBillShipping,DateBillSupplier)"); sb.Append(" VALUES( @ReceiveHeadId,@SupplierId,@ProductId,@ReceiveDetailQuantityPack,@ReceiveDetailQuantity,@ReceiveDetailPriceUnit,@ReceiveDetailTotal,@AmountProduct,@ShippingId,@Invoice,@DateBillShipping,@DateBillSupplier)"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.CommandText = sqlSave2; com.Parameters.Add("@ReceiveHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblRecId.Text.Trim()); com.Parameters.Add("@SupplierId", SqlDbType.Int).Value = Convert.ToInt16(lsvProductList.Items[i].SubItems[14].Text.Replace(",", "")); com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[3].Text.Replace(",", ""); com.Parameters.Add("@ShippingId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[1].Text.Replace(",", ""); com.Parameters.Add("@Invoice", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", ""); if (lsvProductList.Items[i].SubItems[9].Text.Replace(",", "") != "") { com.Parameters.Add("@ReceiveDetailQuantityPack", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[9].Text.Replace(",", "")); } else { com.Parameters.Add("@ReceiveDetailQuantityPack", SqlDbType.NVarChar).Value = ""; } if (lsvProductList.Items[i].SubItems[5].Text.Replace(",", "") != "") { com.Parameters.Add("@AmountProduct", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[5].Text.Replace(",", "")); } else { com.Parameters.Add("@AmountProduct", SqlDbType.NVarChar).Value = "0"; ; } com.Parameters.Add("@ReceiveDetailQuantity", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[7].Text.Replace(",", "")).ToString("#,##0.00"); com.Parameters.Add("@ReceiveDetailPriceUnit", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[12].Text.Replace(",", "")).ToString("#,##0.0000"); com.Parameters.Add("@ReceiveDetailTotal", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[13].Text.Replace(",", "")).ToString("#,##0.00"); com.Parameters.Add("@DateBillShipping", SqlDbType.DateTime).Value = Convert.ToDateTime(lsvProductList.Items[i].SubItems[15].Text.Replace(",", "")); //("dd/MM/yyyy"); com.Parameters.Add("@DateBillSupplier", SqlDbType.DateTime).Value = Convert.ToDateTime(lsvProductList.Items[i].SubItems[16].Text.Replace(",", "")); //("dd/MM/yyyy"); com.ExecuteNonQuery(); string weightext = lsvProductList.Items[i].SubItems[10].Text.ToString(); string Packtext = lsvProductList.Items[i].SubItems[11].Text.ToString(); string[] weighttextarr = weightext.Split('#'); int len = weighttextarr.Length; string[] Packtextarr = Packtext.Split('#'); int lenPack = Packtextarr.Length; if ((weightext != "") && (Packtext != "")) { for (int j = 0; j < weighttextarr.Length - 1; j++) { sb.Remove(0, sb.Length); sb.Append("INSERT INTO RECEIVE_WEIGHT (ReceiveHeadId,ProductId,ReceiveWeight,ReceivePack)"); sb.Append(" VALUES( @ReceiveHeadId,@ProductId,@ReceiveWeight,@ReceivePack)"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.CommandText = sqlSave2; com.Parameters.Add("@ReceiveHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblRecId.Text.Trim()); com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[3].Text.Replace(",", ""); com.Parameters.Add("@ReceiveWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()); com.Parameters.Add("@ReceivePack", SqlDbType.Float).Value = Convert.ToSingle(Packtextarr[j].ToString()); com.ExecuteNonQuery(); } } else { for (int j = 0; j < weighttextarr.Length - 1; j++) { sb.Remove(0, sb.Length); sb.Append("INSERT INTO RECEIVE_WEIGHT (ReceiveHeadId,ProductId,ReceiveWeight )"); sb.Append(" VALUES( @ReceiveHeadId,@ProductId,@ReceiveWeight)"); sqlSave2 = sb.ToString(); com.Parameters.Clear(); com.CommandText = sqlSave2; com.Parameters.Add("@ReceiveHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblRecId.Text.Trim()); com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[3].Text.Replace(",", ""); com.Parameters.Add("@ReceiveWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()); com.ExecuteNonQuery(); } } } tr.Commit(); // ต้องการ print หรือไม่ ///* DialogResult dlg = MessageBox.Show("ต้องการพิมพ์รายงานหรือไม่ !!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlg == DialogResult.OK) { receive.rptReceiveSelect rptReceive = new receive.rptReceiveSelect(); rptReceive.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง rptReceive.setReceiveId = Convert.ToInt16(lblRecId.Text.Trim()); rptReceive.ShowDialog(); } else { MessageBox.Show("ปรับปรุงสำเร็จ"); } Close(); } catch (Exception ex) { MessageBox.Show("ไม่สามารถแกไขรายการรับได้ เนื่องจาก " + ex.Message, "ข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning); //cmdSave.Focus(); tr.Rollback(); } } }