예제 #1
0
        public string GetListData(string name, int pageIndex, int pageSize, out int rowCount)
        {
            string errMsgStr = "";

            rowCount = 0;
            string querySql = "select * from xt_zzjg_dwbm ";

            if (name.Length > 0)
            {
                querySql += "where dwmc like '%" + name + "%' ";
            }
            List <KeyValueItem> items = new List <KeyValueItem>();

            items.Add(new KeyValueItem("p_srcsql", querySql));
            items.Add(new KeyValueItem("p_pageindex", pageIndex));
            items.Add(new KeyValueItem("p_pagesize", pageSize));
            items.Add(new KeyValueItem("p_rowcount", rowCount));
            items.Add(new KeyValueItem("p_errmsg", errMsgStr));
            DataSet ds = dbases.ExecuteDataSet <KeyValueItem>("PKG_ZZJG_manage.proc_xt_zzjg_dwbm_list", items.ToArray());

            int.TryParse(items[items.Count - 2].Value.ToString(), out rowCount);
            var errMsg = items[items.Count - 1];

            return(EasyUIHelper.BuildDataGridDataSource(rowCount, ds.Tables[0]));
        }