private void Btn_Submit_Click(object sender, EventArgs e)
{
if (PIANID.SelectedValue == null || PIANID.SelectedValue == DBNull.Value)
{
mes.Show("请选择片号");
PIANID.Focus();
return;
}
if (areaId.SelectedValue == null || areaId.SelectedValue == DBNull.Value)
{
mes.Show("请选择区号");
areaId.Focus();
return;
}
if (DUANID.SelectedValue == null || DUANID.SelectedValue == DBNull.Value)
{
mes.Show("请选择段号");
DUANID.Focus();
return;
}
if (COMMUNITYID.SelectedValue == null || COMMUNITYID.SelectedValue == DBNull.Value)
{
mes.Show("请选择小区名称");
COMMUNITYID.Focus();
return;
}
if (meterReaderID.SelectedValue == null || meterReaderID.SelectedValue == DBNull.Value)
{
mes.Show("请选择抄表员");
meterReaderID.Focus();
return;
}
if (chargerID.SelectedValue == null || COMMUNITYID.SelectedValue == DBNull.Value)
{
mes.Show("请选择收费员");
chargerID.Focus();
return;
}
if (CreateType.SelectedValue == null || CreateType.SelectedValue == DBNull.Value)
{
mes.Show("请选择建档类型");
CreateType.Focus();
return;
}
if (!Information.IsNumeric(ordernumber.Text))
{
mes.Show("请输入正确的顺序号");
ordernumber.Focus();
return;
}
if (!Information.IsNumeric(waterMeterStartNumber.Text))
{
mes.Show("请输入正确的初始读数");
waterMeterStartNumber.Focus();
return;
}
if (!Information.IsNumeric(WATERFIXVALUE.Text))
{
mes.Show("请输入正确的定量用水量");
WATERFIXVALUE.Focus();
return;
}
if (waterMeterPositionName.SelectedValue == null || waterMeterPositionName.SelectedValue == DBNull.Value)
{
mes.Show("请选择水表位置!");
waterMeterPositionName.Focus();
return;
}
if (waterMeterTypeId.SelectedValue == null || waterMeterTypeId.SelectedValue == DBNull.Value)
{
mes.Show("请选择用水性质!");
waterMeterTypeId.Focus();
return;
}
if (waterMeterState.SelectedValue == null || waterMeterState.SelectedValue == DBNull.Value)
{
mes.Show("请选择水表状态!");
waterMeterState.Focus();
return;
}
if (waterMeterSizeId.SelectedValue == null || waterMeterSizeId.SelectedValue == DBNull.Value)
{
mes.Show("请选择水表口径!");
waterMeterSizeId.Focus();
return;
}
ip = AppDomain.CurrentDomain.GetData("IP").ToString();
ComputerName = AppDomain.CurrentDomain.GetData("COMPUTERNAME").ToString();
Hashtable hs = new Hashtable();
hs["ModifyUser"] = AppDomain.CurrentDomain.GetData("USERNAME").ToString();
hs["ModifyDate"] = DateTime.Now.ToString();
hs["operatorID"] = AppDomain.CurrentDomain.GetData("LOGINID").ToString();;
hs["operatorName"] = AppDomain.CurrentDomain.GetData("USERNAME").ToString();
hs["pianNO"] = PIANID.Text;
hs["areaNO"] = areaId.Text;
hs["duanNO"] = DUANID.Text;
hs["CommunityID"] = COMMUNITYID.SelectedValue;
hs["COMMUNITYNAME"] = COMMUNITYID.Text;
hs["BuildingNO"] = BuildingNO.Text;
hs["UnitNO"] = UnitNO.Text;
hs["meterReaderID"] = meterReaderID.SelectedValue;
hs["meterReaderName"] = meterReaderID.Text;
hs["chargerID"] = chargerID.SelectedValue;
hs["chargerName"] = chargerID.Text;
hs["agentsign"] = (agentsign.SelectedValue == null || agentsign.SelectedValue == DBNull.Value) ? 0 : agentsign.SelectedValue;
hs["bankId"] = bankId.SelectedValue;
hs["BankAcountNumber"] = BankAcountNumber.Text;
hs["chargeType"] = (chargeType.SelectedValue == null || chargeType.SelectedValue == DBNull.Value) ? 0 : chargeType.SelectedValue;
hs["CreateType"] = CreateType.SelectedValue;
hs["CreateUserDate"] = mes.GetDatetimeNow();
hs["ordernumber"] = ordernumber.Text;
hs["Memo"] = Memo.Text;
if (string.IsNullOrEmpty(_waterUserId))
{
_waterUserId = GETTABLEID.GetTableID("", "WATERUSER");
}
hs["waterUserId"] = _waterUserId;
hs["waterUserNO"] = _waterUserId;
if (new SqlServerHelper().Submit_AddOrEdit("Meter_Install_Peccant", "TaskID", TaskID, hs))
{
//取该用户下最大的水表顺序号
DataTable dd = new SqlServerHelper().GetDateTableBySql(string.Format("SELECT RIGHT(MAX(waterMeterNo),2) FROM waterMeter WHERE waterUserId='{0}'", _waterUserId));
int MeterCount = string.IsNullOrEmpty(dd.Rows[0][0].ToString()) ? 0 : int.Parse(dd.Rows[0][0].ToString());
// MeterCount++;
string NewMeterID = _waterUserId + (MeterCount + 1).ToString().PadLeft(2, '0');
Hashtable hnb = new Hashtable();
hnb["waterMeterId"] = NewMeterID;
hnb["waterMeterNo"] = NewMeterID;
hnb["waterUserId"] = _waterUserId;
hnb["waterMeterPositionName"] = waterMeterPositionName.Text;
hnb["waterMeterPositionId"] = waterMeterPositionName.SelectedValue;
hnb["waterMeterSizeId"] = waterMeterSizeId.SelectedValue;
hnb["waterMeterStartNumber"] = waterMeterStartNumber.Text;
hnb["waterMeterTypeId"] = waterMeterTypeId.SelectedValue;
hnb["waterMeterParentId"] = waterMeterParentId.SelectedValue;
hnb["waterMeterState"] = waterMeterState.SelectedValue;
hnb["IsReverse"] = IsReverse.Checked ? '1' : '0';
hnb["WATERFIXVALUE"] = WATERFIXVALUE.Text;
hnb["waterMeterMode"] = waterMeterMode.Text;
hnb["WATERMETERLOCKNO"] = WATERMETERLOCKNO.Text;
new SqlServerHelper().Submit_AddOrEdit("Meter", "MeterID", strWaterMeterID, hnb);
#region
//if (_MeterList.Count > 0)
//{
// for (int i = 0; i < _MeterList.Count; i++)
// {
// string NewMeterID = _waterUserId + (MeterCount + i).ToString().PadLeft(2, '0');
// Hashtable hnb = new Hashtable();
// hnb["waterMeterId"] = NewMeterID;
// hnb["waterMeterNo"] = NewMeterID;
// hnb["waterUserId"] = _waterUserId;
// hnb["waterMeterTypeId"] = waterMeterTypeId.SelectedValue;
// new SqlServerHelper().Submit_AddOrEdit("Meter", "MeterID", _MeterList[i], hnb);
// }
//}
string CHARGEID = GETTABLEID.GetTableID("0092", "WATERFEECHARGE");
string PRESTORERUNNINGACCOUNTID = GETTABLEID.GetTableID("0092", "PRESTORERUNNINGACCOUNT");
#endregion
if (sysidal.Approve_Peccant_Append(TaskID))
{
string Matter = string.Format("【增户】-片：{0}；区：{1}；段：{2}；用水性质：{3}", PIANID.Text, areaId.Text, DUANID.Text, waterMeterTypeId.Text);
int count = sysidal.UpdateApprove_Peccant_defalut(ResolveID, true, "新增用户（水表）", ip, ComputerName, PointSort, TaskID, Matter);
if (count > 0)
{
Btn_Submit.Enabled = false;
MessageBox.Show("增户成功！");
}
else
{
Btn_Submit.Enabled = true;
}
}
}
}
