Пример #1
0
        // POST api/<controller>
        public string Post(APIParmer value)
        {
            var myenum = (APIParmer.MyEnum)value.Type;
            var SQL    = "";

            switch (myenum)
            {
            case APIParmer.MyEnum.Select:
                var select    = value.Data as ActSelect;
                var selectsql = select.ToSQL();
                SQL = selectsql;
                break;

            case APIParmer.MyEnum.Insert:
                var insert    = value.Data as ActInsert;
                var insertsql = insert.ToSQL();
                SQL = insertsql;
                break;

            case APIParmer.MyEnum.Update:
                var update    = value.Data as ActUpdate;
                var updatesql = update.ToSQL();
                SQL = updatesql;
                break;

            case APIParmer.MyEnum.Delete:
                var delete    = value.Data as ActSelect;
                var deletesql = delete.ToSQL();
                SQL = deletesql;
                break;
            }

            if (!string.IsNullOrEmpty(SQL))
            {
            }

            return("");
        }
Пример #2
0
        // POST api/<controller>
        public string Post(APIParmer parmer)
        {
            var SQL = "";
            var res = new ActResult();

            try
            {
                var myenum = (ComEnum.ActEnum)parmer.Type;
                var type   = (DBTypeEnum.DBType)Enum.Parse(typeof(DBTypeEnum.DBType), ComWebSetting.DBType);
                switch (myenum)
                {
                case ComEnum.ActEnum.Select:
                    //查尽量带t {"Type":"1","Data":"{'tablename':'xs_zdjbxx t','fields':'t.zl,t.ysdm','WhereT':'t.zddm=^610821104200GB00039^'}"}
                    var select    = parmer.GetAct() as ActSelect;
                    var selectsql = select.ToSQL();
                    SQL = selectsql;
                    if (!string.IsNullOrEmpty(SQL))
                    {
                        var dt = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBSelectDT(SQL);
                        res.Data = JsonConvert.SerializeObject(dt);
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.Insert:
                    //增values不加引号 {"Type":"2","Data":"{'tablename':'xs_zdjbxx','fields':'zl,ysdm','values':'神木县大柳塔镇光明路66666,666666'}"}
                    var insert    = parmer.GetAct() as ActInsert;
                    var insertsql = insert.ToSQL();
                    SQL = insertsql;
                    if (!string.IsNullOrEmpty(SQL))
                    {
                        res.Data = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBInsert(SQL).ToString();
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.Update:
                    //更新values不加引号 {"Type":"3","Data":"{'tablename':'xs_zdjbxx t','fields':'zl,ysdm','values':'神木县大柳塔镇光明路,6001010001','WhereT':'t.zddm=^610821104200GB00039^'}"}
                    var update    = parmer.GetAct() as ActUpdate;
                    var updatesql = update.ToSQL();
                    SQL = updatesql;
                    if (!string.IsNullOrEmpty(SQL))
                    {
                        res.Data = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBUpdata(SQL).ToString();
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.Delete:
                    //删除 {"Type":"4","Data":"{'tablename':'xs_zdjbxx','wheret':'ysdm=^666666^'}"}
                    var delete    = parmer.GetAct() as ActDelete;
                    var deletesql = delete.ToSQL();
                    SQL = deletesql;
                    if (!string.IsNullOrEmpty(SQL))
                    {
                        res.Data = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBDelete(SQL).ToString();
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.Other:
                    //多条不用begin不行 {"Type":"5","Data":"begin update xs_zdjbxx set zl=zl||'1' where zddm='610821104200GB00030';update xs_zdjbxx set zl=zl||'2' where zddm='610821104200GB00031'; end;"}
                    SQL = parmer.GetAct().ToString();
                    if (!string.IsNullOrEmpty(SQL))
                    {
                        res.Data = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBOther(SQL).ToString();
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.SelectPageProc:
                    PageParam pageparam = parmer.GetAct() as PageParam;
                    if (pageparam != null)
                    {
                        var     intup  = new Tuple <string, int, int>(pageparam.PageSQL, pageparam.PageSize, pageparam.PageCurrt);
                        var     outtup = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).DBProcPage(intup);
                        ComPage page   = new ComPage(outtup);
                        res.Data = JsonConvert.SerializeObject(page);
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;

                case ComEnum.ActEnum.Proc:
                    ComProcParam procparam = parmer.GetAct() as ComProcParam;
                    if (procparam != null)
                    {
                        res.Data = DBExecute.DBAct.InitDBAct(type, ComWebSetting.ConnectString).Proc(procparam.ProcName, procparam.GetOracleParam(), procparam.IsRetTable).ToString();
                        res.Code = ComEnum.EnumActResult.Success;
                        res.Msg  = "操作成功!";
                    }
                    break;
                }
                if (res.Code != ComEnum.EnumActResult.Success)
                {
                    res.Code = ComEnum.EnumActResult.Error;
                    res.Msg  = "操作失败!参数转换不合规范";
                }
            }
            catch (Exception ex)
            {
                res.Code = ComEnum.EnumActResult.Exception;
                res.Msg  = "接口异常!请确认参数是否正确!";
                Log.LogInBatchExceptWrite(ex, parmer.Data.ToString(), SQL);
            }
            return(JsonConvert.SerializeObject(res));
        }