erp/SiteCore/Handler/app.vr.cs

using SQLData;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SiteCore.Handler
{
    public partial class app
    {
        public void get_vrlist()
        {
            DataStruct dStruct = GetPostStruct();
            dStruct.PageSize = 20;
            List<string> lw = new List<string>();

            dStruct.Order = "id asc";

            dStruct.MainWhere = string.Join(" and ", lw.ToArray());
            dStruct.Fileds = "*";
            DataTable dt = WebCache.GetData("s_vrlist", dStruct);
            conGridJson(dStruct.TotalCount, Utils.Serialization.JsonString.DataTable2LowerAjaxJson(dt));
        }

        public void get_allvrlist()
        {
            string sql = "select * from s_vrlist";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            conGridJson(dt.Rows.Count, Utils.Serialization.JsonString.DataTable2LowerAjaxJson(dt));
        }

        public void get_vrpath()
        {
            if(UrlPostParmsCheck("vid"))
            {
                int vid = GetPostInt("vid");
                string sql = "select name,vrpath from s_vrlist where id=" + vid;
                DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
                conGridJson(dt.Rows.Count, Utils.Serialization.JsonString.DataTable2LowerAjaxJson(dt));
                return;
            }
            conGridJson(0,"[]");
        }
    }
}