/// <summary>
/// 根据对象删除信息，用于ObjectDatasource
/// </summary>
/// <param name="tran">事务</param>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Delete(DbTransaction tran, AdvertiesmentMDL _AdvertiesmentMDL)
{
string sql = @"DELETE FROM dbo.Advertiesment WHERE id = @id";
DBHelper db = new DBHelper();
List <SqlParameter> p = new List <SqlParameter>();
p.Add(db.CreateParameter("id", DbType.Int32, _AdvertiesmentMDL.id));
return(db.GetExcuteNonQuery(tran, sql, p.ToArray()));
}
/// <summary>
#region 自定义方法
public static LayPadding <AdvertiesmentMDL> GetAdvertiesmentPageList(string fileds, string orderstr, int PageSize, int PageIndex, string strWhere)
{
LayPadding <AdvertiesmentMDL> ulist = new LayPadding <AdvertiesmentMDL>();
var list = new List <AdvertiesmentMDL>();
string cond = string.IsNullOrEmpty(strWhere) ? "" : string.Format(" where {0}", strWhere);
string sql = string.Format("SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {0}) AS pos, {1} FROM [Advertiesment] {2} ) AS sp WHERE pos BETWEEN {3} AND {4}", orderstr, fileds, cond, (((PageIndex - 1) * PageSize) + 1), PageSize * PageIndex);
DBHelper db = new DBHelper();
using (SqlDataReader reader = db.GetDataReader(sql))
{
AdvertiesmentMDL _AdvertiesmentMDL = null;
while (reader.Read())
{
_AdvertiesmentMDL = new AdvertiesmentMDL();
if (reader["id"] != DBNull.Value)
{
_AdvertiesmentMDL.id = Convert.ToInt32(reader["id"]);
}
if (reader["createtime"] != DBNull.Value)
{
_AdvertiesmentMDL.createtime = Convert.ToDateTime(reader["createtime"]);
}
if (reader["path"] != DBNull.Value)
{
_AdvertiesmentMDL.path = Convert.ToString(reader["path"]);
}
if (reader["type"] != DBNull.Value)
{
_AdvertiesmentMDL.type = Convert.ToString(reader["type"]);
}
if (reader["link"] != DBNull.Value)
{
_AdvertiesmentMDL.link = Convert.ToString(reader["link"]);
}
if (reader["time"] != DBNull.Value)
{
_AdvertiesmentMDL.time = Convert.ToInt32(reader["time"]);
}
if (reader["remark"] != DBNull.Value)
{
_AdvertiesmentMDL.remark = Convert.ToString(reader["remark"]);
}
}
reader.Close();
db.Close();
ulist.data = list;
ulist.count = SelectCount(cond);
return(ulist);
}
}
/// <summary>
/// 根据主键获取单个实体
/// </summary>
/// <param name="AdvertiesmentID">主键</param>
public static AdvertiesmentMDL GetObject(int id)
{
string sql = @"
SELECT [ID],createtime,path,[TYPE],link,[TIME],remark
FROM dbo.Advertiesment
WHERE id = @id" ;
DBHelper db = new DBHelper();
List <SqlParameter> p = new List <SqlParameter>();
p.Add(db.CreateParameter("id", DbType.Int32, id));
using (SqlDataReader reader = db.GetDataReader(sql, p.ToArray()))
{
AdvertiesmentMDL _AdvertiesmentMDL = null;
if (reader.Read())
{
_AdvertiesmentMDL = new AdvertiesmentMDL();
if (reader["id"] != DBNull.Value)
{
_AdvertiesmentMDL.id = Convert.ToInt32(reader["id"]);
}
if (reader["createtime"] != DBNull.Value)
{
_AdvertiesmentMDL.createtime = Convert.ToDateTime(reader["createtime"]);
}
if (reader["path"] != DBNull.Value)
{
_AdvertiesmentMDL.path = Convert.ToString(reader["path"]);
}
if (reader["type"] != DBNull.Value)
{
_AdvertiesmentMDL.type = Convert.ToString(reader["type"]);
}
if (reader["link"] != DBNull.Value)
{
_AdvertiesmentMDL.link = Convert.ToString(reader["link"]);
}
if (reader["time"] != DBNull.Value)
{
_AdvertiesmentMDL.time = Convert.ToInt32(reader["time"]);
}
if (reader["remark"] != DBNull.Value)
{
_AdvertiesmentMDL.remark = Convert.ToString(reader["remark"]);
}
}
reader.Close();
db.Close();
return(_AdvertiesmentMDL);
}
}
/// <summary>
/// 插入信息
/// </summary>
/// <param name="tran">事务</param>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Insert(DbTransaction tran, AdvertiesmentMDL _AdvertiesmentMDL)
{
DBHelper db = new DBHelper();
string sql = @"
INSERT INTO dbo.Advertiesment([ID],createtime,path,[TYPE],link,[TIME],remark)
VALUES (@id,@createtime,@path,@type,@link,@time,@remark)" ;
List <SqlParameter> p = new List <SqlParameter>();
p.Add(db.CreateParameter("id", DbType.Int32, _AdvertiesmentMDL.id));
p.Add(db.CreateParameter("createtime", DbType.DateTime, _AdvertiesmentMDL.createtime));
p.Add(db.CreateParameter("path", DbType.String, _AdvertiesmentMDL.path));
p.Add(db.CreateParameter("type", DbType.String, _AdvertiesmentMDL.type));
p.Add(db.CreateParameter("link", DbType.String, _AdvertiesmentMDL.link));
p.Add(db.CreateParameter("time", DbType.Int32, _AdvertiesmentMDL.time));
p.Add(db.CreateParameter("remark", DbType.String, _AdvertiesmentMDL.remark));
return(db.GetExcuteNonQuery(tran, sql, p.ToArray()));
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="tran">事务</param>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Update(DbTransaction tran, AdvertiesmentMDL _AdvertiesmentMDL)
{
string sql = @"
UPDATE dbo.Advertiesment
SET createtime = @createtime,path = @path,""TYPE"" = @type,link = @link,""TIME"" = @time,remark = @remark
WHERE
id = @id" ;
DBHelper db = new DBHelper();
List <SqlParameter> p = new List <SqlParameter>();
p.Add(db.CreateParameter("id", DbType.Int32, _AdvertiesmentMDL.id));
p.Add(db.CreateParameter("createtime", DbType.DateTime, _AdvertiesmentMDL.createtime));
p.Add(db.CreateParameter("path", DbType.String, _AdvertiesmentMDL.path));
p.Add(db.CreateParameter("type", DbType.String, _AdvertiesmentMDL.type));
p.Add(db.CreateParameter("link", DbType.String, _AdvertiesmentMDL.link));
p.Add(db.CreateParameter("time", DbType.Int32, _AdvertiesmentMDL.time));
p.Add(db.CreateParameter("remark", DbType.String, _AdvertiesmentMDL.remark));
return(db.GetExcuteNonQuery(tran, sql, p.ToArray()));
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Update(AdvertiesmentMDL _AdvertiesmentMDL)
{
return(Update(null, _AdvertiesmentMDL));
}
/// <summary>
/// 插入信息
/// </summary>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Insert(AdvertiesmentMDL _AdvertiesmentMDL)
{
return(Insert(null, _AdvertiesmentMDL));
}
/// <summary>
/// 根据对象删除信息，用于ObjectDatasource
/// </summary>
/// <param name="tran">事务</param>
/// <param name="AdvertiesmentMDL">对象实体类</param>
/// <returns></returns>
public static int Delete(AdvertiesmentMDL _AdvertiesmentMDL)
{
return(Delete(null, _AdvertiesmentMDL));
}
