/// <summary> /// 添加黑名单 /// </summary> /// <param name="blackListModel">黑名单信息</param> /// <returns>执行结果 >0 执行成功, -1执行遇到异常</returns> public static int AddMobileBlackList(BlacklistModel blackListModel) { string sp = "AddMobileBlackList"; SqlParameter[] paras = new SqlParameter[] { GetSqlParameter("@userid", SqlDbType.VarChar, blackListModel.UserID, 20), GetSqlParameter("@state", SqlDbType.TinyInt, blackListModel.State, 4), GetSqlParameter("@userType", SqlDbType.TinyInt, blackListModel.UserType, 4), GetSqlParameter("@userIP", SqlDbType.NVarChar, blackListModel.UserIP, 100), GetSqlParameter("@groupId", SqlDbType.Int, blackListModel.GroupID, 4), GetSqlParameter("@blackDate", SqlDbType.DateTime, blackListModel.BlackDate), GetSqlParameter("@operateIP", SqlDbType.VarChar, blackListModel.OperateIP, 30), GetSqlParameter("@operateNum", SqlDbType.VarChar, blackListModel.OperateBH, 30), GetSqlParameter("@Mobile", SqlDbType.NVarChar, blackListModel.Mobile, 100), GetSqlParameter("@Remark", SqlDbType.Text, blackListModel.Remark, 1000) }; try { return(DBHelper.ExecuteNonQuery(sp, paras, CommandType.StoredProcedure)); } catch (SqlException) { return(-1); } }
/// <summary> /// Exports the blacklists. /// </summary> /// <param name="blacklistModel">The blacklists model.s</param> private void ExportBlacklists(BlacklistModel blacklistModel) { var importExport = new ImportExport(); importExport.WriteDataToXmlFile(blacklistModel, Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Blacklist.xml")); MessageBox.Show(this.languageManager.GetWord("BlacklistSavedTest"), this.languageManager.GetWord("BlacklistSavedCaption"), MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void LoadDataToTable(BlacklistModel blacklistModel) { foreach (var blacklist in blacklistModel.Blacklists) { LoadDataRow(blacklist); } }
public static void AddBlackList(SqlTransaction tran, string number, int type, string operateIP, string operateNum, int groupid) { string sql = ""; if (type == 5) { sql = "select number from memberinfo where placement=@number"; } else { sql = "select number from memberinfo where direct=@number"; } SqlParameter para = new SqlParameter("@number", number); SqlDataReader dr = DBHelper.ExecuteReader(sql, para, CommandType.Text); while (dr.Read()) { number = dr.GetString(0); AddBlackList(tran, number, type, operateIP, operateNum, groupid); BlacklistModel blackListModel = new BlacklistModel(); blackListModel.UserType = 0; blackListModel.UserID = number; blackListModel.OperateBH = operateNum; blackListModel.OperateIP = operateIP; blackListModel.GroupID = groupid; blackListModel.BlackDate = DateTime.Now.ToUniversalTime(); AddBlackList(tran, blackListModel, "AddBlackList"); } dr.Close(); }
/// <summary> /// 获取指定编号的和类型的黑名单 /// </summary> /// <param name="userid">黑名单编号</param> /// <param name="userType">黑名单类型</param> /// <param name="groupId">黑名单组别</param> /// <returns></returns> public static BlacklistModel GetBlackList(string userid, int userType, int groupId) { BlacklistModel obj = null; string sql = "select * from blackList where userid=@userid and userType=@userType and groupId = @groupId"; SqlParameter[] paras = new SqlParameter[] { GetSqlParameter("@userid", SqlDbType.VarChar, userid), GetSqlParameter("@userType", SqlDbType.Int, userType), GetSqlParameter("@groupId", SqlDbType.Int, groupId) }; SqlDataReader dr = DBHelper.ExecuteReader(sql, paras, CommandType.Text); if (dr.Read()) { obj = new BlacklistModel(dr.GetInt32(0)); obj.UserID = dr.GetString(1); obj.State = dr.GetByte(2); obj.UserType = dr.GetByte(3); obj.UserIP = dr.GetString(4); obj.GroupID = dr.GetInt32(5); obj.BlackDate = dr.GetDateTime(6); obj.OperateIP = dr.GetString(7); obj.OperateBH = dr.GetString(8); } dr.Close(); return(obj); }
/// <summary> /// 下发黑名单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SendTrafficRestriction(BlacklistModel models) { bool result = false; try { List <BlacklistDetialModel> sendmodel = new List <BlacklistDetialModel>(); foreach (var model in models.List) { BlacklistDetialModel detialmodel = new BlacklistDetialModel(); detialmodel.CarNo = model.CarNo; detialmodel.Always = model.Always; detialmodel.IsDelete = model.Enable ? false : true; if (!model.Always) { if (model.ByDate) { DateTime startDt = DateTime.MinValue; DateTime.TryParse(model.StartDate, out startDt); DateTime endDt = DateTime.MinValue; DateTime.TryParse(model.EndDate, out endDt); detialmodel.DateInterval = startDt.ToString("yyMMdd") + endDt.ToString("yyMMdd"); } if (model.ByTime) { DateTime startTime = DateTime.MinValue; DateTime.TryParse(model.StatrtTime, out startTime); DateTime endTime = DateTime.MinValue; DateTime.TryParse(model.EndTime, out endTime); detialmodel.TimeInterval = startTime.ToString("HHmmss") + endTime.ToString("HHmmss"); } if (model.ByWeek) { detialmodel.WeekInterval = model.AssignDay; } } sendmodel.Add(detialmodel); } CommandEntity <List <BlacklistDetialModel> > entity = new CommandEntity <List <BlacklistDetialModel> >() { command = BussineCommand.BlackList, idMsg = Convert.ToBase64String(Guid.NewGuid().ToByteArray()), message = sendmodel }; result = m_rabbitMQ.SendMessageForRabbitMQ("发送黑名单指令", m_serializer.Serialize(entity), entity.idMsg, models.ParkCode); if (!result) { LastErrorDescribe = BussinessErrorCodeEnum.BUSINESS_MQ_SEND_ERROR.GetDesc(); } return(result); } catch (Exception ex) { m_logger.LogFatal(LoggerLogicEnum.Bussiness, "", models.ParkCode, "", "Fujica.com.cn.Business.ParkLot.BlacklistManager.SendTrafficRestriction", "下发黑名单时发生异常", ex.ToString()); LastErrorDescribe = BussinessErrorCodeEnum.BUSINESS_MQ_SEND_ERROR.GetDesc(); return(false); } }
private void LoadDataToCombobox(BlacklistModel blacklistModel) { comboBoxBlacklist.Items.Clear(); foreach (var blacklist in blacklistModel.Blacklists) { comboBoxBlacklist.Items.Add(blacklist.Name); } }
private void ExportBlacklists(BlacklistModel blacklistModel) { IImportExport importExport = new ImportExport(); importExport.WriteDataToXmlFile(blacklistModel, Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Blacklist.xml")); MessageBox.Show(Resources.BlacklistSavedTest, Resources.BlacklistSavedCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); }
private BlacklistModel GetDataFromTable() { var model = new BlacklistModel(); foreach (DataGridViewRow row in dataGridViewBlacklist.Rows) { AddItemsToBlacklist(model, row); } return(model); }
private async Task Remove(Infrastructure.Schema.Blacklist row) { var confirmed = await JSRuntime.InvokeAsync <bool>("confirm", new object[] { $"Remove rule '{row.Pattern}'?" }); if (confirmed) { BlacklistModel.Remove(row); _blacklistTable !.InvalidateData(); await ReloadBlacklist(); } }
/// <summary> /// 修改黑名单 /// </summary> /// <returns></returns> public bool ModifyBlacklist(BlacklistModel model) { bool flag = _iBlacklistContext.ModifyBlacklist(model); if (!flag) { LastErrorDescribe = BussinessErrorCodeEnum.BUSINESS_SAVE_BLACK.GetDesc(); return(false); } return(SendTrafficRestriction(model)); }
/// <summary> /// 下发黑名单 /// </summary> /// <param name="parkingCode"></param> /// <returns></returns> public bool SendTrafficRestriction(string parkCode) { bool flag = true; BlacklistModel models = GetBlacklist(parkCode); if (models != null) { flag = SendTrafficRestriction(models); } return(flag); }
protected void Add_blackList_Click(object sender, EventArgs e) { //验证用户填写黑名单店铺 if (txtStoreID.Text == "") { //提示用户填写 ScriptHelper.SetAlert(out msg, GetTran("001393", "必须提供店铺编号!")); this.txtStoreID.Focus(); return; } //判断当前编号是否存在 if (BlackListBLL.CheckStoreID(txtStoreID.Text)) { ScriptHelper.SetAlert(out msg, GetTran("001391", "提供店铺编号在该系统中不存在!")); return; } //判断是否已经存在该黑名单IP 3代表IP类型 if (BlackListBLL.HasBlackList(txtStoreID.Text.Trim(), 4, 0)) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("001390", "指定的店铺编号已经存在,无法增加!")); this.txtStoreID.Text = ""; return; } BlacklistModel blackListModel = new BlacklistModel(); //店铺类型类型 blackListModel.UserType = 4; blackListModel.UserID = txtStoreID.Text; blackListModel.OperateBH = Session["Company"].ToString(); blackListModel.OperateIP = Request.UserHostAddress.ToString(); blackListModel.GroupID = 0; blackListModel.BlackDate = DateTime.Now; switch (BlackListBLL.AddBlackList(blackListModel)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000891", "添加成功!")); break; case -1: ScriptHelper.SetAlert(out msg, GetTran("001087", "执行发生错误!")); break; default: ScriptHelper.SetAlert(out msg, GetTran("001089", "数据异常")); break; } this.txtStoreID.Text = ""; PageSet(); Translations(); }
protected void Add_blackList_Click(object sender, EventArgs e) { //验证用户填写黑名单IP if (txtNumber.Text == "") { //提示用户填写 ScriptHelper.SetAlert(out msg, GetTran("001237", "必须提供会员编号!")); this.txtNumber.Focus(); return; } //判断当前编号是否存在 if (ChangeTeamBLL.CheckNum(this.txtNumber.Text.Trim())) { ScriptHelper.SetAlert(out msg, GetTran("001238", "提供会员编号在该系统中不存在!")); return; } //判断是否已经存在该黑名单IP 3代表IP类型 if (BlackListBLL.HasBlackList(txtNumber.Text, 0, 0)) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("001242", "指定的会员编号已经存在,无法增加!")); this.txtNumber.Text = ""; return; } BlacklistModel blackListModel = new BlacklistModel(); //ip类型 blackListModel.UserType = 0; blackListModel.UserID = txtNumber.Text; blackListModel.OperateBH = Session["Company"].ToString(); blackListModel.OperateIP = HttpContext.Current.Request.UserHostAddress.ToString(); blackListModel.GroupID = 0; blackListModel.BlackDate = DateTime.Now; switch (BlackListBLL.AddBlackList(blackListModel)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000891", "添加成功!")); break; case -1: ScriptHelper.SetAlert(out msg, GetTran("001087", "执行发生错误!")); break; default: ScriptHelper.SetAlert(out msg, GetTran("001089", "数据异常")); break; } this.txtNumber.Text = ""; PageSet(); Translations(); }
public static void AddBlackList(SqlTransaction tran, BlacklistModel blackListModel, string sp) { SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@userid", blackListModel.UserID), new SqlParameter("@state", blackListModel.State), new SqlParameter("@userType", blackListModel.UserType), new SqlParameter("@userIP", blackListModel.UserIP), new SqlParameter("@groupId", blackListModel.GroupID), new SqlParameter("@blackDate", blackListModel.BlackDate), new SqlParameter("@operateIP", blackListModel.OperateIP), new SqlParameter("@operateNum", blackListModel.OperateBH) }; DBHelper.ExecuteNonQuery(tran, sp, paras, CommandType.StoredProcedure); }
/// <summary> /// 获取某黑名单 /// </summary> /// <param name="guid"></param> /// <returns></returns> public BlacklistModel GetBlacklist(string parkcode) { BlacklistModel model = new BlacklistModel(); try { //只从数据库读,redis并不缓存此实体 model = databaseoperate.GetFromDataBase(parkcode); model.List.OrderByDescending(a => a.StartDate).ToList(); //降序 return(model); } catch (Exception ex) { return(null); } }
/// <summary> /// 删除黑名单 /// </summary> /// <returns></returns> public bool DeleteBlacklist(BlacklistModel model) { bool flag = _iBlacklistContext.DeleteBlacklist(model); if (!flag) { LastErrorDescribe = BussinessErrorCodeEnum.BUSINESS_DELETE_BLACK.GetDesc(); return(false); } //删除的时候,将Enable设为不启用,以便发送给相机的数据进行处理 foreach (var item in model.List) { item.Enable = false; } return(SendTrafficRestriction(model)); }
private void LoadBlacklists() { try { if (!File.Exists(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Blacklist.xml"))) { return; } IImportExport importExport = new ImportExport(); _blacklistModel = importExport.LoadConfigFromXmlFile(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Blacklist.xml")); LoadDataToCombobox(_blacklistModel); } catch (Exception ex) { MessageBox.Show(ex.StackTrace, ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void AddItemsToBlacklist(BlacklistModel model, DataGridViewRow row) { if (row.Cells[0].Value == null) { return; } if (model.Blacklists == null) { model.Blacklists = new List <Blacklist>(); } var list = new Blacklist { Name = row.Cells[0].Value.ToString(), FilterList = GetListFromString(row.Cells[1].Value.ToString()) }; model.Blacklists.Add(list); }
/// <summary> /// 分页获取黑名单设置 /// </summary> /// <param name="pageInfo">分页帮助类</param> /// <param name="condition">分页条件</param> /// <param name="tableName">表名</param> /// <param name="columns">列名</param> /// <param name="key">分页键</param> /// <returns></returns> public static IList <BlacklistModel> GetBlackList(Model.Other.PaginationModel pageInfo, string condition, string tableName, string columns, string key) { SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@tableName", tableName), new SqlParameter("@key", key), new SqlParameter("@comlums", columns), new SqlParameter("@condition", condition), new SqlParameter("@start", pageInfo.GetPageDate()), new SqlParameter("@end", pageInfo.GetEndDate()), new SqlParameter("@DataCount", pageInfo.DataCount) }; ps[6].Direction = ParameterDirection.Output; ps[6].Size = 10; SqlDataReader dr = DBHelper.ExecuteReader("GetDataPagePagination", ps, CommandType.StoredProcedure); IList <BlacklistModel> blacks = null; //DataTable blacks = SqlDataReaderHelp.GetDataTable(pageInfo, tableName, key, columns, condition); if (dr.HasRows) { blacks = new List <BlacklistModel>(); while (dr.Read()) { BlacklistModel black = new BlacklistModel(dr.GetInt32(0)); black.UserID = dr.GetString(1); black.State = dr.GetByte(2); black.UserType = dr.GetByte(3); black.UserIP = dr.GetString(4); black.GroupID = dr.GetInt32(5); black.BlackDate = dr.GetDateTime(6); black.OperateIP = dr.GetString(7); black.OperateBH = dr.GetString(8); blacks.Add(black); } dr.NextResult(); pageInfo.DataCount = Convert.ToInt32(ps[6].Value.ToString()); } dr.Close(); return(blacks); }
/// <summary> /// 加入黑名单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Add_blackList_Click(object sender, EventArgs e) { //验证用户填写黑名单IP if (IPBianhao.Text == "") { //提示用户填写 ScriptHelper.SetAlert(out msg, GetTran("001075", "必须提供IP地址!")); this.IPBianhao.Focus(); return; } //验证黑名单IP合法性 if (!IsValidIP(IPBianhao.Text)) { //提示无效 ScriptHelper.SetAlert(out msg, GetTran("001078", "必须提供有效的IP地址!")); this.IPBianhao.Text = ""; this.IPBianhao.Focus(); return; } //判断是否已经存在该黑名单IP 3代表IP类型 string ip = IPBianhao.Text.Replace(" ", ""); string[] ips = ip.Split('.'); ip = ""; foreach (string _ip in ips) { if (ip.Trim() != "*") { try { ip += int.Parse(_ip) + "."; } catch (FormatException) { ScriptHelper.SetAlert(out msg, GetTran("001078", "必须提供有效的IP地址!")); return; } } else { ip += _ip + "."; } } ip = ip.Substring(0, ip.Length - 1); if (BlackListBLL.HasBlackList(ip, 3, 0)) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("001083", "指定的IP已经存在,无法增加!")); this.IPBianhao.Text = ""; return; } BlacklistModel blackListModel = new BlacklistModel(); //ip类型 blackListModel.UserType = 3; blackListModel.UserID = ip; blackListModel.OperateBH = Session["Company"].ToString(); blackListModel.OperateIP = HttpContext.Current.Request.UserHostAddress.ToString(); blackListModel.GroupID = 0; blackListModel.BlackDate = DateTime.Now; switch (BlackListBLL.AddBlackList(blackListModel)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000891", "添加成功!")); break; case -1: ScriptHelper.SetAlert(out msg, GetTran("001087", "执行发生错误!")); break; default: ScriptHelper.SetAlert(out msg, GetTran("001089", "数据异常")); break; } this.IPBianhao.Text = ""; PageSet(); }
/// <summary> /// 添加系统黑名单 /// </summary> /// <param name="userid">黑名单编号</param> /// <param name="userType">黑名单类型</param> /// <param name="groupID">黑名单组别</param> /// <returns></returns> public static int AddBlackList(BlacklistModel blackListModel) { return(BlackListDAL.AddBlackList(blackListModel)); }
/// <summary> /// 添加黑名单组到数据库 /// </summary> /// <param name="blackGroup">黑名单组</param> /// <param name="operateIP">操作人IP</param> /// <param name="operateNum">操作人编号</param> /// <returns></returns> public static int AddBlackGroup(BlackGroupModel blackGroup, string operateIP, string operateNum) { if (blackGroup.IntGroupType == 3) { //保存区域黑名单组 SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@GroupValue", blackGroup.IntGroupValue), new SqlParameter("@operateIP", operateIP), new SqlParameter("@operateNum", operateNum) }; object obj = null; //保存店辖黑名单组 try { obj = DBHelper.ExecuteScalar("AddAreaBlackGroup", paras, CommandType.StoredProcedure); } catch (SqlException) { return(-2); } return(1); } else if (blackGroup.IntGroupType == 4) { SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@GroupValue", blackGroup.IntGroupValue), new SqlParameter("@operateIP", operateIP), new SqlParameter("@operateNum", operateNum) }; object obj = null; //保存店辖黑名单组 try { obj = DBHelper.ExecuteScalar("AddStoreBlackGroup", paras, CommandType.StoredProcedure); } catch (SqlException) { return(-2); } //if (obj != null) //{ // return Convert.ToInt32(obj.ToString()); //} //else //{ // return -3; //} return(1); } else if (blackGroup.IntGroupType == 5 || blackGroup.IntGroupType == 6) { //保存安置网络黑名单组 //保存推荐网络黑名单组 object obj = null; int groupid = 0; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@GroupValue", blackGroup.IntGroupValue), new SqlParameter("@GroupType", blackGroup.IntGroupType) }; SqlConnection conn = new SqlConnection(DBHelper.connString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { string sql = "insert into blackgroup values(@GroupValue,@GroupType)"; DBHelper.ExecuteNonQuery(sql, paras, CommandType.Text); paras = new SqlParameter[] { new SqlParameter("@GroupValue", blackGroup.IntGroupValue), new SqlParameter("@GroupType", blackGroup.IntGroupType) }; sql = "select id from BlackGroup where GroupValue=@GroupValue and GroupType=@GroupType"; obj = DBHelper.ExecuteScalar(sql, paras, CommandType.Text); if (obj == null) { tran.Rollback(); return(-2); } groupid = int.Parse(obj.ToString()); AddBlackList(tran, blackGroup.IntGroupValue, blackGroup.IntGroupType, operateIP, operateNum, groupid); ///////限制该会员登录 BlacklistModel blackListModel = new BlacklistModel(); blackListModel.UserType = 0; blackListModel.UserID = blackGroup.IntGroupValue; blackListModel.OperateBH = operateNum; blackListModel.OperateIP = operateIP; blackListModel.GroupID = groupid; blackListModel.BlackDate = DateTime.Now.ToUniversalTime(); AddBlackList(tran, blackListModel, "AddBlackList"); tran.Commit(); } catch (SqlException) { tran.Rollback(); DelBlackGroup(groupid, blackGroup.IntGroupType); return(-2); } finally { conn.Close(); } return(1); } else { //数据异常 return(-3); } }
/// <summary> /// 删除黑名单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DeleteBlacklist(BlacklistModel model) { bool flag = databaseoperate.DeleteInDataBase(model); return(flag); }
/// <summary> /// 修改黑名单 /// </summary> /// <returns></returns> public bool ModifyBlacklist(BlacklistModel model) { bool flag = databaseoperate.SaveToDataBase(model); return(flag); }
/// <summary> /// 查找用户列表View /// </summary> /// <param name="view"></param> public BlacklistViewModel(BlacklistModel model) : base(model) { this.Items = new ObservableCollection <UserViewModel>(); }