Пример #1
0
        public DataTable GetSSLBInfos(string strWhere, System.Web.HttpRequest context, params object[] objValues)//GetSSLBInfos(out string strError, string dwbm, string gh, System.Web.HttpRequest context)
        {
            //strError = "";
            //EDRS.Common.IceServicePrx iceprx = new IceServicePrx();
            XT_DM_AJLBBM bll = new XT_DM_AJLBBM(context);
            DataSet      ds  = bll.GetSSLBList(strWhere, objValues);

            if (ds != null && ds.Tables.Count > 0)
            {
                return(ds.Tables[0]);
            }
            return(null);

            //string msg = "";
            //msg = GetConfiguration(dwbm, gh, iceprx);
            //return iceprx.GetSSLBInfos(out strError);
        }
Пример #2
0
        /// <summary>
        /// 绑定列表
        /// </summary>
        /// <returns></returns>
        public string ListBind()
        {
            string page = Request.Form["page"];
            string rows = Request.Form["pagesize"];
            string key  = Request.Form["key"];
            string ywbm = Request.Form["ywbm"];

            int pageNumber = int.Parse(page);
            int pageSize   = int.Parse(rows);

            string where = string.Empty;

            List <object> values = new List <object>();

            if (!string.IsNullOrEmpty(key))
            {
                where += " and AJLBMC like :AJLBMC ";
                values.Add("%" + key + "%");
            }
            if (!string.IsNullOrEmpty(ywbm))
            {
                where += " and YWBM = :YWBM ";
                values.Add(ywbm);
            }

            EDRS.BLL.XT_DM_AJLBBM bll = new EDRS.BLL.XT_DM_AJLBBM(this.Request);

            DataSet ds = bll.GetListByPage(where + " and SFSC = 'N' ", " ajlbbm asc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values.ToArray());

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                //数据日志
                OperateLog.AddLog(OperateLog.LogType.参数配置Web, "类别绑定成功", UserInfo, UserRole, this.Request);
                int       count = bll.GetRecordCount(where + " and SFSC='N' ", values.ToArray());
                DataTable dt    = (ds.Tables[0]).Copy();

                return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}");
            }
            //数据日志
            OperateLog.AddLog(OperateLog.LogType.参数配置Web, "类别绑定列表未找到信息", UserInfo, UserRole, this.Request);
            return(ReturnString.JsonToString(Prompt.error, "未找到类别", null));
        }