/// <summary>
/// update
/// </summary>
/// <param name="IOT0000000001"></param>
/// <returns></returns>
public void Update(IOT0000000001 model, SqlConnection connection = null, SqlTransaction transaction = null)
{
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelper.Instance.ExcuteNon(str, dict, connection, transaction);
}
/// <summary>
/// add
/// </summary>
/// <param name="IOT0000000001"></param>
/// <returns></returns>
public int Add(IOT0000000001 model, SqlConnection connection = null, SqlTransaction transaction = null)
{
var str = GetInsertStr(model) + " select @@identity";
var dict = GetParameters(model);
return(Convert.ToInt32(SqlHelper.Instance.ExecuteScalar(str, dict, connection, transaction)));
}
/// <summary>
/// 获取参数
/// </summary>
/// <param name="iot0000000001"></param>
/// <returns></returns>
public Dictionary <string, string> GetParameters(IOT0000000001 iot0000000001)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
if (iot0000000001.Id != null)
{
dict.Add("@Id", iot0000000001.Id.ToString());
}
if (iot0000000001.communicateNo != null)
{
dict.Add("@communicateNo", iot0000000001.communicateNo.ToString());
}
if (iot0000000001.FLMeterNo != null)
{
dict.Add("@FLMeterNo", iot0000000001.FLMeterNo.ToString());
}
if (iot0000000001.siteNo != null)
{
dict.Add("@siteNo", iot0000000001.siteNo.ToString());
}
if (iot0000000001.InstantTime != null)
{
dict.Add("@InstantTime", iot0000000001.InstantTime.ToString());
}
if (iot0000000001.ReceivTime != null)
{
dict.Add("@ReceivTime", iot0000000001.ReceivTime.ToString());
}
if (iot0000000001.StdSum != null)
{
dict.Add("@StdSum", iot0000000001.StdSum.ToString());
}
if (iot0000000001.WorkSum != null)
{
dict.Add("@WorkSum", iot0000000001.WorkSum.ToString());
}
if (iot0000000001.StdFlow != null)
{
dict.Add("@StdFlow", iot0000000001.StdFlow.ToString());
}
if (iot0000000001.WorkFlow != null)
{
dict.Add("@WorkFlow", iot0000000001.WorkFlow.ToString());
}
if (iot0000000001.Temperature != null)
{
dict.Add("@Temperature", iot0000000001.Temperature.ToString());
}
if (iot0000000001.Pressure != null)
{
dict.Add("@Pressure", iot0000000001.Pressure.ToString());
}
if (iot0000000001.FMState != null)
{
dict.Add("@FMState", iot0000000001.FMState.ToString());
}
if (iot0000000001.FMStateMsg != null)
{
dict.Add("@FMStateMsg", iot0000000001.FMStateMsg.ToString());
}
if (iot0000000001.RTUState != null)
{
dict.Add("@RTUState", iot0000000001.RTUState.ToString());
}
if (iot0000000001.RTUStateMsg != null)
{
dict.Add("@RTUStateMsg", iot0000000001.RTUStateMsg.ToString());
}
if (iot0000000001.SumTotal != null)
{
dict.Add("@SumTotal", iot0000000001.SumTotal.ToString());
}
if (iot0000000001.RemainMoney != null)
{
dict.Add("@RemainMoney", iot0000000001.RemainMoney.ToString());
}
if (iot0000000001.RemainVolume != null)
{
dict.Add("@RemainVolume", iot0000000001.RemainVolume.ToString());
}
if (iot0000000001.Overdraft != null)
{
dict.Add("@Overdraft", iot0000000001.Overdraft.ToString());
}
if (iot0000000001.RemoteChargeMoney != null)
{
dict.Add("@RemoteChargeMoney", iot0000000001.RemoteChargeMoney.ToString());
}
if (iot0000000001.RemoteChargeTimes != null)
{
dict.Add("@RemoteChargeTimes", iot0000000001.RemoteChargeTimes.ToString());
}
if (iot0000000001.Price != null)
{
dict.Add("@Price", iot0000000001.Price.ToString());
}
if (iot0000000001.ValveState != null)
{
dict.Add("@ValveState", iot0000000001.ValveState.ToString());
}
if (iot0000000001.ValveStateMsg != null)
{
dict.Add("@ValveStateMsg", iot0000000001.ValveStateMsg.ToString());
}
if (iot0000000001.PowerVoltage != null)
{
dict.Add("@PowerVoltage", iot0000000001.PowerVoltage.ToString());
}
if (iot0000000001.BatteryVoltage != null)
{
dict.Add("@BatteryVoltage", iot0000000001.BatteryVoltage.ToString());
}
if (iot0000000001.Reserve1 != null)
{
dict.Add("@Reserve1", iot0000000001.Reserve1.ToString());
}
if (iot0000000001.Reserve2 != null)
{
dict.Add("@Reserve2", iot0000000001.Reserve2.ToString());
}
if (iot0000000001.Reserve3 != null)
{
dict.Add("@Reserve3", iot0000000001.Reserve3.ToString());
}
if (iot0000000001.Reserve4 != null)
{
dict.Add("@Reserve4", iot0000000001.Reserve4.ToString());
}
return(dict);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="iot0000000001"></param>
/// <returns>是否成功</returns>
public string GetUpdateStr(IOT0000000001 iot0000000001)
{
StringBuilder part1 = new StringBuilder();
part1.Append("update iot0000000001 set ");
if (iot0000000001.communicateNo != null)
{
part1.Append("communicateNo = @communicateNo,");
}
if (iot0000000001.FLMeterNo != null)
{
part1.Append("FLMeterNo = @FLMeterNo,");
}
if (iot0000000001.siteNo != null)
{
part1.Append("siteNo = @siteNo,");
}
if (iot0000000001.InstantTime != null)
{
part1.Append("InstantTime = @InstantTime,");
}
if (iot0000000001.ReceivTime != null)
{
part1.Append("ReceivTime = @ReceivTime,");
}
if (iot0000000001.StdSum != null)
{
part1.Append("StdSum = @StdSum,");
}
if (iot0000000001.WorkSum != null)
{
part1.Append("WorkSum = @WorkSum,");
}
if (iot0000000001.StdFlow != null)
{
part1.Append("StdFlow = @StdFlow,");
}
if (iot0000000001.WorkFlow != null)
{
part1.Append("WorkFlow = @WorkFlow,");
}
if (iot0000000001.Temperature != null)
{
part1.Append("Temperature = @Temperature,");
}
if (iot0000000001.Pressure != null)
{
part1.Append("Pressure = @Pressure,");
}
if (iot0000000001.FMState != null)
{
part1.Append("FMState = @FMState,");
}
if (iot0000000001.FMStateMsg != null)
{
part1.Append("FMStateMsg = @FMStateMsg,");
}
if (iot0000000001.RTUState != null)
{
part1.Append("RTUState = @RTUState,");
}
if (iot0000000001.RTUStateMsg != null)
{
part1.Append("RTUStateMsg = @RTUStateMsg,");
}
if (iot0000000001.SumTotal != null)
{
part1.Append("SumTotal = @SumTotal,");
}
if (iot0000000001.RemainMoney != null)
{
part1.Append("RemainMoney = @RemainMoney,");
}
if (iot0000000001.RemainVolume != null)
{
part1.Append("RemainVolume = @RemainVolume,");
}
if (iot0000000001.Overdraft != null)
{
part1.Append("Overdraft = @Overdraft,");
}
if (iot0000000001.RemoteChargeMoney != null)
{
part1.Append("RemoteChargeMoney = @RemoteChargeMoney,");
}
if (iot0000000001.RemoteChargeTimes != null)
{
part1.Append("RemoteChargeTimes = @RemoteChargeTimes,");
}
if (iot0000000001.Price != null)
{
part1.Append("Price = @Price,");
}
if (iot0000000001.ValveState != null)
{
part1.Append("ValveState = @ValveState,");
}
if (iot0000000001.ValveStateMsg != null)
{
part1.Append("ValveStateMsg = @ValveStateMsg,");
}
if (iot0000000001.PowerVoltage != null)
{
part1.Append("PowerVoltage = @PowerVoltage,");
}
if (iot0000000001.BatteryVoltage != null)
{
part1.Append("BatteryVoltage = @BatteryVoltage,");
}
if (iot0000000001.Reserve1 != null)
{
part1.Append("Reserve1 = @Reserve1,");
}
if (iot0000000001.Reserve2 != null)
{
part1.Append("Reserve2 = @Reserve2,");
}
if (iot0000000001.Reserve3 != null)
{
part1.Append("Reserve3 = @Reserve3,");
}
if (iot0000000001.Reserve4 != null)
{
part1.Append("Reserve4 = @Reserve4,");
}
int n = part1.ToString().LastIndexOf(",");
part1.Remove(n, 1);
part1.Append(" where Id= @Id ");
return(part1.ToString());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="iot0000000001"></param>
/// <returns>是否成功</returns>
public string GetInsertStr(IOT0000000001 iot0000000001)
{
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
if (iot0000000001.communicateNo != null)
{
part1.Append("communicateNo,");
part2.Append("@communicateNo,");
}
if (iot0000000001.FLMeterNo != null)
{
part1.Append("FLMeterNo,");
part2.Append("@FLMeterNo,");
}
if (iot0000000001.siteNo != null)
{
part1.Append("siteNo,");
part2.Append("@siteNo,");
}
if (iot0000000001.InstantTime != null)
{
part1.Append("InstantTime,");
part2.Append("@InstantTime,");
}
if (iot0000000001.ReceivTime != null)
{
part1.Append("ReceivTime,");
part2.Append("@ReceivTime,");
}
if (iot0000000001.StdSum != null)
{
part1.Append("StdSum,");
part2.Append("@StdSum,");
}
if (iot0000000001.WorkSum != null)
{
part1.Append("WorkSum,");
part2.Append("@WorkSum,");
}
if (iot0000000001.StdFlow != null)
{
part1.Append("StdFlow,");
part2.Append("@StdFlow,");
}
if (iot0000000001.WorkFlow != null)
{
part1.Append("WorkFlow,");
part2.Append("@WorkFlow,");
}
if (iot0000000001.Temperature != null)
{
part1.Append("Temperature,");
part2.Append("@Temperature,");
}
if (iot0000000001.Pressure != null)
{
part1.Append("Pressure,");
part2.Append("@Pressure,");
}
if (iot0000000001.FMState != null)
{
part1.Append("FMState,");
part2.Append("@FMState,");
}
if (iot0000000001.FMStateMsg != null)
{
part1.Append("FMStateMsg,");
part2.Append("@FMStateMsg,");
}
if (iot0000000001.RTUState != null)
{
part1.Append("RTUState,");
part2.Append("@RTUState,");
}
if (iot0000000001.RTUStateMsg != null)
{
part1.Append("RTUStateMsg,");
part2.Append("@RTUStateMsg,");
}
if (iot0000000001.SumTotal != null)
{
part1.Append("SumTotal,");
part2.Append("@SumTotal,");
}
if (iot0000000001.RemainMoney != null)
{
part1.Append("RemainMoney,");
part2.Append("@RemainMoney,");
}
if (iot0000000001.RemainVolume != null)
{
part1.Append("RemainVolume,");
part2.Append("@RemainVolume,");
}
if (iot0000000001.Overdraft != null)
{
part1.Append("Overdraft,");
part2.Append("@Overdraft,");
}
if (iot0000000001.RemoteChargeMoney != null)
{
part1.Append("RemoteChargeMoney,");
part2.Append("@RemoteChargeMoney,");
}
if (iot0000000001.RemoteChargeTimes != null)
{
part1.Append("RemoteChargeTimes,");
part2.Append("@RemoteChargeTimes,");
}
if (iot0000000001.Price != null)
{
part1.Append("Price,");
part2.Append("@Price,");
}
if (iot0000000001.ValveState != null)
{
part1.Append("ValveState,");
part2.Append("@ValveState,");
}
if (iot0000000001.ValveStateMsg != null)
{
part1.Append("ValveStateMsg,");
part2.Append("@ValveStateMsg,");
}
if (iot0000000001.PowerVoltage != null)
{
part1.Append("PowerVoltage,");
part2.Append("@PowerVoltage,");
}
if (iot0000000001.BatteryVoltage != null)
{
part1.Append("BatteryVoltage,");
part2.Append("@BatteryVoltage,");
}
if (iot0000000001.Reserve1 != null)
{
part1.Append("Reserve1,");
part2.Append("@Reserve1,");
}
if (iot0000000001.Reserve2 != null)
{
part1.Append("Reserve2,");
part2.Append("@Reserve2,");
}
if (iot0000000001.Reserve3 != null)
{
part1.Append("Reserve3,");
part2.Append("@Reserve3,");
}
if (iot0000000001.Reserve4 != null)
{
part1.Append("Reserve4,");
part2.Append("@Reserve4,");
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into iot0000000001(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")");
return(sql.ToString());
}
