摘要：
DbContext.users.Where(x=>x.LastLogintime > DateTime.Now.AddDays(-(DateTime.Now - DateTime.Parse("2000-01-03")).Days % 7).Date) DateTime.Parse("2000-01 阅读全文
posted @ 2021-07-21 16:51
87de海雷
阅读(137)
评论(0)
推荐(0)
摘要：
public void ConfigureServices(IServiceCollection services) { services.Scan(s => s.FromAssemblyOf<IService>().AddClasses().AsImplementedInterfaces().Wi 阅读全文
posted @ 2021-07-21 15:10
87de海雷
阅读(338)
评论(0)
推荐(0)
摘要：
public static string Save(this IFormFile file) { var NewFileName = $"{Guid.NewGuid()}{Path.GetExtension(file.FileName)}"; var path = Path.Combine($"{D 阅读全文
posted @ 2021-07-21 15:01
87de海雷
阅读(752)
评论(0)
推荐(0)
摘要：
select * from tableName where DATEDIFF(WEEK,ColumnName,GETDATE()) = 0 这样查返回的是上周日到本周六的 select * from TableName where CONVERT(varchar,ColumnName,23) >= 阅读全文
posted @ 2021-07-21 14:49
87de海雷
阅读(66)
评论(0)
推荐(0)
摘要：
WITH tab AS( SELECT * FROM table1 WHERE Id='9' UNION ALL SELECT * FROM tab,table1 WHERE table1.Id=tab.ParentId ) SELECT * FROM tab; 阅读全文
posted @ 2021-07-21 14:36
87de海雷
阅读(39)
评论(0)
推荐(0)
摘要：
/// <summary> /// ip转int /// </summary> /// <param name="ip">ip地址</param> /// <returns></returns> public int ToIPInt(string ip ) { return BitConverter 阅读全文
posted @ 2021-07-21 14:06
87de海雷
阅读(169)
评论(0)
推荐(0)
摘要：
1 /// <summary> 2 /// MD5加密 3 /// </summary> 4 /// <param name="val"></param> 5 /// <returns></returns> 6 public string Md5(string val) 7 { 8 return s 阅读全文
posted @ 2021-07-21 14:04
87de海雷
阅读(216)
评论(0)
推荐(0)
浙公网安备 33010602011771号