/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.T_State model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_State set "); strSql.Append("StateExplanation=@StateExplanation,"); strSql.Append("StateGroup=@StateGroup,"); strSql.Append("StateValue=@StateValue,"); strSql.Append("DeviceState=@DeviceState"); strSql.Append(" where StateMark=@StateMark "); SqlParameter[] parameters = { new SqlParameter("@StateExplanation", SqlDbType.NVarChar, 50), new SqlParameter("@StateGroup", SqlDbType.NVarChar, 255), new SqlParameter("@StateValue", SqlDbType.NVarChar, 255), new SqlParameter("@DeviceState", SqlDbType.NVarChar, 25), new SqlParameter("@StateMark", SqlDbType.NVarChar, 25) }; parameters[0].Value = model.StateExplanation; parameters[1].Value = model.StateGroup; parameters[2].Value = model.StateValue; parameters[3].Value = model.DeviceState; parameters[4].Value = model.StateMark; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_State DataRowToModel(DataRow row) { Maticsoft.Model.T_State model = new Maticsoft.Model.T_State(); if (row != null) { if (row["StateMark"] != null) { model.StateMark = row["StateMark"].ToString(); } if (row["StateExplanation"] != null) { model.StateExplanation = row["StateExplanation"].ToString(); } if (row["StateGroup"] != null) { model.StateGroup = row["StateGroup"].ToString(); } if (row["StateValue"] != null) { model.StateValue = row["StateValue"].ToString(); } if (row["DeviceState"] != null) { model.DeviceState = row["DeviceState"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.T_State model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_State("); strSql.Append("StateMark,StateExplanation,StateGroup,StateValue,DeviceState)"); strSql.Append(" values ("); strSql.Append("@StateMark,@StateExplanation,@StateGroup,@StateValue,@DeviceState)"); SqlParameter[] parameters = { new SqlParameter("@StateMark", SqlDbType.NVarChar, 25), new SqlParameter("@StateExplanation", SqlDbType.NVarChar, 50), new SqlParameter("@StateGroup", SqlDbType.NVarChar, 255), new SqlParameter("@StateValue", SqlDbType.NVarChar, 255), new SqlParameter("@DeviceState", SqlDbType.NVarChar, 25) }; parameters[0].Value = model.StateMark; parameters[1].Value = model.StateExplanation; parameters[2].Value = model.StateGroup; parameters[3].Value = model.StateValue; parameters[4].Value = model.DeviceState; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_State GetModel(string StateMark) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 StateMark,StateExplanation,StateGroup,StateValue,DeviceState from T_State "); strSql.Append(" where StateMark=@StateMark "); SqlParameter[] parameters = { new SqlParameter("@StateMark", SqlDbType.NVarChar, 25) }; parameters[0].Value = StateMark; Maticsoft.Model.T_State model = new Maticsoft.Model.T_State(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }