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