public string CleanUpSql(string sqlCmd)
{
var start = _sc.GetValueByFieldName("OrderDateStart");
var end = _sc.GetValueByFieldName("OrderDateEnd");
return(!string.IsNullOrEmpty(start) && !string.IsNullOrEmpty(end)
? sqlCmd.Replace("--[@orderDateStart]--", string.Empty)
.Replace("--[@orderDateEnd]--", string.Empty)
: sqlCmd);
}
public string CleanUpSql(string sqlCmd)
{
var value = _sc.GetValueByFieldName("EmployeeId");
return(!string.IsNullOrEmpty(value)
? sqlCmd.Replace("--[@employeeId]--", string.Empty)
: sqlCmd);
}
public string CleanUpSql(string sqlCmd)
{
var value = _sc.GetValueByFieldName("ShipCity");
return(!string.IsNullOrEmpty(value)
? sqlCmd.Replace("--[@shipCity]--", string.Empty)
: sqlCmd);
}
public string CleanUpSql(string sqlCmd)
{
var value = _sc.GetValueByFieldName("CustomerId");
return(!string.IsNullOrEmpty(value)
? sqlCmd.Replace("--[@customerId]--", string.Empty)
.Replace("@CustomerId", value)
: sqlCmd);
}
