/// <summary> /// 更新 /// </summary> /// <param name="iot_copydata"></param> /// <returns>是否成功</returns> public string GetUpdateStr(IOT_CopyData iot_copydata) { StringBuilder part1 = new StringBuilder(); part1.Append("update iot_copydata set "); if (iot_copydata.meterNo != null) { part1.Append("meterNo = @meterNo,"); } if (iot_copydata.lastShow != null) { part1.Append("lastShow = @lastShow,"); } if (iot_copydata.lastDosage != null) { part1.Append("lastDosage = @lastDosage,"); } if (iot_copydata.currentShow != null) { part1.Append("currentShow = @currentShow,"); } if (iot_copydata.currentDosage != null) { part1.Append("currentDosage = @currentDosage,"); } if (iot_copydata.unitPrice != null) { part1.Append("unitPrice = @unitPrice,"); } if (iot_copydata.printFlag != null) { part1.Append("printFlag = @printFlag,"); } if (iot_copydata.meterState != null) { part1.Append("meterState = @meterState,"); } if (iot_copydata.copyWay != null) { part1.Append("copyWay = @copyWay,"); } if (iot_copydata.copyState != null) { part1.Append("copyState = @copyState,"); } if (iot_copydata.copyTime != null) { part1.Append("copyTime = @copyTime,"); } if (iot_copydata.copyMan != null) { part1.Append("copyMan = @copyMan,"); } if (iot_copydata.Operator != null) { part1.Append("Operator = @Operator,"); } if (iot_copydata.OperateTime != null) { part1.Append("OperateTime = @OperateTime,"); } if (iot_copydata.isBalance != null) { part1.Append("isBalance = @isBalance,"); } if (iot_copydata.Remark != null) { part1.Append("Remark = @Remark,"); } int n = part1.ToString().LastIndexOf(","); part1.Remove(n, 1); part1.Append(" where Id= @Id "); return(part1.ToString()); }
/// <summary> /// 获取参数 /// </summary> /// <param name="iot_copydata"></param> /// <returns></returns> public Dictionary <string, string> GetParameters(IOT_CopyData iot_copydata) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (iot_copydata.Id != null) { dict.Add("@Id", iot_copydata.Id.ToString()); } if (iot_copydata.meterNo != null) { dict.Add("@meterNo", iot_copydata.meterNo.ToString()); } if (iot_copydata.lastShow != null) { dict.Add("@lastShow", iot_copydata.lastShow.ToString()); } if (iot_copydata.lastDosage != null) { dict.Add("@lastDosage", iot_copydata.lastDosage.ToString()); } if (iot_copydata.currentShow != null) { dict.Add("@currentShow", iot_copydata.currentShow.ToString()); } if (iot_copydata.currentDosage != null) { dict.Add("@currentDosage", iot_copydata.currentDosage.ToString()); } if (iot_copydata.unitPrice != null) { dict.Add("@unitPrice", iot_copydata.unitPrice.ToString()); } if (iot_copydata.printFlag != null) { dict.Add("@printFlag", iot_copydata.printFlag.ToString()); } if (iot_copydata.meterState != null) { dict.Add("@meterState", iot_copydata.meterState.ToString()); } if (iot_copydata.copyWay != null) { dict.Add("@copyWay", iot_copydata.copyWay.ToString()); } if (iot_copydata.copyState != null) { dict.Add("@copyState", iot_copydata.copyState.ToString()); } if (iot_copydata.copyTime != null) { dict.Add("@copyTime", iot_copydata.copyTime.ToString()); } if (iot_copydata.copyMan != null) { dict.Add("@copyMan", iot_copydata.copyMan.ToString()); } if (iot_copydata.Operator != null) { dict.Add("@Operator", iot_copydata.Operator.ToString()); } if (iot_copydata.OperateTime != null) { dict.Add("@OperateTime", iot_copydata.OperateTime.ToString()); } if (iot_copydata.isBalance != null) { dict.Add("@isBalance", iot_copydata.isBalance.ToString()); } if (iot_copydata.Remark != null) { dict.Add("@Remark", iot_copydata.Remark.ToString()); } return(dict); }