From 93473e2792e5d23a168e575f17190a5e51ad7c9f Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期四, 17 七月 2025 09:55:58 +0800 Subject: [PATCH] 111 --- MES.Service/service/BasicData/OrganizeManager.cs | 44 +++++++++++++++++++++++--------------------- 1 files changed, 23 insertions(+), 21 deletions(-) diff --git a/MES.Service/service/BasicData/OrganizeManager.cs b/MES.Service/service/BasicData/OrganizeManager.cs index d0c96dd..b80be86 100644 --- a/MES.Service/service/BasicData/OrganizeManager.cs +++ b/MES.Service/service/BasicData/OrganizeManager.cs @@ -1,12 +1,9 @@ -锘縰sing SqlSugar; -using System; -using System.Collections.Generic; -using MES.Service.DB; -using MES.Service.Modes; +锘縰sing MES.Service.DB; using MES.Service.Dto.webApi; -using System.Xml.Linq; +using MES.Service.Modes; +using SqlSugar; -namespace MES.Service.service; +namespace MES.Service.service.BasicData; public class OrganizeManager : Repository<Organize> { @@ -207,7 +204,7 @@ #region 鏁欏鏂规硶 /// <summary> - /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� + /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� /// </summary> public void Study() { @@ -218,27 +215,31 @@ var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊 - var p = new PageModel() { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ + var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount); //杩斿洖鎬绘暟 - var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc); // 鍒嗛〉鏌ヨ鍔犳帓搴� + var data6 = + base.GetPageList(it => 1 == 1, p, + it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴� Console.Write(p.TotalCount); //杩斿洖鎬绘暟 List<IConditionalModel> conModels = new(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� - conModels.Add(new ConditionalModel() + conModels.Add(new ConditionalModel { - FieldName = typeof(Organize).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, + FieldName = typeof(Organize).GetProperties()[0].Name, + ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 - var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); + var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); - AsQueryable().Where(x => 1 == 1).ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + AsQueryable().Where(x => 1 == 1) + .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 /*********鎻掑叆*********/ - var insertData = new Organize() { }; //娴嬭瘯鍙傛暟 - var insertArray = new Organize[] { insertData }; + var insertData = new Organize(); //娴嬭瘯鍙傛暟 + var insertArray = new[] { insertData }; base.Insert(insertData); //鎻掑叆 base.InsertRange(insertArray); //鎵归噺鎻掑叆 var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒� @@ -246,8 +247,8 @@ /*********鏇存柊*********/ - var updateData = new Organize() { }; //娴嬭瘯鍙傛暟 - var updateArray = new Organize[] { updateData }; //娴嬭瘯鍙傛暟 + var updateData = new Organize(); //娴嬭瘯鍙傛暟 + var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟 base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊 base.UpdateRange(updateArray); //鎵归噺鏇存柊 //base.Update(it => new Organize() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1 @@ -255,12 +256,13 @@ /*********鍒犻櫎*********/ - var deldata = new Organize() { }; //娴嬭瘯鍙傛暟 + var deldata = new Organize(); //娴嬭瘯鍙傛暟 base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎 base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎 - base.DeleteById(new int[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎 + base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎 base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎 - AsDeleteable().Where(it => 1 == 2).ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� + AsDeleteable().Where(it => 1 == 2) + .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� } #endregion -- Gitblit v1.9.3