From f391144114bedefe44c700a590bd50272ff067ec Mon Sep 17 00:00:00 2001
From: yanjinhui <3306209981@qq.com>
Date: 星期一, 10 三月 2025 09:05:26 +0800
Subject: [PATCH] 后端
---
项目代码/WIDESEAWCS_Server 正式/SerialPortService/NjTaskServer.cs | 203 ++++++++++++++++++++++++++++++++------------------
1 files changed, 129 insertions(+), 74 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WIDESEAWCS_Server \346\255\243\345\274\217/SerialPortService/NjTaskServer.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WIDESEAWCS_Server \346\255\243\345\274\217/SerialPortService/NjTaskServer.cs"
index a2750a5..eef7faa 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WIDESEAWCS_Server \346\255\243\345\274\217/SerialPortService/NjTaskServer.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WIDESEAWCS_Server \346\255\243\345\274\217/SerialPortService/NjTaskServer.cs"
@@ -37,23 +37,24 @@
}
- public WebResponseContent Fuzzyquery(string trainkind, string trainnum, string track, string coachnum, string bogie, string processdept)
+ //妯＄硦鏌ヨ
+ public WebResponseContent Fuzzyquery(MhuNjtakeTDO mhuNjtakeTDO)
{
try
- {
+ {
var query = BaseDal.Db.Queryable<Dt_NjTask>();
// 鐢熸垚 OR 鏌ヨ鏉′欢 鍗充换鎰忓瓧娈甸兘鍙互鏌ョ湅
- if (!string.IsNullOrEmpty(trainkind) || !string.IsNullOrEmpty(trainnum) ||
- !string.IsNullOrEmpty(track) || !string.IsNullOrEmpty(coachnum) ||
- !string.IsNullOrEmpty(bogie) || !string.IsNullOrEmpty(processdept))
+ if (!string.IsNullOrEmpty(mhuNjtakeTDO.trainkind) || !string.IsNullOrEmpty(mhuNjtakeTDO.trainnum) ||
+ !string.IsNullOrEmpty(mhuNjtakeTDO.track) || !string.IsNullOrEmpty(mhuNjtakeTDO.coachnum) ||
+ !string.IsNullOrEmpty(mhuNjtakeTDO.bogie) || !string.IsNullOrEmpty(mhuNjtakeTDO.processdept))
{
- query = query.Where(x =>
- (!string.IsNullOrEmpty(trainkind) && x.trainKind.Contains(trainkind)) ||
- (!string.IsNullOrEmpty(trainnum) && x.trainNum.Contains(trainnum)) ||
- (!string.IsNullOrEmpty(track) && x.track.Contains(track)) ||
- (!string.IsNullOrEmpty(coachnum) && x.coachNum.Contains(coachnum)) ||
- (!string.IsNullOrEmpty(bogie) && x.bogie.Contains(bogie)) ||
- (!string.IsNullOrEmpty(processdept) && x.processDept.Contains(processdept))
+ BaseDal.QueryData(x =>
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.trainkind) && x.trainKind.Contains(mhuNjtakeTDO.trainkind)) ||
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.trainnum) && x.trainNum.Contains(mhuNjtakeTDO.trainnum)) ||
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.track) && x.track.Contains(mhuNjtakeTDO.track)) ||
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.coachnum) && x.coachNum.Contains(mhuNjtakeTDO.coachnum)) ||
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.bogie) && x.bogie.Contains(mhuNjtakeTDO.bogie)) ||
+ (!string.IsNullOrEmpty(mhuNjtakeTDO.processdept) && x.processDept.Contains(mhuNjtakeTDO.processdept))
);
}
@@ -73,35 +74,7 @@
public WebResponseContent Submtandsave(NjtakeDTO njtakeDTO)
{
try
- {
-
- #region 鑷畾涔夊懡鍚嶇粰Njtaskid
- // 鑾峰彇浠婂ぉ鐨勬棩鏈熼儴鍒嗭紝濡� "KH0306"
- string todayPrefix = $"KH{DateTime.Now:MMdd}";
-
- // 鏌ヨ鏁版嵁搴擄紝鎵惧嚭褰撳ぉ鏈�澶х殑 NJtaskID
- var lastTask = BaseDal.QueryData(i => i.NJtaskID.StartsWith(todayPrefix))
- .OrderByDescending(i => i.NJtaskID)
- .FirstOrDefault();
-
- int nextNumber = 1; // 榛樿缂栧彿
-
- if (lastTask != null)
- {
- // 鑾峰彇鍚庝袱浣嶅垎閽熺紪鍙�
- string lastNumberPart = lastTask.NJtaskID.Substring(6, 2);
- if (int.TryParse(lastNumberPart, out int lastNumber))
- {
- nextNumber = lastNumber + 1;
- }
- }
-
- // 鐢熸垚 NJtaskID锛屼緥濡� KH030601, KH030602...
- string CustomizeID = $"{todayPrefix}{nextNumber:D2}";
- #endregion
-
-
-
+ {
//鏇村叿妯℃澘id鏉ユ煡璇㈡槸鍚﹀瓨鍦ㄨ鏉℃暟鎹�
var existtepm = _templateRepository.QueryFirst(i => i.TemplateID == njtakeDTO.Tpid);
var Temp = new Dt_Template(); //濡傛灉浣犺鏇存柊閭ｄ箞瑕佸厛鎵惧埌锛屽惁鍒欎綘杩欐牱鏄垱寤轰竴涓柊鐨勫璞�
@@ -116,15 +89,13 @@
Temp.zhiJianYuan_Dq = njtakeDTO.zhijianyuan_dq;
Temp.zhiJianYuan_Lc = njtakeDTO.zhijianyuan_lc;
Temp.zhiJianYuan_Dg = njtakeDTO.zhijianyuan_dg;
- Temp.liJu_Dg = njtakeDTO.liju_dq;
+ Temp.liJu_Dg = njtakeDTO.liju_dg;
Temp.liJu_Dq = njtakeDTO.liju_dq;
Temp.liJu_Lc = njtakeDTO.liju_lc;
Temp.fuZhu_Dg = njtakeDTO.fuzhu_dg;
Temp.fuZhu_Dq = njtakeDTO.fuzhu_dq;
Temp.fuZhu_Lc = njtakeDTO.fuzhu_lc;
-
-
-
+
}
//濡傛灉鏈夊氨鍦ㄦā鏉夸笂杩涜鏇存敼
else
@@ -132,7 +103,7 @@
existtepm.zhiJianYuan_Dq = njtakeDTO.zhijianyuan_dq;
existtepm.zhiJianYuan_Lc = njtakeDTO.zhijianyuan_lc;
existtepm.zhiJianYuan_Dg = njtakeDTO.zhijianyuan_dg;
- existtepm.liJu_Dg = njtakeDTO.liju_dq;
+ existtepm.liJu_Dg = njtakeDTO.liju_dg;
existtepm.liJu_Dq = njtakeDTO.liju_dq;
existtepm.liJu_Lc = njtakeDTO.liju_lc;
existtepm.fuZhu_Dg = njtakeDTO.fuzhu_dg;
@@ -151,7 +122,7 @@
if (existtepm == null)
{
- task.NJtaskID = CustomizeID;
+
task.TakeName = njtakeDTO.takename;
task.jiShuYuan = njtakeDTO.jishuyuan;
task.zhiJianYuan_DG = njtakeDTO.zhijianyuan_dg;
@@ -165,6 +136,7 @@
task.fuZhu_DQ = njtakeDTO.fuzhu_dq;
task.fuZhu_LC = njtakeDTO.fuzhu_lc;
task.dispatchTime = DateTime.Now;
+ task.startTime = DateTime.Now;
}
else
{
@@ -181,6 +153,7 @@
task.fuZhu_DQ = njtakeDTO.fuzhu_dq;
task.fuZhu_LC = njtakeDTO.fuzhu_lc;
task.dispatchTime = DateTime.Now;
+ task.startTime = DateTime.Now;
}
@@ -313,30 +286,7 @@
{
try
{
- #region 鑷畾涔夊懡鍚嶇粰Njtaskid
- // 鑾峰彇浠婂ぉ鐨勬棩鏈熼儴鍒嗭紝濡� "KH0306"
- string todayPrefix = $"KH{DateTime.Now:MMdd}";
-
- // 鏌ヨ鏁版嵁搴擄紝鎵惧嚭褰撳ぉ鏈�澶х殑 NJtaskID
- var lastTask = BaseDal.QueryData(i => i.NJtaskID.StartsWith(todayPrefix))
- .OrderByDescending(i => i.NJtaskID)
- .FirstOrDefault();
-
- int nextNumber = 1; // 榛樿缂栧彿
-
- if (lastTask != null)
- {
- // 鑾峰彇鍚庝袱浣嶅垎閽熺紪鍙�
- string lastNumberPart = lastTask.NJtaskID.Substring(6, 2);
- if (int.TryParse(lastNumberPart, out int lastNumber))
- {
- nextNumber = lastNumber + 1;
- }
- }
-
- // 鐢熸垚 NJtaskID锛屼緥濡� KH030601, KH030602...
- string CustomizeID = $"{todayPrefix}{nextNumber:D2}";
- #endregion
+
//鍏堟牴鎹甶d鍒ゆ柇鏄惁鏈夎浠诲姟
@@ -348,7 +298,7 @@
task.Taskstatus = "宸叉淳宸�";
- task.NJtaskID = CustomizeID;
+
task.TakeName = notempDTO.takename;
task.jiShuYuan = notempDTO.jishuyuan;
task.zhiJianYuan_DG = notempDTO.zhijianyuan_dg;
@@ -362,8 +312,7 @@
task.fuZhu_DQ = notempDTO.fuzhu_dq;
task.fuZhu_LC = notempDTO.fuzhu_lc;
task.dispatchTime=DateTime.Now;
- //task.NJtaskID=
- // task.startTime =DateTime.Now;
+ task.startTime = DateTime.Now;
@@ -461,6 +410,112 @@
}
}
+ //娣诲姞淇℃伅
+ public WebResponseContent AddNJinfom(AddNjtDTO addNjtDTO)
+ {
+ try
+ {
+ #region 鑷畾涔夊懡鍚嶇粰Njtaskid
+ // 鑾峰彇浠婂ぉ鐨勬棩鏈熼儴鍒嗭紝濡� "KH0306"
+ string todayPrefix = $"KH{DateTime.Now:MMdd}";
+ // 鏌ヨ鏁版嵁搴擄紝鎵惧嚭褰撳ぉ鏈�澶х殑 NJtaskID
+ var lastTask = BaseDal.QueryData(i => i.NJtaskID.StartsWith(todayPrefix))
+ .OrderByDescending(i => i.NJtaskID)
+ .FirstOrDefault();
+
+ int nextNumber = 1; // 榛樿缂栧彿
+
+ if (lastTask != null)
+ {
+ // 鑾峰彇鍚庝袱浣嶅垎閽熺紪鍙�
+ string lastNumberPart = lastTask.NJtaskID.Substring(6, 2);
+ if (int.TryParse(lastNumberPart, out int lastNumber))
+ {
+ nextNumber = lastNumber + 1;
+ }
+ }
+
+ // 鐢熸垚 NJtaskID锛屼緥濡� KH030601, KH030602...
+ string CustomizeID = $"{todayPrefix}{nextNumber:D2}";
+ #endregion
+
+ var addnj = new Dt_NjTask ()
+ {
+ NJtaskID= CustomizeID,
+ trainKind=addNjtDTO.trainkind,
+ trainNum=addNjtDTO.trainNum,
+ track=addNjtDTO.track,
+ coachNum=addNjtDTO.coachnum,
+ bogie=addNjtDTO.bogie,
+ processDept=addNjtDTO.processdept,
+ Taskstatus="鏈淳宸�",
+ createTime=DateTime.Now,
+ };
+
+ _unitOfWorkManage.BeginTran();
+ BaseDal.AddData(addnj);
+
+ _unitOfWorkManage.CommitTran();
+ return new WebResponseContent { Status = true, Data = addnj };
+
+ }
+ catch (Exception ex)
+ {
+ _unitOfWorkManage.RollbackTran();
+ return new WebResponseContent { Status = false, Message = "澶辫触" + ex.Message };
+ }
+ }
+
+ //鏌ョ湅璇︽儏 杩斿洖鏁翠釜琛ㄧ殑鏁版嵁锛堟洿鍏穒d锛�
+ public WebResponseContent GetNjdetail(string njtaskID)
+ {
+ try
+ {
+ _unitOfWorkManage.BeginTran();
+ var datatail = BaseDal.QueryData(x => x.NJtaskID == njtaskID).FirstOrDefault();
+ if (datatail == null)
+ {
+ return new WebResponseContent { Status = false, Message = "娌℃湁鎵惧埌" };
+
+ }
+ _unitOfWorkManage.CommitTran();
+ return new WebResponseContent { Status = true,Data = datatail };
+ }
+ catch (Exception ex)
+ {
+
+ _unitOfWorkManage.RollbackTran();
+ return new WebResponseContent() { Status = false, Message ="澶辫触"+ ex.Message };
+ }
+ }
+
+ //鏇村叿id鏇存柊
+ public WebResponseContent PuNjtake(PutNjtDTO putNjtDTO)
+ {
+ try
+ {
+ var putake = BaseDal.QueryData(x => x.id==putNjtDTO.id).FirstOrDefault();
+ if (putake == null)
+ {
+ return new WebResponseContent { Status = false, Message = "娌℃湁鎵惧埌" };
+ }
+ putake.trainKind= putNjtDTO.trainkind;
+ putake.trainNum= putNjtDTO.trainNum;
+ putake.track=putNjtDTO.track;
+ putake.coachNum=putake.coachNum;
+ putake.bogie=putNjtDTO.bogie;
+ putake.processDept=putake.processDept;
+ _unitOfWorkManage.BeginTran();
+ BaseDal.UpdateData(putake);
+ _unitOfWorkManage.CommitTran();
+ return new WebResponseContent { Status = true, Data = putake };
+ }
+ catch (Exception ex)
+ {
+ _unitOfWorkManage.RollbackTran();
+ return new WebResponseContent { Status = false, Message = "鏌ヨ澶辫触锛�" + ex.Message };
+ }
+ }
}
}
--
Gitblit v1.9.3