| | |
| | | |
| | | } |
| | | |
| | | //æ¨¡ç³æ¥è¯¢ |
| | | public WebResponseContent Fuzzyquery(MhuNjtakeTDO mhuNjtakeTDO) |
| | | { |
| | | try |
| | | { |
| | | var query = BaseDal.QueryData(); |
| | | // çæ OR æ¥è¯¢æ¡ä»¶ å³ä»»æå段é½å¯ä»¥æ¥ç |
| | | 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)|| |
| | | !string.IsNullOrEmpty(mhuNjtakeTDO.taskstatus) || !string.IsNullOrEmpty(mhuNjtakeTDO.createtime)) |
| | | { |
| | | 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))|| |
| | | (!string.IsNullOrEmpty(mhuNjtakeTDO.taskstatus) && x.processDept.Contains(mhuNjtakeTDO.taskstatus))|| |
| | | (!string.IsNullOrEmpty(mhuNjtakeTDO.createtime) && x.processDept.Contains(mhuNjtakeTDO.createtime)) |
| | | ); |
| | | } |
| | | |
| | | var result = query.ToList(); // æ§è¡æ¥è¯¢ .ToList()æ¥è¯¢åè¡¨ï¼ .InSingle(1); // æ ¹æ®æ¥è¯¢å个å®ä½ |
| | | return new WebResponseContent { Status = true, Data = result }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | return new WebResponseContent { Status = false, Message = "æ¥ç失败ï¼" + ex.Message }; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | //ä¿åæ¨¡æ¿ |
| | |
| | | } |
| | | |
| | | //æ·»å ä¿¡æ¯ |
| | | public WebResponseContent AddNJinfom(AddNjtDTO addNjtDTO) |
| | | public WebResponseContent AddNjtake(AddNjtDTO addNjtDTO) |
| | | { |
| | | try |
| | | { |
| | |
| | | string CustomizeID = $"{todayPrefix}{nextNumber:D3}";//D3表示 3使°ï¼ä¸è¶³è¡¥0 |
| | | #endregion |
| | | |
| | | var addnj = new Dt_NjTask () |
| | | 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=0, |
| | | createTime=DateTime.Now, |
| | | NJtaskID = CustomizeID, |
| | | trainKind = addNjtDTO.trainKind, |
| | | trainNum = addNjtDTO.trainNum, |
| | | track = addNjtDTO.track, |
| | | coachNum = addNjtDTO.coachNum, |
| | | bogie = addNjtDTO.bogie, |
| | | processDept = addNjtDTO.processDept, |
| | | jiShuYuan=addNjtDTO.jiShuYuan, |
| | | zhiJianYuan_LC=addNjtDTO.zhiJianYuan_LC, |
| | | zhiJianYuan_DG=addNjtDTO.zhiJianYuan_DG, |
| | | zhiJianYuan_DQ=addNjtDTO.zhiJianYuan_DQ, |
| | | gongZhang=addNjtDTO.gongZhang, |
| | | liJu_LC=addNjtDTO.liJu_LC, |
| | | liJu_DG=addNjtDTO.liJu_DG, |
| | | liJu_DQ=addNjtDTO.liJu_DQ, |
| | | fuZhu_LC=addNjtDTO.fuZhu_LC, |
| | | fuZhu_DG=addNjtDTO.fuZhu_DG, |
| | | fuZhu_DQ=addNjtDTO.fuZhu_DQ, |
| | | Taskstatus = 0, |
| | | createTime = DateTime.Now, |
| | | }; |
| | | |
| | | _unitOfWorkManage.BeginTran(); |