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