From 1f9064d0d5ae5ed89800cc3603af3a47be646817 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 29 三月 2021 09:46:20 +0800
Subject: [PATCH] 文件上传改用npoi helper 类
---
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 25 -------------------------
1 files changed, 0 insertions(+), 25 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index 79eab08..0bb8d39 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -309,7 +309,6 @@
/// </summary>
public void Save()
{
-
List<string> sqlList = new List<string>();
string sql;
//鑾峰彇鍗曟嵁浣撲俊鎭�
@@ -317,21 +316,17 @@
//鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
DateTime date = Convert.ToDateTime(DateTime.Now.ToString("d"));
-
string _result = "";
-
foreach (DynamicObject current in entityDataObjoct)
{
if (Convert.ToInt32(current["FNoScheduled"]) < 0)
_result += "搴忓彿锛�" + Convert.ToString(current["SEQ"]) + ",鏃ヨ鍒掓�绘暟閲忚秴鍑虹敓浜ц鍗曟暟閲�";
-
}
if (_result != "")
{
this.View.ShowErrMessage(_result);
return;
}
-
foreach (DynamicObject current in entityDataObjoct)
{
JObject jsonRoot = new JObject();
@@ -346,11 +341,9 @@
jsonModel.Add("FOrderQuantity", Convert.ToString(current["FOrderQuantity"]));
jsonModel.Add("FDayPlanQuantity", Convert.ToString(current["FDayPlanQuantity"]));
jsonModel.Add("FNoScheduled", Convert.ToString(current["FNoScheduled"]));
-
sql = $" /*dialect*/ select FEntryID, FHMASTERDATE from SC_WORKBILLSORTBILLSub where FID={Convert.ToString(current["FDayPlanWorkID"])} ";
List<DayPlanModel> dayPlanModel = new List<DayPlanModel>();
dayPlanModel = DBServiceHelper.ExecuteDataSet(Context, sql).ToModelList<DayPlanModel>();
-
JArray Entry = new JArray();
for (int i = 0; i <= 60; i++)
{
@@ -377,24 +370,6 @@
LogHelper.Error("鐢熶骇璁″垝骞冲彴淇濆瓨澶辫触:" + jsonRoot.ToString());
this.View.ShowMessage("鏁版嵁鍌ㄥ瓨澶辫触锛佽鑱旂郴绠＄悊鍛橈紒");
}
-
-
- //sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FOrderQuantity={current["FOrderQuantity"]},FDayPlanQuantity={current["FDayPlanQuantity"]},FNoScheduled={current["FNoScheduled"]} where FID = {current["FDayPlanWorkID"]}";
- //sqlList.Add(sql);
- //DateTime FBzDate = Convert.ToDateTime(Convert.ToDateTime(current["FBzDate"]));
- //DateTime end = Convert.ToDateTime(Convert.ToDateTime(current["FBzDate"]).AddDays(60).ToShortDateString());//鏈�澶ф棩鏈�
- //for (int i = 0; i <= 60; i++)
- //{
- // DateTime start = Convert.ToDateTime(date.AddDays(i).ToShortDateString());
- // TimeSpan getDay = end.Subtract(start);
- // //缂栧埗鏃ユ湡+61澶�>date.AddDays(i).ToShortDateString() continue
- // if (getDay.Days < 0)
- // break;
- // sql = $"/*dialect*/update t1 set FHQTY='{Convert.ToString(current["FT" + "" + i + ""])}' from Sc_WorkBillSortBillSub t1 join " +
- // $" Sc_WorkBillSortBillMain t2 on t1.FID = t2.FID where FHMASTERDATE='{date.AddDays(i).ToShortDateString()}' and t2.FID='{Convert.ToString(current["FDayPlanWorkID"])}'";
- // sqlList.Add(sql);
- //}
-
}
this.View.ShowMessage("鎿嶄綔鎴愬姛");
--
Gitblit v1.9.1