private bool CheckForm()
{
if (string.IsNullOrEmpty(WATERUSERNO.Text.Trim()))
{
mes.Show("获取用户号失败！");
return(false);
}
if (!Information.IsNumeric(NewTotalNumber.Text.Trim()))
{
mes.Show("请输入正确的减免后水量！");
NewTotalNumber.Focus();
return(false);
}
if (string.IsNullOrEmpty(AbateDescribe.Text.Trim()))
{
mes.Show("请输入减免原因！");
AbateDescribe.Focus();
return(false);
}
if (string.IsNullOrEmpty(readMeterRecordId.Text.Trim()))
{
mes.Show("获取台账ID失败,请重新查询");
return(false);
}
if (!Information.IsNumeric(TotalChargeEND.Text.Trim()))
{
mes.Show("获取欠费金额失败,请重新查询");
return(false);
}
if (!CkeckAbate())
{
mes.Show("减免后水量不能大于原用水量！");
NewTotalNumber.Text = "1";
NewTotalNumber.Focus();
return(false);
}
return(true);
}
private void Btn_Search_Click(object sender, EventArgs e)
{
new SqlServerHelper().ClearControls(this.groupBox2.Controls);
if (txtWaterUser.Text.Trim() == "")
{
mes.Show("请输入用户编号");
return;
}
if (!txtWaterUser.Text.Contains("U"))
{
txtWaterUser.Text = "U" + txtWaterUser.Text.Trim();
}
_WATERUSERNO = txtWaterUser.Text;
string strFilter = " WHERE waterUserId='" + _WATERUSERNO + "'";
if (chkYearAndMonth.Checked)
{
strFilter += " AND readMeterRecordYearAndMonth BETWEEN '" + dtpStart.Text + "' AND '" + dtpEnd.Text + "'";
}
strFilter += " ORDER BY readMeterRecordYearAndMonth DESC";
string sqlstr = "SELECT * FROM V_YSDETAIL_BYWATERMETER " + strFilter;
DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr);
if (DataTableHelper.IsExistRows(dt))
{
dgWaterFeeList.DataSource = dt;
Btn_Submit.Enabled = true;
NewTotalNumber.Focus();
}
else
{
dgWaterFeeList.DataSource = null;
mes.Show("该用户不存在欠费信息！");
}
}