/// <summary> /// 更新一条数据 /// </summary> public bool Update(AdModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Ad set "); strSql.Append("Title=@Title,"); strSql.Append("Link=@Link,"); strSql.Append("Image=@Image,"); strSql.Append("DisplayMode=@DisplayMode,"); strSql.Append("sort=@sort,"); strSql.Append("StartTime=@StartTime,"); strSql.Append("EndTime=@EndTime,"); strSql.Append("CategoryId=@CategoryId,"); strSql.Append("video=@video,"); strSql.Append("AddPerson=@AddPerson"); strSql.Append(" where AdId=@AdId"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.VarChar, 50), new SqlParameter("@Link", SqlDbType.VarChar, 100), new SqlParameter("@Image", SqlDbType.VarChar, 100), new SqlParameter("@DisplayMode", SqlDbType.Int, 4), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@CategoryId", SqlDbType.Int, 4), new SqlParameter("@video", SqlDbType.VarChar, 150), new SqlParameter("@AddPerson", SqlDbType.VarChar, 50), new SqlParameter("@AdId", SqlDbType.BigInt, 8) }; parameters[0].Value = model.Title; parameters[1].Value = model.Link; parameters[2].Value = model.Image; parameters[3].Value = model.DisplayMode; parameters[4].Value = model.sort; parameters[5].Value = model.StartTime; parameters[6].Value = model.EndTime; parameters[7].Value = model.CategoryId; parameters[8].Value = model.video; parameters[9].Value = model.AddPerson; parameters[10].Value = model.AdId; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AdModel DataRowToModel(DataRow row) { AdModel model = new AdModel(); if (row != null) { if (row["AdId"] != null && row["AdId"].ToString() != "") { model.AdId = long.Parse(row["AdId"].ToString()); } if (row["Title"] != null) { model.Title = row["Title"].ToString(); } if (row["Link"] != null) { model.Link = row["Link"].ToString(); } if (row["Image"] != null) { model.Image = row["Image"].ToString(); } if (row["DisplayMode"] != null && row["DisplayMode"].ToString() != "") { model.DisplayMode = int.Parse(row["DisplayMode"].ToString()); } if (row["sort"] != null && row["sort"].ToString() != "") { model.sort = int.Parse(row["sort"].ToString()); } if (row["StartTime"] != null && row["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(row["StartTime"].ToString()); } if (row["EndTime"] != null && row["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(row["EndTime"].ToString()); } if (row["CategoryId"] != null && row["CategoryId"].ToString() != "") { model.CategoryId = int.Parse(row["CategoryId"].ToString()); } if (row["video"] != null) { model.video = row["video"].ToString(); } if (row["AddPerson"] != null) { model.AddPerson = row["AddPerson"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(AdModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Ad("); strSql.Append("Title,Link,Image,DisplayMode,sort,StartTime,EndTime,CategoryId,video,AddPerson)"); strSql.Append(" values ("); strSql.Append("@Title,@Link,@Image,@DisplayMode,@sort,@StartTime,@EndTime,@CategoryId,@video,@AddPerson)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.VarChar, 50), new SqlParameter("@Link", SqlDbType.VarChar, 100), new SqlParameter("@Image", SqlDbType.VarChar, 100), new SqlParameter("@DisplayMode", SqlDbType.Int, 4), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@CategoryId", SqlDbType.Int, 4), new SqlParameter("@video", SqlDbType.VarChar, 150), new SqlParameter("@AddPerson", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Title; parameters[1].Value = model.Link; parameters[2].Value = model.Image; parameters[3].Value = model.DisplayMode; parameters[4].Value = model.sort; parameters[5].Value = model.StartTime; parameters[6].Value = model.EndTime; parameters[7].Value = model.CategoryId; parameters[8].Value = model.video; parameters[9].Value = model.AddPerson; object obj = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AdModel GetModel(long AdId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AdId,Title,Link,Image,DisplayMode,sort,StartTime,EndTime,CategoryId,video,AddPerson from T_Ad "); strSql.Append(" where AdId=@AdId"); SqlParameter[] parameters = { new SqlParameter("@AdId", SqlDbType.BigInt) }; parameters[0].Value = AdId; AdModel model = new AdModel(); DataSet ds = adoHelper.ExecuteSqlDataset(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(AdModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(AdModel model) { return(dal.Add(model)); }