public static DataSet ProcedureRDataTable(HttpContext context, string storedProcName) { using (ConnDB db = new ConnDB()) { context.Response.ContentType = "text/json"; context.Response.Charset = "utf-8"; context.Response.Cache.SetNoStore(); SqlParameter[] pList; if (context.Request.HttpMethod == "GET") { //获取url?后的键和值 var all_url = context.Request.Url; string[] s1 = all_url.ToString().Split('?'); if (s1.Length > 1) { string[] s2 = s1[1].Split('&'); pList = new SqlParameter[s2.Length]; for (int i = 0; i < s2.Length; i++) { string name = s2[i].Split('=')[0]; //键值 string val = s2[i].Split('=')[1]; //对应的值 SqlParameter par = new SqlParameter(); par.ParameterName = "@" + name; par.SqlDbType = SqlDbType.NVarChar; par.SqlValue = val; pList[i] = par; } return(db.RunProcedureRdataSet(storedProcName, pList)); } else { return(db.RunProcedureRdataSet(storedProcName)); } } else if (context.Request.HttpMethod == "POST") { //获取url?后的键和值 var pForm = context.Request.Form.AllKeys; if (pForm.Length > 0) { pList = new SqlParameter[pForm.Length]; for (int i = 0; i < pForm.Length; i++) { string name = pForm[i]; //键值 string val = context.Request.Form[pForm[i]]; //对应的值 SqlParameter par = new SqlParameter(); par.ParameterName = "@" + name; par.SqlDbType = SqlDbType.NVarChar; par.SqlValue = val; pList[i] = par; } return(db.RunProcedureRdataSet(storedProcName, pList)); } else { return(db.RunProcedureRdataSet(storedProcName)); } } } return(null); }