/// <summary> /// 根据用户号更新开票相关基础信息 /// </summary> /// <param name="MODELWaterUser"></param> /// <returns></returns> public bool UpdateUserByWaterUserNO(MODELWaterUser MODELWaterUser) { StringBuilder str = new StringBuilder(); str.Append("UPDATE waterUser SET waterUserName=@waterUserName,waterPhone=@waterPhone," + "waterUserAddress=@waterUserAddress,FPTaxNO=@FPTaxNO,FPBankNameAndAccountNO=@FPBankNameAndAccountNO "); str.Append("WHERE waterUserNO=@waterUserNO"); SqlParameter[] para = { new SqlParameter("@waterUserName", SqlDbType.VarChar, 70), new SqlParameter("@waterPhone", SqlDbType.VarChar, 50), new SqlParameter("@waterUserAddress", SqlDbType.VarChar, 100), new SqlParameter("@FPTaxNO", SqlDbType.VarChar, 50), new SqlParameter("@FPBankNameAndAccountNO", SqlDbType.VarChar, 100), new SqlParameter("@waterUserNO", SqlDbType.VarChar, 30) }; para[0].Value = MODELWaterUser.waterUserName; para[1].Value = MODELWaterUser.waterPhone; para[2].Value = MODELWaterUser.waterUserAddress; para[3].Value = MODELWaterUser.FPTaxNO; para[4].Value = MODELWaterUser.FPBankNameAndAccountNO; para[5].Value = MODELWaterUser.waterUserNO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void btSetUp_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == "") { mes.Show("用户名不能为空!"); txtName.Focus(); return; } MODELWaterUser MODELWaterUser = new MODELWaterUser(); MODELWaterUser.waterUserNO = txtWaterUserNO.Text; MODELWaterUser.waterUserName = txtName.Text; MODELWaterUser.waterPhone = txtTel.Text; MODELWaterUser.waterUserAddress = txtAddress.Text; MODELWaterUser.FPTaxNO = txtTaxNO.Text; MODELWaterUser.FPBankNameAndAccountNO = txtBankNameAndAccountNO.Text; if (BLLwaterUser.UpdateUserByWaterUserNO(MODELWaterUser)) { mes.Show("设置成功!"); return; } } catch (Exception ex) { mes.Show(ex.Message); log.Write(ex.ToString(), MsgType.Error); return; } }
/// <summary> /// 修改新的用户名 /// </summary> /// <param name="MODELWaterUser"></param> /// <returns></returns> public bool UpdateUserName(MODELWaterUser MODELWaterUser) { StringBuilder str = new StringBuilder(); str.Append("UPDATE waterUser SET waterUserName=@waterUserName "); str.Append("WHERE waterUserId=@waterUserId"); SqlParameter[] para = { new SqlParameter("@waterUserName", SqlDbType.VarChar, 70), new SqlParameter("@waterUserId", SqlDbType.VarChar, 30) }; para[0].Value = MODELWaterUser.waterUserName; para[1].Value = MODELWaterUser.waterUserId; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void btChange_Click(object sender, EventArgs e) { try { if (strRecordID.Trim() == "") { mes.Show("抄表记录ID为空,请重新查询抄表记录后再修改用户名!"); return; } if (txtWaterUserNameNew.Text.Trim() == "") { mes.Show("请输入新用户名!"); txtWaterUserNameNew.Focus(); return; } if (mes.ShowQ("确定要变更'" + strWaterUserName + "'的用户名吗?") != DialogResult.OK) { return; } MODELreadMeterRecord MODELreadMeterRecord = new MODELreadMeterRecord(); MODELreadMeterRecord.waterUserName = txtWaterUserNameNew.Text; MODELreadMeterRecord.readMeterRecordId = strRecordID; if (BLLreadMeterRecord.UpdateHandSetWaterUserName(MODELreadMeterRecord)) { try { MODELWaterUser MODELWaterUser = new MODELWaterUser(); MODELWaterUser.waterUserId = strWaterUserID; MODELWaterUser.waterUserName = txtWaterUserNameNew.Text; if (BLLwaterUser.UpdateUserName(MODELWaterUser)) { frmWaterMeterRead.dgWaterList.CurrentRow.Cells["waterUserName"].Value = txtWaterUserNameNew.Text; MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG(); MODELOPERATORLOG.METERREADINGID = strMeterReadingID; MODELOPERATORLOG.LOGCONTENT = "变更用户名:" + MODELWaterUser.waterUserId + "-" + txtWaterUserName.Text + "→" + MODELWaterUser.waterUserName; MODELOPERATORLOG.LOGTYPE = "1"; //1代表用户 2代表水表 MODELOPERATORLOG.OPERATORID = strLogID; MODELOPERATORLOG.OPERATORNAME = strUserName; BLLOPERATORLOG.Insert(MODELOPERATORLOG); mes.Show("户名变更成功!"); btChange.Enabled = false; } } catch (Exception) { mes.Show("户名基础信息变更失败,请重试!"); return; } } else { mes.Show("抄表记录户名变更失败,请重试!"); return; } } catch (Exception ex) { mes.Show("抄表记录户名变更失败,原因:" + ex.ToString()); log.Write(ex.ToString(), MsgType.Error); return; } }
public bool InsertwaterUser(MODELWaterUser MODELWaterUser) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO waterUser(waterUserId,waterUserNO,waterUserName,waterUserNameCode,waterUserCerficateType,waterUserCerficateNO," + "waterUserTelphoneNO,waterPhone,waterUserAddress,waterUserPeopleCount,areaNO,pianNO,duanNO,communityID,buildingNO,unitNO,meterReaderID," + "meterReaderName,chargerID,chargerName," + "meterReadingID,meterReadingPageNo,waterUserTypeId,waterUserCreateDate,operatorName,waterUserHouseType,agentsign,bankId," + "BankAcountNumber,createType,memo,ordernumber,chargeType) "); str.Append("VALUES(@waterUserId,@waterUserNO,@waterUserName,@waterUserNameCode,@waterUserCerficateType,@waterUserCerficateNO,@waterUserTelphoneNO," + "@waterPhone,@waterUserAddress,@waterUserPeopleCount,@areaNO,@pianNO,@duanNO,@communityID,@buildingNO,@unitNO,@meterReaderID," + "@meterReaderName,@chargerID,@chargerName," + "@meterReadingID,@meterReadingPageNo,@waterUserTypeId,@waterUserCreateDate,@operatorName,@waterUserHouseType,@agentsign,@bankId," + "@BankAcountNumber,@createType,@memo,@ordernumber,@chargeType)"); SqlParameter[] para = { new SqlParameter("@waterUserId", SqlDbType.VarChar, 30), new SqlParameter("@waterUserNO", SqlDbType.VarChar, 30), new SqlParameter("@waterUserName", SqlDbType.VarChar, 50), new SqlParameter("@waterUserNameCode", SqlDbType.VarChar, 50), new SqlParameter("@waterUserCerficateType", SqlDbType.VarChar, 50), new SqlParameter("@waterUserCerficateNO", SqlDbType.VarChar, 50), new SqlParameter("@waterUserTelphoneNO", SqlDbType.VarChar, 50), new SqlParameter("@waterPhone", SqlDbType.VarChar, 50), new SqlParameter("@waterUserAddress", SqlDbType.VarChar, 100), new SqlParameter("@waterUserPeopleCount", SqlDbType.Int), new SqlParameter("@areaNO", SqlDbType.VarChar, 50), new SqlParameter("@pianNO", SqlDbType.VarChar, 50), new SqlParameter("@duanNO", SqlDbType.VarChar, 50), new SqlParameter("@communityID", SqlDbType.VarChar, 50), new SqlParameter("@buildingNO", SqlDbType.VarChar, 50), new SqlParameter("@unitNO", SqlDbType.VarChar, 50), new SqlParameter("@meterReaderID", SqlDbType.VarChar, 50), new SqlParameter("@meterReaderName", SqlDbType.VarChar, 50), new SqlParameter("@chargerID", SqlDbType.VarChar, 50), new SqlParameter("@chargerName", SqlDbType.VarChar, 50), new SqlParameter("@meterReadingID", SqlDbType.VarChar, 30), new SqlParameter("@meterReadingPageNo", SqlDbType.VarChar, 30), new SqlParameter("@waterUserTypeId", SqlDbType.VarChar, 30), new SqlParameter("@waterUserCreateDate", SqlDbType.DateTime), new SqlParameter("@operatorName", SqlDbType.VarChar, 30), new SqlParameter("@waterUserHouseType", SqlDbType.VarChar, 10), new SqlParameter("@agentsign", SqlDbType.VarChar, 10), new SqlParameter("@bankId", SqlDbType.VarChar, 30), new SqlParameter("@BankAcountNumber", SqlDbType.VarChar, 50), new SqlParameter("@createType", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@ordernumber", SqlDbType.Int), new SqlParameter("@chargeType", SqlDbType.VarChar, 10) }; para[0].Value = MODELWaterUser.waterUserId; para[1].Value = MODELWaterUser.waterUserNO; para[2].Value = MODELWaterUser.waterUserName; para[3].Value = MODELWaterUser.waterUserNameCode; para[4].Value = MODELWaterUser.waterUserCerficateType; para[5].Value = MODELWaterUser.waterUserCerficateNO; para[6].Value = MODELWaterUser.waterUserTelphoneNO; para[7].Value = MODELWaterUser.waterPhone; para[8].Value = MODELWaterUser.waterUserAddress; para[9].Value = MODELWaterUser.waterUserPeopleCount; para[10].Value = MODELWaterUser.areaNO; para[11].Value = MODELWaterUser.pianNO; para[12].Value = MODELWaterUser.duanNO; para[13].Value = MODELWaterUser.communityID; para[14].Value = MODELWaterUser.buildingNO; para[15].Value = MODELWaterUser.unitNO; para[16].Value = MODELWaterUser.meterReaderID; para[17].Value = MODELWaterUser.meterReaderName; para[18].Value = MODELWaterUser.chargerID; para[19].Value = MODELWaterUser.chargerName; para[20].Value = MODELWaterUser.meterReadingID; para[21].Value = MODELWaterUser.meterReadingPageNo; para[22].Value = MODELWaterUser.waterUserTypeId; para[23].Value = MODELWaterUser.waterUserCreateDate; para[24].Value = MODELWaterUser.operatorName; para[25].Value = MODELWaterUser.waterUserHouseType; para[26].Value = MODELWaterUser.agentsign; para[27].Value = MODELWaterUser.bankId; para[28].Value = MODELWaterUser.BankAcountNumber; para[29].Value = MODELWaterUser.createType; para[30].Value = MODELWaterUser.MEMO; para[31].Value = MODELWaterUser.ordernumber; para[32].Value = MODELWaterUser.chargeType; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSaveUser_Click(object sender, EventArgs e) { #region 用户验证 int intStartNO = 0, intCount = 1, intOrderNumberStart = 1; if (txtWaterUserNOStart.Text.Trim() == "") { mes.Show("请输入用户编号!"); txtWaterUserNOStart.Focus(); return; } else { string strWaterUserNOStart = txtWaterUserNOStart.Text; if (strWaterUserNOStart.Length == 6) { if (strWaterUserNOStart.Substring(0, 1) != "U") { mes.Show("用户号由'U'+5位数字组成,请重新填写!"); txtWaterUserNOStart.SelectAll(); return; } else { if (!Information.IsNumeric(strWaterUserNOStart.Substring(1, 5))) { mes.Show("用户号由'U'+5位数字组成,请重新填写!"); txtWaterUserNOStart.SelectAll(); return; } else { intStartNO = Convert.ToInt32(strWaterUserNOStart.Substring(1, 5)); } } } else { mes.Show("用户号由'U'+5位数字组成,请重新填写!"); txtWaterUserNOStart.SelectAll(); return; } } if (!Information.IsNumeric(txtCount.Text)) { mes.Show("请输入正确的数量!"); txtCount.SelectAll(); return; } else { if (Convert.ToInt16(txtCount.Text) < 1) { mes.Show("请输入大于0的整数!"); txtCount.SelectAll(); return; } else { intCount = Convert.ToInt16(txtCount.Text); } } //if (txtWaterUserName.Text.Trim() == "") //{ // mes.Show("请输入用户名称!"); // txtWaterUserName.Focus(); // return; //} if (txtWaterUserCount.Text.Trim() == "") { mes.Show("请输入人口数量!"); txtWaterUserCount.Focus(); return; } string strWaterUserIsExist = "SELECT * FROM WATERUSER WHERE WATERUSERID BETWEEN 'U" + intStartNO.ToString().PadLeft(5, '0') + "' AND 'U" + (intStartNO + intCount).ToString().PadLeft(5, '0') + "'"; DataTable dtWaterUserQuery = BLLwaterUser.QuerySQL(strWaterUserIsExist); if (dtWaterUserQuery.Rows.Count > 0) { string strWaterUserIDS = ""; for (int i = 0; i < dtWaterUserQuery.Rows.Count; i++) { object objWaterUserID = dtWaterUserQuery.Rows[i]["WATERUSERID"]; if (objWaterUserID != null && objWaterUserID != DBNull.Value) { if (strWaterUserIDS == "") { strWaterUserIDS = objWaterUserID.ToString(); } else { strWaterUserIDS += ";" + objWaterUserID.ToString(); } } } mes.Show("存在已使用的用户号'" + strWaterUserIDS + "'"); return; } if (cmbAreaNO.SelectedValue == null || cmbAreaNO.SelectedValue == DBNull.Value) { mes.Show("请选择区号!"); cmbAreaNO.Focus(); return; } if (cmbPianNO.SelectedValue == null || cmbPianNO.SelectedValue == DBNull.Value) { mes.Show("请选择片号!"); cmbPianNO.Focus(); return; } if (cmbDuanNO.SelectedValue == null || cmbDuanNO.SelectedValue == DBNull.Value) { mes.Show("请选择段号!"); cmbDuanNO.Focus(); return; } if (cmbCommunity.SelectedValue == null || cmbCommunity.SelectedValue == DBNull.Value) { mes.Show("请选择小区!"); cmbCommunity.Focus(); return; } if (cmbMeterReader.SelectedValue == null || cmbMeterReader.SelectedValue == DBNull.Value) { mes.Show("请选择抄表员!"); cmbMeterReader.Focus(); return; } if (cmbCharger.SelectedValue == null || cmbCharger.SelectedValue == DBNull.Value) { mes.Show("请选择收费员!"); cmbCharger.Focus(); return; } if (cmbCreateType.SelectedIndex < 0) { mes.Show("请选择建档类型!"); cmbCreateType.Focus(); return; } if (!Information.IsNumeric(txtOrderNumber.Text)) { mes.Show("请输入正确的顺序号!"); txtOrderNumber.Focus(); return; } else { intOrderNumberStart = Convert.ToInt32(txtOrderNumber.Text); } if (cmbCerficateType.Text != "") { if (txtCerficateNO.Text.Trim() == "") { mes.Show("请输入证件编号!"); cmbUserType.Focus(); return; } } if (cmbWaterUserChargeType.Text == "") { mes.Show("请选择交费方式!"); cmbWaterUserChargeType.Focus(); return; } if (cmbAgentSign.Text == "") { mes.Show("请设置银行是否托收!"); cmbAgentSign.Focus(); return; } else { if (cmbAgentSign.Text == "托收") { if (cmbAgentBank.SelectedValue == null || cmbAgentBank.SelectedValue == DBNull.Value) { mes.Show("请选择托收银行!"); cmbAgentBank.Focus(); return; } if (txtWaterUserBankNO.Text.Trim() == "") { mes.Show("请输入银行卡号!"); txtWaterUserBankNO.Focus(); return; } } } #endregion #region 水表验证 if (cmbWaterMeterSize.SelectedValue == null || cmbWaterMeterSize.SelectedValue == DBNull.Value) { mes.Show("请选择水表口径!"); cmbWaterMeterSize.Focus(); return; } if (cmbWaterType.SelectedValue == null || cmbWaterType.SelectedValue == DBNull.Value) { mes.Show("请选择用水类别!"); cmbWaterType.Focus(); return; } if (cmbWaterMeterState.Text == "") { mes.Show("请选择水表状态!"); cmbWaterMeterState.Focus(); return; } if (!Information.IsNumeric(txtWaterMeterStartNum.Text)) { mes.Show("初始读数只能为整数!"); txtWaterMeterStartNum.Focus(); return; } if (!Information.IsNumeric(txtWaterMeterMagnification.Text)) { mes.Show("倍率只能为整数!"); txtWaterMeterMagnification.Focus(); return; } if (!Information.IsNumeric(txtWaterMeterMaxRange.Text)) { mes.Show("最大量程只能为整数!"); txtWaterMeterMaxRange.Focus(); return; } if (!Information.IsNumeric(txtProofreadingPeriod.Text)) { mes.Show("鉴定周期只能为整数!"); txtProofreadingPeriod.Focus(); return; } if (!Information.IsNumeric(txtWaterMeterFixedValue.Text)) { mes.Show("定量用水只能为整数!"); txtWaterMeterFixedValue.Focus(); return; } if (cmbIsSummary.Text == "") { mes.Show("请选择是否为总表!"); cmbIsSummary.Focus(); return; } if (txtWaterMeterIsSummary.Text.Trim() != "") { if (txtWaterMeterIsSummary.Text.Trim().Length != 8 && txtWaterMeterIsSummary.Text.Trim().Length != 6) { mes.Show("总表编号只能为6位用户号或者8位水表编号!"); txtWaterMeterIsSummary.Focus(); return; } } #endregion #region 自动排序 try { string strSQL = "UPDATE WATERUSER SET ordernumber=ordernumber+" + intCount + " WHERE areaNO='" + strAreaNO + "' AND pianNO='" + strPianNO + "' AND duanNO='" + strDuanNO + "' AND ordernumber>=" + intOrderNumberStart; BLLwaterUser.ExcuteSQL(strSQL); } catch (Exception ex) { mes.Show("自动排序失败,批量添加成功后请手动排序!"); } #endregion for (int i = 0; i < intCount; i++) { try { MODELWaterUser MODELWaterUser = new MODELWaterUser(); //MODELWaterUser.waterUserNO = GETTABLEID.GetTableID("", "WATERUSER"); MODELWaterUser.waterUserName = txtWaterUserName.Text; MODELWaterUser.waterUserNameCode = txtCode.Text; MODELWaterUser.waterUserAddress = txtWaterUserAddress.Text; MODELWaterUser.waterUserCerficateType = cmbCerficateType.Text; MODELWaterUser.waterUserCerficateNO = txtCerficateNO.Text; MODELWaterUser.waterUserTelphoneNO = txtWaterUserTel.Text; MODELWaterUser.waterPhone = txtPhone.Text; MODELWaterUser.waterUserPeopleCount = txtWaterUserCount.Text; MODELWaterUser.areaNO = cmbAreaNO.Text; MODELWaterUser.pianNO = cmbPianNO.Text; MODELWaterUser.duanNO = cmbDuanNO.Text; MODELWaterUser.communityID = cmbCommunity.SelectedValue.ToString(); MODELWaterUser.buildingNO = txtBuildingNO.Text; MODELWaterUser.unitNO = txtUnitNO.Text; MODELWaterUser.waterUserTypeId = cmbUserType.SelectedValue.ToString(); MODELWaterUser.chargeType = cmbWaterUserChargeType.SelectedIndex.ToString(); MODELWaterUser.waterUserHouseType = cmbUserHouseType.Text; if (MODELWaterUser.waterUserHouseType == "楼房") { MODELWaterUser.waterUserHouseType = "1"; } else { MODELWaterUser.waterUserHouseType = "2"; } MODELWaterUser.meterReaderID = cmbMeterReader.SelectedValue.ToString(); MODELWaterUser.meterReaderName = cmbMeterReader.Text; MODELWaterUser.chargerID = cmbCharger.SelectedValue.ToString(); MODELWaterUser.chargerName = cmbCharger.Text; //MODELWaterUser.meterReadingID = cmbWaterUserMeterReadingNO.SelectedValue.ToString(); //MODELWaterUser.meterReadingPageNo = txtMeterReadingPageNO.Text; MODELWaterUser.ordernumber = intOrderNumberStart + i; MODELWaterUser.agentsign = cmbAgentSign.Text; if (MODELWaterUser.agentsign == "托收") { MODELWaterUser.agentsign = "1"; MODELWaterUser.bankId = cmbAgentBank.SelectedValue.ToString(); MODELWaterUser.BankAcountNumber = txtWaterUserBankNO.Text; } else { MODELWaterUser.agentsign = "2"; } MODELWaterUser.createType = cmbCreateType.Text; MODELWaterUser.MEMO = txtWaterUserMemo.Text; MODELWaterUser.operatorName = strLogName; MODELWaterUser.waterUserNO = "U" + (intStartNO + i).ToString().PadLeft(5, '0'); MODELWaterUser.waterUserId = MODELWaterUser.waterUserNO; MODELWaterUser.waterUserCreateDate = mes.GetDatetimeNow(); if (BLLwaterUser.InsertwaterUser(MODELWaterUser)) { try { MODELwaterMeter MODELwaterMeter = new MODELwaterMeter(); //if(cmbWaterMeterPosition.SelectedValue!=null&&cmbWaterMeterPosition.SelectedValue!=DBNull.Value) // MODELwaterMeter.waterMeterPositionId = cmbWaterMeterPosition.SelectedValue.ToString(); MODELwaterMeter.waterMeterPositionName = cmbWaterMeterPosition.Text; MODELwaterMeter.waterMeterSizeId = cmbWaterMeterSize.SelectedValue.ToString(); //如果正常则添加启用时间 if (cmbWaterMeterState.Text == "正常") { MODELwaterMeter.waterMeterState = "1"; MODELwaterMeter.STARTUSEDATETIME = mes.GetDatetimeNow(); } //if (cmbWaterMeterState.Text == "停水") // MODELwaterMeter.waterMeterState = "2"; //if (cmbWaterMeterState.Text == "报废") MODELwaterMeter.waterMeterState = (cmbWaterMeterState.SelectedIndex + 1).ToString(); MODELwaterMeter.waterMeterTypeId = cmbWaterType.SelectedValue.ToString(); MODELwaterMeter.WATERFIXVALUE = Convert.ToInt32(txtWaterMeterFixedValue.Text); MODELwaterMeter.waterMeterStartNumber = Convert.ToInt32(txtWaterMeterStartNum.Text); MODELwaterMeter.waterMeterProduct = txtWaterMeterProductor.Text; MODELwaterMeter.waterMeterSerialNumber = txtWaterMeterSerialNum.Text; MODELwaterMeter.waterMeterMode = txtWaterMeterModel.Text; MODELwaterMeter.WATERMETERLOCKNO = txtLockNO.Text; MODELwaterMeter.waterMeterMaxRange = Convert.ToInt32(txtWaterMeterMaxRange.Text); //if (Information.IsDate(txtWaterMeterProofDate.Text)) // MODELwaterMeter.waterMeterProofreadingDate = Convert.ToDateTime(txtWaterMeterProofDate.Text); MODELwaterMeter.waterMeterProofreadingDate = dtpProofDate.Value; MODELwaterMeter.waterMeteProofreadingPeriod = Convert.ToInt32(txtProofreadingPeriod.Text); MODELwaterMeter.waterMeterMagnification = Convert.ToInt32(txtWaterMeterMagnification.Text); MODELwaterMeter.waterUserId = MODELWaterUser.waterUserId; MODELwaterMeter.isSummaryMeter = (cmbIsSummary.SelectedIndex + 1).ToString();//分表为1 总表为2 MODELwaterMeter.waterMeterParentId = txtWaterMeterIsSummary.Text; MODELwaterMeter.IsReverse = "0"; MODELwaterMeter.MEMO = txtWaterMeterMemo.Text; MODELwaterMeter.waterMeterId = MODELWaterUser.waterUserId + "01"; MODELwaterMeter.waterMeterNo = MODELwaterMeter.waterMeterId; //MODELwaterMeter.STARTUSEDATETIME = mes.GetDatetimeNow(); if (!BLLwaterMeter.Insert(MODELwaterMeter)) { mes.Show("添加用户编号为'" + MODELWaterUser.waterUserId + "'的水表信息时保存失败!请检查填写项目是否符合验证规则!"); return; } else { MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG(); MODELOPERATORLOG.LOGCONTENT = "新增水表:" + MODELwaterMeter.waterMeterId; //MODELOPERATORLOG.METERREADINGID = cmbWaterUserMeterReadingNO.SelectedValue.ToString(); MODELOPERATORLOG.LOGTYPE = "2"; //1代表用户 2代表水表 MODELOPERATORLOG.OPERATORID = strLogID; MODELOPERATORLOG.OPERATORNAME = strLogName; BLLOPERATORLOG.Insert(MODELOPERATORLOG); } } catch (Exception ex) { //回滚用户表 BLLwaterUser.DeleteUser(MODELWaterUser.waterUserId); mes.Show(ex.Message); log.Write(ex.ToString(), MsgType.Error); return; } } else { mes.Show("添加用户编号为'" + MODELWaterUser.waterUserId + "'时保存失败!请检查填写项目是否符合验证规则!"); return; } } catch (Exception ex) { mes.Show(ex.Message); log.Write(ex.ToString(), MsgType.Error); return; } } DataTable dtList = BLLwaterMeter.QueryConnectWaterUser(" AND WATERUSERID BETWEEN 'U" + intStartNO.ToString().PadLeft(5, '0') + "' AND 'U" + (intStartNO + intCount).ToString().PadLeft(5, '0') + "'"); dgList.DataSource = dtList; }
private void btOK_Click(object sender, EventArgs e) { if (txtWaterUserName.Text.Trim() == "") { mes.Show("请输入变更后的用户名!"); txtWaterUserName.Focus(); return; } if (mes.ShowQ("确定要将姓名为'" + strWaterUserName + "'的用户名变更为'" + txtWaterUserName.Text + "'吗?") != DialogResult.OK) { return; } try { MODELreadMeterRecord MODELreadMeterRecord = new MODELreadMeterRecord(); MODELreadMeterRecord.readMeterRecordId = strRecordID; MODELreadMeterRecord.waterUserName = txtWaterUserName.Text; if (BLLreadMeterRecord.UpdateHandSetWaterUserName(MODELreadMeterRecord)) { string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDBFPath + ";Extended Properties=dBASE IV;User ID=Admin;Password=;"; string strSQLUpdateWaterMeterType = "UPDATE INTERDB SET yhm='" + MODELreadMeterRecord.waterUserName + "' " + " WHERE recordid='" + strRecordID + "'"; int intRow = ExcuteSQL(strSQLUpdateWaterMeterType, connectString); if (intRow > 0) { frm.dgList.CurrentRow.Cells["yhm"].Value = MODELreadMeterRecord.waterUserName; //mes.Show("信息变更成功,如果要更改用户基础信息请手动更改!"); if (mes.ShowQ("信息变更成功,是否要继续更改用户基础信息?") != DialogResult.OK) { return; } MODELWaterUser MODELWaterUser = new MODELWaterUser(); MODELWaterUser.waterUserNO = strWaterUserNO; MODELWaterUser.waterUserName = MODELreadMeterRecord.waterUserName; if (BLLwaterUser.UpdateHandSetUser(MODELWaterUser)) { mes.Show("用户基础信息变更成功!"); MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG(); MODELOPERATORLOG.LOGCONTENT = "修改用户名:" + strWaterUserName + "→" + txtWaterUserName.Text; MODELOPERATORLOG.METERREADINGID = strMeterReadingID; MODELOPERATORLOG.LOGTYPE = "3"; //1代表用户 2代表水表 3抄表机 MODELOPERATORLOG.OPERATORID = strLogID; MODELOPERATORLOG.OPERATORNAME = strUserName; BLLOPERATORLOG.Insert(MODELOPERATORLOG); } else { mes.Show("用户基础信息变更失败,请手动修改户号为'" + strWaterUserNO + "的用户名!"); return; } } else { mes.Show("更新抄表数据文件失败,请重试!"); return; } } else { mes.Show("更新抄表数据失败,请重试!"); return; } } catch (Exception ex) { mes.Show(ex.Message); log.Write(ex.ToString(), MsgType.Error); } }