nothing

zzr99

2021-10-29 5057ba80001ab72765800b8fc008828d099b17dc

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
using WebAPI.DbUntil;
 
namespace WebAPI.Controllers
{
    public class ReportFromController : ApiController
    {
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public WebServer webserver = new WebServer();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
 
 
        #region [动态列表]
        [Route("Sc_MESReportFrom/ReportFromBillList")]
        [HttpGet]
        public object ReportFrom(int page,int limit,string sWhere)
        {
            List<object> columnNameList = new List<object>();
            try
            {
                int count = 0;
                int pageNum = page;
                int pageSize = limit;
                if (sWhere == null || sWhere.Equals(""))
                {
                    sWhere = " where 1=1";
                }
                else 
                {
                    sWhere = " where 1=1" + sWhere;
                }
               
                count = new SQLHelper.ClsCN().RunProcReturn("select HItemID,HNumber 编码,HName 姓名,HRemark 说明,HUseFlag 使用状态,HBirthDay 生日  from Gy_Employee " + sWhere, "Gy_Employee").Tables[0].Rows.Count;
                string sql = string.Format(@"select top " + pageSize + " HItemID,HNumber 编码,HName 姓名,HRemark 说明,HUseFlag 使用状态,HBirthDay 生日 from(select row_number() over (order by HBirthDay desc) as RowNumber,HItemID,HNumber,HName ,HRemark,HUseFlag,HBirthDay from Gy_Employee " + sWhere + ")   as A where RowNumber >" + pageSize + " *(" + pageNum + "-1)");
                ds=new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_IF_ICMOBillList_Table");
                string aa = ds.Tables[0].Columns[0].ToString();
                
                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列对象的列名
                }
    
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = count;
                    objJsonResult.Message = "获取资源绑定数据成功！";
                    objJsonResult.data =JsonConvert.DeserializeObject<DataTable>(JsonConvert.SerializeObject(ds.Tables[0], new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" }));  //序列化DataSet中的时间格式，然后再反序列化回来
                    objJsonResult.list = columnNameList;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "暂无资源绑定！";
                    objJsonResult.data = null;
                    objJsonResult.list = columnNameList;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
 
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = e.Message.ToString();
                objJsonResult.data = null;
                objJsonResult.list = columnNameList;
            }
            return objJsonResult;
        }
        #endregion
 
 
        #region [动态列表2]
        [Route("Sc_MESReportFrom/ReportFromBillList2")]
        [HttpGet]
        public object ReportFromBillList2(string sWhere)
        {
            try
            {
                string sql = "select HItemID,HNumber 代码,HName 名称 from Gy_Process where 1 = 1 " + sWhere;
                ds = new SQLHelper.ClsCN().RunProcReturn(sql, "Gy_Employee");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = DataFormatUntil.BackRowCount(sql, "Gy_Employee");
                    objJsonResult.Message = "Sucess！";
                    objJsonResult.data = ds.Tables[0];
                    objJsonResult.list = DataFormatUntil.BackColTitle(ds);
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false！";
                    objJsonResult.data = null;
                    objJsonResult.list = DataFormatUntil.BackColTitle(ds);
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
 
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message.ToString();
                objJsonResult.data = null;
                objJsonResult.list = null;
            }
            return objJsonResult;
        }
        #endregion
    }
}