public ThGoodsInfoForm(string EmpID) : this()
{
txtEmpID.Text = EmpID;
thGoodsInfo = new tb_ThGoodsInfo();
thGoodsMenthod = new tb_ThGoodsMenthod();
thGoodsMenthod.Find(dataGridView1);
}
//保存按钮
private void saveButton_Click(object sender, EventArgs e)
{
if (IsComplete())
{
if (count == 1) //添加操作
{
if (thGoodsMenthod.Add(thGoodsInfo))
{
if (num == txtThGoodsNum.Text) //置对应的销售记录删除标志为1
{
string sqlcmd = "update tb_SellGoods set SellFlag=1 where SellID='" + txtSellID.Text + "'";
SqlConnection conn = (new GetSqlConnection()).GetCon();
SqlCommand cmd = new SqlCommand(sqlcmd, conn);
cmd.ExecuteNonQuery();
conn.Dispose();
}
MessageBox.Show("添加成功");
Clear();
ChangeToolsStatus();
count = 0;
thGoodsMenthod.Find(dataGridView1); //返回操作后的数据库
button1.Enabled = false;
Ban();
}
else
{
MessageBox.Show("添加失败");
Clear();
ChangeToolsStatus();
count = 0;
button1.Enabled = false;
Ban();
}
}
if (count == 2) //修改操作
{
if (thGoodsMenthod.Update(thGoodsInfo, this.dataGridView1[3, this.dataGridView1.CurrentCell.RowIndex].Value.ToString()))
{
if (num == txtThGoodsNum.Text) //置对应的销售记录删除标志为1
{
string sqlcmd = "update tb_SellGoods set SellFlag=1 where SellID='" + txtSellID.Text + "'";
SqlConnection conn = (new GetSqlConnection()).GetCon();
SqlCommand cmd = new SqlCommand(sqlcmd, conn);
cmd.ExecuteNonQuery();
conn.Dispose();
}
MessageBox.Show("修改成功");
Clear();
ChangeToolsStatus();
count = 0;
thGoodsMenthod.Find(dataGridView1); //返回操作后的数据库
Ban();
}
else
{
MessageBox.Show("修改失败");
Clear();
ChangeToolsStatus();
count = 0;
Ban();
}
}
if (count == 3) //删除操作
{
if (thGoodsMenthod.Delete(thGoodsInfo.strThGoodsID))
{
MessageBox.Show("删除成功");
Clear();
ChangeToolsStatus();
count = 0;
thGoodsMenthod.Find(dataGridView1); //返回操作后的数据库
}
else
{
MessageBox.Show("删除失败");
Clear();
ChangeToolsStatus();
count = 0;
}
}
}
}
