/// <summary> /// 分页获取黑名单组信息 /// </summary> /// <param name="pageInfo"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="condition"></param> /// <param name="key"></param> /// <returns></returns> public static IList <BlackGroupModel> GetBlackGroups(Model.Other.PaginationModel pageInfo, string tableName, string columns, string condition, 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 reader = DBHelper.ExecuteReader("GetDataPagePagination", ps, CommandType.StoredProcedure); IList <BlackGroupModel> blacks = null; if (reader.HasRows) { blacks = new List <BlackGroupModel>(); while (reader.Read()) { BlackGroupModel black = new BlackGroupModel(reader.GetInt32(0)); black.IntGroupType = reader.GetInt32(1); black.IntGroupValue = reader.GetString(2); blacks.Add(black); } reader.NextResult(); pageInfo.DataCount = Convert.ToInt32(ps[6].Value.ToString()); } reader.Close(); return(blacks); }
/// <summary> /// 加入黑名单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Add_blackList_Click(object sender, EventArgs e) { //验证用户填写黑名单区域管辖 string country = CountryCity1.Country; string p = CountryCity1.Province; string city = CountryCity1.City; string xian = CountryCity1.Xian; if (!this.CountryCity1.CheckFill()) { ScriptHelper.SetAlert(out msg, GetTran("000886", "必须提供有效的区域")); CountryCity1.SelectCountry(country, p, city, xian); return; } string area = country + "," + p + "," + city + "," + xian; area = area.Replace(" ", ""); string[] areas = area.Split(','); if (areas.Length != 4) { ScriptHelper.SetAlert(out msg, GetTran("000887", "必须提供有效的区域!")); CountryCity1.SelectCountry(country, p, city, xian); return; } //判断是否已经存在该黑名单区域管辖 3代表区域管辖类型 string cpcode = CommonDataDAL.GetCPCCode(country, p, city, xian); if (BlackGroupBLL.HasBlackGroup(cpcode, 3)) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("000890", "指定的黑名单区域已经存在,无法增加!")); CountryCity1.SelectCountry(country, p, city, xian); return; } BlackGroupModel blackGroup = new BlackGroupModel(); //区域管辖类型 blackGroup.IntGroupType = 3; blackGroup.IntGroupValue = cpcode; string operateIP = Request.UserHostAddress.ToString(); string operateNum = Session["Company"].ToString(); switch (BlackGroupBLL.AddBlackGroup(blackGroup, operateIP, operateNum)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000891", "添加成功!")); PageSet(); break; default: ScriptHelper.SetAlert(out msg, GetTran("000893", "执行发生错误")); break; } }
/// <summary> /// 加入黑名单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Add_blackList_Click(object sender, EventArgs e) { string storeId = txtStoreID.Text.Trim(); //验证用户填写黑名单店铺管辖 if (storeId == "") { //提示用户填写 ScriptHelper.SetAlert(out msg, GetTran("001417", "必须提供管辖店铺编号!")); this.txtStoreID.Focus(); return; } //验证黑名单店铺管辖合法性 if (BlackListBLL.CheckStoreID(storeId)) { //提示无效 ScriptHelper.SetAlert(out msg, GetTran("001415", "必须提供有效的管辖店铺编号!")); this.txtStoreID.Text = ""; this.txtStoreID.Focus(); return; } //判断是否已经存在该黑名单店铺管辖 3代表店铺管辖类型 if (BlackGroupBLL.HasBlackGroup(storeId, 4)) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("001412", "指定的管辖店铺已经存在,无法增加!")); this.txtStoreID.Text = ""; return; } BlackGroupModel blackGroup = new BlackGroupModel(); //店铺管辖类型 blackGroup.IntGroupType = 4; blackGroup.IntGroupValue = storeId; string operateIP = Request.UserHostAddress.ToString(); string operateNum = Session["Company"].ToString(); switch (BlackGroupBLL.AddBlackGroup(blackGroup, operateIP, operateNum)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000891", "添加成功!")); break; default: ScriptHelper.SetAlert(out msg, GetTran("001087", "执行发生错误")); break; } this.txtStoreID.Text = ""; PageSet(); Translations(); }
/// <summary> /// 加入黑名单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Add_blackList_Click(object sender, EventArgs e) { //验证用户填写黑名单网络团队 if (txtNumber.Text == "") { //提示用户填写 ScriptHelper.SetAlert(out msg, GetTran("001343", "必须提供网络关系编号!")); this.txtNumber.Focus(); return; } //验证黑名单网络团队合法性 if (registermemeberBLL.CheckNumberTwice(txtNumber.Text) == null) { //提示无效 ScriptHelper.SetAlert(out msg, GetTran("001347", "必须提供有效的网络关系编号!")); this.txtNumber.Text = ""; this.txtNumber.Focus(); return; } //判断是否已经存在该黑名单网络团队 3代表网络团队类型 if (BlackGroupBLL.HasBlackGroup(txtNumber.Text, (this.radlnetWorkType.SelectedIndex == 0?5:6))) { //提示已经存在,无需填写 ScriptHelper.SetAlert(out msg, GetTran("001350", "指定的网络关系已经存在,无法增加!")); this.txtNumber.Text = ""; return; } BlackGroupModel blackGroup = new BlackGroupModel(); //网络团队类型 blackGroup.IntGroupType = (this.radlnetWorkType.SelectedIndex == 0 ? 5 : 6); blackGroup.IntGroupValue = txtNumber.Text; string operateIP = Request.UserHostAddress.ToString(); string operateNum = Session["Company"].ToString(); switch (BlackGroupBLL.AddBlackGroup(blackGroup, operateIP, operateNum)) { case 1: ScriptHelper.SetAlert(out msg, GetTran("000006", "添加成功!")); break; default: ScriptHelper.SetAlert(out msg, GetTran("001087", "执行发生错误")); break; } this.txtNumber.Text = ""; PageSet(); Translations(); }
/// <summary> /// 存储当前黑名单组 /// </summary> /// <param name="blackGroup">黑名单组类型</param> /// <returns>执行结果</returns> public static int AddBlackGroup(BlackGroupModel blackGroup, string operateIP, string operateNum) { return(BlackGroupDAL.AddBlackGroup(blackGroup, operateIP, operateNum)); }
/// <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); } }