/// <summary>
/// 设置集中器信息
/// </summary>
/// <param name="esp"></param>
/// <returns></returns>
public int SetMeter(MeterVModel meter)
{
StringBuilder strSql = new StringBuilder();
if (meter.Meter_id == 0)
{
strSql.Clear();
strSql.Append("select max(Meter_id)as cnt from v1_gateway_esp_meter where Ledger=@Ledger");
meter.Meter_id = CommFunc.ConvertDBNullToInt32(SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger })) + 1;
}
object params01 = new
{
Ledger = this.Ledger,
Meter_id = meter.Meter_id,
Esp_id = meter.Esp_id,
MeterName = meter.MeterName,
MeterAddr = meter.MeterAddr,
Inst_loc = meter.Inst_loc,
//Supplier = meter.Supplier,
//Switch = meter.Switch,
//ChrgType = meter.ChrgType,
Disabled = meter.Disabled,
Remark = meter.Remark,
Multiply = meter.Multiply,
EnergyItemCode = "01000",
Mm_id = meter.MeterTypeId,
Co_id = meter.RoomId,
SysUid = this.SysUid
};
strSql.Clear();
strSql.Append("insert into v1_gateway_esp_meter(");
strSql.Append("Ledger,Meter_id,Esp_id,MeterName,MeterAddr,Inst_loc,Disabled,Remark,Multiply,EnergyItemCode,Mm_id,Co_id,Create_by,Create_dt,Update_by,Update_dt,Attrib,ActiveTime)");
strSql.Append(" values (");
strSql.Append("@Ledger,@Meter_id,@Esp_id,@MeterName,@MeterAddr,@Inst_loc,@Disabled,@Remark,@Multiply,@EnergyItemCode,@Mm_id,@Co_id,@SysUid,now(),@SysUid,now(),0,now())");
strSql.Append("ON DUPLICATE KEY UPDATE ");
strSql.Append("Esp_id=@Esp_id,");
strSql.Append("MeterName=@MeterName,");
strSql.Append("MeterAddr=@MeterAddr,");
strSql.Append("Inst_loc=@Inst_loc,");
strSql.Append("Disabled=@Disabled,");
strSql.Append("Remark=@Remark,");
strSql.Append("Multiply=@Multiply,");
strSql.Append("Mm_id=@Mm_id,");
strSql.Append("Co_id=@Co_id,");
strSql.Append("Update_by=@SysUid,");
strSql.Append("Update_dt=now();");
//strSql.Append("insert into v1_gateway_esp_module_info (Ledger,Module_id,ChrgType,Update_by,Update_dt)values(@Ledger,@Module_id,@ChrgType,@SysUid,now())");
//strSql.Append("ON DUPLICATE KEY UPDATE ChrgType=@ChrgType,Update_by=@SysUid,Update_dt=now();");
return(SQLHelper.Execute(strSql.ToString(), params01));
}
/// <summary>
/// 设置设备信息
/// </summary>
/// <param name="meter">设备信息</param>
/// <returns></returns>
public APIResult SetMeter(MeterVModel meter)
{
APIResult rst = new APIResult();
try
{
int cnt = bll.SetMeter(meter);
rst.Code = 0;
rst.Msg = "";
rst.Data = this.GetMeterList(meter.Meter_id, "");
}
catch (Exception ex)
{
rst.Code = -1;
rst.Msg = ex.Message;
FileLog.WriteLog("设置设备信息错误(SetMeter):" + ex.Message + ex.StackTrace);
}
return(rst);
}
/// <summary>
/// 设置设备信息
/// </summary>
/// <param name="meter">设备信息</param>
/// <returns></returns>
public int SetMeter(MeterVModel meter)
{
return(dal.SetMeter(meter));
}
public APIResult SetMeter(MeterVModel meter)
{
return(baseInfoHelper.SetMeter(meter));
}
public APIResult AddMeter(MeterVModel meter)
{
meter.Meter_id = 0;
return(baseInfoHelper.SetMeter(meter));
}
