private void btnSave_Click(object sender, System.EventArgs e) { try { if (this.txtHangYeName.Text.Trim() == "") { MessageBox.Show("行业名称不能为空!"); return; } string strSql = String.Format("select count(*) from tbHangYe where HangYeName='{0}'", this.txtHangYeName.Text.Trim()); string strCount = CDBConnection.ExecuteScalar(strSql); int iCount = Convert.ToInt32(strCount); if (iCount > 0) { MessageBox.Show("该行业名称已存在!"); return; } strSql = String.Format("insert into tbHangYe(HangYeName,HangYeType) values('{0}','{1}')", this.txtHangYeName.Text.Trim(), this.txtHangYeType.Text.Trim()); CDBConnection.ExecuteSql(strSql); this.m_bInserted = true; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnSet_Click(object sender, System.EventArgs e) { try { if (this.txtInterval.Text.Trim() == "") { MessageBox.Show("请填写时间间隔!"); return; } if (this.txtWarnLevel.Text.Trim() == "") { MessageBox.Show("请填写报警下限!"); return; } double dWarn = Convert.ToDouble(this.txtWarnLevel.Text.Trim()); string strSql = String.Format("update tbInfo set val='{0}' where des='{1}'", dWarn.ToString(), "报警下限"); CDBConnection.ExecuteSql(strSql); double dInter = Convert.ToDouble(this.txtInterval.Text); double iInter = Convert.ToDouble(dInter * 60); this.m_xDoc.DocumentElement.SelectSingleNode("./interval").InnerText = iInter.ToString(); this.m_xDoc.Save("Info.xml"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button1_Click(object sender, System.EventArgs e) { try { if (this.txtUserID.Text.Trim() == "") { MessageBox.Show("请填写用户ID"); return; } if (this.txtUserName.Text.Trim() == "") { MessageBox.Show("请填写用户名!"); return; } if (this.txtUserPwd.Text.Trim() == "") { MessageBox.Show("请填写用户密码!"); return; } if (this.txtUserPwd.Text.Trim() != this.txtPwdCer.Text.Trim()) { MessageBox.Show("密码与确认密码不同!"); return; } if (this.chkPower.Checked == true) { if (this.cmbManagers.Text.Trim() == "") { MessageBox.Show("请选择具有相同权限的管理员,或去掉应用权限项!"); return; } } else { if (this.cmbManagers.Text.Trim() != "") { MessageBox.Show("请选中应用权限框,或清除所选的管理员!"); return; } } if (this.m_bEdit == false) { //添加用户 this.fInserUsers(); } else { //修改 string strSql = String.Format("delete from tbUsers where userID='{0}'", this.txtUserID.Text.Trim()); CDBConnection.ExecuteSql(strSql); this.fInserUsers(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnDel_Click(object sender, System.EventArgs e) { try { //MessageBox.Show("因为删除将导致系统错误,所以删除被禁用!"); //return; if (this.lsvDep.SelectedItems.Count <= 0) { MessageBox.Show("请选择要删除的管理处!"); return; } string strDepShortName = this.lsvDep.SelectedItems[0].Text.Trim(); string strSql = String.Format("select count(*) from tbWell where depName ='{0}'", strDepShortName); string strCount = CDBConnection.ExecuteScalar(strSql); if (strCount.Trim() != "0") { MessageBox.Show("该单位下已录入监测站,请先删除其下的站点!"); return; } strSql = String.Format("delete from tbDep where depShortName='{0}'", strDepShortName); CDBConnection.ExecuteSql(strSql); this.paintFrm(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnDel_Click(object sender, System.EventArgs e) { try { if (this.lsvCountry.SelectedItems.Count == 0) { MessageBox.Show("请选中要删除的管理局!"); return; } string strCountryName = this.lsvCountry.SelectedItems[0].Text.Trim(); // string strSql = String.Format("select count(*) from tbDep where countryName='{0}'", strCountryName); string strCount = CDBConnection.ExecuteScalar(strSql); if (strCount != "0") { MessageBox.Show("该管理局以下已录入管理处,请先将其下的管理处信息删除!"); return; } strSql = String.Format("delete from tbCountry where countryName='{0}'", strCountryName); CDBConnection.ExecuteSql(strSql); this.paintFrm(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnDel_Click(object sender, System.EventArgs e) { try { if (this.lsvTown.SelectedItems.Count == 0) { MessageBox.Show("请选中要删除的县!"); return; } string strSql = String.Format("select count(*) from tbCountry where townName='{0}'", this.lsvTown.SelectedItems[0].SubItems[0].Text.Trim()); string strCount = CDBConnection.ExecuteScalar(strSql); if (strCount.Trim() != "0") { MessageBox.Show("该县以下已录入乡镇信息不能删除!"); return; } string strTownName = this.lsvTown.SelectedItems[0].Text.Trim(); strSql = String.Format("delete from tbTown where townName='{0}'", strTownName); CDBConnection.ExecuteSql(strSql); this.paintFrm(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private bool saveData(string strWellNo, string strICNo, string strDepName) { string strSql = String.Format("delete from tbIC where icNo='{0}'", strICNo); CDBConnection.ExecuteSql(strSql); strSql = String.Format("insert into tbIC(wellNo,icNo,depName) values('{0}','{1}','{2}')", strWellNo, strICNo, strDepName); CDBConnection.ExecuteSql(strSql); return(true); }
private void btnSave_Click(object sender, System.EventArgs e) { try { if (this.txtDepShortName.Text.Trim() == "") { MessageBox.Show("管理处简称不能为空!"); return; } if (this.txtDepName.Text.Trim() == "") { MessageBox.Show("管理处名称不能为空!"); return; } string strSql = ""; if (this.m_bEdit == true) { strSql = String.Format("delete from tbDep where depShortName='{0}'", this.txtDepShortName.Text.Trim()); CDBConnection.ExecuteSql(strSql); } strSql = String.Format("select count(*) from tbDep where depName='{0}'", this.txtDepName.Text.Trim()); string strCount = CDBConnection.ExecuteScalar(strSql); int iCount = Convert.ToInt32(strCount); if (iCount > 0) { MessageBox.Show("该管理处名称已存在!"); return; } strSql = String.Format("select count(*) from tbDep where depShortName='{0}'", this.txtDepShortName.Text.Trim()); strCount = CDBConnection.ExecuteScalar(strSql); if (strCount != "0") { MessageBox.Show("该管理处简称已存在!"); return; } strSql = String.Format("insert into tbDep(DepShortName,depName,countryName,hangYeName,contactPer,contactTel,address,des) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", this.txtDepShortName.Text.Trim(), this.txtDepName.Text.Trim(), this.cmbCountry.Text.Trim(), this.cmbHangYe.Text.Trim(), this.txtContactPer.Text.Trim(), this.txtContactTel.Text.Trim(), this.txtAddress.Text.Trim(), this.txtDes.Text.Trim()); CDBConnection.ExecuteSql(strSql); this.m_bInserted = true; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnDel_Click(object sender, System.EventArgs e) { try { if (this.lsvHangYe.SelectedItems.Count == 0) { MessageBox.Show("请选中要删除的行业!"); return; } string strHangYeName = this.lsvHangYe.SelectedItems[0].Text.Trim(); string strSql = String.Format("delete from tbHangYe where HangYeName='{0}'", strHangYeName); CDBConnection.ExecuteSql(strSql); this.paintFrm(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnSave_Click(object sender, System.EventArgs e) { try { if (this.lswUserInfo.SelectedItems.Count == 0) { MessageBox.Show("请选中一名用户!"); return; } string strUserID = this.lswUserInfo.SelectedItems[0].Text.Trim(); string strSql = String.Format("delete from userMenu where UserID='{0}'", strUserID); CDBConnection.ExecuteSql(strSql); for (int i = 0; i < this.tvwMenuInfo.Nodes.Count; i++) { if (this.tvwMenuInfo.Nodes[i].Checked) { string strMenu = this.tvwMenuInfo.Nodes[i].Text.Trim(); strSql = String.Format("insert into userMenu(userID,MenuName) values('{0}','{1}')", strUserID, strMenu); CDBConnection.ExecuteSql(strSql); } for (int j = 0; j < this.tvwMenuInfo.Nodes[i].Nodes.Count; j++) { if (this.tvwMenuInfo.Nodes[i].Nodes[j].Checked) { string strMenuChild = this.tvwMenuInfo.Nodes[i].Nodes[j].Text.Trim(); strSql = String.Format("insert into userMenu(userID,MenuName) values('{0}','{1}')", strUserID, strMenuChild); CDBConnection.ExecuteSql(strSql); } } } MessageBox.Show("权限设置成功!"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private bool SaveDatas() { try { string strPrice = this.txtPrice.Text.Trim(); string strMony = this.txtMony.Text.Trim(); string strAmount = this.txtAmount.Text.Trim(); string strPer = CDBConnection.m_strUserName; string strTime = System.DateTime.Now.ToString(); string strWellNo = this.txtWellNo.Text.Trim(); string strSql = String.Format("insert into tbSal(wellNo,price,salMony,salAmount,time,salPer) values('{0}','{1}','{2}','{3}','{4}','{5}')", strWellNo, strPrice, strMony, strAmount, strTime, strPer); CDBConnection.ExecuteSql(strSql); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
private void btnSave_Click(object sender, System.EventArgs e) { try { if (this.m_bEdit) { DialogResult result = MessageBox.Show(this, "警告:修改站点信息将对实时监测和报表统计造成影响是否继续?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign); if (result != DialogResult.Yes) { return; } else { } } if (this.chkJTS.Checked) { if (!this.paintPrice()) { return; } } if (this.txtPrice.Text.Trim() == "") { MessageBox.Show("水价不能为空!"); return; } if (this.txtWatNo.Text.Trim() == "") { MessageBox.Show("请填入控制器编号。"); return; } try { double dPrice = double.Parse(this.txtPrice.Text.Trim()); } catch { MessageBox.Show("水价不是有效数字!"); return; } string strSqlE = string.Format("select count(*) from tbWell where watchNo='{0}' and not wellNo='{1}'", this.txtWatNo.Text.Trim(), this.txtWellNo.Text.Trim()); string strCount = BengZhan.CDBConnection.ExecuteScalar(strSqlE); if (strCount.Trim() != "0") { MessageBox.Show("该控制器编号已录入!"); return; } if (this.txtWellName.Text.Trim() == "") { MessageBox.Show("请填入监测站名称!"); return; } if (this.txtGprsNo.Text.Trim() == "") { MessageBox.Show("请输入GPRS号!"); return; } if (this.txtAddress.Text.Trim() == "") { MessageBox.Show("请输入设备地址!"); return; } if (this.txtGprsNo.Text.Trim().Length != 11) { MessageBox.Show("GPRS号长度有误!"); return; } string strSql = String.Format("select count(*) from tbWell where wellName='{0}' and not wellNo='{1}'", this.txtWellName.Text.Trim(), this.txtWellNo.Text.Trim()); string strCountE = CDBConnection.ExecuteScalar(strSql); if (strCountE.Trim() != "0") { MessageBox.Show("该监测站名称已录入!"); return; } strSql = String.Format("select count(*) from tbWell where gprsNo='{0}' and not wellNo='{1}'", this.txtGprsNo.Text.Trim(), this.txtWellNo.Text.Trim()); strCount = CDBConnection.ExecuteScalar(strSql); if (strCount != "0") { MessageBox.Show("该GPRS号已存在!"); return; } string strWatchType = ""; strSql = String.Format("select watchType from tbWell where wellNo='{0}'", this.txtWellNo.Text.Trim()); strWatchType = BengZhan.CDBConnection.ExecuteScalar(strSql); strSql = String.Format("delete from tbWell where wellNo='{0}'", this.txtWellNo.Text.Trim()); CDBConnection.ExecuteSql(strSql); string strX = ""; if (this.txtX.Text.Trim() == "") { strX = "null"; } else { try { double dX = Convert.ToDouble(this.txtX.Text.Trim()); strX = dX.ToString(); } catch (Exception ex) { MessageBox.Show("你所填入的x坐标不是有效数字!"); return; } } string strY = ""; if (this.txtY.Text.Trim() == "") { strY = "null"; } else { try { double dY = Convert.ToDouble(this.txtY.Text.Trim()); strY = dY.ToString(); } catch (Exception ex) { MessageBox.Show("你所填入的x坐标不是有效数字!"); return; } } //地址十六进制 string strAddress = this.txtAddress.Text.Trim(); int iAddress = Convert.ToInt32(strAddress, 16); strAddress = iAddress.ToString(); strSql = String.Format("insert into tbWell(wellNo,wellName,depName,gprsNo,watAddress,wellDes,x,y,ICNo,watchType) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7},'{8}','{9}')", this.txtWellNo.Text.Trim(), this.txtWellName.Text.Trim(), this.txtDepShortName.Text.Trim(), this.txtGprsNo.Text.Trim(), strAddress, this.txtDes.Text.Trim(), strX, strY, this.txtICNo.Text.Trim(), strWatchType); CDBConnection.ExecuteSql(strSql); strSql = String.Format("delete from tbDel where tbName='{0}' and tbNo='{1}'", "tbWell", this.txtWellNo.Text.Trim()); CDBConnection.ExecuteSql(strSql); strSql = string.Format("update tbWell set iniAmount='{0}',watchNo='{1}',xi='{2}',warnAmount='{3}',price1='{5}' where wellNo='{4}'", this.txtIniAmount.Text.Trim(), this.txtWatNo.Text.Trim(), this.txtXi.Text.Trim(), this.txtWarnLevel.Text.Trim(), this.txtWellNo.Text.Trim(), this.txtPrice.Text.Trim()); BengZhan.CDBConnection.ExecuteSql(strSql); if (this.chkJTS.Checked) { strSql = string.Format("update tbWell set bjt='true' where wellNo='{0}'", this.txtWellNo.Text.Trim()); BengZhan.CDBConnection.ExecuteSql(strSql); this.saveJTPrice(); } this.m_bInserted = true; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnDel_Click(object sender, System.EventArgs e) { try { if (MessageBox.Show("删除操作可能对数据统计造成影响,是否继续?", "删除", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } //return; if (this.lsvWell.SelectedItems.Count == 0) { MessageBox.Show("请选中要删除的监测站!"); return; } string strWellNo = this.lsvWell.SelectedItems[0].Text.Trim(); string strSql = String.Format("select count(*) from (select * from tbWellAmount where wellNo='{0}' union select * from tbWellAmount where wellNo='{0}') temp", strWellNo); string strCount = CDBConnection.ExecuteScalar(strSql); // if(strCount!="") // { // int iCount=Convert.ToInt32(strCount); // if(iCount>0) // { // if(MessageBox.Show("流量信息表中已有该监测站的信息,继续操作将造成历史记录混乱,是否继续?","删除",MessageBoxButtons.OKCancel)!=DialogResult.OK) // { // return; // } // // } // } strSql = String.Format("select count(*) from tbSal where wellNo='{0}'", strWellNo); strCount = CDBConnection.ExecuteScalar(strSql); // if(strCount!="") // { // int iCount=Convert.ToInt32(strCount); // if(iCount>0) // { // if(MessageBox.Show("售水历史记录表中已有该监测站的信息,继续操作将造成历史记录混乱,是否继续?","删除",MessageBoxButtons.OKCancel)!=DialogResult.OK) // { // return; // } // // } // } strSql = String.Format("delete from tbWell where wellNo='{0}'", strWellNo); CDBConnection.ExecuteSql(strSql); strSql = String.Format("delete from tbw_WellInfo where WellID='{0}'", strWellNo); CDBConnection.ExecuteSql(strSql); // strSql = String.Format("insert into tbDel(tbNo,tbName) values('{0}','{1}')", strWellNo, "tbWell"); CDBConnection.ExecuteSql(strSql); this.paintFrm(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }