/// <summary>
/// 插入t_GalleryClassification
/// </summary>
public virtual bool Insert(t_GalleryClassification galleryClassification)
{
string sql = "insert into t_GalleryClassification (Id, Name, Description, Sort) values (@Id, @Name, @Description, @Sort)";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@Id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Id", DataRowVersion.Default, galleryClassification.Id),
new SqlParameter("@Name", SqlDbType.NVarChar, 32, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Default, galleryClassification.Name),
new SqlParameter("@Description", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Default, galleryClassification.Description),
new SqlParameter("@Sort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Sort", DataRowVersion.Default, galleryClassification.Sort)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public List<t_GalleryClassification> selectAllDate()
{
string sql = "select * from t_GalleryClassification";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
List<t_GalleryClassification> _List = new List<t_GalleryClassification>();
foreach (DataRow dr in dt.Rows)
{
t_GalleryClassification obj = new t_GalleryClassification(dr);
_List.Add(obj);
}
return _List;
}
public void Clone(t_GalleryClassification obj)
{
//分类Id
Id = obj.Id;
//分类名称
Name = obj.Name;
//分类说明
Description = obj.Description;
//排序字段
Sort = obj.Sort;
}
public t_GalleryClassification selectARowDate(string m_id)
{
string sql = string.Format("select * from t_GalleryClassification where Id='{0}'",m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
t_GalleryClassification m_Gall=new t_GalleryClassification(dr);
return m_Gall;
}
/// <summary>
/// 更新t_GalleryClassification
/// </summary>
public virtual bool Update(t_GalleryClassification galleryClassification)
{
string sql = "update t_GalleryClassification set Name = @Name, Description = @Description, Sort = @Sort where Id = @Id";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@Id", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Id", DataRowVersion.Default, galleryClassification.Id),
new SqlParameter("@Name", SqlDbType.NVarChar, 32, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Default, galleryClassification.Name),
new SqlParameter("@Description", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Default, galleryClassification.Description),
new SqlParameter("@Sort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Sort", DataRowVersion.Default, galleryClassification.Sort)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}