private void 除申请ToolStripMenuItem_Click(object sender, EventArgs e) { if (listview.SelectedItems.Count <= 0 || listview.SelectedItems[0].SubItems[1].Text == "") { MessageBox.Show("未选中任何一条服务!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (listview.SelectedItems[0].SubItems[5].Text == "已受理" || listview.SelectedItems[0].SubItems[5].Text == "已完成") { MessageBox.Show("该记录处于受理或完成状态,无法进行删除动作!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (DialogResult.OK == MessageBox.Show("确定删除([" + listview.SelectedItems[0].SubItems[1].Text + "]" + listview.SelectedItems[0].SubItems[2].Text + ")的所有信息吗?", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)) { //确认删除数据 SQLClass.getsqlcom("delete from fuwu where id = '" + listview.SelectedItems[0].SubItems[1].Text + "'"); treeview_AfterSelect(sender, e); SQLClass.con_close(); //关闭数据库连接,释放资源 MessageBox.Show("删除服务申请成功!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("操作已取消!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_gongsi.Text != "" && txt_fuzeren.Text != "" && (txt_lianxi.Text != "" && Input_Regex.IsPhoneNum(txt_lianxi.Text)) && Convert.ToBoolean(txt_dizhi.Text.Count())) { switch (Form_Type) { case 0: SqlDataReader dr = SQLClass.getcom("select id from kaifashang where gongsi = '" + txt_gongsi.Text.ToString().Trim() + "'"); bool ifcom = dr.Read(); if (ifcom) { MessageBox.Show("该开发商已存在,不能重复添加!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } SQLClass.getsqlcom("insert into kaifashang values ('" + txt_gongsi.Text.ToString().Trim() + "','" + txt_dizhi.Text.ToString().Trim() + "','" + txt_lianxi.Text.ToString().Trim() + "','" + txt_fuzeren.Text.ToString().Trim() + "')"); Form_OK = 1; //操作完成 break; case 1: SQLClass.getsqlcom("update kaifashang set gongsi = '" + txt_gongsi.Text.ToString().Trim() + "', fuzeren = '" + txt_fuzeren.Text.ToString().Trim() + "', lianxi = '" + txt_lianxi.Text.ToString().Trim() + "', dizhi = '" + txt_dizhi.Text.ToString().Trim() + "' where id = '" + kfsid + "'"); Form_OK = 1; break; case 2: Form_OK = 0; //没有执行相关操作 break; } SQLClass.con_close(); this.Close(); } else { lab_message.Text = "操作失败,请检查你的输入是否正确!"; } }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_jianzu.Text != "" && txt_dizhi.Text != "") { switch (Form_Type) { case 0: SqlDataReader dr = SQLClass.getcom("select id from fangchan where jianzu = '" + txt_jianzu.Text.ToString().Trim() + "'"); bool ifcom = dr.Read(); if (ifcom) { MessageBox.Show("该楼房已存在,不能重复添加!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } SQLClass.getsqlcom("insert into fangchan values ('" + txt_jianzu.Text.ToString().Trim() + "','" + txt_dizhi.Text.ToString().Trim() + "','" + zhuangtai.KaifashangName(combox_kfs.SelectedItem.ToString(), false) + "','" + datetime_riqi.Text + "','" + txt_beizhu.Text.ToString().Trim() + "')"); Form_OK = 1; //操作完成 break; case 1: SQLClass.getsqlcom("update fangchan set jianzu = '" + txt_jianzu.Text.ToString().Trim() + "', dizhi = '" + txt_dizhi.Text.ToString().Trim() + "', kaifashangid = '" + zhuangtai.KaifashangName(combox_kfs.SelectedItem.ToString(), false) + "', shijian = '" + datetime_riqi.Text.ToString() + "', beizhu = '" + txt_beizhu.Text.ToString().Trim() + "' where id = '" + fcid + "'"); Form_OK = 1; break; case 2: Form_OK = 0; break; } SQLClass.con_close(); this.Close(); } else { lab_messgae.Text = "操作失败,请检查你的输入是否正确!"; } }
public string KaifashangName(string num, bool isname) { string kaifashang; if (isname) { DataSet DSet = SQLClass.getDataSet("select gongsi from kaifashang where id = '" + num + "'", "开发商信息表"); DataTable dt = DSet.Tables["开发商信息表"]; if (dt.Rows.Count > 0) { kaifashang = dt.Rows[0][0].ToString(); } else { kaifashang = null; } } else { DataSet DSet = SQLClass.getDataSet("select id from kaifashang where gongsi = '" + num + "'", "开发商信息表"); DataTable dt = DSet.Tables["开发商信息表"]; if (dt.Rows.Count > 0) { kaifashang = dt.Rows[0][0].ToString(); } else { kaifashang = null; } } SQLClass.con_close(); return(kaifashang); }
private void btn_ok_Click(object sender, EventArgs e) { if ((txt_louceng.Tag.ToString() == "1") && (txt_peizhi.Tag.ToString() == "1") && (txt_yezhu.Tag.ToString() == "1") && (txt_shoufei.Tag.ToString() == "1")) { string zhufangzt; if (rad_wei.Checked) { zhufangzt = "0"; } else { zhufangzt = "1"; } switch (Form_Type) { case 0: SQLClass.getsqlcom("insert into zhufang values ('" + txt_louceng.Text.ToString().Trim() + "','" + txt_peizhi.Text.ToString().Trim() + "','" + zhuangtai.YezhuName(txt_yezhu.Text.ToString().Trim(), false) + "','" + zhufangzt + "','" + zhuangtai.FangchanName(combox_fc.SelectedItem.ToString(), false) + "','" + txt_shoufei.Text.ToString().Trim() + "')"); Form_OK = 1; //操作完成 break; case 1: SQLClass.getsqlcom("update zhufang set louceng = '" + txt_louceng.Text.ToString().Trim() + "', peizhi = '" + txt_peizhi.Text.ToString().Trim() + "', yezhuid = '" + zhuangtai.YezhuName(txt_yezhu.Text.ToString().Trim(), false) + "', fangchanid = '" + zhuangtai.FangchanName(combox_fc.SelectedItem.ToString(), false) + "', shoufei = '" + txt_shoufei.Text.ToString().Trim() + "' where id = '" + zfid + "'"); Form_OK = 1; break; case 2: Form_OK = 0; break; case 3: if (txt_yezhu.Text == "") { lab_message.Text = "操作失败,请检查你的输入是否正确!"; return; } SQLClass.getsqlcom("update zhufang set yezhuid = '" + txt_yezhu.Text.ToString().Trim() + "', zhuangtai = '" + zhufangzt + "' where id = '" + zfid + "'"); yzfy += Convert.ToInt32(txt_shoufei.Text); SQLClass.getsqlcom("update yezhu set feiyong = '" + yzfy + "' where id = '" + txt_yezhu.Text.ToString().Trim() + "'"); Form_OK = 1; break; case 4: SQLClass.getsqlcom("update zhufang set louceng = '" + txt_louceng.Text.ToString().Trim() + "', peizhi = '" + txt_peizhi.Text.ToString().Trim() + "', yezhuid = '" + zhuangtai.YezhuName(txt_yezhu.Text.ToString().Trim(), false) + "', zhuangtai = '" + zhufangzt + "', fangchanid = '" + zhuangtai.FangchanName(combox_fc.SelectedItem.ToString(), false) + "', shoufei = '" + txt_shoufei.Text.ToString().Trim() + "' where id = '" + zfid + "'"); Form_OK = 1; break; } SQLClass.con_close(); this.Close(); } else { lab_message.Text = "操作失败,请检查你的输入是否正确!"; } }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_gangwei.Tag.ToString() == "1" && txt_fuzeren.Tag.ToString() == "1" && combox_bm.Tag.ToString() == "1") { switch (Form_Type) { case 0: SqlDataReader sdr = SQLClass.getcom("select id from gangwei where bumen = '" + combox_bm.Text.ToString() + "' and gangwei = '" + txt_gangwei.Text.Trim() + "'"); bool ifcom = sdr.Read(); if (ifcom) { lab_message.Text = "你输入的岗位已存在,请重新修改后提交!"; return; } else { SQLClass.getsqlcom("insert into gangwei values ('" + combox_bm.Text.ToString() + "', '" + txt_gangwei.Text.ToString().Trim() + "', '" + txt_fuzeren.Text.ToString().Trim() + "')"); Form_OK = 1; //操作完成 } break; case 1: DataSet gwDSet = SQLClass.getDataSet("select id from gangwei where bumen = '" + combox_bm.Text.ToString() + "' and gangwei = '" + txt_gangwei.Text.Trim() + "'", "岗位信息表"); DataTable gwdt = gwDSet.Tables["岗位信息表"]; if (gwdt.Rows.Count > 0) { if (gwdt.Rows[0][0].ToString() != gwid) { lab_message.Text = "你修改的信息在已存在,请修改后再试!"; return; } else { } } else { } SQLClass.getsqlcom("update gangwei set bumen = '" + combox_bm.Text.ToString() + "', gangwei = '" + txt_gangwei.Text.Trim() + "', yuangongid = '" + txt_fuzeren.Text.Trim() + "' where id = '" + gwid + "'"); Form_OK = 1; break; case 2: Form_OK = 0; break; } SQLClass.con_close(); this.Close(); } else { lab_message.Text = "操作失败,请检查你的输入是否正确!"; } }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_bumen.Text == "") { MessageBox.Show("部门名称不能为空!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { SQLClass.getsqlcom("update gangwei set bumen = '" + txt_bumen.Text + "' where bumen = '" + bmname + "'"); } SQLClass.con_close(); Form_OK = 1; this.Close(); }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_xingming.Tag.ToString() == "1" && txt_lianxi.Tag.ToString() == "1" && txt_zhuzhi.Tag.ToString() == "1" && txt_username.Tag.ToString() == "1" && txt_password1.Tag.ToString() == "1" && txt_password2.Tag.ToString() == "1") { if (rad_nan.Checked == true) { rad_nan.Tag = "男"; } else { rad_nan.Tag = "女"; } DataSet okDSet = SQLClass.getDataSet("select id from gangwei where gangwei = '" + combox_gw.SelectedItem.ToString() + "' and bumen = '" + combox_bm.SelectedItem.ToString() + "'", "岗位信息表"); DataTable okdt = okDSet.Tables["岗位信息表"]; switch (Form_Type) { case 0: SQLClass.getsqlcom("insert into yuangong values ('" + txt_xingming.Text.Trim() + "', '" + rad_nan.Tag.ToString() + "', '" + okdt.Rows[0][0].ToString() + "', '" + txt_lianxi.Text.Trim() + "', '" + txt_zhuzhi.Text.Trim() + "', '0', '" + txt_username.Text.Trim() + "', '" + txt_password1.Text.Trim() + "')"); Form_OK = 1; break; case 1: if (txt_password1.Text == txt_password2.Text && txt_password1.Text == "" && txt_password2.Text == "") { SQLClass.getsqlcom("update yuangong set xingming = '" + txt_xingming.Text.Trim() + "', xingbie = '" + rad_nan.Tag.ToString() + "', gangweiid = '" + okdt.Rows[0][0].ToString() + "', lianxi = '" + txt_lianxi.Text.Trim() + "', dizhi = '" + txt_zhuzhi.Text.Trim() + "', username = '******' where id = '" + ygid + "'"); } else { SQLClass.getsqlcom("update yuangong set xingming = '" + txt_xingming.Text.Trim() + "', xingbie = '" + rad_nan.Tag.ToString() + "', gangweiid = '" + okdt.Rows[0][0].ToString() + "', lianxi = '" + txt_lianxi.Text.Trim() + "', dizhi = '" + txt_zhuzhi.Text.Trim() + "', username = '******', password = '******' where id = '" + ygid + "'"); } Form_OK = 1; break; case 2: Form_OK = 0; break; } SQLClass.con_close(); this.Close(); } else { lab_message.Text = "操作失败,请检查你的输入是否正确!"; } }
private void btn_ok_Click(object sender, EventArgs e) { if (txt_shixiang.Tag.ToString() == "1" && txt_yuangong.Tag.ToString() == "1") { switch (Form_Type) { case 0: SQLClass.getcom("insert into richang values ('" + txt_shixiang.Text.Trim() + "', '" + date_shijian.Text.ToString() + "', '0', '" + txt_yuangong.Text.Trim() + "', '" + txt_beizhu.Text.Trim() + "')"); Form_OK = 1; break; case 1: SQLClass.getcom("update richang set shixiang = '" + txt_shixiang.Text.Trim() + "',shijian = '" + date_shijian.ToString() + "', yuangongid = '" + txt_yuangong.Text.Trim() + ", beizhu = '" + txt_beizhu.Text.Trim() + "' where id = '" + rcid + "'"); Form_OK = 1; break; case 2: break; } SQLClass.con_close(); this.Close(); } }
private void btn_ok_Click(object sender, EventArgs e) { switch (Form_Type) { case 0: if (txt_shixiang.Tag.ToString() == "1" && txt_jine.Tag.ToString() == "1" && txt_yezhu.Tag.ToString() == "1") { //DataSet yzDSet = SQLClass.getDataSet("select feiyong from yezhu where id = '" + txt_yezhu.Text.Trim() + "'", "业主信息表"); //DataTable yzdt = yzDSet.Tables["业主信息表"]; //sfje = Convert.ToInt32(yzdt.Rows[0][0].ToString()) + Convert.ToInt32(txt_jine.Text.Trim()); //SQLClass.getsqlcom("update yezhu set feiyong = '" + sfje + "' where id = '" + txt_yezhu.Text.Trim() + "'"); SQLClass.getsqlcom("insert into shoufei values ('" + txt_shixiang.Text + "', '" + txt_jine.Text.Trim() + "', '0', '', '" + txt_yezhu.Text + "', '', '" + txt_beizhu.Text + "')"); Form_OK = 1; } else { lab_message.Text = "操作失败,请检查后再试!"; return; } break; case 1: if (txt_shixiang.Tag.ToString() == "1" && txt_jine.Tag.ToString() == "1" && txt_yezhu.Tag.ToString() == "1") { SQLClass.getsqlcom("update shoufei set shixiang = '" + txt_shixiang.Text + "', jine = '" + txt_jine.Text.Trim() + "', yezhuid = '" + txt_yezhu.Text.Trim() + "', beizhu = '" + txt_beizhu.Text + "' where id = '" + sfid + "'"); Form_OK = 1; } else { lab_message.Text = "操作失败,请检查后再试!"; return; } break; case 2: break; case 3: if (txt_yuangong.Tag.ToString() == "1") { DataSet yzDSet = SQLClass.getDataSet("select feiyong from yezhu where id = '" + txt_yezhu.Text.Trim() + "'", "业主信息表"); DataTable yzdt = yzDSet.Tables["业主信息表"]; if (yzdt.Rows.Count > 0) { sfje = Convert.ToInt32(yzdt.Rows[0][0].ToString()) - Convert.ToInt32(txt_jine.Text); } SQLClass.getsqlcom("update shoufei set shijian = '" + date_shijian.Text.ToString() + "', yuangongid = '" + txt_yuangong.Text.Trim() + "', leixing = '1' where id = '" + sfid + "'"); SQLClass.getsqlcom("update yezhu set feiyong = '" + sfje + "' where id = '" + txt_yezhu.Text.Trim() + "'"); Form_OK = 1; } else { lab_message.Text = "操作失败,请检查后再试!"; return; } break; } SQLClass.con_close(); this.Close(); }
private void btn_ok_Click(object sender, EventArgs e) { switch (Form_Type) { case 0: if (txt_shixiang.Tag.ToString() == "1" && txt_yezhu.Tag.ToString() == "1") { SQLClass.getsqlcom("insert into fuwu values ('" + txt_shixiang.Text.Trim() + "', '" + txt_yezhu.Text.Trim() + "', '" + DateTime.Now.Date.ToShortDateString() + "', '0', '', '', '', '')"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; case 1: if (txt_shixiang.Tag.ToString() == "1" && txt_yezhu.Tag.ToString() == "1") { SQLClass.getsqlcom("update fuwu set shixiang = '" + txt_shixiang.Text.Trim() + "', yezhuid = '" + txt_yezhu.Text.Trim() + "', shenqing = '" + DateTime.Now.Date.ToShortDateString() + "' where id = '" + fwid + "'"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; case 2: if (txt_yuangong.Tag.ToString() == "1") { SQLClass.getsqlcom("update fuwu set yuangongid = '" + txt_yuangong.Text.Trim() + "', queren = '" + DateTime.Now.Date.ToShortDateString() + "', zhuangtai = '1' where id = '" + fwid + "'"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; case 3: if (txt_shoufei.Tag.ToString() == "1") { DataSet yzDSet = SQLClass.getDataSet("select feiyong from yezhu where id = '" + txt_yezhu.Text.Trim() + "'", "业主信息表"); DataTable yzdt = yzDSet.Tables["业主信息表"]; if (yzdt.Rows.Count > 0) { sfje = Convert.ToInt32(yzdt.Rows[0][0].ToString()) + Convert.ToInt32(txt_shoufei.Text.Trim()); } SQLClass.getsqlcom("update yezhu set feiyong = '" + sfje + "' where id = '" + txt_yezhu.Text.Trim() + "'"); SQLClass.getsqlcom("update fuwu set shoufei = '" + txt_shoufei.Text.Trim() + "', zhuangtai = '2', wancheng = '" + DateTime.Now.Date.ToShortDateString() + "' where id = '" + fwid + "'"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; case 4: if (txt_shixiang.Tag.ToString() == "1") { SQLClass.getsqlcom("insert into fuwu values ('" + txt_shixiang.Text.Trim() + "', '" + txt_yezhu.Text.Trim() + "', '" + DateTime.Now.Date.ToShortDateString() + "', '0', '', '', '', '')"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; case 5: if (txt_shixiang.Tag.ToString() == "1") { SQLClass.getsqlcom("update fuwu set shixiang = '" + txt_shixiang.Text.Trim() + "', shenqing = '" + DateTime.Now.Date.ToShortDateString() + "' where id = '" + fwid + "'"); } else { lab_message.Text = "操作失败,请检查你的输入!"; return; } Form_OK = 1; break; } SQLClass.con_close(); this.Close(); }