| | |
| | | |
| | | if (@column.EffectType == "datepicker" && @column.QueryType == "between"){ |
| | | |
| | | @:.Where(input.@column.ColumnName!=null, u => u.@(@column.ColumnName)>= Convert.ToDateTime(input.@(@column.ColumnName)[0]+" 00:00:00") && u.@(@column.ColumnName)<= Convert.ToDateTime(input.@(@column.ColumnName)[1]+" 23:59:59")) |
| | | @:.Where(SysCommUtil.ValidateListForQueryTimeArray(input.@column.ColumnName), u => u.@(@column.ColumnName) > Convert.ToDateTime(input.@(@column.ColumnName)[0]+" 00:00:00").AddSeconds(-1) && u.@(@column.ColumnName)< Convert.ToDateTime(input.@(@column.ColumnName)[1]+" 23:59:59").AddSeconds(1)) |
| | | } |
| | | else if (@column.EffectType == "datetimepicker" && @column.QueryType == "between"){ |
| | | |
| | | @:.Where(input.@column.ColumnName!=null, u => u.@(@column.ColumnName)>= Convert.ToDateTime(input.@(@column.ColumnName)[0]) && u.@(@column.ColumnName)<= Convert.ToDateTime(input.@(@column.ColumnName)[1])) |
| | | @:.Where(SysCommUtil.ValidateListForQueryTimeArray(input.@column.ColumnName), u => u.@(@column.ColumnName) > Convert.ToDateTime(input.@(@column.ColumnName)[0]).AddSeconds(-1) && u.@(@column.ColumnName)< Convert.ToDateTime(input.@(@column.ColumnName)[1]).AddSeconds(1)) |
| | | } |
| | | |
| | | else { |
| | |
| | | } else if (@column.EffectType == "datepicker"&&@column.QueryType == "between") |
| | | { |
| | | |
| | | @:.Where(input.@column.ColumnName!=null, u => u.@(@column.ColumnName)>= Convert.ToDateTime(input.@(@column.ColumnName)[0]+" 00:00:00") && u.@(@column.ColumnName)<= Convert.ToDateTime(input.@(@column.ColumnName)[1]+" 23:59:59")) |
| | | @:.Where(SysCommUtil.ValidateListForQueryTimeArray(input.@column.ColumnName), u => u.@(@column.ColumnName) > Convert.ToDateTime(input.@(@column.ColumnName)[0]+" 00:00:00").AddSeconds(-1) && u.@(@column.ColumnName)< Convert.ToDateTime(input.@(@column.ColumnName)[1]+" 23:59:59").AddSeconds(1)) |
| | | |
| | | } else if (@column.EffectType == "datetimepicker" && @column.QueryType == "between"){ |
| | | |
| | | @:.Where(input.@column.ColumnName!=null, u => u.@(@column.ColumnName)>= Convert.ToDateTime(input.@(@column.ColumnName)[0]) && u.@(@column.ColumnName)<= Convert.ToDateTime(input.@(@column.ColumnName)[1])) |
| | | @:.Where(SysCommUtil.ValidateListForQueryTimeArray(input.@column.ColumnName), u => u.@(@column.ColumnName) > Convert.ToDateTime(input.@(@column.ColumnName)[0]).AddSeconds(-1) && u.@(@column.ColumnName)< Convert.ToDateTime(input.@(@column.ColumnName)[1]).AddSeconds(1)) |
| | | }else if (@column.EffectType == "fk") |
| | | { |
| | | @:.Where(p@(@column.ColumnName) > 0, u => u.@(@column.ColumnName) @column.QueryType p@(@column.ColumnName)) |
| | |
| | | /// <returns></returns> |
| | | private async Task CheckExisit( @(@Model.ClassName) input,bool isEdit=false) |
| | | { |
| | | |
| | | |
| | | @{ |
| | | var columnIndex = 0; |
| | | string my_message = string.Empty; |
| | | } |
| | | |
| | | @foreach (var column in Model.TableField) |
| | | { |
| | | if (@column.WhetherUnionKey == "Y") |
| | | { |
| | | my_message += "," + @column.ColumnComment + "[{input." + @column.ColumnName + "}]"; |
| | | } |
| | | if (@column.WhetherUnionKey == "Y") |
| | | { |
| | | columnIndex++; |
| | |
| | | @:,false); |
| | | @:} |
| | | } |
| | | |
| | | |
| | | |
| | | @if(columnIndex>0){ |
| | | @:if (isExist) throw Oops.Oh(ErrorCode.E0001); |
| | | @:if (isExist) throw Oops.Oh($"验证失败@(@my_message)已存在"); |
| | | }else{ |
| | | @://没有配置联合主键,不需要验重 |
| | | } |