private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string sql = "update cost_dept set cname = '" + textEditName.Text.ToString().Trim() + "',saletype_id =" + comboBoxSaleType.SelectedValue.ToString();
sql = sql + " where cid = " + textEditID.Text.ToString();
string sql2 = "select cname from cost_dept where cname = '" + textEditName.Text.ToString() + "' and saletype_id = " + comboBoxSaleType.SelectedValue.ToString();
if (textEditName.Text.ToString().Trim() != "" && comboBoxSaleType.SelectedValue.ToString() != "0")
{
int rows = conn.ReturnRecordCount(sql2);
if (rows > 0)
{
MessageBox.Show("该部门已经存在！");
}
else
{
bool isok = conn.EditDatabase(sql);
if (isok)
{
MessageBox.Show("修改成功！");
DeptQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
}
else
{
MessageBox.Show("不能为空值！");
}
conn.Close();
}
private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string strsql, strsql2;
int rows;
strsql = "insert into cost_dept(CNAME,SALETYPE_ID) values('" + textEditName.Text.ToString().Trim() + "'," + comboBoxSaleType.SelectedValue.ToString() + ")";
strsql2 = "select cname from cost_dept where cname = '" + textEditName.Text.ToString().Trim() + "'";
if (textEditName.Text.ToString().Trim() != "")
{
rows = conn.ReturnRecordCount(strsql2);
if (rows > 0)
{
MessageBox.Show("该部门已经存在！");
}
else
{
bool isok = conn.EditDatabase(strsql);
if (isok)
{
MessageBox.Show("添加成功！");
DeptQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
}
else
{
MessageBox.Show("名称不能为空！");
}
conn.Close();
}
private void barButtonItem反禁用_ItemClick(object sender, ItemClickEventArgs e)
{
DeptQuery.cEnable();
DeptQuery.RefreshEX();
}
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
{
DeptQuery.RefreshEX();
}
