private void Btn_Submit_Click(object sender, EventArgs e)
{
Btn_Submit.Enabled = false;
Hashtable hs = new SqlServerHelper().GetHashTableByControl(this.PL.Controls);
new SqlServerHelper().Submit_AddOrEdit("Meter_Install_Single", "TaskID", TaskID, hs);
foreach (Control c in this.FP.Controls)
{
if (c is UC_MeterInfo)
{
UC_MeterInfo UM = (UC_MeterInfo)c;
Hashtable hu = new SqlServerHelper().GetHashTableByControl(UM.Controls);
new SqlServerHelper().Submit_AddOrEdit("Meter", "MeterID", UM.MeterID, hu);
}
}
string Matter = string.Format("【用户信息审核】-用户名：{0}；地址：{1}；联系方式：{2}", waterUserName.Text, waterUserAddress.Text, waterPhone.Text);
int count = sysidal.UpdateApprove_Single_defalut(ResolveID, true, "用户信息审核完成", ip, ComputerName, PointSort, TaskID, Matter);
if (count > 0)
{
MessageBox.Show("审批成功！");
}
else
{
Btn_Submit.Enabled = true;
}
}
private void BindUserMeter()
{
// string sqlstr = string.Format("SELECT M.MeterID FROM METER M LEFT JOIN METER_USER MU ON M.MeterID=MU.MeterID WHERE MU.TaskID='{0}' ", TaskID);
// DataTable dt = new SqlServerHelper().GetDateTableBySql(sqlstr);
DataTable dt = sysidal.GetUserMaterByTaskID(TaskID);
if (DataTableHelper.IsExistRows(dt))
{
this.FP.Controls.Clear();
foreach (DataRow dr in dt.Rows)
{
UC_MeterInfo UM = new UC_MeterInfo();
UM.MeterID = dr[0].ToString();
UM.InitData();
this.FP.Controls.Add(UM);
}
}
}
