MES-WEB-API.git

			@@ -6,8 +6,13 @@
			using System.Collections.Generic;
			using System.Data;
			using System.Data.SqlClient;
			using System.Web;
			using System.Web.Http;
			using WebAPI.Models;
			using WebAPI.Controllers.SCGL.æ¥è®¡åç®¡ç;
			using System.IO;
			using System.Linq;
			using System.Text;

			namespace WebAPI.Controllers
			{
			@@ -950,5 +955,463 @@
			#endregion



			#region æä»¶ä¸ä¼
			[Route("CB_ItemMoneyBillController/CB_ItemMoneyBill_Excel")]
			[HttpPost]
			public json CB_ItemMoneyBill_Excel()
			{
			json res = new json();
			try
			{
			//è·åæä»¶åç§°
			var file = HttpContext.Current.Request.Files[0];
			//è·åæä»¶ç©çè·¯å¾
			string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
			//ä¿åæä»¶
			file.SaveAs(ExcelPath);

			SCGL.æ¥è®¡åç®¡ç.NpoiHelper np = new NpoiHelper();
			DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0");

			//å é¤æä»¶
			File.Delete(ExcelPath);

			//åå»ºä¸´æ¶è¡¨
			DataTable provisional = new DataTable("dt2");

			//æ·»å åå
			for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)
			{
			provisional.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());
			}
			provisional.Columns.Add("åæ®å·", typeof(string));

			//æ·»å æ°æ®
			for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
			{
			DataRow row = provisional.NewRow();
			for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
			{
			row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
			}
			provisional.Rows.Add(row);
			}

			//å¤æå
			string error = JudgmentColumns(provisional);
			if (error.Length > 0)
			{
			res.code = "0";
			res.count = 0;
			res.Message = $"Excelæ¨¡æ¿åå¨éè¯¯,{error}\r\n";
			res.data = null;
			return res;
			}

			for (int i = 0; i <= provisional.Rows.Count - 1; i++)
			{
			//string HBillNo= DBUtility.ClsPub.CreateBillCode("1802", ref DBUtility.ClsPub.sExeReturnInfo, true);
			//provisional.Rows[i]["åæ®å·"] = HBillNo;
			string HDepNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["é¨é¨ä»£ç "].ToString());
			string HDepName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["é¨é¨"].ToString());

			string HEmpNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["èåä»£ç "].ToString());
			string HEmpName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["èå"].ToString());

			string HICMOBillNo = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["çäº§è®¢åå·"].ToString());
			string HProc = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å·¥åº"].ToString());

			string HCostItemNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ææ¬é¡¹ç®ä»£ç "].ToString());
			string HCostItemName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ææ¬é¡¹ç®"].ToString());

			//string HEntryID = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åè¡¨åç "].ToString());

			//string HDepNumber_sub = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åé¨é¨ä»£ç "].ToString());
			//string HDepName_sub = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åé¨é¨"].ToString());

			string HMaterNumber = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç©æç¼ç "].ToString());
			string HMaterName = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["ç©æåç§°"].ToString());

			string HQty = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æ°é"].ToString());
			string HPrice = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["åä»·"].ToString());
			string HMoney = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["éé¢"].ToString());
			string HWaster = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["æèé"].ToString());
			//string HRelationQty = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å³èæ°é"].ToString());
			//string HRelationMoney = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å³èéé¢"].ToString());
			string remark = DBUtility.ClsPub.isStrNull(provisional.Rows[i]["å¤æ³¨"].ToString());

			//è·åçå®è¡æ°
			int line = i + 1;
			}

			res.code = "1";
			res.count = 1;
			res.Message = error;
			res.data = provisional;
			return res;
			}
			catch (Exception e)
			{
			res.code = "0";
			res.count = 0;
			res.Message = "Exceptionï¼" + e.ToString();
			res.data = null;
			return res;
			}
			}

			/// <summary>
			/// å¤æå
			/// </summary>
			/// <param name="provisional"></param>
			/// <returns></returns>
			private static string JudgmentColumns(DataTable provisional)
			{
			var error = "";

			//æ¥è¯¢æ²¡æçå
			//if (!provisional.Columns.Contains("åè¡¨åç "))
			// error += "æ²¡ææ¾å°ãåè¡¨åç ãçæ é¢,";

			if (!provisional.Columns.Contains("ç©æç¼ç "))
			error += "æ²¡ææ¾å°ãç©æç¼ç ãçæ é¢,";
			return error;
			}
			#endregion

			#region ä¸ä¼ ä¿å
			[Route("CB_ItemMoneyBillController/Excel_btnSave")]
			[HttpPost]
			public object Excel_btnSave([FromBody] JObject sMainSub)
			{
			var _value = sMainSub["sMainSub"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string user = sArray[1].ToString();
			string organ = sArray[2].ToString();
			json res = new json();

			try
			{
			oCN.BeginTran();
			List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2);
			List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();

			foreach (JObject item in Excel)
			{
			Dictionary<string, string> dic = new Dictionary<string, string>();
			foreach (var itm in item.Properties())
			{
			dic.Add(itm.Name, itm.Value.ToString());
			}
			list.Add(dic);
			}

			// 1. æ¶éææéè¦æ¥è¯¢çæ°æ®
			var HBillnos = list.Select(x => x["åæ®å·"].ToString()).Distinct().ToList();
			var HProc = list.Select(x => x["å·¥åº"].ToString()).Distinct().ToList();
			//var HDeptNames = list.Select(x => x["é¨é¨"].ToString()).Distinct().ToList();
			//var HDeptNumbers = list.Select(x => x["é¨é¨ä»£ç "].ToString()).Distinct().ToList();
			var HDeptNames_sub = list.Select(x => x["é¨é¨"].ToString()).Distinct().ToList();
			var HDeptNumbers_sub = list.Select(x => x["é¨é¨ä»£ç "].ToString()).Distinct().ToList();
			var materialNumbers = list.Select(x => x["ç©æç¼ç "].ToString()).Distinct().ToList();
			var materialNames = list.Select(x => x["ç©æåç§°"].ToString()).Distinct().ToList();
			//var EmpNumbers = list.Select(x => x["èåä»£ç "].ToString()).Distinct().ToList();
			//var EmpNames = list.Select(x => x["èå"].ToString()).Distinct().ToList();
			var EmpNumbers = list.Select(x => x["èåä»£ç "]?.ToString())
			.Where(s => !string.IsNullOrEmpty(s))
			.Distinct()
			.ToList();
			var EmpNames = list.Select(x => x["èå"]?.ToString())
			.Where(s => !string.IsNullOrEmpty(s))
			.Distinct()
			.ToList();
			var CostNumbers = list.Select(x => x["ææ¬é¡¹ç®ä»£ç "].ToString()).Distinct().ToList();
			var CostNames = list.Select(x => x["ææ¬é¡¹ç®"].ToString()).Distinct().ToList();
			var ICMONumbers = list.Select(x => x["çäº§è®¢åå·"].ToString()).Distinct().ToList();

			// 2. æ¹éæ¥è¯¢çäº§è®¢ååç
			string ICMOQuery = $"SELECT HInterID,HBillNo FROM Sc_ICMOBillMain WHERE HBillNo IN ({string.Join(",", ICMONumbers.Select(s => $"'{s.Replace("'", "''")}'"))}) and HPRDORGID={organ}";
			DataSet icmoData = oCN.RunProcReturn(ICMOQuery, "Sc_ICMOBillMain");
			Dictionary<string, int> ICMODict = new Dictionary<string, int>();
			foreach (DataRow row in icmoData.Tables[0].Rows)
			{
			ICMODict[row["HBillNo"].ToString()] = (int)row["HInterID"];
			}

			//// 2. æ¹éæ¥è¯¢ä¸»åè¡¨é¨é¨ä¿¡æ¯
			//string supplierQuery = $"SELECT HItemID, HName FROM Gy_Department WHERE HName IN ({string.Join(",", HDeptNames.Select(s => $"'{s.Replace("'", "''")}'"))})";
			//DataSet supData = oCN.RunProcReturn(supplierQuery, "Gy_Department");
			//Dictionary<string, int> supplierDict = new Dictionary<string, int>();
			//foreach (DataRow row in supData.Tables[0].Rows)
			//{
			// supplierDict[row["HName"].ToString()] = (int)row["HItemID"];
			//}

			// 2.1 æ¹éæ¥è¯¢ä¸»åè¡¨é¨é¨ä¿¡æ¯
			string supplierQuery_sub = $"SELECT HItemID, HName FROM Gy_Department WHERE HName IN ({string.Join(",", HDeptNames_sub.Select(s => $"'{s.Replace("'", "''")}'"))}) and HUSEORGID ={organ}";
			DataSet supData_sub = oCN.RunProcReturn(supplierQuery_sub, "Gy_Department");
			Dictionary<string, int> supplierDict_sub = new Dictionary<string, int>();
			foreach (DataRow row in supData_sub.Tables[0].Rows)
			{
			supplierDict_sub[row["HName"].ToString()] = (int)row["HItemID"];
			}

			// 3. æ¹éæ¥è¯¢ç©æä¿¡æ¯
			string materialQuery =
			$"SELECT HItemID, HNumber, HName FROM Gy_Material WHERE HNumber IN ({string.Join(",", materialNumbers.Select(m => $"'{m.Replace("'", "''")}'"))}) AND HName IN ({string.Join(",", materialNames.Select(m => $"'{m.Replace("'", "''")}'"))}) and HUSEORGID ={organ}";
			DataSet materData = oCN.RunProcReturn(materialQuery, "Gy_Material");
			Dictionary<string, int> materialDict = new Dictionary<string, int>();
			foreach (DataRow row in materData.Tables[0].Rows)
			{
			string key = $"{row["HNumber"]}_{row["HName"]}";
			materialDict[key] = (int)row["HItemID"];
			}
			if (EmpNames.Count == 0 && EmpNumbers.Count == 0)
			{

			}
			// 3. æ¹éæ¥è¯¢èåä¿¡æ¯
			string empNumbersIn = EmpNumbers.Any()
			? string.Join(",", EmpNumbers.Select(m => $"'{m.Replace("'", "''")}'"))
			: "''";
			string empNamesIn = EmpNames.Any()
			? string.Join(",", EmpNames.Select(m => $"'{m.Replace("'", "''")}'"))
			: "''";
			string EmployeeQuery = $"SELECT HItemID, HNumber, HName FROM Gy_Employee WHERE HNumber IN ({empNumbersIn}) AND HName IN ({empNamesIn}) and HUSEORGID ={organ}";
			DataSet EmpData = oCN.RunProcReturn(EmployeeQuery, "Gy_Employee");
			Dictionary<string, int> EmpDict = new Dictionary<string, int>();
			foreach (DataRow row in EmpData.Tables[0].Rows)
			{
			string key = $"{row["HName"].ToString()}";
			EmpDict[key] = (int)row["HItemID"];
			}

			// 3. æ¹éæ¥è¯¢chengbenxiangmuä¿¡æ¯
			string CostQuery = $"SELECT HItemID, HNumber, HName FROM Gy_CostItem WHERE HNumber IN ({string.Join(",", CostNumbers.Select(m => $"'{m.Replace("'", "''")}'"))}) AND HName IN ({string.Join(",", CostNames.Select(m => $"'{m.Replace("'", "''")}'"))}) and HUSEORGID ={organ}";
			DataSet CostData = oCN.RunProcReturn(CostQuery, "Gy_CostItem");
			Dictionary<string, int> CostDict = new Dictionary<string, int>();
			foreach (DataRow row in CostData.Tables[0].Rows)
			{
			string key = $"{row["HName"].ToString()}";
			CostDict[key] = (int)row["HItemID"];
			}
			// 3.1 æ¹éæ¥è¯¢å·¥åºä¿¡æ¯
			string ProcessQuery = $"SELECT HItemID, HNumber, HName FROM Gy_Process WHERE HName IN ({string.Join(",", HProc.Select(m => $"'{m.Replace("'", "''")}'"))}) and HUSEORGID ={organ}";
			DataSet ProcData = oCN.RunProcReturn(ProcessQuery, "Gy_Process");
			Dictionary<string, int> ProcDict = new Dictionary<string, int>();
			foreach (DataRow row in ProcData.Tables[0].Rows)
			{
			string key = $"{row["HName"].ToString()}";
			ProcDict[key] = (int)row["HItemID"];
			}
			// 4. æ¥è¯¢ç¨æ·ä¿¡æ¯
			DataSet emp = oCN.RunProcReturn($"SELECT Czybm FROM Gy_Czygl WHERE Czymc = '{user.Replace("'", "''")}'", "Gy_Czygl");
			if (emp.Tables[0].Rows.Count == 0)
			{
			res.code = "0";
			res.count = 0;
			res.Message = "ç¨æ·ä¸åå¨ï¼";
			res.data = null;
			return res;
			}
			string HUserID = emp.Tables[0].Rows[0]["Czybm"].ToString();

			// 5. æ£æ¥ç¼ºå¤±çé¨é¨åç©æï¼å¹¶è®°å½è¡å·
			List<string> missingSupplierMessages = new List<string>();
			List<string> missingMaterialMessages = new List<string>();
			List<string> missingCostMessages = new List<string>();
			List<string> missingmoneyMessages = new List<string>();
			List<string> missingEmployeeMessages = new List<string>();

			// éåæ¯ä¸è¡æ°æ®ï¼è®°å½è¡å·ï¼ä»1å¼å§ï¼
			for (int i = 0; i < list.Count; i++)
			{
			var item = list[i];
			int lineNumber = i + 1; // è¡å·ä»1å¼å§

			string ICMOcheck = item["çäº§è®¢åå·"];
			string Costcheck = item["ææ¬é¡¹ç®"];
			string Procheck = item["å·¥åº"];
			string supplier = item["é¨é¨"];
			string materialNumber = item["ç©æç¼ç "];
			string materialName = item["ç©æåç§°"];
			string monetcheck = item["éé¢"];
			string materialKey = $"{materialNumber}_{materialName}";
			string empName = item["èå"];
			if (!string.IsNullOrEmpty(empName) && !EmpDict.ContainsKey(empName))
			{
			missingEmployeeMessages.Add($"ç¬¬{lineNumber}è¡çèåã{empName}ã");
			}
			// æ£æ¥ä¾åºå
			if (!supplierDict_sub.ContainsKey(supplier))
			{
			missingSupplierMessages.Add($"ç¬¬{lineNumber}è¡çé¨é¨ã{supplier}ã");
			}

			// æ£æ¥ç©æ
			if (!materialDict.ContainsKey(materialKey))
			{
			missingMaterialMessages.Add($"ç¬¬{lineNumber}è¡çç©æã{materialName}(ç¼ç :{materialNumber})ã");
			}
			// æ£æ¥çäº§è®¢å
			if (!string.IsNullOrEmpty(ICMOcheck) && !ICMODict.ContainsKey(ICMOcheck))
			{
			missingMaterialMessages.Add($"ç¬¬{lineNumber}è¡ççäº§è®¢åã{ICMOcheck}ã");
			}
			// æ£æ¥é¡¹ç®ææ¬
			if (CostDict.Count == 0\|\| !CostDict.ContainsKey(Costcheck))
			{
			missingCostMessages.Add($"ç¬¬{lineNumber}è¡çé¡¹ç®ææ¬ã{Costcheck}ã");
			}
			// æ£æ¥å·¥åº
			if (ProcDict.Count == 0 && Procheck != "")
			{
			missingCostMessages.Add($"ç¬¬{lineNumber}è¡çå·¥åºã{Procheck}ã");
			}
			if (monetcheck == "" \|\| monetcheck == null)
			{
			missingmoneyMessages.Add($"ç¬¬{lineNumber}è¡éé¢ã{monetcheck}ã");
			}
			}

			StringBuilder errorMessage = new StringBuilder();

			if (missingSupplierMessages.Any())
			{
			errorMessage.Append("ä»¥ä¸é¨é¨æªç»´æ¤ï¼");
			errorMessage.Append(string.Join("ã", missingSupplierMessages));
			errorMessage.Append("ï¼");
			}

			if (missingMaterialMessages.Any())
			{
			errorMessage.Append("ä»¥ä¸ç©ææªç»´æ¤ï¼");
			errorMessage.Append(string.Join("ã", missingMaterialMessages));
			errorMessage.Append("ï¼");
			}
			if (missingCostMessages.Any())
			{
			errorMessage.Append("ææ¬é¡¹ç®æªç»´æ¤ææè¯¯ï¼");
			errorMessage.Append(string.Join("ã", missingCostMessages));
			errorMessage.Append("ï¼");
			}
			if (missingmoneyMessages.Any())
			{
			errorMessage.Append("éé¢æªç»´æ¤ææè¯¯ï¼");
			errorMessage.Append(string.Join("ã", missingmoneyMessages));
			errorMessage.Append("ï¼");
			}
			if (missingEmployeeMessages.Any())
			{
			errorMessage.Append("ä»¥ä¸èåæªç»´æ¤ï¼");
			errorMessage.Append(string.Join("ã", missingEmployeeMessages));
			errorMessage.Append("ï¼");
			}

			if (errorMessage.Length > 0)
			{
			res.code = "0";
			res.count = 0;
			res.Message = errorMessage.ToString();
			res.data = null;
			return res;
			}



			// 7. æç§é¨é¨ä»£ç ãé¨é¨ãèåä»£ç ãèåãçäº§è®¢åå·è¿è¡åç»
			var groupedData = list.GroupBy(item => new
			{
			é¨é¨ä»£ç = item["é¨é¨ä»£ç "],
			é¨é¨ = item["é¨é¨"],
			èåä»£ç = item["èåä»£ç "],
			èå = item["èå"],
			çäº§è®¢åå· = item["çäº§è®¢åå·"]
			}).ToList();

			StringBuilder insertSql = new StringBuilder();
			StringBuilder insertSql_sub = new StringBuilder();
			string currentDate = DateTime.Today.ToString("yyyy-MM-dd");

			foreach (var group in groupedData)
			{
			var firstItem = group.First();

			// è·åç»ä¿¡æ¯
			int HSupplierID = supplierDict_sub[firstItem["é¨é¨"]];
			//int EmpID = EmpDict[firstItem["èå"]];
			int EmpID;
			string empName = firstItem["èå"];
			if (string.IsNullOrEmpty(empName))
			EmpID = 0; // æå¶ä»é»è®¤å¼
			else
			EmpID = EmpDict[empName];
			string ICMO = firstItem["çäº§è®¢åå·"];
			int ICMOInterID = !string.IsNullOrEmpty(ICMO) && ICMODict.ContainsKey(ICMO) ? ICMODict[ICMO] : 0;

			// çæä¸»è¡¨IDååæ®å·ï¼æ¯ç»çæä¸ä¸ªï¼
			string HBillNo = DBUtility.ClsPub.CreateBillCode("1802", ref DBUtility.ClsPub.sExeReturnInfo, true);
			long HInterID = DBUtility.ClsPub.CreateBillID("1802", ref DBUtility.ClsPub.sExeReturnInfo);




			DateTime firstDayWithTime = new DateTime(Convert.ToInt32(list[0]["å¹´ä»½"]), Convert.ToInt32(list[0]["æä»½"]), 1);
			// æå¥ä¸»è¡¨ï¼æ¯ç»æå¥ä¸æ¬¡ï¼
			insertSql.AppendLine($"INSERT INTO CB_ItemMoneyBillMain ([HInterID], [HBillNo], [HDate], [HYear], [HPeriod], [HBillType], [HBillSubType], [HBillStatus], [HCheckItemNowID], [HCheckItemNextID], [HCheckFlowID], [HRemark], [HBacker], [HBackDate], [HBackRemark], [HChecker], [HCheckDate], [HMaker], [HMakeDate], [HUpDater], [HUpDateDate], [HCloseMan], [HCloseDate], [HCloseType], [HDeleteMan], [HDeleteDate], [HMainSourceBillType], [HMainSourceInterID], [HMainSourceEntryID], [HMainSourceBillNo], [HPrintQty], [HEmpID], [HDeptID], [HICMOInterID], [HMaterID], [HICMOBillNo], [HExplanation], [HInnerBillNo], [HBeginDate], [HEndDate], [HOrgID]) VALUES (");
			insertSql.AppendLine($"'{HInterID}', '{HBillNo}', '{firstDayWithTime}', {list[0]["å¹´ä»½"]}, {list[0]["æä»½"]}, {"1802"}, '{"1802"}', '{"1"}', '{"0"}', '{"0"}', '{"0"}', '{"excelå¯¼å¥"}', '{""}', '{DateTime.Now}', '{""}', '{""}', '{DateTime.Now}', '{user}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{""}', '{DateTime.Now}', '{"0"}', '{""}', '{DateTime.Now}', '{""}', '{"0"}', '{"0"}', '{""}', '{"0"}', '{EmpID}', '{HSupplierID}', '{ICMOInterID}','{0}','{ICMO}','{""}','{"0"}','{DateTime.Now}','{DateTime.Now}','{"100038"}');");

			// æå¥åè¡¨ï¼ç»åæ¯ä¸ªç©ææå¥ä¸æ¬¡ï¼
			int HEntryID = 1;
			foreach (var item in group)
			{
			int HMaterID = materialDict[$"{item["ç©æç¼ç "]}_{item["ç©æåç§°"]}"];
			int HCostID = CostDict[item["ææ¬é¡¹ç®"]];
			int HProcID = ProcDict[item["å·¥åº"]];

			insertSql_sub.AppendLine($"INSERT INTO [CB_ItemMoneyBillSub] ([HInterID], [HEntryID], [HCloseMan], [HEntryCloseDate], [HCloseType], [HRemark],[HSourceInterID], [HSourceEntryID], [HSourceBillNo], [HSourceBillType],[HRelationQty], [HRelationMoney], [HBillNo_bak], [HCostItemID],[HDeptID], [HQty], [HPrice], [HMoney],[HMaterID], [HWaster], [HDate], [HBeginBalance], [HEndBalance], [HTimes],[HProcID]) VALUES (");
			insertSql_sub.AppendLine($"'{HInterID}', '{HEntryID}', '{""}', '{DateTime.Now}', '{"0"}', '{"excelå¯¼å¥"}','{"0"}', '{"0"}', '{"0"}', '{"0"}','{"0"}', '{"0"}', '{""}', '{HCostID}', '{HSupplierID}', '{item["æ°é"]}', '{item["åä»·"]}', '{item["éé¢"]}','{HMaterID}', '{item["æèé"] ?? "0"}', '{DateTime.Now}', '{"0"}', '{"0"}', '{"0"}', '{HProcID}');");
			HEntryID++;
			}



			}

			// æ§è¡æ¹éæä½
			if (insertSql.Length > 0)
			{
			oCN.RunProc(insertSql.ToString());
			}

			if (insertSql_sub.Length > 0)
			{
			oCN.RunProc(insertSql_sub.ToString());
			}

			oCN.Commit();

			res.code = "1";
			res.count = groupedData.Count;
			res.Message = $"å¯¼å¥æå! å±å¤ç{groupedData.Count}ç»æ°æ®";
			res.data = null;
			return res;
			}
			catch (Exception e)
			{
			//oCN.Rollback();
			LogService.Write(e);
			res.code = "0";
			res.count = 0;
			res.Message = "Exceptionï¼" + e.ToString();
			res.data = null;
			return res;
			}
			}
			#endregion

			}
			}