/// <summary>
/// 变更用水性质
/// </summary>
/// <param name="MODELwaterMeter"></param>
/// <returns></returns>
public bool UpdateWaterMeterType(MODELwaterMeter MODELwaterMeter)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE waterMeter SET waterMeterTypeId=@waterMeterTypeId");
str.Append(" WHERE waterMeterId=@waterMeterId");
SqlParameter[] para =
{
new SqlParameter("@waterMeterTypeId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterId", SqlDbType.VarChar, 30)
};
para[0].Value = MODELwaterMeter.waterMeterTypeId;
para[1].Value = MODELwaterMeter.waterMeterId;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
public bool Insert(MODELwaterMeter MODELwaterMeter)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO waterMeter(waterMeterId,waterMeterNo,waterMeterStartNumber,waterMeterPositionName,waterMeterState," +
"waterMeterSizeId,waterMeterTypeId,WATERFIXVALUE,waterMeterProduct,waterMeterSerialNumber,waterMeterMode," +
"waterMeterMagnification,waterMeterMaxRange,waterMeterProofreadingDate,waterMeteProofreadingPeriod,waterUserId," +
"waterMeterParentId,memo,STARTUSEDATETIME,isSummaryMeter,ISUSECHANGE,CHANGEMONTH,waterMeterTypeIdChange,IsReverse,WATERMETERLOCKNO,SummaryMeterClass,ChannelNO) ");
str.Append("VALUES(@waterMeterId,@waterMeterNo,@waterMeterStartNumber,@waterMeterPositionName,@waterMeterState," +
"@waterMeterSizeId,@waterMeterTypeId,@WATERFIXVALUE,@waterMeterProduct,@waterMeterSerialNumber,@waterMeterMode," +
"@waterMeterMagnification,@waterMeterMaxRange,@waterMeterProofreadingDate," +
"@waterMeteProofreadingPeriod,@waterUserId,@waterMeterParentId,@memo,@STARTUSEDATETIME,@isSummaryMeter," +
"@ISUSECHANGE,@CHANGEMONTH,@waterMeterTypeIdChange,@IsReverse,@WATERMETERLOCKNO,@SummaryMeterClass,@ChannelNO)");
SqlParameter[] para =
{
new SqlParameter("@waterMeterId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterNo", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterStartNumber", SqlDbType.Int),
new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterState", SqlDbType.VarChar, 10),
new SqlParameter("@waterMeterSizeId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterTypeId", SqlDbType.VarChar, 30),
new SqlParameter("@WATERFIXVALUE", SqlDbType.Int),
new SqlParameter("@waterMeterProduct", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterSerialNumber", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterMode", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterMagnification", SqlDbType.Int),
new SqlParameter("@waterMeterMaxRange", SqlDbType.Int),
new SqlParameter("@waterMeterProofreadingDate", SqlDbType.DateTime),
new SqlParameter("@waterMeteProofreadingPeriod", SqlDbType.Int),
new SqlParameter("@waterUserId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterParentId", SqlDbType.VarChar, 30),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200),//04216816395
new SqlParameter("@STARTUSEDATETIME", SqlDbType.DateTime),
new SqlParameter("@isSummaryMeter", SqlDbType.VarChar, 10),
new SqlParameter("@ISUSECHANGE", SqlDbType.VarChar, 10),
new SqlParameter("@CHANGEMONTH", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterTypeIdChange", SqlDbType.VarChar, 30),
new SqlParameter("@IsReverse", SqlDbType.VarChar, 30),
new SqlParameter("@WATERMETERLOCKNO", SqlDbType.VarChar, 50),
new SqlParameter("@SummaryMeterClass", SqlDbType.VarChar, 10),
new SqlParameter("@ChannelNO", SqlDbType.VarChar, 30)
};
para[0].Value = MODELwaterMeter.waterMeterId;
para[1].Value = MODELwaterMeter.waterMeterNo;
para[2].Value = MODELwaterMeter.waterMeterStartNumber;
para[3].Value = MODELwaterMeter.waterMeterPositionName;
para[4].Value = MODELwaterMeter.waterMeterState;
para[5].Value = MODELwaterMeter.waterMeterSizeId;
para[6].Value = MODELwaterMeter.waterMeterTypeId;
para[7].Value = MODELwaterMeter.WATERFIXVALUE;
para[8].Value = MODELwaterMeter.waterMeterProduct;
para[9].Value = MODELwaterMeter.waterMeterSerialNumber;
para[10].Value = MODELwaterMeter.waterMeterMode;
para[11].Value = MODELwaterMeter.waterMeterMagnification;
para[12].Value = MODELwaterMeter.waterMeterMaxRange;
para[13].Value = MODELwaterMeter.waterMeterProofreadingDate;
para[14].Value = MODELwaterMeter.waterMeteProofreadingPeriod;
para[15].Value = MODELwaterMeter.waterUserId;
para[16].Value = MODELwaterMeter.waterMeterParentId;
para[17].Value = MODELwaterMeter.MEMO;
if (MODELwaterMeter.waterMeterState == "1")
{
para[18].Value = MODELwaterMeter.STARTUSEDATETIME;
}
else
{
para[18].Value = null;
}
para[19].Value = MODELwaterMeter.isSummaryMeter;
para[20].Value = MODELwaterMeter.ISUSECHANGE;
//如果启用了自动变更新水价，则插入变更的月份和用水性质，如果没启用则不插入
if (MODELwaterMeter.ISUSECHANGE == "1")
{
para[21].Value = MODELwaterMeter.CHANGEMONTH;
para[22].Value = MODELwaterMeter.waterMeterTypeIdChange;
}
else
{
para[21].Value = null;
para[22].Value = null;
}
para[23].Value = MODELwaterMeter.IsReverse;
para[24].Value = MODELwaterMeter.WATERMETERLOCKNO;
para[25].Value = MODELwaterMeter.SummaryMeterClass;
para[26].Value = MODELwaterMeter.ChannelNO;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(MODELwaterMeter MODELwaterMeter)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE waterMeter SET waterMeterNo=@waterMeterNo,waterMeterStartNumber=@waterMeterStartNumber,waterMeterPositionName=@waterMeterPositionName," +
"waterMeterState=@waterMeterState,waterMeterSizeId=@waterMeterSizeId,waterMeterTypeId=@waterMeterTypeId,WATERFIXVALUE=@WATERFIXVALUE," +
"waterMeterProduct=@waterMeterProduct,waterMeterSerialNumber=@waterMeterSerialNumber,waterMeterMode=@waterMeterMode," +
"waterMeterMagnification=@waterMeterMagnification,waterMeterMaxRange=@waterMeterMaxRange,waterMeterProofreadingDate=@waterMeterProofreadingDate," +
"waterMeteProofreadingPeriod=@waterMeteProofreadingPeriod,waterUserId=@waterUserId,waterMeterParentId=@waterMeterParentId,MEMO=@MEMO,isSummaryMeter=@isSummaryMeter," +
"ISUSECHANGE=@ISUSECHANGE,CHANGEMONTH=@CHANGEMONTH,waterMeterTypeIdChange=@waterMeterTypeIdChange,IsReverse=@IsReverse,WATERMETERLOCKNO=@WATERMETERLOCKNO," +
"ChannelNO=@ChannelNO,SummaryMeterClass=@SummaryMeterClass ");
str.Append("WHERE waterMeterId=@waterMeterId");
SqlParameter[] para =
{
new SqlParameter("@waterMeterNo", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterStartNumber", SqlDbType.Int),
new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterState", SqlDbType.VarChar, 10),
new SqlParameter("@waterMeterSizeId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterTypeId", SqlDbType.VarChar, 30),
new SqlParameter("@WATERFIXVALUE", SqlDbType.Int),
new SqlParameter("@waterMeterProduct", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterSerialNumber", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterMode", SqlDbType.VarChar, 50),
new SqlParameter("@waterMeterMagnification", SqlDbType.Int),
new SqlParameter("@waterMeterMaxRange", SqlDbType.Int),
new SqlParameter("@waterMeterProofreadingDate", SqlDbType.DateTime),
new SqlParameter("@waterMeteProofreadingPeriod", SqlDbType.Int),
new SqlParameter("@waterUserId", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterParentId", SqlDbType.VarChar, 30),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200),
new SqlParameter("@isSummaryMeter", SqlDbType.VarChar, 10),
new SqlParameter("@ISUSECHANGE", SqlDbType.VarChar, 10),
new SqlParameter("@CHANGEMONTH", SqlDbType.VarChar, 30),
new SqlParameter("@waterMeterTypeIdChange", SqlDbType.VarChar, 30),
new SqlParameter("@IsReverse", SqlDbType.VarChar, 30),
new SqlParameter("@WATERMETERLOCKNO", SqlDbType.VarChar, 50),
new SqlParameter("@ChannelNO", SqlDbType.VarChar, 30),
new SqlParameter("@SummaryMeterClass", SqlDbType.VarChar, 10),
new SqlParameter("@waterMeterId", SqlDbType.VarChar, 30)
};
para[0].Value = MODELwaterMeter.waterMeterNo;
para[1].Value = MODELwaterMeter.waterMeterStartNumber;
para[2].Value = MODELwaterMeter.waterMeterPositionName;
para[3].Value = MODELwaterMeter.waterMeterState;
para[4].Value = MODELwaterMeter.waterMeterSizeId;
para[5].Value = MODELwaterMeter.waterMeterTypeId;
para[6].Value = MODELwaterMeter.WATERFIXVALUE;
para[7].Value = MODELwaterMeter.waterMeterProduct;
para[8].Value = MODELwaterMeter.waterMeterSerialNumber;
para[9].Value = MODELwaterMeter.waterMeterMode;
para[10].Value = MODELwaterMeter.waterMeterMagnification;
para[11].Value = MODELwaterMeter.waterMeterMaxRange;
para[12].Value = MODELwaterMeter.waterMeterProofreadingDate;
para[13].Value = MODELwaterMeter.waterMeteProofreadingPeriod;
para[14].Value = MODELwaterMeter.waterUserId;
para[15].Value = MODELwaterMeter.waterMeterParentId;
para[16].Value = MODELwaterMeter.MEMO;
para[17].Value = MODELwaterMeter.isSummaryMeter;
para[18].Value = MODELwaterMeter.ISUSECHANGE;
//如果启用了自动变更新水价，则更新变更的月份和用水性质，如果没启用则不更新
if (MODELwaterMeter.ISUSECHANGE == "1")
{
para[19].Value = MODELwaterMeter.CHANGEMONTH;
para[20].Value = MODELwaterMeter.waterMeterTypeIdChange;
}
else
{
para[19].Value = null;
para[20].Value = null;
}
para[21].Value = MODELwaterMeter.IsReverse;
para[22].Value = MODELwaterMeter.WATERMETERLOCKNO;
para[23].Value = MODELwaterMeter.ChannelNO;
para[24].Value = MODELwaterMeter.SummaryMeterClass;
para[25].Value = MODELwaterMeter.waterMeterId;
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;
}
