1 引用
2 #region 程序集 Newtonsoft.Json.dll, v4.5.0.0
3 // E:\Newtonsoft.Json.dll
4 #endregion
5 public DataTable RunProc(string ProcName, string Parameter)
6 {
7 try
8 {
9 db = new DataBaseDoor(GetConnection.getcon());
10 DataSet ds = new DataSet();
11 JsonTextReader JR = new JsonTextReader(new StringReader(Parameter));
12 int i = 0;
13
14
15 while (JR.Read())
16 {
17 if(JR.Value!=null&&JR.Value.ToString()!=",")
18 {
19 i++;
20 }
21 //JR.TokenType;
22 // JR.Value;
23 // JR.ValueType;
24 }
25 SqlParameter[] para = new SqlParameter[i/2];
26
27 JsonTextReader JTR = new JsonTextReader(new StringReader(Parameter));
28
29 int j = 0;
30 string key = "";
31 string value = "";
32 while (JTR.Read())
33 {
34
35 if (JTR.Value != null && JTR.Value.ToString() != ",")
36 {
37 if (j <= i)
38 {
39 if (j % 2 == 0)
40 {
41
42 key = "";
43 if (JTR.Value != null)
44 {
45 key = JTR.Value.ToString().Replace("!@!", "\"");
46 }
47 }
48 else
49 {
50 value = "";
51 if (JTR.Value != null)
52 {
53 value = JTR.Value.ToString().Replace("!@!", "\"");
54 para[((j+1)/2)-1] = new SqlParameter("@" + key, value);
55 }
56 }
57
58 }
59 j++;
60 }
61 }
62 db.RunProcedure(ProcName, para, ref ds);
63
64 return ds.Tables[0];
65 }
66 catch (Exception ex)
67 {
68 throw ex;
69 }
70 finally
71 {
72 db.CloseConnection();
73 }
74 }
75 //JS调用 以及字符串特殊字符替换规则
76
77 var parameter = "{ ID:" + ID + ",Name:'" + $.trim($('#txt_groupname').val()).replace(/"/ig, '!@!') + "'}";
78
79 var result = RunNewProc('sp_UserLevel_AddGroupName', parameter);
80
81
82 function RunNewProc(procname, Parameter) {
83
84 if (procname.length > 0) {
85 var returnmsg = ErpAjax("/RunProcedure.aspx?Proc=" + procname + "&Parameter="+Parameter+"");
86 if (returnmsg.length > 0) {
87 return returnmsg;
88 }
89 else {
90 return '操作失败';
91 }
92 }
93 }
94
95 function ErpAjax(url) {
96 var xmlhttp;
97 if (url.indexOf("?") > 0) {
98 url = url + "&NowDateTimeSign=" + new Date().getTime();
99 }
100 else {
101 url = url + "?NowDateTimeSign=" + new Date().getTime();
102 }
103 if (window.ActiveXObject) {
104 xmlhttp = new ActiveXObject('Microsoft.XMLHTTP');
105 }
106 else {
107 xmlhttp = new XMLHttpRequest();
108 }
109
110 var url1 = url.split('?');
111 var url2 = url1[1].toString().split('&');
112
113 var furl = url1[0].toString() + "?";
114
115 for (var i = 0; i < url2.length; i++) {
116 var j = url2[i].indexOf('=');
117
118 if (i == 0) {
119 furl += url2[i].toString().substring(0, j) + "=" + encodeURIComponent(url2[i].toString().substring(j + 1));
120 }
121 else {
122 furl += "&" + url2[i].toString().substring(0, j) + "=" + encodeURIComponent(url2[i].toString().substring(j + 1));
123 }
124 }
125 //encodeURIComponent
126 xmlhttp.open("POST", furl, false);
127
128 xmlhttp.send();
129 return xmlhttp.responseText;
130
131 }
