我在sqlserver 操作方式：

   /// <summary>///獲取當前門店工資列表/// </summary>/// <param name="wheres">其他條件</param>/// <param name="ThisMendian">當前門店</param>/// <param name="IsNotUseYearMonth">是否需要單一的年月來獲取工資</param>/// <returns></returns>public IEnumerable<GongziInfos> QueryListByMendianInWhere(string wheres ,bool IsNotUseYearMonth){string Top = string.IsNullOrWhiteSpace(wheres) ? "Top 1000" : string.Empty; string sql = $@"SELECT  {Top} * from ( select  *, cast(CONVERT( varchar,Year)+ '-'+CONVERT(varchar,Month)+'-15' as Date) as SetGongziDate FROM [GongziInfos]) aWhere 1 = 1 {wheres} ";return DapperDbHelper.Query<GongziInfos>(sql);}

替換為sqlite的操作：

        /// <summary>///獲取當前門店工資列表/// </summary>/// <param name="wheres">其他條件</param>/// <param name="ThisMendian">當前門店</param>/// <param name="IsNotUseYearMonth">是否需要單一的年月來獲取工資</param>/// <returns></returns>public IEnumerable<GongziInfos> QueryListByMendianInWhere(string wheres, bool IsNotUseYearMonth){string Top = string.IsNullOrWhiteSpace(wheres) ? "limit 100" : string.Empty;string sql = $@"SELECT  * from ( select  *, cast(Year+'-'+Month+'-15' as Date) as SetGongziDate FROM [GongziInfos]) aWhere 1 = 1 {wheres} {Top} ";//return DapperDbHelper.Query<GongziInfos>(sql);using (IDbConnection Conn = new DALDBBase().GetOpenConn()){return Conn.Query<GongziInfos>(sql);}}