public ActionResult Data_DB_AD() { string[] keys = this.Request.Form.AllKeys; string page = this.Request.Form["page"]; string rows = this.Request.Form["rows"]; string where = this.Request.Form["where"]; string order = this.Request.Form["order"]; int _page = 0, _rows = 0; int.TryParse(page, out _page); int.TryParse(rows, out _rows); if (_page == 0) { _page = 1; } if (_rows == 0) { _rows = 50; } BLL.DB_AD dal = new BLL.DB_AD(); List <NModel.DB_AD> inModel = new List <NModel.DB_AD>(); inModel = dal.GetSortAndWherePagerList(_page, _rows, order, where); NModel.PageData <NModel.DB_AD> outModel = BLL.Fun.SetJsonData <NModel.DB_AD>(inModel); // inModel[0].Count_Show dal.Close(); return(View(outModel)); }
public ActionResult Edit_DB_AD() { this.Response.ContentType = "text/plain"; NModel.DB_AD model = new NModel.DB_AD(); BLL.DB_AD dal = new BLL.DB_AD(); String JsonStr = ""; bool isGet = Tool.NStr.PostForSetVal <NModel.DB_AD>(ref model, ref JsonStr, ""); // 下面代码编写 if (isGet && !string.IsNullOrEmpty(model.AD_Name) && !string.IsNullOrEmpty(model.AD_Num) && !string.IsNullOrEmpty(model.AD_Img) && model.AD_AddTime != null ) { //取默认值 model.AD_EditTime = DateTime.Parse(DateTime.Now.ToString("s")); bool isEdit = dal.Edit(model) > 0 ? true : false; string msg = dal.ErrorMsg; if (!string.IsNullOrEmpty(msg)) { msg = "原因:" + msg; } if (isEdit) { this.Response.Write(Tool.NMsg.SetMsg("修改成功", "1")); this.Response.End(); } else { this.Response.Write(Tool.NMsg.SetMsg("修改失败" + msg, "0")); this.Response.End(); } dal.Close(); } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败", "0")); this.Response.End(); } return(View()); }
public ActionResult Index() { NModel.NewsPager model_pager = LoadConfig("Index"); BLL.DB_News bll_news = new BLL.DB_News(); model_pager.IDctNewsList = new Dictionary <string, IList <NModel.DB_News> >(); LoadLeftRight(ref model_pager); IList <NModel.DB_News> model_news_num = null; IList <string> numList = new List <string>(); numList.Add("0101"); numList.Add("0102"); numList.Add("0103"); numList.Add("0201"); numList.Add("0202"); numList.Add("0203"); numList.Add("0301"); numList.Add("0302"); numList.Add("0303"); numList.Add("0401"); numList.Add("0402"); numList.Add("0403"); numList.Add("0501"); numList.Add("0502"); numList.Add("0503"); numList.Add("0504"); numList.Add("0601"); numList.Add("0602"); numList.Add("0603"); foreach (string val in numList) { model_news_num = bll_news.GetNewListByWhereAndTop(string.Format(" news_num=''{0}''and News_IsIndex=1", val), 6); model_pager.IDctNewsList.Add(val, model_news_num != null ? model_news_num : new List <NModel.DB_News>()); } model_pager.IDictListAd = new Dictionary <string, IList <NModel.DB_AD> >(); BLL.DB_AD bll_ad = new BLL.DB_AD(); string sql_ad = string.Format(" ''01'' "); IList <NModel.DB_AD> model_ad_list = bll_ad.GetListByNumAndTop(sql_ad, 8); model_pager.IDictListAd.Add("中间广告", model_ad_list != null ? model_ad_list : new List <NModel.DB_AD>()); bll_ad.Close(); bll_news.Close(); return(View(model_pager)); }
public ActionResult Add_DB_AD() { this.Response.ContentType = "text/plain"; NModel.DB_AD model = new NModel.DB_AD(); BLL.DB_AD dal = new BLL.DB_AD(); String JsonStr = ""; bool isGet = Tool.NStr.PostForSetVal <NModel.DB_AD>(ref model, ref JsonStr, ""); // 下面代码编写 if (isGet && !string.IsNullOrEmpty(model.AD_Name) && !string.IsNullOrEmpty(model.AD_Num) && !string.IsNullOrEmpty(model.AD_Img) ) { { model.AD_EditTime = DateTime.Parse(DateTime.Now.ToString("s")); model.AD_AddTime = DateTime.Parse(DateTime.Now.ToString("s")); // bool isAdd = dal.Add(model) > 0 ? true : false; if (isAdd) { this.Response.Write(Tool.NMsg.SetMsg("增加成功", "1")); this.Response.End(); } else { this.Response.Write(Tool.NMsg.SetMsg("增加失败" + dal.ErrorMsg, "1")); this.Response.End(); } } } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败", "0")); } dal.Close(); return(View()); }
public ActionResult Del_DB_AD() { this.Response.ContentType = "text/plain"; string delList = this.Request.Form["delList[]"]; if (!string.IsNullOrEmpty(delList)) { string[] arrStr = delList.Split(','); int[] delIntArr = Tool.NTool.ArrayToAll <int, string>(arrStr); if (Tool.NTool.IsArrNULL <int>(delIntArr)) { BLL.DB_AD dal = new BLL.DB_AD(); long long_Result = dal.DelList(delIntArr); if (long_Result > 0) { this.Response.Write(Tool.NMsg.SetMsg(string.Format("删除成功!总共删除{0}条", long_Result), "1")); this.Response.End(); } else { this.Response.Write(Tool.NMsg.SetMsg("删除失败!", "0")); this.Response.End(); } dal.Close(); } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败/填写数据不完整!", "0")); this.Response.End(); } } else { this.Response.Write(Tool.NMsg.SetMsg("提交失败/填写数据不完整!", "0")); this.Response.End(); } return(View()); }
public ActionResult Del_All_DB_AD() { string num = this.Request.QueryString["Num"]; BLL.DB_AD bll = new BLL.DB_AD(); long delNumber = bll.DelAllByNum(num); if (delNumber > 0) { this.Response.Write(Tool.NMsg.SetMsg("删除成功", "1")); this.Response.End(); } else { this.Response.Write(Tool.NMsg.SetMsg("删除失败", "0")); this.Response.End(); } bll.Close(); return(View()); }
public ActionResult Index() { //分类 BLL.DB_Classify bll_Classify = new BLL.DB_Classify(); //广告 BLL.DB_AD bll_ad = new BLL.DB_AD(); NModel.NewsPager model_pager = LoadConfig("/nlcq/index"); model_pager.IDictClassify = new Dictionary <string, IList <NModel.DB_Classify> >(); { IList <NModel.DB_Classify> modelClassifyList = null; modelClassifyList = bll_Classify.GetListByNumAndTop("1", 150); modelClassifyList = modelClassifyList != null ? modelClassifyList : new List <NModel.DB_Classify>(); model_pager.IDictClassify.Add("代码分类", modelClassifyList); } { IList <NModel.DB_Classify> modelClassifyList = null; modelClassifyList = bll_Classify.GetListByNumAndTop("2", 150); modelClassifyList = modelClassifyList != null ? modelClassifyList : new List <NModel.DB_Classify>(); model_pager.IDictClassify.Add("素材分类", modelClassifyList); } { model_pager.IDictListAd = new Dictionary <string, IList <NModel.DB_AD> >(); string sql_ad = string.Format(" ''01'' "); IList <NModel.DB_AD> model_ad_list = bll_ad.GetListByNumAndTop(sql_ad, 8); model_pager.IDictListAd.Add("首页广告一", model_ad_list != null ? model_ad_list : new List <NModel.DB_AD>()); } bll_ad.Close(); bll_Classify.Close(); return(View(model_pager)); }
public ActionResult Item_db_ad() { BLL.DB_AD dal = new BLL.DB_AD(); string pagenum = this.Request.Form["pagenum"]; string numPerPage = this.Request.Form["numPerPage"]; string dbaddate = this.Request.Form["dbaddate"]; string dbadname = this.Request.Form["dbadname"]; string num = this.Request.QueryString["Num"]; string where = "", order = "ad_addtime desc"; if (string.IsNullOrEmpty(numPerPage)) { numPerPage = "20"; } if (string.IsNullOrEmpty(pagenum)) { pagenum = "1"; } where += " 1=1 "; if (!string.IsNullOrEmpty(num)) { where += string.Format(" and ad_num=''{0}'' ", num); } if (!string.IsNullOrEmpty(dbaddate)) { where += string.Format(" and ( CONVERT(varchar(100), ad_addtime, 23)=''{0}'' )", dbaddate); } if (!string.IsNullOrEmpty(dbadname)) { where += string.Format(" and ad_name like ''%{0}%'' ", dbadname); } string _where = Server.UrlDecode(this.Request.QueryString["nwhere"] + ""); bool HasOneEqOne = !((_where + "").Trim().Length <= 3); bool IsOneEqOne = ((where + "").Trim().Length <= 3); if (IsOneEqOne && !string.IsNullOrEmpty(_where) && HasOneEqOne) { _where = this.Server.UrlDecode(_where); where = _where; } else { _where = where; } NModel.PageData <NModel.DB_AD> PD = new NModel.PageData <NModel.DB_AD>() { NumPerPage = numPerPage, PageNum = pagenum, TotalPage = dal.GetWhereListTotal(where), Where = where, OrderField = order }; dal.Close(); return(View(PD)); }