public bool IsExists(int publishmentSystemId, int cardId, string userName)
{
var isExist = false;
string sqlWhere = $"WHERE PublishmentSystemID = {publishmentSystemId}";
if (cardId > 0)
{
sqlWhere += $" AND CardID={cardId}";
}
if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" AND UserName='******'";
}
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
isExist = true;
}
rdr.Close();
}
return(isExist);
}
public List <string> GetUserNameList(string searchWord, int dayOfCreation, int dayOfLastActivity, bool isChecked)
{
var arraylist = new List <string>();
var whereString = string.Empty;
if (dayOfCreation > 0)
{
var dateTime = DateTime.Now.AddDays(-dayOfCreation);
whereString += $" AND (CreationDate >= '{dateTime:yyyy-MM-dd}') ";
}
if (dayOfLastActivity > 0)
{
var dateTime = DateTime.Now.AddDays(-dayOfLastActivity);
whereString += $" AND (LastActivityDate >= '{dateTime:yyyy-MM-dd}') ";
}
if (!string.IsNullOrEmpty(searchWord))
{
var word = PageUtils.FilterSql(searchWord);
whereString += $" AND (UserName LIKE '%{word}%' OR EMAIL LIKE '%{word}%') ";
}
string sqlString =
$"SELECT * FROM bairong_Administrator WHERE IsChecked = '{isChecked}' {whereString}";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
arraylist.Add(GetString(rdr, 0));
}
rdr.Close();
}
return(arraylist);
}
public CardSnInfo GetCardSnInfo(int publishmentSystemId, int cardId, string cardSn, string userName)
{
CardSnInfo cardSnInfo = null;
string sqlWhere = $"WHERE {CardSnAttribute.PublishmentSystemId} = {publishmentSystemId} ";
if (cardId > 0)
{
sqlWhere += $" AND {CardSnAttribute.CardId}='{cardId}'";
}
if (!string.IsNullOrEmpty(cardSn))
{
sqlWhere += $" AND {CardSnAttribute.Sn}='{PageUtils.FilterSql(cardSn)}'";
}
if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" AND {CardSnAttribute.UserName}='{PageUtils.FilterSql(userName)}'";
}
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
cardSnInfo = new CardSnInfo(rdr);
}
rdr.Close();
}
return(cardSnInfo);
}
public IDataReader GetDataSource(int siteId, string searchText, string templateTypeString)
{
if (string.IsNullOrEmpty(searchText) && string.IsNullOrEmpty(templateTypeString))
{
var parms = new IDataParameter[]
{
GetParameter(ParmSiteId, DataType.Integer, siteId)
};
var enumerable = ExecuteReader(SqlSelectAllTemplateBySiteId, parms);
return(enumerable);
}
if (!string.IsNullOrEmpty(searchText))
{
var whereString = (string.IsNullOrEmpty(templateTypeString)) ? string.Empty :
$"AND TemplateType = '{templateTypeString}' ";
searchText = PageUtils.FilterSql(searchText);
whereString +=
$"AND (TemplateName LIKE '%{searchText}%' OR RelatedFileName LIKE '%{searchText}%' OR CreatedFileFullName LIKE '%{searchText}%' OR CreatedFileExtName LIKE '%{searchText}%')";
string sqlString =
$"SELECT Id, SiteId, TemplateName, TemplateType, RelatedFileName, CreatedFileFullName, CreatedFileExtName, Charset, IsDefault FROM siteserver_Template WHERE SiteId = {siteId} {whereString} ORDER BY TemplateType, RelatedFileName";
var enumerable = ExecuteReader(sqlString);
return(enumerable);
}
return(GetDataSourceByType(siteId, TemplateTypeUtils.GetEnumType(templateTypeString)));
}
public List <string> GetUserNameList(int publishmentSystemId, int cardId, string cardSn, string userName)
{
var userNameList = new List <string>();
string sqlWhere = $"WHERE {CardSnAttribute.PublishmentSystemId} = {publishmentSystemId} ";
if (cardId > 0)
{
sqlWhere += $" AND CardID = {cardId}";
}
if (!string.IsNullOrEmpty(cardSn))
{
sqlWhere += $" AND {CardSnAttribute.Sn}='{PageUtils.FilterSql(cardSn)}'";
}
if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" AND {CardSnAttribute.UserName} ='{PageUtils.FilterSql(userName)}'";
}
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var cardSnInfo = new CardSnInfo(rdr);
if (!userNameList.Contains(cardSnInfo.UserName))
{
userNameList.Add(cardSnInfo.UserName);
}
}
rdr.Close();
}
return(userNameList);
}
public AppointmentContentInfo GetLatestContentInfo(int itemID, string cookieSN, string wxOpenID, string userName)
{
AppointmentContentInfo contentInfo = null;
string SQL_WHERE = $"WHERE {AppointmentContentAttribute.AppointmentItemID} = {itemID}";
SQL_WHERE += $" AND ({AppointmentContentAttribute.CookieSN} = '{PageUtils.FilterSql(cookieSN)}'";
if (!string.IsNullOrEmpty(wxOpenID))
{
SQL_WHERE += $" AND {AppointmentContentAttribute.WXOpenID} = '{PageUtils.FilterSql(wxOpenID)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
SQL_WHERE += $" AND {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
SQL_WHERE += ")";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
contentInfo = new AppointmentContentInfo(rdr);
}
rdr.Close();
}
return(contentInfo);
}
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 AppointmentContentInfo GetLatestContentInfo(int itemId, string cookieSn, string wxOpenId, string userName)
{
AppointmentContentInfo contentInfo = null;
string sqlWhere = $"WHERE {AppointmentContentAttribute.AppointmentItemId} = {itemId}";
sqlWhere += $" AND ({AppointmentContentAttribute.CookieSn} = '{PageUtils.FilterSql(cookieSn)}'";
if (!string.IsNullOrEmpty(wxOpenId))
{
sqlWhere += $" AND {AppointmentContentAttribute.WxOpenId} = '{PageUtils.FilterSql(wxOpenId)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" AND {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
sqlWhere += ")";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
contentInfo = new AppointmentContentInfo(rdr);
}
rdr.Close();
}
return(contentInfo);
}
public string GetSelectCommend(ETriState successState, string keyword, string dateFrom, string dateTo)
{
var whereString = new StringBuilder("WHERE ");
if (successState != ETriState.All)
{
whereString.AppendFormat("IsSuccess = '{0}'", ETriStateUtils.GetValue(successState));
}
else
{
whereString.Append("1 = 1");
}
if (!string.IsNullOrEmpty(keyword))
{
whereString.Append(" AND ");
whereString.AppendFormat("(ErrorMessage LIKE '%{0}%')", PageUtils.FilterSql(keyword));
}
if (!string.IsNullOrEmpty(dateFrom))
{
whereString.Append(" AND ");
whereString.AppendFormat("(AddDate >= '{0}')", dateFrom);
}
if (!string.IsNullOrEmpty(dateTo))
{
whereString.Append(" AND ");
whereString.AppendFormat("(AddDate <= '{0}')", dateTo);
}
return("SELECT ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate FROM siteserver_CreateTaskLog " + whereString);
}
public string GetSelectCommendByContentGroup(string tableName, string contentGroupName, int publishmentSystemId)
{
contentGroupName = PageUtils.FilterSql(contentGroupName);
string sqlString =
$"SELECT * FROM {tableName} WHERE PublishmentSystemID={publishmentSystemId} AND NodeID>0 AND (ContentGroupNameCollection LIKE '{contentGroupName},%' OR ContentGroupNameCollection LIKE '%,{contentGroupName}' OR ContentGroupNameCollection LIKE '%,{contentGroupName},%' OR ContentGroupNameCollection='{contentGroupName}')";
return(sqlString);
}
//得到属于此发布系统和栏目组的所有栏目
public List <NodeInfo> GetNodeInfoListChecked(int publishmentSystemId, string nodeGroupName)
{
nodeGroupName = PageUtils.FilterSql(nodeGroupName);
string whereString =
$" AND (siteserver_Node.NodeGroupNameCollection = '{nodeGroupName}' OR siteserver_Node.NodeGroupNameCollection LIKE '{nodeGroupName},%' OR siteserver_Node.NodeGroupNameCollection LIKE '%,{nodeGroupName},%' OR siteserver_Node.NodeGroupNameCollection LIKE '%,{nodeGroupName}')";
return(DataProvider.NodeDao.GetNodeInfoListByPublishmentSystemId(publishmentSystemId, whereString));
}
private void SetTaxisSubtract(int areaId, string parentsPath, int subtractNum)
{
var path = PageUtils.FilterSql(parentsPath);
string sqlString =
$"UPDATE bairong_Area SET Taxis = Taxis - {subtractNum} WHERE AreaID = {areaId} OR ParentsPath = '{path}' OR ParentsPath LIKE '{path},%'";
ExecuteNonQuery(sqlString);
AreaManager.ClearCache();
}
public List <string> GetKeywordListByContent(string content)
{
//string sqlString =
// $"SELECT Keyword FROM siteserver_Keyword WHERE CHARINDEX(Keyword, '{PageUtils.FilterSql(content)}') > 0";
var inStr = WebConfigUtils.IsMySql ? $"INSTR('{PageUtils.FilterSql(content)}', Keyword) > 0" : $"CHARINDEX(Keyword, '{PageUtils.FilterSql(content)}') > 0";
var sqlString = $"SELECT Keyword FROM siteserver_Keyword WHERE {inStr}";
return(BaiRongDataProvider.DatabaseDao.GetStringList(sqlString));
}
private void SetTaxisAdd(int areaId, string parentsPath, int addNum)
{
var path = PageUtils.FilterSql(parentsPath);
string sqlString =
$"UPDATE siteserver_Area SET Taxis = Taxis + {addNum} WHERE Id = {areaId} OR ParentsPath = '{path}' OR ParentsPath LIKE '{path},%'";
ExecuteNonQuery(sqlString);
AreaManager.ClearCache();
}
private void SetTaxisSubtract(int id, string parentsPath, int subtractNum)
{
var path = PageUtils.FilterSql(parentsPath);
string sqlString =
$"UPDATE siteserver_Department SET Taxis = Taxis - {subtractNum} WHERE Id = {id} OR ParentsPath = '{path}' OR ParentsPath LIKE '{path},%'";
ExecuteNonQuery(sqlString);
DepartmentManager.ClearCache();
}
private void SetTaxisAdd(int departmentId, string parentsPath, int addNum)
{
var path = PageUtils.FilterSql(parentsPath);
string sqlString =
$"UPDATE bairong_Department SET Taxis = Taxis + {addNum} WHERE DepartmentID = {departmentId} OR ParentsPath = '{path}' OR ParentsPath LIKE '{path},%'";
ExecuteNonQuery(sqlString);
DepartmentManager.ClearCache();
}
public void Page_Load(object sender, EventArgs e)
{
var type = PageUtils.FilterSql(Request.QueryString["type"]);
if (string.IsNullOrEmpty(type))
{
type = TypeRedirect;
}
if (StringUtils.EqualsIgnoreCase(type, TypeRedirect))
{
Redirect();
}
}
public IEnumerable GetDataSourceByName(string adAreaName, int publishmentSystemId)
{
var strSql = new StringBuilder();
strSql.AppendFormat("SELECT AdAreaID, PublishmentSystemID,AdAreaName, Width, Height, Summary, IsEnabled,AddDate FROM siteserver_AdArea WHERE PublishmentSystemID ={0}", publishmentSystemId);
if (!string.IsNullOrEmpty(adAreaName))
{
strSql.AppendFormat(" AND AdAreaName LIKE '%{0}%'", PageUtils.FilterSql(adAreaName));
}
strSql.Append("ORDER BY AddDate DESC");
var enumerable = (IEnumerable)ExecuteReader(strSql.ToString());
return(enumerable);
}
public string GetSelectCommend(string userName, string keyword, string dateFrom, string dateTo)
{
if (string.IsNullOrEmpty(userName) && string.IsNullOrEmpty(keyword) && string.IsNullOrEmpty(dateFrom) && string.IsNullOrEmpty(dateTo))
{
return(GetSelectCommend());
}
var whereString = new StringBuilder("WHERE ");
var isWhere = false;
if (!string.IsNullOrEmpty(userName))
{
isWhere = true;
whereString.AppendFormat("(UserName = '******')", PageUtils.FilterSql(userName));
}
if (!string.IsNullOrEmpty(keyword))
{
if (isWhere)
{
whereString.Append(" AND ");
}
isWhere = true;
whereString.AppendFormat("(Action LIKE '%{0}%' OR Summary LIKE '%{0}%')", PageUtils.FilterSql(keyword));
}
if (!string.IsNullOrEmpty(dateFrom))
{
if (isWhere)
{
whereString.Append(" AND ");
}
isWhere = true;
whereString.Append($"(AddDate >= {SqlUtils.GetComparableDate(TranslateUtils.ToDateTime(dateFrom))})");
}
if (!string.IsNullOrEmpty(dateTo))
{
if (isWhere)
{
whereString.Append(" AND ");
}
whereString.Append($"(AddDate <= {SqlUtils.GetComparableDate(TranslateUtils.ToDateTime(dateTo))})");
}
return("SELECT ID, UserName, IPAddress, AddDate, Action, Summary FROM siteserver_Log " + whereString);
}
public List <AppointmentContentInfo> GetLatestContentInfoList(int appointmentId, string cookieSn, string wxOpenId, string userName)
{
var list = new List <AppointmentContentInfo>();
string sqlWhere = $"WHERE {AppointmentContentAttribute.AppointmentId} = {appointmentId}";
sqlWhere += $" AND ({AppointmentContentAttribute.CookieSn} = '{PageUtils.FilterSql(cookieSn)}'";
if (!string.IsNullOrEmpty(wxOpenId))
{
sqlWhere += $" AND {AppointmentContentAttribute.WxOpenId} = '{PageUtils.FilterSql(wxOpenId)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" AND {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
sqlWhere += ")";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var contentInfo = new AppointmentContentInfo(rdr);
var isExists = false;
foreach (var theContentInfo in list)
{
if (theContentInfo.AppointmentItemId == contentInfo.AppointmentItemId)
{
isExists = true;
}
}
if (!isExists)
{
list.Add(contentInfo);
}
}
rdr.Close();
}
return(list);
}
public List <AppointmentContentInfo> GetLatestContentInfoList(int appointmentID, string cookieSN, string wxOpenID, string userName)
{
var list = new List <AppointmentContentInfo>();
string SQL_WHERE = $"WHERE {AppointmentContentAttribute.AppointmentID} = {appointmentID}";
SQL_WHERE += $" AND ({AppointmentContentAttribute.CookieSN} = '{PageUtils.FilterSql(cookieSN)}'";
if (!string.IsNullOrEmpty(wxOpenID))
{
SQL_WHERE += $" AND {AppointmentContentAttribute.WXOpenID} = '{PageUtils.FilterSql(wxOpenID)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
SQL_WHERE += $" AND {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
SQL_WHERE += ")";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, "ORDER BY ID DESC");
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
var contentInfo = new AppointmentContentInfo(rdr);
var isExists = false;
foreach (var theContentInfo in list)
{
if (theContentInfo.AppointmentItemID == contentInfo.AppointmentItemID)
{
isExists = true;
}
}
if (!isExists)
{
list.Add(contentInfo);
}
}
rdr.Close();
}
return(list);
}
private string GetWhereString(string tag, int siteId, int contentId)
{
var builder = new StringBuilder();
builder.Append($" WHERE SiteId = {siteId} ");
if (!string.IsNullOrEmpty(tag))
{
builder.Append($"AND Tag = '{PageUtils.FilterSql(tag)}' ");
}
if (contentId > 0)
{
builder.Append(
$"AND (ContentIdCollection = '{contentId}' OR ContentIdCollection LIKE '{contentId},%' OR ContentIdCollection LIKE '%,{contentId},%' OR ContentIdCollection LIKE '%,{contentId}')");
}
return(builder.ToString());
}
public decimal GetAmount(int cardSnid, string userName)
{
decimal amount = 0;
string sqlWhere = $"WHERE ID = {cardSnid} AND userName='******'";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
var cardSnInfo = new CardSnInfo(rdr);
amount = cardSnInfo.Amount;
}
rdr.Close();
}
return(amount);
}
public bool IsExists(string tableName)
{
var isExists = false;
string sqlString =
$"SELECT TableName FROM siteserver_Table WHERE TableName = '{PageUtils.FilterSql(tableName)}'";
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read() && !rdr.IsDBNull(0))
{
isExists = true;
}
rdr.Close();
}
return(isExists);
}
public decimal GetAmount(int cardSNID, string userName)
{
decimal amount = 0;
string SQL_WHERE = $"WHERE ID = {cardSNID} AND userName='******'";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
var cardSNInfo = new CardSNInfo(rdr);
amount = cardSNInfo.Amount;
}
rdr.Close();
}
return(amount);
}
public bool IsSign(int publishmentSystemId, string userName)
{
var isSign = false;
string sqlWhere =
$"WHERE PublishmentSystemID ={publishmentSystemId} AND UserName = '******' AND SignDate > '{DateTime.Now.Year}-{DateTime.Now.Month}-{DateTime.Now.Day}'";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
isSign = true;
}
rdr.Close();
}
return(isSign);
}
public string GetSelectString(int publishmentSystemID, int cardID, string cardSN, string userName, string mobile)
{
string whereString =
$"WHERE {CardEntitySNAttribute.PublishmentSystemID} = {publishmentSystemID} AND {CardEntitySNAttribute.CardID} = {cardID}";
if (!string.IsNullOrEmpty(cardSN))
{
whereString += $" AND {CardEntitySNAttribute.SN} ='{PageUtils.FilterSql(cardSN)}')";
}
if (!string.IsNullOrEmpty(userName))
{
whereString += $" AND {CardEntitySNAttribute.UserName}='{PageUtils.FilterSql(userName)}'";
}
if (!string.IsNullOrEmpty(mobile))
{
whereString += $" AND {CardEntitySNAttribute.Mobile} ='{PageUtils.FilterSql(mobile)}')";
}
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TABLE_NAME, SqlUtils.Asterisk, whereString));
}
public bool IsSign(int publishmentSystemID, string userName)
{
var isSign = false;
string SQL_WHERE =
$"WHERE PublishmentSystemID ={publishmentSystemID} AND UserName = '******' AND SignDate > '{DateTime.Now.Year}-{DateTime.Now.Month}-{DateTime.Now.Day}'";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
isSign = true;
}
rdr.Close();
}
return(isSign);
}
public string GetSelectCommend(string pluginId, string keyword, string dateFrom, string dateTo)
{
var whereString = new StringBuilder();
if (!string.IsNullOrEmpty(pluginId))
{
whereString.Append($"PluginId = '{PageUtils.FilterSql(pluginId)}'");
}
if (!string.IsNullOrEmpty(keyword))
{
if (whereString.Length > 0)
{
whereString.Append(" AND ");
}
var filterKeyword = PageUtils.FilterSql(keyword);
var keywordId = TranslateUtils.ToInt(keyword);
whereString.Append(keywordId > 0
? $"Id = {keywordId}"
: $"(Message LIKE '%{filterKeyword}%' OR Stacktrace LIKE '%{filterKeyword}%' OR Summary LIKE '%{filterKeyword}%')");
}
if (!string.IsNullOrEmpty(dateFrom))
{
if (whereString.Length > 0)
{
whereString.Append(" AND ");
}
whereString.Append($"AddDate >= {SqlUtils.GetComparableDate(TranslateUtils.ToDateTime(dateFrom))}");
}
if (!string.IsNullOrEmpty(dateTo))
{
if (whereString.Length > 0)
{
whereString.Append(" AND ");
}
whereString.Append($"AddDate <= {SqlUtils.GetComparableDate(TranslateUtils.ToDateTime(dateTo))}");
}
return(whereString.Length > 0
? $"SELECT Id, PluginId, Message, Stacktrace, Summary, AddDate FROM {TableName} WHERE {whereString}"
: $"SELECT Id, PluginId, Message, Stacktrace, Summary, AddDate FROM {TableName}");
}
public List <DateTime> GetSignDateList(int publishmentSystemId, string userName)
{
var signDateList = new List <DateTime>();
string sqlWhere =
$"WHERE PublishmentSystemID = {publishmentSystemId} AND UserName='******'";
var sqlOrder = " ORDER BY SignDate DESC ";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, CardSignLogAttribute.SignDate, sqlWhere, sqlOrder);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
signDateList.Add(ConvertHelper.GetDateTime(rdr.GetValue(0)));
}
rdr.Close();
}
return(signDateList);
}