public readonly string ColName_Field_Title = defDAL.ColName_Field_Title; /* 字段中文标题 */
/// <summary>
/// 获得字段
/// </summary>
/// <param name="field_name"></param>
/// <param name="site_id"></param>
/// <param name="channel_name"></param>
/// <param name="channel_id"></param>
/// <returns></returns>
public Model.dv_SiteChannelFieldInfo[] GetFields(string field_name, int site_id = 0, string channel_name = "", int channel_id = 0)
{
List <string> wheres = new List <string>();
wheres.Add(CreateSQL.WhereEqual(ColName_Field_Name, field_name));
if (site_id > 0)
{
wheres.Add(CreateSQL.WhereEqual(ColName_Channel_SiteID, site_id.ToString()));
}
if (!CheckData.IsStringNull(channel_name))
{
wheres.Add(CreateSQL.WhereEqual(ColName_Channel_Name, channel_name.ToString()));
}
if (channel_id > 0)
{
wheres.Add(CreateSQL.WhereEqual(ColName_ID_ChannelInfo, channel_id.ToString()));
}
string sqlwhere = ConvertTool.ToString(wheres, CreateSQL.WHERE_AND);
DataTable dt = base.GetList(0, sqlwhere, string.Empty).Tables[0];
if (CheckData.IsSizeEmpty(dt))
{
return(new Model.dv_SiteChannelFieldInfo[] { });
}
return(base.GetModelList(dt).ToArray());
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="sid">ID条件</param>
/// <returns>是否成功</returns>
public virtual bool IDDelete(string sid)
{
if (sid == AbsTable_StringID.ERROR_DEFAULT_SID_VALUE)
{
return(true); // 没有错误数据不用删除
}
return(Delete(CreateSQL.WhereEqual(ColName_SID, sid.ToString())));
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="id">ID条件</param>
/// <returns>是否成功</returns>
public virtual bool IDDelete(int id)
{
if (id <= AbsTable_IntID.ERROR_DEFAULT_INT_VALUE)
{
return(true); // 没有错误数据不用删除
}
return(Delete(CreateSQL.WhereEqual(ColName_IID, id.ToString())));
}
/// <summary>
/// 获得IP重复数量
/// </summary>
/// <param name="ip"></param>
/// <param name="time_where"></param>
/// <param name="minute_interval"></param>
/// <returns></returns>
public int GetIPRepeatCount(string ip, DateTime time_where, int minute_interval = 15)
{
if (CheckData.IsStringNull(ip))
{
return(0);
}
List <string> wheres = new List <string>();
wheres.Add(CreateSQL.WhereEqual(ColName_ipaddress, ip));
wheres.Add(string.Format("DATEADD(MINUTE, -{0}, GETDATE()) <= {1}", minute_interval, ColName_TimeAdd));
wheres.Add(string.Format("{0} <= GETDATE()", ColName_TimeAdd));
string sqlwhere = ConvertTool.ToString(wheres, CreateSQL.WHERE_AND);
return(base.GetCount(sqlwhere));
}
/// <summary>
/// 组合字符串
/// </summary>
protected override string CombSqlTxt(BasicsPageDataModel Obj_DaModel)
{
DataModel daModel = new DataModel();
try { daModel = (DataModel)Obj_DaModel; } catch (Exception) { }
List <string> sqls = new List <string>();
if (!CheckData.IsStringNull(daModel.Name))
{
sqls.Add(CreateSQL.WhereEqual(BLL_vismsg.ColName_name, daModel.Name));
}
daModel.Time_Start = daModel.Time_Start.Replace("'", "");
if (!CheckData.IsStringNull(daModel.Time_Start))
{
sqls.Add(CreateSQL.WhereBigThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_Start));
}
daModel.Time_End = daModel.Time_End.Replace("'", "");
if (!CheckData.IsStringNull(daModel.Time_End))
{
sqls.Add(CreateSQL.WhereSmallThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_End));
}
if (!CheckData.IsStringNull(daModel.LikeSelectValue))
{
string[] valArr = ConvertTool.ToArrayList(daModel.LikeSelectValue, ',');
string likeSelString = CreateSQL.WhereLikeAllPropertyInfo(new Model.visitor_message(), valArr);
if (!CheckData.IsStringNull(likeSelString))
{
sqls.Add(likeSelString);
}
}
string resultSQLStr = ConvertTool.ToString(sqls, CreateSQL.WHERE_AND);
if (CheckData.IsStringNull(resultSQLStr.Trim()))
{
return(string.Empty);
}
return(CreateSQL.WHERE_AND + resultSQLStr);
}
/// <summary>
/// Microsoft SQL Server SQL 操作符解析器
/// </summary>
public static string MSQLServer_OperChar_Parser(FieldValueModel FVm)
{
if (CheckData.IsObjectNull(FVm))
{
return(string.Empty);
}
switch (FVm.KeyChar)
{
case DataChar.OperChar.EQUAL:
return(CreateSQL.WhereEqual(FVm.Name, FVm.Value));
case DataChar.OperChar.EQUAL_NOT:
return(CreateSQL.WhereEqualNot(FVm.Name, FVm.Value));
case DataChar.OperChar.LIKE:
return(CreateSQL.WhereLike(FVm.Name, FVm.Value));
case DataChar.OperChar.IN:
return(CreateSQL.WhereIn(FVm.Name, ConvertTool.ToArrayList(FVm.Value, DataChar.ARRAYLIST_INTERVAL_CHAR)));
case DataChar.OperChar.IN_NOT:
return(CreateSQL.WhereInNot(FVm.Name, ConvertTool.ToArrayList(FVm.Value, DataChar.ARRAYLIST_INTERVAL_CHAR)));
case DataChar.OperChar.BigTHAN:
return(CreateSQL.WhereBigThan(FVm.Name, FVm.Value));
case DataChar.OperChar.BigTHAN_EQUAL:
return(CreateSQL.WhereBigThanEqual(FVm.Name, FVm.Value));
case DataChar.OperChar.SmallTHAN:
return(CreateSQL.WhereSmallThan(FVm.Name, FVm.Value));
case DataChar.OperChar.SmallTHAN_EQUAL:
return(CreateSQL.WhereSmallThanEqual(FVm.Name, FVm.Value));
default:
FVm.SetKeyChar(DataChar.OperChar.EQUAL);
return(MSQLServer_OperChar_Parser(FVm));
}
}
/// <summary>
/// 获取模型数据
/// </summary>
/// <param name="sid">ID条件</param>
/// <returns>映射数据模型</returns>
public virtual M IDGetModel(string sid)
{
return(GetModel(CreateSQL.WhereEqual(ColName_SID, sid.ToString()), null));
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="keyvaluedic">更新的内容和其值</param>
/// <param name="sid">ID条件</param>
/// <returns>是否成功</returns>
public virtual bool IDUpdate(KeyObject[] keyvaluedic, string sid)
{
return(Update(keyvaluedic, CreateSQL.WhereEqual(ColName_SID, sid.ToString())));
}
/// <summary>
/// 获取模型数据
/// </summary>
/// <param name="id">ID条件</param>
/// <returns>映射数据模型</returns>
public virtual M IDGetModel(int id)
{
return(GetModel(CreateSQL.WhereEqual(ColName_IID, id.ToString()), null));
}
