Пример #1
0
        public JSONArray ExecuteService(string parameter, string parameter2)
        {
            string  stree  = parameter.ToString();
            string  stree2 = parameter2.ToString();
            JObject jsooo  = (JObject)JsonConvert.DeserializeObject(stree2);
            //连接数据库
            //连接字符串
            string        constr = "server=.;database=AIS20190425233758;uid=sa;pwd=123";
            SqlConnection sqlc   = new SqlConnection(constr);

            sqlc.Open();

            //查看,若使用批量查询,需将where条件做字符串拼接,在for循环中加二次遍历
            string         findstr = "select * from " + stree + " where FBILLNO = '" + jsooo["Number"].ToString() + "'";
            SqlDataAdapter sqlda   = new SqlDataAdapter(findstr, sqlc);
            //结果集保存
            DataSet ds = new DataSet();

            sqlda.Fill(ds, "test");
            sqlc.Close();
            JSONObject jsob      = new JSONObject();
            JSONArray  jsonArray = new JSONArray();

            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                string ssh = ds.Tables[0].Columns[i].ToString();
                string sss = ds.Tables[0].Rows[0][ssh].ToString();

                jsob.Add(ssh, sss);
                jsonArray.Add("{" + jsob.ElementAt(i).Key + ":" + jsob.ElementAt(i).Value + "}");
            }
            return(jsonArray);
        }