public IList <AdItemContentInfo> GetList() { StringBuilder sb = new StringBuilder(250); sb.Append(@"select AdItemId,Descr,ContentText from AdItemContent order by LastUpdatedDate desc " ); IList <AdItemContentInfo> list = new List <AdItemContentInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemContentInfo model = new AdItemContentInfo(); model.AdItemId = reader.GetGuid(0); model.Descr = reader.GetString(1); model.ContentText = reader.GetString(2); list.Add(model); } } } return(list); }
public IList <AdItemContentInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); sb.Append(@"select AdItemId,Descr,ContentText from AdItemContent "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } IList <AdItemContentInfo> list = new List <AdItemContentInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemContentInfo model = new AdItemContentInfo(); model.AdItemId = reader.GetGuid(0); model.Descr = reader.GetString(1); model.ContentText = reader.GetString(2); list.Add(model); } } } return(list); }
public IList <AdItemContentInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(250); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, AdItemId,Descr,ContentText from AdItemContent " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <AdItemContentInfo> list = new List <AdItemContentInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { AdItemContentInfo model = new AdItemContentInfo(); model.AdItemId = reader.GetGuid(1); model.Descr = reader.GetString(2); model.ContentText = reader.GetString(3); list.Add(model); } } } return(list); }
public AdItemContentInfo GetModel(object AdItemId) { AdItemContentInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 AdItemId,Descr,ContentText from AdItemContent where AdItemId = @AdItemId " ); SqlParameter parm = new SqlParameter("@AdItemId", SqlDbType.UniqueIdentifier); parm.Value = Guid.Parse(AdItemId.ToString()); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parm)) { if (reader != null) { while (reader.Read()) { model = new AdItemContentInfo(); model.AdItemId = reader.GetGuid(0); model.Descr = reader.GetString(1); model.ContentText = reader.GetString(2); } } } return(model); }
public int Update(AdItemContentInfo model) { StringBuilder sb = new StringBuilder(250); sb.Append(@"update AdItemContent set Descr = @Descr,ContentText = @ContentText where AdItemId = @AdItemId " ); SqlParameter[] parms = { new SqlParameter("@AdItemId", SqlDbType.UniqueIdentifier), new SqlParameter("@Descr", SqlDbType.NVarChar,300), new SqlParameter("@ContentText", SqlDbType.NVarChar, 3000) }; parms[0].Value = model.AdItemId; parms[1].Value = model.Descr; parms[2].Value = model.ContentText; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms)); }
/// <summary> /// 广告项内容提交 /// </summary> /// <param name="context"></param> private void SaveAdItemContent(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; } Guid adItemId = Guid.Empty; if (!string.IsNullOrWhiteSpace(context.Request.Form["adItemId"])) { Guid.TryParse(context.Request.Form["adItemId"], out adItemId); } if (adItemId.Equals(Guid.Empty)) { context.Response.Write("{\"success\": false,\"message\": \"请先完成广告项再继续此操作\"}"); return; } if (string.IsNullOrWhiteSpace(context.Request.Form["content"])) { context.Response.Write("{\"success\": false,\"message\": \"" + MessageContent.Submit_Params_InvalidError + "\"}"); return; } string content = HttpUtility.HtmlDecode(context.Request.Form["content"].Trim()); AdItemContent bll = new AdItemContent(); AdItemContentInfo model = new AdItemContentInfo(); model.AdItemId = adItemId; model.Descr = context.Request.Form["txtaDescr"].Trim(); model.ContentText = content; int effect = -1; if (bll.IsExist(adItemId)) { effect = bll.Update(model); } else { 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 + "\"}"); } 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(AdItemContentInfo model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(AdItemContentInfo model) { return(dal.Insert(model)); }