コード例 #1
0
        public ActionResult GetTextButtonQueryResult(string sql)
        {
            Ctx         ctx  = Session["ctx"] as Ctx;
            SqlParamsIn sqlP = new SqlParamsIn();

            sql      = SecureEngineBridge.DecryptByClientKey(sql, ctx.GetSecureKey());
            sqlP.sql = sql;
            VIS.Helpers.SqlHelper help = new Helpers.SqlHelper();
            return(Json(JsonConvert.SerializeObject(help.ExecuteJDataSet(sqlP)), JsonRequestBehavior.AllowGet));
        }
コード例 #2
0
        public ActionResult GetPrintFormatDetails(int AD_Table_ID)
        {
            Ctx       ctx   = Session["ctx"] as Ctx;
            FormModel model = new FormModel(ctx);

            string sql = MRole.GetDefault(ctx).AddAccessSQL(
                "SELECT AD_PrintFormat_ID, Name, Description,IsDefault "
                + "FROM AD_PrintFormat "
                + "WHERE AD_Table_ID= " + AD_Table_ID
                + " ORDER BY Name",
                "AD_PrintFormat", MRole.SQL_NOTQUALIFIED, MRole.SQL_RO);


            SqlParamsIn sqlP = new SqlParamsIn();

            sqlP.sql = sql;

            VIS.Helpers.SqlHelper help   = new Helpers.SqlHelper();
            List <JTable>         result = help.ExecuteJDataSet(sqlP);

            return(Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet));
        }