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)); }