/// <summary> /// 增加一条数据 /// </summary> public bool Add(View_batteryPropertyModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into View_batteryProperty("); strSql.Append("batteryID,propertyName,propertyCata,batteryPropertyValueID,propertyID,propertyValue)"); strSql.Append(" values ("); strSql.Append("@batteryID,@propertyName,@propertyCata,@batteryPropertyValueID,@propertyID,@propertyValue)"); SqlParameter[] parameters = { new SqlParameter("@batteryID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyName", SqlDbType.NVarChar, 50), new SqlParameter("@propertyCata", SqlDbType.NVarChar, 50), new SqlParameter("@batteryPropertyValueID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyValue", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.batteryID; parameters[1].Value = model.propertyName; parameters[2].Value = model.propertyCata; parameters[3].Value = model.batteryPropertyValueID; parameters[4].Value = model.propertyID; parameters[5].Value = model.propertyValue; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public View_batteryPropertyModel DataRowToModel(DataRow row) { View_batteryPropertyModel model = new View_batteryPropertyModel(); if (row != null) { if (row["batteryID"] != null) { model.batteryID = row["batteryID"].ToString(); } if (row["propertyName"] != null) { model.propertyName = row["propertyName"].ToString(); } if (row["propertyCata"] != null) { model.propertyCata = row["propertyCata"].ToString(); } if (row["batteryPropertyValueID"] != null) { model.batteryPropertyValueID = row["batteryPropertyValueID"].ToString(); } if (row["propertyID"] != null) { model.propertyID = row["propertyID"].ToString(); } if (row["propertyValue"] != null) { model.propertyValue = row["propertyValue"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public View_batteryPropertyModel GetModel(string batteryID, string propertyName, string propertyCata, string batteryPropertyValueID, string propertyID, string propertyValue) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 batteryID,propertyName,propertyCata,batteryPropertyValueID,propertyID,propertyValue from View_batteryProperty "); strSql.Append(" where batteryID=@batteryID and propertyName=@propertyName and propertyCata=@propertyCata and batteryPropertyValueID=@batteryPropertyValueID and propertyID=@propertyID and propertyValue=@propertyValue "); SqlParameter[] parameters = { new SqlParameter("@batteryID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyName", SqlDbType.NVarChar, 50), new SqlParameter("@propertyCata", SqlDbType.NVarChar, 50), new SqlParameter("@batteryPropertyValueID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyValue", SqlDbType.NVarChar, 50) }; parameters[0].Value = batteryID; parameters[1].Value = propertyName; parameters[2].Value = propertyCata; parameters[3].Value = batteryPropertyValueID; parameters[4].Value = propertyID; parameters[5].Value = propertyValue; View_batteryPropertyModel model = new View_batteryPropertyModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(View_batteryPropertyModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update View_batteryProperty set "); strSql.Append("batteryID=@batteryID,"); strSql.Append("propertyName=@propertyName,"); strSql.Append("propertyCata=@propertyCata,"); strSql.Append("batteryPropertyValueID=@batteryPropertyValueID,"); strSql.Append("propertyID=@propertyID,"); strSql.Append("propertyValue=@propertyValue"); strSql.Append(" where batteryID=@batteryID and propertyName=@propertyName and propertyCata=@propertyCata and batteryPropertyValueID=@batteryPropertyValueID and propertyID=@propertyID and propertyValue=@propertyValue "); SqlParameter[] parameters = { new SqlParameter("@batteryID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyName", SqlDbType.NVarChar, 50), new SqlParameter("@propertyCata", SqlDbType.NVarChar, 50), new SqlParameter("@batteryPropertyValueID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyID", SqlDbType.NVarChar, 50), new SqlParameter("@propertyValue", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.batteryID; parameters[1].Value = model.propertyName; parameters[2].Value = model.propertyCata; parameters[3].Value = model.batteryPropertyValueID; parameters[4].Value = model.propertyID; parameters[5].Value = model.propertyValue; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(View_batteryPropertyModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(View_batteryPropertyModel model) { return(dal.Add(model)); }