public int ContentCate_UpdateById(ContentCate obj)
{
using (SiteFictionAccess access = new SiteFictionAccess())
{
return(access.ContentCate_UpdateById(obj));
}
}
public int ContentCate_Insert(ContentCate obj)
{
using (SiteFictionAccess access = new SiteFictionAccess())
{
return(access.ContentCate_Insert(obj));
}
}
public List <ContentCate> ContentCate_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_ContentCate_SelectPage");
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy);
db.AddInParameter(dbCmd, "@where", DbType.String, where);
List <ContentCate> list = new List <ContentCate>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
ContentCate obj = this.Obj2Model <ContentCate>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static int ContentCate_UpdateById(ContentCate obj)
{
IYuYangService channel = Entity.CreateChannel <IYuYangService>(SiteEnum.SiteService.YuYangService);
var result = channel.ContentCate_UpdateById(obj);
(channel as IDisposable).Dispose();
return(result);
}
public int ContentCate_UpdateById(ContentCate obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_ContentCate_UpdateById");
db.AddInParameter(dbCmd, "@Id", DbType.Int32, obj.Id);
db.AddInParameter(dbCmd, "@CateName", DbType.String, obj.CateName);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public int ContentCate_Insert(ContentCate obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_ContentCate_Insert");
db.AddOutParameter(dbCmd, "@Id", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@CateName", DbType.String, obj.CateName);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
int Id = (int)dbCmd.Parameters["@Id"].Value;
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ContentCate ContentCate_SelectById(int Id)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_ContentCate_SelectById");
db.AddInParameter(dbCmd, "@Id", DbType.Int32, Id);
ContentCate obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
obj = this.Obj2Model <ContentCate>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
