/// <summary> /// update /// </summary> /// <param name="IOT_FLMeterData"></param> /// <returns></returns> public void Update(IOT_FLMeterData 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="IOT_FLMeterData"></param> /// <returns></returns> public int Add(IOT_FLMeterData 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="iot_flmeterdata"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(IOT_FLMeterData iot_flmeterdata) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (iot_flmeterdata.Id != null) { dict.Add("@Id", iot_flmeterdata.Id.ToString()); } if (iot_flmeterdata.communicateNo != null) { dict.Add("@communicateNo", iot_flmeterdata.communicateNo.ToString()); } if (iot_flmeterdata.FLMeterNo != null) { dict.Add("@FLMeterNo", iot_flmeterdata.FLMeterNo.ToString()); } if (iot_flmeterdata.siteNo != null) { dict.Add("@siteNo", iot_flmeterdata.siteNo.ToString()); } if (iot_flmeterdata.InstantTime != null) { dict.Add("@InstantTime", iot_flmeterdata.InstantTime.ToString()); } if (iot_flmeterdata.ReceivTime != null) { dict.Add("@ReceivTime", iot_flmeterdata.ReceivTime.ToString()); } if (iot_flmeterdata.StdSum != null) { dict.Add("@StdSum", iot_flmeterdata.StdSum.ToString()); } if (iot_flmeterdata.WorkSum != null) { dict.Add("@WorkSum", iot_flmeterdata.WorkSum.ToString()); } if (iot_flmeterdata.StdFlow != null) { dict.Add("@StdFlow", iot_flmeterdata.StdFlow.ToString()); } if (iot_flmeterdata.WorkFlow != null) { dict.Add("@WorkFlow", iot_flmeterdata.WorkFlow.ToString()); } if (iot_flmeterdata.Temperature != null) { dict.Add("@Temperature", iot_flmeterdata.Temperature.ToString()); } if (iot_flmeterdata.Pressure != null) { dict.Add("@Pressure", iot_flmeterdata.Pressure.ToString()); } if (iot_flmeterdata.FMState != null) { dict.Add("@FMState", iot_flmeterdata.FMState.ToString()); } if (iot_flmeterdata.FMStateMsg != null) { dict.Add("@FMStateMsg", iot_flmeterdata.FMStateMsg.ToString()); } if (iot_flmeterdata.RTUState != null) { dict.Add("@RTUState", iot_flmeterdata.RTUState.ToString()); } if (iot_flmeterdata.RTUStateMsg != null) { dict.Add("@RTUStateMsg", iot_flmeterdata.RTUStateMsg.ToString()); } if (iot_flmeterdata.SumTotal != null) { dict.Add("@SumTotal", iot_flmeterdata.SumTotal.ToString()); } if (iot_flmeterdata.RemainMoney != null) { dict.Add("@RemainMoney", iot_flmeterdata.RemainMoney.ToString()); } if (iot_flmeterdata.RemainVolume != null) { dict.Add("@RemainVolume", iot_flmeterdata.RemainVolume.ToString()); } if (iot_flmeterdata.Overdraft != null) { dict.Add("@Overdraft", iot_flmeterdata.Overdraft.ToString()); } if (iot_flmeterdata.RemoteChargeMoney != null) { dict.Add("@RemoteChargeMoney", iot_flmeterdata.RemoteChargeMoney.ToString()); } if (iot_flmeterdata.RemoteChargeTimes != null) { dict.Add("@RemoteChargeTimes", iot_flmeterdata.RemoteChargeTimes.ToString()); } if (iot_flmeterdata.Price != null) { dict.Add("@Price", iot_flmeterdata.Price.ToString()); } if (iot_flmeterdata.ValveState != null) { dict.Add("@ValveState", iot_flmeterdata.ValveState.ToString()); } if (iot_flmeterdata.ValveStateMsg != null) { dict.Add("@ValveStateMsg", iot_flmeterdata.ValveStateMsg.ToString()); } if (iot_flmeterdata.PowerVoltage != null) { dict.Add("@PowerVoltage", iot_flmeterdata.PowerVoltage.ToString()); } if (iot_flmeterdata.BatteryVoltage != null) { dict.Add("@BatteryVoltage", iot_flmeterdata.BatteryVoltage.ToString()); } if (iot_flmeterdata.Reserve1 != null) { dict.Add("@Reserve1", iot_flmeterdata.Reserve1.ToString()); } if (iot_flmeterdata.Reserve2 != null) { dict.Add("@Reserve2", iot_flmeterdata.Reserve2.ToString()); } if (iot_flmeterdata.Reserve3 != null) { dict.Add("@Reserve3", iot_flmeterdata.Reserve3.ToString()); } if (iot_flmeterdata.Reserve4 != null) { dict.Add("@Reserve4", iot_flmeterdata.Reserve4.ToString()); } return(dict); }
/// <summary> /// 更新 /// </summary> /// <param name="iot_flmeterdata"></param> /// <returns>是否成功</returns> public string GetUpdateStr(IOT_FLMeterData iot_flmeterdata) { StringBuilder part1 = new StringBuilder(); part1.Append("update iot_flmeterdata set "); if (iot_flmeterdata.communicateNo != null) { part1.Append("communicateNo = @communicateNo,"); } if (iot_flmeterdata.FLMeterNo != null) { part1.Append("FLMeterNo = @FLMeterNo,"); } if (iot_flmeterdata.siteNo != null) { part1.Append("siteNo = @siteNo,"); } if (iot_flmeterdata.InstantTime != null) { part1.Append("InstantTime = @InstantTime,"); } if (iot_flmeterdata.ReceivTime != null) { part1.Append("ReceivTime = @ReceivTime,"); } if (iot_flmeterdata.StdSum != null) { part1.Append("StdSum = @StdSum,"); } if (iot_flmeterdata.WorkSum != null) { part1.Append("WorkSum = @WorkSum,"); } if (iot_flmeterdata.StdFlow != null) { part1.Append("StdFlow = @StdFlow,"); } if (iot_flmeterdata.WorkFlow != null) { part1.Append("WorkFlow = @WorkFlow,"); } if (iot_flmeterdata.Temperature != null) { part1.Append("Temperature = @Temperature,"); } if (iot_flmeterdata.Pressure != null) { part1.Append("Pressure = @Pressure,"); } if (iot_flmeterdata.FMState != null) { part1.Append("FMState = @FMState,"); } if (iot_flmeterdata.FMStateMsg != null) { part1.Append("FMStateMsg = @FMStateMsg,"); } if (iot_flmeterdata.RTUState != null) { part1.Append("RTUState = @RTUState,"); } if (iot_flmeterdata.RTUStateMsg != null) { part1.Append("RTUStateMsg = @RTUStateMsg,"); } if (iot_flmeterdata.SumTotal != null) { part1.Append("SumTotal = @SumTotal,"); } if (iot_flmeterdata.RemainMoney != null) { part1.Append("RemainMoney = @RemainMoney,"); } if (iot_flmeterdata.RemainVolume != null) { part1.Append("RemainVolume = @RemainVolume,"); } if (iot_flmeterdata.Overdraft != null) { part1.Append("Overdraft = @Overdraft,"); } if (iot_flmeterdata.RemoteChargeMoney != null) { part1.Append("RemoteChargeMoney = @RemoteChargeMoney,"); } if (iot_flmeterdata.RemoteChargeTimes != null) { part1.Append("RemoteChargeTimes = @RemoteChargeTimes,"); } if (iot_flmeterdata.Price != null) { part1.Append("Price = @Price,"); } if (iot_flmeterdata.ValveState != null) { part1.Append("ValveState = @ValveState,"); } if (iot_flmeterdata.ValveStateMsg != null) { part1.Append("ValveStateMsg = @ValveStateMsg,"); } if (iot_flmeterdata.PowerVoltage != null) { part1.Append("PowerVoltage = @PowerVoltage,"); } if (iot_flmeterdata.BatteryVoltage != null) { part1.Append("BatteryVoltage = @BatteryVoltage,"); } if (iot_flmeterdata.Reserve1 != null) { part1.Append("Reserve1 = @Reserve1,"); } if (iot_flmeterdata.Reserve2 != null) { part1.Append("Reserve2 = @Reserve2,"); } if (iot_flmeterdata.Reserve3 != null) { part1.Append("Reserve3 = @Reserve3,"); } if (iot_flmeterdata.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="iot_flmeterdata"></param> /// <returns>是否成功</returns> public string GetInsertStr(IOT_FLMeterData iot_flmeterdata) { StringBuilder part1 = new StringBuilder(); StringBuilder part2 = new StringBuilder(); if (iot_flmeterdata.communicateNo != null) { part1.Append("communicateNo,"); part2.Append("@communicateNo,"); } if (iot_flmeterdata.FLMeterNo != null) { part1.Append("FLMeterNo,"); part2.Append("@FLMeterNo,"); } if (iot_flmeterdata.siteNo != null) { part1.Append("siteNo,"); part2.Append("@siteNo,"); } if (iot_flmeterdata.InstantTime != null) { part1.Append("InstantTime,"); part2.Append("@InstantTime,"); } if (iot_flmeterdata.ReceivTime != null) { part1.Append("ReceivTime,"); part2.Append("@ReceivTime,"); } if (iot_flmeterdata.StdSum != null) { part1.Append("StdSum,"); part2.Append("@StdSum,"); } if (iot_flmeterdata.WorkSum != null) { part1.Append("WorkSum,"); part2.Append("@WorkSum,"); } if (iot_flmeterdata.StdFlow != null) { part1.Append("StdFlow,"); part2.Append("@StdFlow,"); } if (iot_flmeterdata.WorkFlow != null) { part1.Append("WorkFlow,"); part2.Append("@WorkFlow,"); } if (iot_flmeterdata.Temperature != null) { part1.Append("Temperature,"); part2.Append("@Temperature,"); } if (iot_flmeterdata.Pressure != null) { part1.Append("Pressure,"); part2.Append("@Pressure,"); } if (iot_flmeterdata.FMState != null) { part1.Append("FMState,"); part2.Append("@FMState,"); } if (iot_flmeterdata.FMStateMsg != null) { part1.Append("FMStateMsg,"); part2.Append("@FMStateMsg,"); } if (iot_flmeterdata.RTUState != null) { part1.Append("RTUState,"); part2.Append("@RTUState,"); } if (iot_flmeterdata.RTUStateMsg != null) { part1.Append("RTUStateMsg,"); part2.Append("@RTUStateMsg,"); } if (iot_flmeterdata.SumTotal != null) { part1.Append("SumTotal,"); part2.Append("@SumTotal,"); } if (iot_flmeterdata.RemainMoney != null) { part1.Append("RemainMoney,"); part2.Append("@RemainMoney,"); } if (iot_flmeterdata.RemainVolume != null) { part1.Append("RemainVolume,"); part2.Append("@RemainVolume,"); } if (iot_flmeterdata.Overdraft != null) { part1.Append("Overdraft,"); part2.Append("@Overdraft,"); } if (iot_flmeterdata.RemoteChargeMoney != null) { part1.Append("RemoteChargeMoney,"); part2.Append("@RemoteChargeMoney,"); } if (iot_flmeterdata.RemoteChargeTimes != null) { part1.Append("RemoteChargeTimes,"); part2.Append("@RemoteChargeTimes,"); } if (iot_flmeterdata.Price != null) { part1.Append("Price,"); part2.Append("@Price,"); } if (iot_flmeterdata.ValveState != null) { part1.Append("ValveState,"); part2.Append("@ValveState,"); } if (iot_flmeterdata.ValveStateMsg != null) { part1.Append("ValveStateMsg,"); part2.Append("@ValveStateMsg,"); } if (iot_flmeterdata.PowerVoltage != null) { part1.Append("PowerVoltage,"); part2.Append("@PowerVoltage,"); } if (iot_flmeterdata.BatteryVoltage != null) { part1.Append("BatteryVoltage,"); part2.Append("@BatteryVoltage,"); } if (iot_flmeterdata.Reserve1 != null) { part1.Append("Reserve1,"); part2.Append("@Reserve1,"); } if (iot_flmeterdata.Reserve2 != null) { part1.Append("Reserve2,"); part2.Append("@Reserve2,"); } if (iot_flmeterdata.Reserve3 != null) { part1.Append("Reserve3,"); part2.Append("@Reserve3,"); } if (iot_flmeterdata.Reserve4 != null) { part1.Append("Reserve4,"); part2.Append("@Reserve4,"); } StringBuilder sql = new StringBuilder(); sql.Append("insert into iot_flmeterdata(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")"); return(sql.ToString()); }