private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; strsql = "insert into cost_saletype(CNAME) values(LTRIM(rtrim('" + textEditName.Text.ToString() + "')))"; strsql2 = "select cname from cost_saletype where cname = LTRIM(rtrim('" + textEditName.Text.ToString() + "'))"; if (textEditName.Text.ToString().Trim() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("该营业类型已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); SaleTypeQuery.RefreshEX(); this.Close(); } } } else { MessageBox.Show("名称不能为空!"); } conn.Close(); }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string sql = "update cost_saletype set cname = ltrim(rtrim('" + textEditNew.Text.ToString() + "')) where cname = ltrim(rtrim('" + textEditOld.Text.ToString() + "'))"; string sql2 = "select cname from cost_saletype where cname = LTRIM(rtrim('" + textEditNew.Text.ToString() + "'))"; if (textEditNew.Text.ToString().Trim() != "") { int rows = conn.ReturnRecordCount(sql2); if (rows > 0) { MessageBox.Show("该营业类型已经存在!"); } else { bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); SaleTypeQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("新值不能为空!"); } conn.Close(); }
private void barButtonItem反禁用_ItemClick(object sender, ItemClickEventArgs e) { SaleTypeQuery.cEnable(); SaleTypeQuery.RefreshEX(); }
private void barButtonItem删除_ItemClick(object sender, ItemClickEventArgs e) { SaleTypeQuery.Delete(); SaleTypeQuery.RefreshEX(); }