private void btnSave_Click(object sender, EventArgs e) { if (ProductId < 0) { MessageBox.Show("请选择产品类型"); return; } if (cmbCustomerName.SelectedIndex == -1) { MessageBox.Show("请选择客户"); return; } if (txtAmount.Text.Trim() == "") { MessageBox.Show("请输入数量"); return; } if (txtPrice.Text.Trim() == "") { MessageBox.Show("请输入单价"); return; } if (txtSum.Text.Trim() == "") { MessageBox.Show("请输入金额"); return; } if (txtStockOutNo.Text.Trim() == "") { MessageBox.Show("出库单编号不能为空"); return; } if (cmbUnit.Text.Trim() == "") { MessageBox.Show("单位不能为空"); return; } try { int ret = new T_ProductSendTableAdapter().UpdateById(cmbCustomerName.SelectedValue.ToString(), dtpDate1.Value.Date, ProductId, Convert.ToDecimal(txtAmount.Text), Convert.ToDecimal(txtPrice.Text), Convert.ToDecimal(txtSum.Text), (long)cmbUserName.SelectedValue, txtStockOutNo.Text.Trim(), cmbUnit.Text.Trim(), mId); if (ret > 0) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { if (CityId < 0) { if (Classes.PubClass.CompanyId == 0) { MessageBox.Show("请选择客户"); return; } else { MessageBox.Show("请先设置该客户所在地区"); return; } } if (dgvDetails.Rows.Count < 1) { MessageBox.Show("出库内容不能为空"); return; } try { int ret = 0; using (SqlConnection mconn = new SqlConnection(Common.CommonClass.SqlConnStr)) { mconn.Open(); using (SqlTransaction mTrans = mconn.BeginTransaction()) { try { var adapter = new T_ProductSendTableAdapter(); adapter.Connection = mconn; adapter.Transaction = mTrans; foreach (DataGridViewRow mRow in dgvDetails.Rows) { ret = adapter.Insert1((long)cmbUserName.SelectedValue, Classes.PubClass.CompanyId.ToString(), dtpDate1.Value.Date, Convert.ToInt64(mRow.Cells["ColumnProductId"].Value), Convert.ToDecimal(mRow.Cells["ColumnAmount"].Value), Convert.ToDecimal(mRow.Cells["ColumnPrice"].Value), Convert.ToDecimal(mRow.Cells["ColumnSumMoney"].Value), CityId, mRow.Cells["ColumnUnit"].Value.ToString(), txtStockOutNo.Text.Trim(), "正常"); if (ret == 0) { MessageBox.Show("第" + mRow.Index.ToString() + "项插入失败"); mTrans.Rollback(); return; } } mTrans.Commit(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } } MessageBox.Show("保存成功"); btnSave.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void 销售明细维护_Load(object sender, EventArgs e) { cmbUserName.DisplayMember = "UserName"; cmbUserName.ValueMember = "id"; cmbUserName.DataSource = new T_UsersTableAdapter().GetSalers(); cmbUserName.SelectedIndex = -1; //获取一级产品名单 var mTable = new T_ProductsTableAdapter().GetDataByLevel(1); //获取level1的产品 cmbProduct1.DataSource = mTable; cmbProduct1.SelectedIndex = -1; if (mId == -1) { //获取出库单编号 //string m_date = DateTime.Now.ToString("yyyyMM"); //txtStockOutNo.Text = new T_SaleDetailsTableAdapter().GetNextStockOutNo(m_date).ToString(); } else { DataTable dt = new DataTable(); dt = new T_ProductSendTableAdapter().GetDataById(mId); if (dt.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetProductSend.T_ProductSendRow)dt.Rows[0]; cmbUserName.SelectedValue = mRow.UserName; cmbUserName_SelectionChangeCommitted(sender, e); if (mRow.IsCustomerNameNull() == false) { long mCustomerId; if (Int64.TryParse(mRow.CustomerName, out mCustomerId) == true) { cmbCustomerName.SelectedValue = Convert.ToInt64(mRow.CustomerName); } else { cmbCustomerName.SelectedIndex = cmbCustomerName.FindStringExact(mRow.CustomerName); } } //获取产品信息 //long pLevel, pId; var mTableProduct = new T_ProductsTableAdapter().GetDataByID(mRow.ProductName); if (mTableProduct.Rows.Count > 0) { 销售管理.DAL.DataSetProducts.T_ProductsRow mProductRow = mTableProduct[0]; //设置产品 SetProduct(mProductRow); } dtpDate1.Value = mRow.SaleDate; txtAmount.Text = mRow.Amount.ToString(); txtPrice.Text = mRow.Price.ToString(); txtSum.Text = mRow.SumMoney.ToString(); txtStockOutNo.Text = mRow.StockOutNo.ToString(); cmbUnit.Text = mRow.Unit.ToString(); } } }