Exemple #1
0
        /// <summary>
        /// 异步方法
        /// </summary>
        /// <param name="SPname">存储过程名称</param>
        /// <param name="LD">参数集合</param>
        /// <param name="RouteName">路由名称</param>
        /// <returns></returns>
        public async Task <BllClass> CallWebAPI_Async(string SPname, List <DbParameter> LD, string RouteName)
        {
            List <IoRyDbParameter> li = new List <IoRyDbParameter>();

            foreach (var item in LD)
            {
                IoRyDbParameter ip = new IoRyDbParameter();
                ip.Name  = item.ParameterName;
                ip.Value = Convert.ToString(item.Value);
                li.Add(ip);
            }
            BllClass bc = new BllClass();

            bc.RouteName = RouteName;
            DLLjson dj = new DLLjson();

            dj.SQL_string = SPname;
            dj.ConfigPath = this.ConfigPth;
            dj.DbParaList = li;
            bc.JsonIn     = JsonConvert.SerializeObject(dj);
            string rts = await CallWebAPI_Async(bc);

            BllClass bcrt = JsonConvert.DeserializeObject <BllClass>(rts);

            if (!bcrt.IsNormal)
            {
                throw new Exception(bcrt.ErrorMsg);
            }
            return(bcrt);
        }
Exemple #2
0
        /// <summary>
        /// 同步调用方法
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="RouteName">路由名称</param>
        /// <returns></returns>
        public BllClass CallWebAPI_Syn(string sql, string RouteName)
        {
            BllClass bc = new BllClass();

            bc.RouteName = RouteName;
            DLLjson dj = new DLLjson();

            dj.SQL_string = sql;
            dj.ConfigPath = this.ConfigPth;
            bc.JsonIn     = JsonConvert.SerializeObject(dj);
            string   rts  = CallWebAPI_Syn(bc);
            BllClass bcrt = JsonConvert.DeserializeObject <BllClass>(rts);

            if (!bcrt.IsNormal)
            {
                throw new Exception(bcrt.ErrorMsg);
            }
            return(bcrt);
        }
Exemple #3
0
        /// <summary>
        /// 异步方法
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="cuser">操作者</param>
        /// <param name="RouteName">路由名称</param>
        /// <returns></returns>
        public async Task <BllClass> CallWebAPI_Async(string sql, string cuser, string RouteName)
        {
            BllClass bc = new BllClass();

            bc.RouteName = RouteName;
            DLLjson dj = new DLLjson();

            dj.SQL_string = sql;
            dj.ConfigPath = this.ConfigPth;
            dj.Operater   = cuser;
            bc.JsonIn     = JsonConvert.SerializeObject(dj);
            string rts = await CallWebAPI_Async(bc);

            BllClass bcrt = JsonConvert.DeserializeObject <BllClass>(rts);

            if (!bcrt.IsNormal)
            {
                throw new Exception(bcrt.ErrorMsg);
            }
            return(bcrt);
        }