public string GetSelectStringOfContentId(int inputId, string whereString)
{
var orderByString = ETaxisTypeUtils.GetInputContentOrderByString(ETaxisType.OrderByTaxisDesc);
string where = $"WHERE (InputID = {inputId} {whereString}) {orderByString}";
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TableName, "ID, Taxis", where));
}
public List <int> GetContentIdListWithChecked(int inputId, List <string> searchFields, string keyword)
{
var contentIdList = new List <int>();
var taxisString = ETaxisTypeUtils.GetInputContentOrderByString(ETaxisType.OrderByTaxisDesc);
var whereStringBuilder = new StringBuilder();
foreach (var field in searchFields)
{
if (!string.IsNullOrEmpty(field))
{
whereStringBuilder.Append($" {field} LIKE '%{PageUtils.FilterSql(keyword)}%' OR");
}
}
if (whereStringBuilder.Length > 0)
{
whereStringBuilder.Remove(whereStringBuilder.Length - 3, 3);
}
string sqlString =
$"SELECT ID FROM {TableName} WHERE (InputID = {inputId} AND IsChecked = '{true}' AND ({whereStringBuilder})) {taxisString}";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
contentIdList.Add(GetInt(rdr, 0));
}
rdr.Close();
}
return(contentIdList);
}
public List <int> GetContentIdListWithChecked(int inputId)
{
var list = new List <int>();
var taxisString = ETaxisTypeUtils.GetInputContentOrderByString(ETaxisType.OrderByTaxisDesc);
string sqlString =
$"SELECT ID FROM {TableName} WHERE (InputID = {inputId} AND IsChecked = '{true}') {taxisString}";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
list.Add(GetInt(rdr, 0));
}
rdr.Close();
}
return(list);
}
public DataSet GetDataSetWithChecked(int inputId)
{
return(GetDataSetWithChecked(inputId, ETaxisTypeUtils.GetInputContentOrderByString(ETaxisType.OrderByTaxisDesc), ""));
}
