| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | //判断查询权限 |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 1, false, user)) |
|---|
| | | { |
|---|
| | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Xs_SeOrderBillList_Query " + page + "," + size + ",'" + Organization + "','" + sWhere + "',2", "h_p_Xs_SeOrderBillList_Query"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
| | | { |
|---|
| | | Type dataType = col.DataType; |
|---|
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
|---|
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 |
|---|
| | | } |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | | objJsonResult.list = columnNameList; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
