From a0aa7dbfd9b42eca6e3cf2c095b88d59d5212951 Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期三, 21 九月 2022 12:30:35 +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