public int Update(AdItemInfo model) { StringBuilder sb = new StringBuilder(250); sb.Append(@"update AdItem set AdvertisementId = @AdvertisementId,PictureId = @PictureId,ActionTypeId = @ActionTypeId,Sort = @Sort,IsDisable = @IsDisable where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@AdvertisementId", SqlDbType.UniqueIdentifier), new SqlParameter("@PictureId", SqlDbType.UniqueIdentifier), new SqlParameter("@ActionTypeId", SqlDbType.UniqueIdentifier), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@IsDisable", SqlDbType.Bit) }; parms[0].Value = model.Id; parms[1].Value = model.AdvertisementId; parms[2].Value = model.PictureId; parms[3].Value = model.ActionTypeId; parms[4].Value = model.Sort; parms[5].Value = model.IsDisable; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <AdItemInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,AdvertisementId,PictureId,ActionTypeId,Sort,IsDisable from AdItem "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } IList <AdItemInfo> list = new List <AdItemInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemInfo model = new AdItemInfo(); model.Id = reader.GetGuid(0); model.AdvertisementId = reader.GetGuid(1); model.PictureId = reader.GetGuid(2); model.ActionTypeId = reader.GetGuid(3); model.Sort = reader.GetInt32(4); model.IsDisable = reader.GetBoolean(5); list.Add(model); } } } return(list); }
public IList <AdItemInfo> GetList() { StringBuilder sb = new StringBuilder(250); sb.Append(@"select Id,AdvertisementId,PictureId,ActionTypeId,Sort,IsDisable from AdItem order by LastUpdatedDate desc " ); IList <AdItemInfo> list = new List <AdItemInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemInfo model = new AdItemInfo(); model.Id = reader.GetGuid(0); model.AdvertisementId = reader.GetGuid(1); model.PictureId = reader.GetGuid(2); model.ActionTypeId = reader.GetGuid(3); model.Sort = reader.GetInt32(4); model.IsDisable = reader.GetBoolean(5); list.Add(model); } } } return(list); }
public AdItemInfo GetModel(object Id) { AdItemInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,AdvertisementId,PictureId,ActionTypeId,Sort,IsDisable from AdItem where Id = @Id " ); SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(Id.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { while (reader.Read()) { model = new AdItemInfo(); model.Id = reader.GetGuid(0); model.AdvertisementId = reader.GetGuid(1); model.PictureId = reader.GetGuid(2); model.ActionTypeId = reader.GetGuid(3); model.Sort = reader.GetInt32(4); model.IsDisable = reader.GetBoolean(5); } } } return(model); }
public IList <AdItemInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select count(*) from AdItem "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <AdItemInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, Id,AdvertisementId,PictureId,ActionTypeId,Sort,IsDisable from AdItem " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <AdItemInfo> list = new List <AdItemInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemInfo model = new AdItemInfo(); model.Id = reader.GetGuid(1); model.AdvertisementId = reader.GetGuid(2); model.PictureId = reader.GetGuid(3); model.ActionTypeId = reader.GetGuid(4); model.Sort = reader.GetInt32(5); model.IsDisable = reader.GetBoolean(6); list.Add(model); } } } return(list); }
public AdItemInfo GetModelByJoin(object Id) { AdItemInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 adi.Id,adi.AdvertisementId,adi.PictureId,adi.ActionTypeId,adi.Sort,adi.IsDisable ,adp.FileDirectory,adp.FileExtension,adp.RandomFolder from AdItem adi left join AdvertisementPicture adp on adp.Id = adi.PictureId where adi.Id = @Id " ); SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(Id.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { while (reader.Read()) { model = new AdItemInfo(); model.Id = reader.GetGuid(0); model.AdvertisementId = reader.GetGuid(1); model.PictureId = reader.GetGuid(2); model.ActionTypeId = reader.GetGuid(3); model.Sort = reader.GetInt32(4); model.IsDisable = reader.GetBoolean(5); model.FileDirectory = reader.IsDBNull(6) ? null : reader.GetString(6); model.FileExtension = reader.IsDBNull(7) ? null : reader.GetString(7); model.RandomFolder = reader.IsDBNull(8) ? null : reader.GetString(8); } } } return(model); }
/// <summary> /// 广告项提交 /// </summary> /// <param name="context"></param> private void SaveAdItem(HttpContext context) { try { Guid adId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["adId"])) { Guid.TryParse(context.Request.Form["adId"], out adId); } if (adId.Equals(Guid.Empty)) { context.Response.Write("{\"success\": false,\"message\": \"请先完成基本信息\"}"); return; } if (string.IsNullOrWhiteSpace(context.Request.Form["ddlActionType"])) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}"); return; } Guid adItemId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["hAdItemId"])) { Guid.TryParse(context.Request.Form["hAdItemId"], out adItemId); } Guid pictureId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["hImgPictureId"])) { Guid.TryParse(context.Request.Form["hImgPictureId"], out pictureId); } Guid actionTypeId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["ddlActionType"])) { Guid.TryParse(context.Request.Form["ddlActionType"], out actionTypeId); } int sort = 0; if (!string.IsNullOrWhiteSpace(context.Request.Form["txtSort"])) { int.TryParse(context.Request.Form["txtSort"], out sort); } bool isDisable = false; if (!string.IsNullOrWhiteSpace(context.Request.Form["isDisable"])) { bool.TryParse(context.Request.Form["isDisable"], out isDisable); } AdItem bll = new AdItem(); AdItemInfo model = new AdItemInfo(); model.AdvertisementId = adId; model.Id = adItemId; model.PictureId = pictureId; model.ActionTypeId = actionTypeId; model.Sort = sort; model.IsDisable = isDisable; int effect = -1; if (!adItemId.Equals(Guid.Empty)) { var oldModel = bll.GetModel(adItemId); if (oldModel.ActionTypeId != model.ActionTypeId) { AdItemLink adlBll = new AdItemLink(); if (adlBll.Delete(adItemId) < 1) { AdItemContent adcBll = new AdItemContent(); adcBll.Delete(adItemId); } } else { effect = bll.Update(model); } } else { model.Id = Guid.NewGuid(); effect = bll.Insert(model); } if (effect == 110) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Exist + "\"}"); return; } if (effect != 1) { context.Response.Write("{\"success\": false,\"message\": \"操作失败,原因:请正确输入并重试,如果再出现此问题请联系管理员\"}"); return; } context.Response.Write("{\"success\": true,\"message\": \"" + MessageContent.Submit_Success + "\",\"data\": \"" + model.Id + "\"}"); } catch (Exception ex) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.AlertTitle_Ex_Error + ":" + ex.Message + "\"}"); } }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(AdItemInfo model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(AdItemInfo model) { return(dal.Insert(model)); }