예제 #1
0
파일: SumValue.cs 프로젝트: sGeeK44/Orm
 /// <summary>
 ///     Convert part to sql string equivalent
 /// </summary>
 /// <param name="params">existing param list to populate in case of part object value</param>
 /// <returns>Sql string representation</returns>
 public string ToStatement(List <IDataParameter> @params)
 {
     return($"SUM({_columnToSum.ToStatement(@params)}) as {_columnToSum.AliasFiledName}");
 }
예제 #2
0
파일: CountValue.cs 프로젝트: sGeeK44/Orm
 /// <summary>
 ///     Convert part to sql string equivalent
 /// </summary>
 /// <param name="params">existing param list to populate in case of part object value</param>
 /// <returns>Sql string representation</returns>
 public string ToStatement(List <IDataParameter> @params)
 {
     return($"COUNT({_columnToCount.ToStatement(@params)}) AS {ColumnName}");
 }
예제 #3
0
 public string ToStatement(List <IDataParameter> @params)
 {
     return($"DATEADD(DAY, {_buildColumnValue.ToStatement(@params)}, {_value.ToStatement(@params)})");
 }