/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.AccessDataBase.Model.Media model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Media("); strSql.Append("MediaID,MediaFileName,MediaFilePath,MediaGroupID,MediaType,PlayPriority)"); strSql.Append(" values ("); strSql.Append("@MediaID,@MediaFileName,@MediaFilePath,@MediaGroupID,@MediaType,@PlayPriority)"); SqlParameter[] parameters = { new SqlParameter("@MediaID", SqlDbType.Int, 4), new SqlParameter("@MediaFileName", SqlDbType.NVarChar, 50), new SqlParameter("@MediaFilePath", SqlDbType.NVarChar, 100), new SqlParameter("@MediaGroupID", SqlDbType.Int, 4), new SqlParameter("@MediaType", SqlDbType.Int, 4), new SqlParameter("@PlayPriority", SqlDbType.Int, 4) }; parameters[0].Value = model.MediaID; parameters[1].Value = model.MediaFileName; parameters[2].Value = model.MediaFilePath; parameters[3].Value = model.MediaGroupID; parameters[4].Value = model.MediaType; parameters[5].Value = model.PlayPriority; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.Media DataRowToModel(DataRow row) { KryptonAccessController.AccessDataBase.Model.Media model = new KryptonAccessController.AccessDataBase.Model.Media(); if (row != null) { if (row["MediaID"] != null && row["MediaID"].ToString() != "") { model.MediaID = int.Parse(row["MediaID"].ToString()); } if (row["MediaFileName"] != null) { model.MediaFileName = row["MediaFileName"].ToString(); } if (row["MediaFilePath"] != null) { model.MediaFilePath = row["MediaFilePath"].ToString(); } if (row["MediaGroupID"] != null && row["MediaGroupID"].ToString() != "") { model.MediaGroupID = int.Parse(row["MediaGroupID"].ToString()); } if (row["MediaType"] != null && row["MediaType"].ToString() != "") { model.MediaType = int.Parse(row["MediaType"].ToString()); } if (row["PlayPriority"] != null && row["PlayPriority"].ToString() != "") { model.PlayPriority = int.Parse(row["PlayPriority"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.Media GetModel(int MediaID, int PlayPriority) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MediaID,MediaFileName,MediaFilePath,MediaGroupID,MediaType,PlayPriority from Media "); strSql.Append(" where MediaID=@MediaID and PlayPriority=@PlayPriority "); SqlParameter[] parameters = { new SqlParameter("@MediaID", SqlDbType.Int, 4), new SqlParameter("@PlayPriority", SqlDbType.Int, 4) }; parameters[0].Value = MediaID; parameters[1].Value = PlayPriority; KryptonAccessController.AccessDataBase.Model.Media model = new KryptonAccessController.AccessDataBase.Model.Media(); 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(KryptonAccessController.AccessDataBase.Model.Media model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Media set "); strSql.Append("MediaFileName=@MediaFileName,"); strSql.Append("MediaFilePath=@MediaFilePath,"); strSql.Append("MediaGroupID=@MediaGroupID,"); strSql.Append("MediaType=@MediaType"); strSql.Append(" where MediaID=@MediaID and PlayPriority=@PlayPriority "); SqlParameter[] parameters = { new SqlParameter("@MediaFileName", SqlDbType.NVarChar, 50), new SqlParameter("@MediaFilePath", SqlDbType.NVarChar, 100), new SqlParameter("@MediaGroupID", SqlDbType.Int, 4), new SqlParameter("@MediaType", SqlDbType.Int, 4), new SqlParameter("@MediaID", SqlDbType.Int, 4), new SqlParameter("@PlayPriority", SqlDbType.Int, 4) }; parameters[0].Value = model.MediaFileName; parameters[1].Value = model.MediaFilePath; parameters[2].Value = model.MediaGroupID; parameters[3].Value = model.MediaType; parameters[4].Value = model.MediaID; parameters[5].Value = model.PlayPriority; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.Media DataRowToModel(DataRow row) { KryptonAccessController.AccessDataBase.Model.Media model=new KryptonAccessController.AccessDataBase.Model.Media(); if (row != null) { if(row["MediaID"]!=null && row["MediaID"].ToString()!="") { model.MediaID=int.Parse(row["MediaID"].ToString()); } if(row["MediaFileName"]!=null) { model.MediaFileName=row["MediaFileName"].ToString(); } if(row["MediaFilePath"]!=null) { model.MediaFilePath=row["MediaFilePath"].ToString(); } if(row["MediaGroupID"]!=null && row["MediaGroupID"].ToString()!="") { model.MediaGroupID=int.Parse(row["MediaGroupID"].ToString()); } if(row["MediaType"]!=null && row["MediaType"].ToString()!="") { model.MediaType=int.Parse(row["MediaType"].ToString()); } if(row["PlayPriority"]!=null && row["PlayPriority"].ToString()!="") { model.PlayPriority=int.Parse(row["PlayPriority"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.Media GetModel(int MediaID,int PlayPriority) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 MediaID,MediaFileName,MediaFilePath,MediaGroupID,MediaType,PlayPriority from Media "); strSql.Append(" where MediaID=@MediaID and PlayPriority=@PlayPriority "); SqlParameter[] parameters = { new SqlParameter("@MediaID", SqlDbType.Int,4), new SqlParameter("@PlayPriority", SqlDbType.Int,4) }; parameters[0].Value = MediaID; parameters[1].Value = PlayPriority; KryptonAccessController.AccessDataBase.Model.Media model=new KryptonAccessController.AccessDataBase.Model.Media(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }