From cc775470bb566f87081af30682aa9f5d093a2bbd Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 12 一月 2024 13:11:47 +0800
Subject: [PATCH] (按生产订单)客户订单报表、生产入库报表、不良原因分析报表、生产日记、流转卡未入库报表、半成品报表、工序异常过站报表、白坯发布汇总报表、白坯发布明细报表、染厂汇总报表、染厂明细报表、染厂产量报表、领料统计报表、后整一号_缩刷出站报表、后整一号_定型出站报表、后整一号_烫光出站报表、后整二号_缩刷出站报表、后整二号_定型出站报表、后整二号_烫光出站报表、后整三号_烘干定型出站报表、后整三号_上浆定型出站报表、后整三号_刷毛出站报表、后整三号_色胚烫光出站报表、特整_缩刷出站报表、特整_压花出站报表、特整_立体花型机出站报表：增加查询权限
---
WebAPI/DbUntil/DataFormatUntil.cs | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/WebAPI/DbUntil/DataFormatUntil.cs b/WebAPI/DbUntil/DataFormatUntil.cs
index 5779273..381cd8d 100644
--- a/WebAPI/DbUntil/DataFormatUntil.cs
+++ b/WebAPI/DbUntil/DataFormatUntil.cs
@@ -4,6 +4,7 @@
using System.Linq;
using System.Reflection;
using System.Web;
+using Newtonsoft.Json;
namespace WebAPI.DbUntil
{
@@ -64,5 +65,28 @@
}
return entity;
}
+
+ #region 杩斿洖sql褰卞搷琛屾暟
+ public static int BackRowCount(string sql,string tableName)
+ {
+ return new SQLHelper.ClsCN().RunProcReturn(sql, tableName).Tables[0].Rows.Count;
+ }
+ #endregion
+
+ #region 杩斿洖sql杩斿洖鐨勬暟鎹爣棰�
+ public static List<object> BackColTitle(DataSet ds)
+ {
+ List<object> columnNameList = new List<object>();
+ foreach (DataColumn col in ds.Tables[0].Columns)
+ {
+
+ Type dataType = col.DataType;
+ string ColmString = "{\"ColmName\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+ columnNameList.Add(JsonConvert.DeserializeObject(ColmString));
+ }
+ return columnNameList;
+ }
+ #endregion
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1