private void btnSave_Click(object sender, EventArgs e)
{
string strSql = null;
GoodsSeries gs = new GoodsSeries();
if (String.IsNullOrEmpty(txtGoodsSeriesName.Text.Trim()))
{
MessageBox.Show("系列名称不许为空！", "软件提示");
txtGoodsSeriesName.Focus();
return;
}
if (String.IsNullOrEmpty(txtUnitPrice.Text.Trim()))
{
MessageBox.Show("单价不许为空！", "软件提示");
txtUnitPrice.Focus();
return;
}
else
{
if (Convert.ToDecimal(txtUnitPrice.Text.Trim()) == 0)
{
MessageBox.Show("单价不许为零！", "软件提示");
txtUnitPrice.Focus();
return;
}
}
SetParametersValue();
if (this.Tag.ToString() == "Add")
{
strSql = "INSERT INTO GoodsSeries(GoodsSeriesCode,GoodsSeriesName,UnitPrice) ";
strSql += "VALUES(@GoodsSeriesCode,@GoodsSeriesName,@UnitPrice)";
if (gs.Insert(dal, strSql))
{
formGoodsSeries.dgvGoodsSeries.DataSource = gs.GetDataTable("GoodsSeries", "");
if (MessageBox.Show("保存成功，是否继续添加？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
strGoodsSeriesCode = useful.BuildCode("GoodsSeries", "", "GoodsSeriesCode", "", 2);
txtGoodsSeriesName.Text = "";
txtUnitPrice.Text = "";
txtGoodsSeriesName.Focus();
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
if (this.Tag.ToString() == "Edit")
{
strSql = "Update GoodsSeries Set GoodsSeriesName = @GoodsSeriesName,UnitPrice = @UnitPrice Where GoodsSeriesCode = @GoodsSeriesCode";
if (gs.Update(dal, strSql) == true)
{
formGoodsSeries.dgvGoodsSeries.DataSource = gs.GetDataTable("GoodsSeries", "");
MessageBox.Show("保存成功！", "软件提示");
this.Close();
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
}
