private void toolDelete_Click(object sender, EventArgs e)
{
if (dgLog.Rows.Count == 0)
{
mes.Show("日志列表为空,请查询后再清空日志!");
return;
}
if (mes.ShowQ("清除日志内容将不可恢复，确定要清除日志列表中的日志吗?") == DialogResult.OK)
{
int intCount = BLLOPERATORLOG.Delete(txtFilter.Text);
if (intCount > 0)
{
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "管理员:" + strLogID + "-" + strUserName + ",清空" + intCount + "条日志";
MODELOPERATORLOG.LOGTYPE = "4"; //1代表用户 2代表水表 3代表抄表机相关日志 4清除日志
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
toolSearch_Click(null, null);
mes.Show("共清空'" + intCount.ToString() + "'条日志");
}
}
}
public bool Insert(MODELOPERATORLOG MODELOPERATORLOG)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO OPERATORLOG(LOGTYPE,METERREADINGID,LOGCONTENT,LOGDATETIME,OPERATORID,OPERATORNAME,MEMO) ");
str.Append("VALUES(@LOGTYPE,@METERREADINGID,@LOGCONTENT,GETDATE(),@OPERATORID,@OPERATORNAME,@MEMO)");
SqlParameter[] para =
{
new SqlParameter("@LOGTYPE", SqlDbType.VarChar, 10),
new SqlParameter("@METERREADINGID", SqlDbType.VarChar, 30),
new SqlParameter("@LOGCONTENT", SqlDbType.VarChar, 1000),
new SqlParameter("@OPERATORID", SqlDbType.VarChar, 30),
new SqlParameter("@OPERATORNAME", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50)
};
para[0].Value = MODELOPERATORLOG.LOGTYPE;
para[1].Value = MODELOPERATORLOG.METERREADINGID;
para[2].Value = MODELOPERATORLOG.LOGCONTENT;
para[3].Value = MODELOPERATORLOG.OPERATORID;
para[4].Value = MODELOPERATORLOG.OPERATORNAME;
para[5].Value = MODELOPERATORLOG.MEMO;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void frmMain_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
BLLOPERATORLOG BLLOPERATORLOG = new BLLOPERATORLOG();
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "用户:" + strLogID + "-" + strUserName + "退出";
//MODELOPERATORLOG.METERREADINGID = cmbWaterUserMeterReadingNO.SelectedValue.ToString();
MODELOPERATORLOG.LOGTYPE = "5"; //5登陆日志
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
catch (Exception ex)
{
}
}
private void btLogin_Click(object sender, EventArgs e)
{
string strLogID;
string strName;
string strRealName;
string strPWD;
string strDepID, strDepName, strPostID, strState = "", strGroupID = "", strGroupName = "";
string strSQL;
DataTable dt = new DataTable();
if (txtLogName.Text.Trim() == "")
{
mes.Show("请输入用户名!");
return;
}
else
{
strName = txtLogName.Text.Trim();
}
if (txtLogPWD.Text.Trim() == "")
{
mes.Show("请输入密码!");
return;
}
else
{
strPWD = txtLogPWD.Text.Trim();
}
//strPWD = DBUtility.DESEncrypt.Encrypt(strPWD);
strSQL = " AND LOGINNAME='" + strName + "' AND Password='******' ";
//btLogin.Enabled = false;
//btCancle.Enabled = false;
//labelS.Visible = true;
try
{
dt = BLLBASE_LOGIN.QueryUser(strSQL);
if (dt.Rows.Count > 0)
{
strLogID = dt.Rows[0]["LOGINID"].ToString();
strRealName = dt.Rows[0]["USERNAME"].ToString();
strDepID = dt.Rows[0]["DEPARTMENTID"].ToString();
strPostID = dt.Rows[0]["POSTID"].ToString();
strDepName = dt.Rows[0]["DEPARTMENTNAME"].ToString();
strState = dt.Rows[0]["userstateS"].ToString();
strGroupID = dt.Rows[0]["groupID"].ToString();
strGroupName = dt.Rows[0]["groupName"].ToString();
if (strState == "停用")
{
mes.Show("用户已被管理员停用!");
return;
}
AppDomain.CurrentDomain.SetData("LOGINID", strLogID);
AppDomain.CurrentDomain.SetData("LOGINNAME", strName);
AppDomain.CurrentDomain.SetData("USERNAME", strRealName);
AppDomain.CurrentDomain.SetData("DEPARTMENTID", strDepID);
AppDomain.CurrentDomain.SetData("DEPARTMENTNAME", strDepName);
AppDomain.CurrentDomain.SetData("POSTID", strPostID);
AppDomain.CurrentDomain.SetData("GROUPID", strGroupID);
AppDomain.CurrentDomain.SetData("GROUPNAME", strGroupName);
AppDomain.CurrentDomain.SetData("IP", GetAddressIP());
AppDomain.CurrentDomain.SetData("COMPUTERNAME", System.Environment.GetEnvironmentVariable("ComputerName"));
//Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//AppSettingsSection app = config.AppSettings; //app.Settings.Add("x", "this is X");
// app.Settings["USERNAME"].Value = strName;
// config.Save(ConfigurationSaveMode.Modified);
//如果配置文件中的登陆名和现在登陆的登陆名不一致，则修改config配置文件中的用户名
if (strLogNameOld != strName)
{
ModifyConfig(strName);
}
try
{
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "用户:" + strLogID + "-" + strRealName + "登陆,登陆IP:" + GetAddressIP();
//MODELOPERATORLOG.METERREADINGID = cmbWaterUserMeterReadingNO.SelectedValue.ToString();
MODELOPERATORLOG.LOGTYPE = "5"; //5登陆日志
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strRealName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
catch (Exception ex)
{
}
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
mes.Show("用户不存在或密码错误!");
return;
}
}
catch (Exception ex)
{
//labelS.Visible = false;
mes.Show(ex.ToString());
}
}
private void btOK_Click(object sender, EventArgs e)
{
if (mes.ShowQ("变更后该记录将置为未抄!\n确定要将用户'" + strWaterUserName + "'的水表编号为'" + strSBH + "'的水表初始读数变更吗?") != DialogResult.OK)
{
return;
}
if (!Information.IsNumeric(txtSYDSNew.Text))
{
mes.Show("上月读数只能为数字!");
txtSYDSNew.Focus();
return;
}
else
{
if ((int)Math.Ceiling(Convert.ToDouble(txtSYDSNew.Text)) != Convert.ToInt64(txtSYDSNew.Text))
{
mes.Show("上月读数只能为整数!");
txtSYDSNew.Focus();
return;
}
}
try
{
MODELreadMeterRecord MODELreadMeterRecord = new MODELreadMeterRecord();
MODELreadMeterRecord.readMeterRecordId = strRecordID;
MODELreadMeterRecord.waterMeterLastNumber = Convert.ToInt32(txtSYDSNew.Text);
MODELreadMeterRecord.MEMO = "初始读数变更:" + strSYDS + "→" + txtSYDSNew.Text + ";";
if (BLLreadMeterRecord.UpdateHandSetWaterMeterLastNumber(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 sy1syds=" + MODELreadMeterRecord.waterMeterLastNumber +
" WHERE cbsx='" + strRecordID + "'";
int intRow = 0;
try
{
intRow = ExcuteSQL(strSQLUpdateWaterMeterType, connectString);
}
catch (Exception ex)
{
mes.Show("修改抄表机数据库失败,请确认数据文件是否存在");
log.Write(ex.ToString(), MsgType.Error);
return;
}
if (intRow > 0)
{
try
{
frm.dgList.CurrentRow.Cells["syds"].Value = MODELreadMeterRecord.waterMeterLastNumber;
string strSQLUpdateSetUnRead = "UPDATE INTERDB SET CBBZ='0',DYBZ='0' WHERE cbsx='" + strRecordID + "'";
ExcuteSQL(strSQLUpdateSetUnRead, connectString);
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "修改初始读数:" + strWaterUserName + "'-'" + strSBH + ":" + strSYDS + "→" + txtSYDSNew.Text;
MODELOPERATORLOG.METERREADINGID = strMeterReadingID;
MODELOPERATORLOG.LOGTYPE = "3"; //1代表用户 2代表水表 3抄表机
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
catch (Exception ex)
{
mes.Show("置为未抄失败,请确认抄表机数据文件是否存在");
log.Write(ex.ToString(), MsgType.Error);
return;
}
}
else
{
mes.Show("修改抄表机数据库失败,请确认数据文件中抄表记录是否存在!");
return;
}
}
else
{
mes.Show("修改抄表表记录失败,请确认抄表表记录是否存在!");
return;
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
private void btChangeWaterMeterTypeID_Click(object sender, EventArgs e)
{
if (mes.ShowQ("变更后该记录将置为未抄!\n确定要将用户'" + strWaterUserName + "'的水表编号为'" + strSBH + "'的用水性质信息变更吗?") != DialogResult.OK)
{
return;
}
try
{
MODELreadMeterRecord MODELreadMeterRecord = new MODELreadMeterRecord();
if (cmbWaterMeterTypeNew.SelectedValue == null || cmbWaterMeterTypeNew.SelectedValue == DBNull.Value)
{
mes.Show("用水性质不能为空!");
return;
}
else
{
DataRow[] drWaterMeterType = dtWaterMeterType.Select("waterMeterTypeId='" + cmbWaterMeterTypeNew.SelectedValue.ToString() + "'");
if (drWaterMeterType.Length > 0)
{
object objTrapePrice = drWaterMeterType[0]["trapezoidPrice"];
if (objTrapePrice != null && objTrapePrice != DBNull.Value)
{
MODELreadMeterRecord.trapezoidPrice = objTrapePrice.ToString();
}
string[] strTrapePrice = objTrapePrice.ToString().Split('|');
if (strTrapePrice[0].Split(':').Length > 0)
{
if (Information.IsNumeric(strTrapePrice[0].Split(':')[1]))
{
MODELreadMeterRecord.avePrice = Convert.ToDecimal(strTrapePrice[0].Split(':')[1]);
}
}
object objExtraFee = drWaterMeterType[0]["extraCharge"];
if (objExtraFee != null && objExtraFee != DBNull.Value)
{
MODELreadMeterRecord.extraCharge = objExtraFee.ToString();
string[] strAllExtraFee = objExtraFee.ToString().Split('|');
for (int j = 0; j < strAllExtraFee.Length; j++)
{
string[] strSingleExtraFee = strAllExtraFee[j].Split(':');
if (strSingleExtraFee[0].Contains("F"))
{
string strNum = strSingleExtraFee[0].Substring(1, 1);
if (strNum == "1")
{
if (Information.IsNumeric(strSingleExtraFee[1]))
{
MODELreadMeterRecord.extraChargePrice1 = Convert.ToDecimal(strSingleExtraFee[1]);
}
}
if (strNum == "2")
{
if (Information.IsNumeric(strSingleExtraFee[1]))
{
MODELreadMeterRecord.extraChargePrice2 = Convert.ToDecimal(strSingleExtraFee[1]);
}
}
}
}
}
}
else
{
mes.Show("获取用水单价失败,无法完成修改!");
return;
}
}
MODELreadMeterRecord.readMeterRecordId = strRecordID;
MODELreadMeterRecord.waterMeterTypeId = cmbWaterMeterTypeNew.SelectedValue.ToString();
MODELreadMeterRecord.waterMeterTypeName = cmbWaterMeterTypeNew.Text;
MODELreadMeterRecord.MEMO = "用水性质变更:" + strWaterMeterTypeName + "→" + cmbWaterMeterTypeNew.Text + ";";
if (BLLreadMeterRecord.UpdateHandSetWaterMeterType(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 yslbdm='" + MODELreadMeterRecord.waterMeterTypeId + "'," +
"yslb='" + MODELreadMeterRecord.waterMeterTypeName + "'," +
"szydj=" + MODELreadMeterRecord.avePrice + "," +
"fjfdj=" + MODELreadMeterRecord.extraChargePrice1 + "," +
"fjfdj1=" + MODELreadMeterRecord.extraChargePrice2 +
" WHERE recordid='" + strRecordID + "'";
int intRow = 0;
try
{
intRow = ExcuteSQL(strSQLUpdateWaterMeterType, connectString);
}
catch (Exception ex)
{
mes.Show("修改抄表机数据库失败,请确认数据文件是否存在");
log.Write(ex.ToString(), MsgType.Error);
return;
}
if (intRow > 0)
{
frm.dgList.CurrentRow.Cells["yslbdm"].Value = MODELreadMeterRecord.waterMeterTypeId;
frm.dgList.CurrentRow.Cells["yslb"].Value = MODELreadMeterRecord.waterMeterTypeName;
frm.dgList.CurrentRow.Cells["szydj"].Value = MODELreadMeterRecord.avePrice;
frm.dgList.CurrentRow.Cells["fjfdj"].Value = MODELreadMeterRecord.extraChargePrice1;
frm.dgList.CurrentRow.Cells["fjfdj1"].Value = MODELreadMeterRecord.extraChargePrice2;
string strSQLUpdateSetUnRead = "UPDATE INTERDB SET CBBZ='0',DYBZ='0' WHERE recordid='" + strRecordID + "'";
try
{
ExcuteSQL(strSQLUpdateSetUnRead, connectString);
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "修改用水性质:" + strWaterUserName + "'-'" + strSBH + ":" + strWaterMeterTypeName + "→" + cmbWaterMeterTypeNew.Text;
MODELOPERATORLOG.LOGTYPE = "3"; //1代表用户 2代表水表 3抄表机
MODELOPERATORLOG.METERREADINGID = strMeterReadingID;
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
catch (Exception ex)
{
mes.Show("置为未抄失败,请确认抄表机数据文件是否存在");
log.Write(ex.ToString(), MsgType.Error);
return;
}
if (mes.ShowQ("是否要继续更改水表的用水性质?") != DialogResult.OK)
{
return;
}
MODELwaterMeter MODELwaterMeter = new MODELwaterMeter();
MODELwaterMeter.waterMeterId = strSBH;
MODELwaterMeter.waterMeterTypeId = MODELreadMeterRecord.waterMeterTypeId;
if (BLLwaterMeter.UpdateWaterMeterType(MODELwaterMeter))
{
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "修改水表基础表用水性质:" + strWaterUserName + "'-'" + strSBH + ":" + strWaterMeterTypeName + "→" + cmbWaterMeterTypeNew.Text;
MODELOPERATORLOG.LOGTYPE = "3"; //1代表用户 2代表水表 3抄表机
MODELOPERATORLOG.METERREADINGID = strMeterReadingID;
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
mes.Show("水表编号为'" + strSBH + "'的用水性质更改成功!");
}
}
else
{
mes.Show("修改抄表机数据文件失败,请确认抄表记录是否存在");
return;
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
private void btSubmit_Click(object sender, EventArgs e)
{
try
{
string strSQLUpdate = "UPDATE WATERUSER SET ";
string strUpdateContent = "";
if (chkWaterUserName.Checked)
{
strUpdateContent = "WATERUSERNAME='******'";
}
if (chkWaterUserAddress.Checked)
{
if (strUpdateContent == "")
{
strUpdateContent = "waterUserAddress='" + txtWaterUserAddress.Text + "'";
}
else
{
strUpdateContent += "," + "waterUserAddress='" + txtWaterUserAddress.Text + "'";
}
}
if (chkWaterUserTel.Checked)
{
if (strUpdateContent == "")
{
strUpdateContent = "waterUserTelphoneNO='" + txtWaterUserTel.Text + "'";
}
else
{
strUpdateContent += "," + "waterUserTelphoneNO='" + txtWaterUserTel.Text + "'";
}
}
if (strUpdateContent == "")
{
mes.Show("请勾选要变更的信息!");
return;
}
else
{
if (BLLwaterUser.UpdateSQL(strSQLUpdate + strUpdateContent + " WHERE WATERUSERID='" + strWaterUserID + "'"))
{
frmWaterMeterReadSingleCharge frm = (frmWaterMeterReadSingleCharge)this.Owner;
if (chkWaterUserName.Checked)
{
frm.txtWaterUserName.Text = txtWaterUserName.Text;
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
//MODELOPERATORLOG.METERREADINGID = strMeterReadingID;
MODELOPERATORLOG.LOGCONTENT = "变更用户名:" + strWaterUserID + "-" + labWaterUserName.Text + "→" + txtWaterUserName.Text;
MODELOPERATORLOG.LOGTYPE = "1"; //1代表用户 2代表水表
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
if (chkWaterUserAddress.Checked)
{
frm.txtWaterUserAddress.Text = txtWaterUserAddress.Text;
}
if (chkWaterUserTel.Checked)
{
frm.txtWaterUserPhone.Text = txtWaterUserTel.Text;
}
this.DialogResult = DialogResult.OK;
}
else
{
mes.Show("变更用户信息失败!");
return;
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
return;
}
}
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;
}
}
private void btChange_Click(object sender, EventArgs e)
{
try
{
if (!Information.IsNumeric(txtWaterMeterEndNumber.Text.Trim()))
{
mes.Show("变更后的读数只能为数字!");
txtWaterMeterEndNumber.Focus();
return;
}
if (txtMemo.Text.Trim() == "")
{
mes.Show("请输入变更原因!");
txtMemo.Focus();
return;
}
if (mes.ShowQ("表底数变更前请将所有费用收取完毕!\n确定要变更'" + strWaterUserName + "-" + strWaterMeterID + "'的表底数吗？") != DialogResult.OK)
{
return;
}
DateTime dtNow = mes.GetDatetimeNow();
MODELreadMeterRecord MODELreadMeterRecord = new MODELreadMeterRecord();
MODELreadMeterRecord.waterUserName = strWaterUserName;
MODELreadMeterRecord.waterUserNO = strWaterUserNO;
MODELreadMeterRecord.waterUserId = strWaterUserNO;
MODELreadMeterRecord.waterUserAddress = strWaterUserAddress;
MODELreadMeterRecord.readMeterRecordIdLast = strLastRecordID;
MODELreadMeterRecord.lastNumberYearMonth = dtNow.ToString("yyyyMM");
MODELreadMeterRecord.initialReadMeterMesDateTime = dtNow;
MODELreadMeterRecord.waterMeterId = strWaterMeterID;
MODELreadMeterRecord.waterMeterNo = strWaterMeterID;
if (Information.IsNumeric(strWaterMeterLastNumber))
{
MODELreadMeterRecord.waterMeterLastNumber = Convert.ToInt32(strWaterMeterLastNumber);
}
MODELreadMeterRecord.waterMeterEndNumber = Convert.ToInt32(txtWaterMeterEndNumber.Text.Trim());
MODELreadMeterRecord.totalNumber = 0;
MODELreadMeterRecord.waterTotalCharge = 0;
MODELreadMeterRecord.extraChargePrice1 = 0;
MODELreadMeterRecord.extraChargePrice2 = 0;
MODELreadMeterRecord.extraChargePrice3 = 0;
MODELreadMeterRecord.extraChargePrice4 = 0;
MODELreadMeterRecord.extraChargePrice5 = 0;
MODELreadMeterRecord.extraChargePrice6 = 0;
MODELreadMeterRecord.extraChargePrice7 = 0;
MODELreadMeterRecord.extraChargePrice8 = 0;
MODELreadMeterRecord.extraCharge1 = 0;
MODELreadMeterRecord.extraCharge2 = 0;
MODELreadMeterRecord.extraCharge3 = 0;
MODELreadMeterRecord.extraCharge4 = 0;
MODELreadMeterRecord.extraCharge5 = 0;
MODELreadMeterRecord.extraCharge6 = 0;
MODELreadMeterRecord.extraCharge7 = 0;
MODELreadMeterRecord.extraCharge8 = 0;
MODELreadMeterRecord.extraTotalCharge = 0;
MODELreadMeterRecord.totalCharge = 0;
MODELreadMeterRecord.WATERFIXVALUE = 0;
MODELreadMeterRecord.readMeterRecordYear = Convert.ToInt16(strRecordYear);
MODELreadMeterRecord.readMeterRecordMonth = Convert.ToInt16(strRecordMonth);
string strYearAndMonth = strRecordYear + "-" + strRecordMonth + "-01";
if (Information.IsDate(strYearAndMonth))
{
MODELreadMeterRecord.readMeterRecordYearAndMonth = Convert.ToDateTime(strYearAndMonth);
}
else
{
MODELreadMeterRecord.readMeterRecordYearAndMonth = dtNow;
}
//变更记录将抄表时间置为空
//MODELreadMeterRecord.readMeterRecordDate =null;
MODELreadMeterRecord.chargeState = "1";
MODELreadMeterRecord.checkState = "1";
MODELreadMeterRecord.checkDateTime = dtNow;
MODELreadMeterRecord.WATERMETERNUMBERCHANGESTATE = "1";
MODELreadMeterRecord.MEMO = txtMemo.Text; //将特殊的用户（按面积均摊或者按月份确定开票名称）存储到memo字段里。备用
MODELreadMeterRecord.readMeterRecordId = GETTABLEID.GetTableID(strLogID, "READMETERRECORD");
if (BLLreadMeterRecord.Insert(MODELreadMeterRecord))
{
try
{
if (BLLreadMeterRecord.UpdateCheckStateChangeNumber(MODELreadMeterRecord))
{
mes.Show("表底数变更成功!");
btChange.Enabled = false;
MODELOPERATORLOG MODELOPERATORLOG = new MODELOPERATORLOG();
MODELOPERATORLOG.LOGCONTENT = "表底变更:" + MODELreadMeterRecord.waterUserNO + "-" + MODELreadMeterRecord.waterUserName + "-" + MODELreadMeterRecord.waterMeterNo + "," + MODELreadMeterRecord.waterMeterLastNumber + "→" + MODELreadMeterRecord.waterMeterEndNumber;
MODELOPERATORLOG.METERREADINGID = strMeterReadingID;
MODELOPERATORLOG.LOGTYPE = "2"; //1代表用户 2代表水表
MODELOPERATORLOG.OPERATORID = strLogID;
MODELOPERATORLOG.OPERATORNAME = strUserName;
BLLOPERATORLOG.Insert(MODELOPERATORLOG);
}
else
{
//回滚抄表数据
BLLreadMeterRecord.Delete(MODELreadMeterRecord.readMeterRecordId);
}
}
catch (Exception)
{
//回滚抄表数据
BLLreadMeterRecord.Delete(MODELreadMeterRecord.readMeterRecordId);
mes.Show("表底数变更过程更新审核状态失败,请重试!");
return;
}
}
else
{
mes.Show("表底数变更失败,请重试!");
return;
}
}
catch (Exception ex)
{
mes.Show("表底数变更失败,原因:" + ex.ToString());
log.Write(ex.ToString(), MsgType.Error);
return;
}
}
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);
}
}
