From 565c3a3d0e7fb13effb526d2d6014f70a4d23f3b Mon Sep 17 00:00:00 2001 From: hutongqing <hutongqing@hnkhzn.com> Date: 星期一, 13 一月 2025 22:06:46 +0800 Subject: [PATCH] 板材仓 --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_Core/AOP/SqlSugarAop.cs | 71 +++++++++++------------------------ 1 files changed, 22 insertions(+), 49 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/AOP/SqlSugarAop.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/AOP/SqlSugarAop.cs" index aa8cc06..14b05f2 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/AOP/SqlSugarAop.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_Core/AOP/SqlSugarAop.cs" @@ -30,18 +30,21 @@ CodeRuleAttribute? codeRuleAttribute = propertyInfo.GetCustomAttribute<CodeRuleAttribute>(); if (codeRuleAttribute != null) { - SqlSugarClient sugarClient = new SqlSugarClient(new ConnectionConfig + if (propertyInfo.GetValue(entityInfo.EntityValue) == null) { - ConfigId = MainDb.CurrentDbConnId, - ConnectionString = DBContext.GetMainConnectionDb().Connection, - IsAutoCloseConnection = true, - DbType = MainDb.DbType, - }); - dynamic ruleConfig = sugarClient.Queryable(MainDb.CodeRuleConfig, "x").Where(nameof(CodeRuleAttribute.RuleCode), "=", codeRuleAttribute.RuleCode.ToString()).First(); - if (ruleConfig != null) - { - string code = CreateCodeByRule(ruleConfig, sugarClient); - propertyInfo.SetValue(entityInfo.EntityValue, code, null); + SqlSugarClient sugarClient = new SqlSugarClient(new ConnectionConfig + { + ConfigId = MainDb.CurrentDbConnId, + ConnectionString = DBContext.GetMainConnectionDb().Connection, + IsAutoCloseConnection = true, + DbType = MainDb.DbType, + }); + dynamic ruleConfig = sugarClient.Queryable(MainDb.CodeRuleConfig, "x").Where(nameof(CodeRuleAttribute.RuleCode), "=", codeRuleAttribute.RuleCode.ToString()).First(); + if (ruleConfig != null) + { + string code = CreateCodeByRule(ruleConfig, sugarClient); + propertyInfo.SetValue(entityInfo.EntityValue, code, null); + } } } @@ -66,26 +69,21 @@ int seq = sugarClient.Ado.GetScalar($"SELECT NEXT VALUE FOR {sequenceAttirbute.SequenceName}").ObjToInt(); propertyInfo.SetValue(entityInfo.EntityValue, seq, null); } - } } if (entityInfo.EntityValue is BaseEntity baseEntity) { // 鏂板鎿嶄綔 - if (entityInfo.OperationType == DataFilterType.InsertByObject) + if (entityInfo.OperationType == DataFilterType.InsertByObject && entityInfo.PropertyName == nameof(BaseEntity.CreateDate)) { - if (entityInfo.PropertyName == nameof(BaseEntity.CreateDate)) - { - baseEntity.CreateDate = DateTime.Now; - } + baseEntity.CreateDate = DateTime.Now; } - if (entityInfo.OperationType == DataFilterType.UpdateByObject) + if (entityInfo.OperationType == DataFilterType.UpdateByObject && entityInfo.PropertyName == nameof(BaseEntity.ModifyDate)) { baseEntity.ModifyDate = DateTime.Now; } - //if (App.User?.UserId > 0) { @@ -100,17 +98,13 @@ } } } - } - private static void UpdateConfigData(dynamic ruleConfig) - { - try + if (entityInfo.EntityValue is IBaseHistoryEntity baseHistoryEntity) { - - } - catch (Exception ex) - { - + if (entityInfo.OperationType == DataFilterType.InsertByObject && entityInfo.PropertyName == nameof(IBaseHistoryEntity.InsertTime)) + { + baseHistoryEntity.InsertTime = DateTime.Now; + } } } @@ -159,27 +153,6 @@ sugarClient.Updateable(keyValuePairs).AS(MainDb.CodeRuleConfig).WhereColumns(nameof(ruleConfig.Id)).ExecuteCommand(); } return code; - } - - private static string GetWholeSql(SugarParameter[] paramArr, string sql) - { - foreach (var param in paramArr) - { - sql = sql.Replace(param.ParameterName, $@"'{param.Value.ObjToString()}'"); - } - - return sql; - } - - private static string GetParas(SugarParameter[] pars) - { - string key = "銆怱QL鍙傛暟銆戯細"; - foreach (var param in pars) - { - key += $"{param.ParameterName}:{param.Value}\n"; - } - - return key; } } } -- Gitblit v1.9.3