/// <summary> /// 图文分页列表 /// </summary> /// <param name="page_size">页面大小</param> /// <param name="page_index">当前页码</param> /// <param name="strwhere">查询条件</param> /// <param name="totalcount">总记录数</param> /// <returns>DateTable</returns> public DataTable get_link_list(int page_size, int page_index, string strwhere, out int totalcount) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.link().GetList(page_size, page_index, _where, "sort_id asc,add_time desc", out totalcount).Tables[0]; return dt; }
/// <summary> /// 友情链接列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="strwhere">查询条件</param> /// <returns>DataTable</returns> public DataTable get_link_list(int top, string strwhere) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.link().GetList(top, _where).Tables[0]; return dt; }
/// <summary> /// 图文分页列表 /// </summary> /// <param name="page_size">页面大小</param> /// <param name="page_index">当前页码</param> /// <param name="strwhere">查询条件</param> /// <param name="totalcount">总记录数</param> /// <returns>DateTable</returns> public DataTable get_link_list(int page_size, int page_index, string strwhere, out int totalcount) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.link().GetList(page_size, page_index, _where, "sort_id asc,add_time desc", out totalcount).Tables[0]; return(dt); }
/// <summary> /// 友情链接列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="strwhere">查询条件</param> /// <returns>DataTable</returns> public DataTable get_link_list(int top, string strwhere) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.link().GetList(top, _where).Tables[0]; return(dt); }
private void link_add(HttpContext context) { StringBuilder strTxt = new StringBuilder(); BLL.link bll = new BLL.link(); Model.link model = new Model.link(); string _site_path = DTRequest.GetQueryString("site"); string _code = DTRequest.GetFormString("txtCode"); string _title = DTRequest.GetFormString("txtTitle"); string _user_name = DTRequest.GetFormString("txtUserName"); string _user_tel = DTRequest.GetFormString("txtUserTel"); string _email = DTRequest.GetFormString("txtEmail"); string _site_url = DTRequest.GetFormString("txtSiteUrl"); string _img_url = DTRequest.GetFormString("txtImgUrl"); //检查站点目录 if (string.IsNullOrEmpty(_site_path)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,网站传输参数有误!\"}"); return; } //校检验证码 if (string.IsNullOrEmpty(_code)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入验证码!\"}"); return; } if (context.Session[DTKeys.SESSION_CODE] == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,系验证码已过期!\"}"); return; } if (_code.ToLower() != (context.Session[DTKeys.SESSION_CODE].ToString()).ToLower()) { context.Response.Write("{\"status\":0, \"msg\":\"验证码与系统的不一致!\"}"); return; } if (string.IsNullOrEmpty(_title)) { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,请输入网站标题!\"}"); return; } if (string.IsNullOrEmpty(_site_url)) { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,请输入网站网址!\"}"); return; } model.site_path = Utils.DropHTML(_site_path); model.title = Utils.DropHTML(_title); model.is_lock = 1; model.is_red = 0; model.user_name = Utils.DropHTML(_user_name); model.user_tel = Utils.DropHTML(_user_tel); model.email = Utils.DropHTML(_email); model.site_url = Utils.DropHTML(_site_url); model.img_url = Utils.DropHTML(_img_url); model.is_image = 1; if (string.IsNullOrEmpty(model.img_url)) { model.is_image = 0; } if (bll.Add(model) > 0) { context.Response.Write("{\"status\": 1, \"msg\": \"恭喜您,提交成功!\"}"); return; } context.Response.Write("{\"status\": 0, \"msg\": \"对不起,保存过程中发生错误!\"}"); return; }
private void link_add(HttpContext context) { StringBuilder strTxt = new StringBuilder(); BLL.link bll = new BLL.link(); Model.link model = new Model.link(); string _code = DTRequest.GetFormString("txtCode"); string _title =DTRequest.GetFormString("txtTitle"); string _user_name = DTRequest.GetFormString("txtUserName"); string _user_tel =DTRequest.GetFormString("txtUserTel"); string _email = DTRequest.GetFormString("txtEmail"); string _site_url = DTRequest.GetFormString("txtSiteUrl"); string _img_url = DTRequest.GetFormString("txtImgUrl"); //校检验证码 if (string.IsNullOrEmpty(_code)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入验证码!\"}"); return; } if (context.Session[DTKeys.SESSION_CODE] == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,系验证码已过期!\"}"); return; } if (_code.ToLower() != (context.Session[DTKeys.SESSION_CODE].ToString()).ToLower()) { context.Response.Write("{\"status\":0, \"msg\":\"验证码与系统的不一致!\"}"); return; } if (string.IsNullOrEmpty(_title)) { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,请输入网站标题!\"}"); return; } if (string.IsNullOrEmpty(_site_url)) { context.Response.Write("{\"status\": 0, \"msg\": \"对不起,请输入网站网址!\"}"); return; } model.title = Utils.DropHTML(_title); model.is_lock = 1; model.is_red = 0; model.user_name = Utils.DropHTML(_user_name); model.user_tel = Utils.DropHTML(_user_tel); model.email = Utils.DropHTML(_email); model.site_url = Utils.DropHTML(_site_url); model.img_url = Utils.DropHTML(_img_url); model.is_image = 1; if (string.IsNullOrEmpty(model.img_url)) { model.is_image = 0; } if (bll.Add(model) > 0) { context.Response.Write("{\"status\": 1, \"msg\": \"恭喜您,提交成功!\"}"); return; } context.Response.Write("{\"status\": 0, \"msg\": \"对不起,保存过程中发生错误!\"}"); return; }
private void link_add(HttpContext context) { StringBuilder strTxt = new StringBuilder(); BLL.link bll = new BLL.link(); Model.link model = new Model.link(); string _code = DTRequest.GetFormString("txtCode"); string _title = DTRequest.GetFormString("txtTitle"); string _user_name = DTRequest.GetFormString("txtUserName"); string _user_tel = DTRequest.GetFormString("txtUserTel"); string _email = DTRequest.GetFormString("txtEmail"); string _site_url = DTRequest.GetFormString("txtSiteUrl"); string _img_url = DTRequest.GetFormString("txtImgUrl"); //校检验证码 if (string.IsNullOrEmpty(_code)) { context.Response.Write("{msg:0, msgbox:\"对不起,请输入验证码!\"}"); return; } if (context.Session[DTKeys.SESSION_CODE] == null) { context.Response.Write("{msg:0, msgbox:\"对不起,系统找不到生成的验证码!\"}"); return; } if (_code.ToLower() != (context.Session[DTKeys.SESSION_CODE].ToString()).ToLower()) { context.Response.Write("{msg:0, msgbox:\"您输入的验证码与系统的不一致!\"}"); return; } if (string.IsNullOrEmpty(_title)) { context.Response.Write("{msg: 0, msgbox: \"对不起,请输入网站标题!\"}"); return; } if (string.IsNullOrEmpty(_site_url)) { context.Response.Write("{msg: 0, msgbox: \"对不起,请输入网站网址!\"}"); return; } model.title = _title; model.is_lock = 1; model.is_red = 0; model.user_name = _user_name; model.user_tel = _user_tel; model.email = _email; model.site_url = _site_url; model.img_url = _img_url; model.is_image = 1; if (string.IsNullOrEmpty(model.img_url)) { model.is_image = 0; } if (bll.Add(model) > 0) { context.Response.Write("{msg: 1, msgbox: \"恭喜您,提交成功啦!\"}"); return; } context.Response.Write("{msg: 0, msgbox: \"对不起,保存过程中发生错误!\"}"); return; }