/// <summary>
/// 修改密码
/// </summary>
/// <returns></returns>
public JsonResult EditPwd()
{
//根据登录编号修改个人信息
//用户登录编号
string str_U_id = U_Id();
//根据登录编号修改个人信息
int Login_Id = Convert.ToInt32(str_U_id);
//获取新密码
string newpwd = Request["newpassword"];
//Md5加密
string newpassword = MD5JM(newpwd);
//指定_ug对象需要在数据库中修改
ULogin _ug = new ULogin()
{
ULogin_Id = Login_Id, ULogin_Password = newpassword
};
//修改密码
_be.Entry(_ug).State = System.Data.EntityState.Modified;
//Save保存受影响行数
int result = _be.SaveChanges();
//返回result的结果
return(Json(result, JsonRequestBehavior.AllowGet));
}
private void Main_Load(object sender, EventArgs e)
{
mpnlSetting.Visible = false;
_instance = this;
ULogin login = new ULogin();
login.Dock = DockStyle.Fill;
pnlMainContent.Controls.Add(login);
serverIP = Properties.Settings.Default.serverIP;
serverPort = Properties.Settings.Default.serverPort;
txtIpServer.Text = serverIP;
txtPortServer.Text = serverPort.ToString();
checkconnect = new Thread(new ThreadStart(ConnectCheckStatus));
running = true;
checkconnect.Start();
for (int i = 3; i < 13; i++)
{
MetroTile _tile = new MetroTile();
_tile.Size = new Size(30, 30);
_tile.Tag = i;
_tile.Style = (MetroColorStyle)i;
_tile.Click += _tile_Click;
flColor.Controls.Add(_tile);
}
}
public DataTable Login(ULogin usuario)
{
DataTable Usuario = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("uniempleo.f_loggin", conection);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_name", NpgsqlDbType.Varchar).Value = usuario.Username1;
dataAdapter.SelectCommand.Parameters.Add("_clave", NpgsqlDbType.Varchar).Value = usuario.Clave1;
conection.Open();
dataAdapter.Fill(Usuario);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Usuario);
}
public DataTable GuardarSesion(ULogin datauser)//
{
DataTable loggin = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["MiConexion"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.f_guarda_sesion", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_user_id", NpgsqlDbType.Integer).Value = datauser.IdRol;
dataAdapter.SelectCommand.Parameters.Add("_ip", NpgsqlDbType.Varchar, 100).Value = datauser.Ip;
dataAdapter.SelectCommand.Parameters.Add("_mac", NpgsqlDbType.Varchar, 100).Value = datauser.Mac;
dataAdapter.SelectCommand.Parameters.Add("_session", NpgsqlDbType.Text).Value = datauser.Sesion;
conectar.Open();
dataAdapter.Fill(loggin);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();//
}
}
return(loggin);
}
private void btnLogout_Click(object sender, EventArgs e)
{
ULogin login = new ULogin();
login.Dock = DockStyle.Fill;
pnlMainContent.Controls.Clear();
pnlMainContent.Controls.Add(login);
}
void _login_LogInSuccess(object sender, EventArgs e)
{
_login.swipe(false);
ULogin a = new ULogin(this);
a.Dock = DockStyle.Fill;
a.swipe();
}
// GET: Usuario
public ActionResult Index()
{
if (ULogin.IsAdmin("Administrador"))
{
return(View(Mapper.Map <IEnumerable <Usuario>, IEnumerable <UsuarioModelView> >(_usuarioService.GetAll())));
}
return(View(Mapper.Map <IEnumerable <Usuario>, IEnumerable <UsuarioModelView> >(_usuarioService.UsuariosAtivos())));
}
/// <summary>
/// Session获取用户登录信息
/// </summary>
/// <returns></returns>
public string U_Id()
{
ULogin ud = Session["ULogin"] as ULogin;
string Login_Id = null;
if (ud != null)
{
Login_Id = ud.ULogin_Id.ToString();
}
return(Login_Id);
}
/// <summary>
/// 名称：修改密码
/// 时间：
/// 作者：
/// </summary>
/// <param name="phone">手机号</param>
/// <param name="newpassword">新密码</param>
/// <param name="code">验证码</param>
/// <returns></returns>
public JsonResult ForgetSucc(string newpassword, string code)
{
//验证已获取验证码
if (Session["sendCode"] == null)
{
return(Json(new DTO_Result()
{
Result_Code = "6565", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
else if (!code.Equals((Session["sendCode"] as DTO_Reg).Code))
{
return(Json(new DTO_Result()
{
Result_Code = "6565", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
else if (string.IsNullOrEmpty(newpassword))
{
return(Json(new DTO_Result()
{
Result_Code = "656665", Result_Title = "请输入密码"
}, JsonRequestBehavior.AllowGet));
}
//创建数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
string s = (Session["sendCode"] as DTO_Reg).Phone;
//查询用户
ULogin _ul = _db.ULogin.Where(a => a.ULogin_Phone.Equals(s)).FirstOrDefault();
if (_ul != null)
{
_ul.ULogin_Password = MD5JM(newpassword);
}
//提交数据
if (_db.SaveChanges() > 0)
{
return(Json(new DTO_Result()
{
Result_Code = "000000", Result_Title = "密码修改成功，请重新登录"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new DTO_Result()
{
Result_Code = "004400", Result_Title = "密码修改失败"
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 我评论的
/// </summary>
/// <param name="searchcontent"></param>
/// <returns></returns>
public ActionResult MyCommentIndex()
{
MonkeyDBEntities db = new MonkeyDBEntities();
int rows;
//如果为""就赋值为1
if (Request["num"] == "")
{
rows = 1;
}
//如果为null就赋值为1
rows = Convert.ToInt32(Request["num"] ?? "1");
ULogin ul = Session["ULogin"] as ULogin;
//博主评论别人的信息
List <Blog_Comment> bcomlist = db.Blog_Comment.AsNoTracking().Where(a => a.BC_UserID == ul.ULogin_Id).ToList();
//三表联查
var query = from b in bcomlist
join wb in db.Write_blog on b.BC_ArticleID equals wb.Write_blog_Id
join u in db.ULogin on b.BC_ForUserID equals u.ULogin_Id
select new BC_CommentDTO
{
BC_CommentId = b.BC_CommentId,
BC_ArticleID = b.BC_ArticleID,
BC_Comment = b.BC_Comment,
BC_Comment_Time = b.BC_Comment_Time,
Write_Title = wb.Write_Title,
Ulogin_BlogName = u.Ulogin_BlogName
};
//分页
List <BC_CommentDTO> bcdlist = query.OrderByDescending(a => a.BC_CommentId).Skip((rows - 1) * 5).Take(5).ToList();
//得到所有条数
int allcount = query.Count();
//得到所有页数
int allpage = allcount / 5;
//判断是否除尽或页数是否为0
if (allcount % 5 != 0 || allpage == 0)
{
allpage = allpage + 1;
}
ViewBag.bcdlist = bcdlist;
ViewBag.allpage = allpage;
ViewBag.rows = rows;
return(View());
}
public ActionResult CreateTransaction(FormCollection form)
{
try
{
ULogin trd_User = (ULogin)Session["user_ID"];
transaction.TransactionID = "";
transaction.Drug_Code = form["drug"];
transaction.Drug_Count = Convert.ToInt32(form["Drug_Count"]);
transaction.Sold_By = trd_User.user_ID;
transaction.Sold_Datetime = System.DateTime.Now;
transaction.Comment = form["Comment"];
transaction.BuyerName = form["BuyerName"];
// am testing here
// Mapper.CreateMap<Models.Transaction, VCRI_DAL.Transaction>();
// transaction_data = Mapper.Map<Models.Transaction, VCRI_DAL.Transaction>(transaction);
//transaction_data = Mapper.Map< VCRI_DAL.Transaction>(transaction);
//bool status = dal.Create_Transaction(transaction_data);
bool status = dal.Create_Transaction(Mapper.Map <VCRI_DAL.Transaction>(transaction));
if (status)
{
if (dal.update_stock(transaction.Drug_Code, Convert.ToInt32(form["Drug_Count"])))
{
TempData["msg"] = "Data Inserted Successfully";
return(RedirectToAction("Index"));
}
else
{
return(View("Invalid_user"));
}
}
else
{
return(View("Invalid_user"));
}
}
catch
{
return(null);
}
}
public ActionResult WriteBlogIndex()
{
ULogin u = new ULogin()
{
ULogin_Id = 1
}; //Session["ULogin"] as ULogin;
//查询所有的后台博客类别
List <Backstage_Category> _bclist = DTO_Backstage_Category.SelectBackstage_Category();
//查询所有自定类别
List <Category> clist = DTO_Category.SelectCategory(u.ULogin_Id);
@ViewBag._bclist = _bclist;
@ViewBag.clist = clist;
return(View());
}
public ActionResult Ativar(int id)
{
try
{
if (ValidateRequest)
{
if (ULogin.IsAdmin("Administrador"))
{
TempData["success"] = "Usuário foi ativado com sucesso!!";
__usuarioService.Ativar(_usuarioService.GetById(id));
return(RedirectToAction("Index"));
}
}
throw new Exception("Não foi possivel ativar este usuário, por favor contate o administrador do sistema.");
}
catch (Exception e)
{
TempData["warning"] = e.Message;
return(RedirectToAction("Index"));
}
}
protected void bt_ingresar_Click(object sender, EventArgs e)
{
ULogin llevaDatos = new ULogin();
LLogin llevaD = new LLogin();
llevaDatos.Username1 = tb_usuario.Text;
llevaDatos.Clave1 = tb_clave.Text;
llevaDatos = llevaD.Logear(llevaDatos, Session.SessionID);
Session["id"] = llevaDatos.IdRegistro;
Session["nombre"] = llevaDatos.Nombre;
Session["rol"] = llevaDatos.IdRol;
Session["estado"] = llevaDatos.Estado;
ScriptManager.RegisterStartupScript(this, typeof(Page), "invocarfuncion", llevaDatos.Script, false);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message", llevaDatos.Script);
L_Error.Text = llevaDatos.ErrorInicio;
L_error_sus.Text = llevaDatos.Script;
}
public ActionResult UpdateWriteBlogIndex(int Write_blog_Id)
{
ULogin u = Session["ULogin"] as ULogin;//Session["ULogin"] as ULogin;
MonkeyDBEntities db = new MonkeyDBEntities();
//查询所有的后台博客类别
List <Backstage_Category> _bclist = DTO_Backstage_Category.SelectBackstage_Category();
//查询所有自定类别
List <Category> clist = DTO_Category.SelectCategory(u.ULogin_Id);
Write_blog wb = db.Write_blog.Where(a => a.Write_blog_Id == Write_blog_Id).FirstOrDefault();
string[] strlist = wb.Category_Id.Split(',');//这篇文章的类型数组
@ViewBag._bclist = _bclist;
@ViewBag.clist = clist;
@ViewBag.wb = wb;
@ViewBag.Mycalist = strlist;
return(View());
}
public Response <ULogin> GetLogin(string Uname, string password)
{
Response <ULogin> response = null;
ULogin Logindetails = new ULogin();
try
{
businessLayer businessLayer = new businessLayer();
Logindetails = businessLayer.Login(Uname, password);
response = new Response <ULogin>(Logindetails);
if (Logindetails != null)
{
if (response.Result.LoginID != null && response.Result.Username != null && response.Result.Name != null)
{
response.ResponseCode = 0;
response.Status = "Login Successfully";
response.ResponseMessage = "Success";
}
else
{
response.ResponseCode = 1;
response.Status = "Faliure";
response.ResponseMessage = "Login details not available";
}
}
}
catch (Exception ex)
{
response = new Response <ULogin>(Logindetails);
response.ResponseCode = 1;
response.Status = "Error";
response.ResponseMessage = ex.Message;
}
return(response);
}
public ActionResult Login(ULogin login)
{
using (var db = new OKBEntities1())
{
List <Login> lg = (from p in db.Logins where p.UserEmail == login.UserEmail && p.Password == login.Password select p).ToList();
foreach (var professor in lg)
{
List <Role> role = (from R in db.Roles
where R.RoleId == professor.RoleId select R).ToList();
Session["RoleName"] = role.FirstOrDefault().RoleName;
Session["RoleName"] = Session["RoleName"] + "," + role.FirstOrDefault().RoleName;
}
if ((lg.ToList().Count > 0))
{
Session["User"] = lg.FirstOrDefault().UserEmail;
Session["User"] = Session["User"] + "," + lg.FirstOrDefault().RoleId;
Session["FirstName"] = lg.FirstOrDefault().FirstName;
Session["FirstName"] = Session["FirstName"] + "," + lg.FirstOrDefault().FirstName;
return(RedirectToAction("Admin", "User"));
}
}
return(View());
}
/// <summary>
/// 删除的文章（回收站）
/// </summary>
/// <returns></returns>
public ActionResult DelBlogManagerIndex(string searchcontent)
{
MonkeyDBEntities db = new MonkeyDBEntities();
int rows;
//如果为""就赋值为1
if (Request["num"] == "")
{
rows = 1;
}
//如果为null就赋值为1
rows = Convert.ToInt32(Request["num"] ?? "1");
int Write_ArticleType;
if (Request["Write_ArticleType"] == "")//判断得到的文章类型是否为“”
{
Write_ArticleType = -1;
}
Write_ArticleType = Convert.ToInt32(Request["Write_ArticleType"] ?? "-1");
//得到博主信息
//ULogin ul= Session["ULogin"] as ULogin;
ULogin ul = new ULogin()
{
ULogin_Id = 1
};
//创建一个返回值为bool型的委托
Func <Write_blog, bool> getpage = a => a.Write_IsDel == 0 && a.ULogin_Id == ul.ULogin_Id && a.ULogin_IdIsManager == "否" && (Write_ArticleType == -1 || a.Write_ArticleType == Write_ArticleType) && (string.IsNullOrEmpty(searchcontent) || a.Write_Content.Contains(searchcontent.Trim()) || a.Write_Title.Contains(searchcontent.Trim()) || a.Write_Label.Contains(searchcontent.Trim()));
//创建以及博客集合
List <Write_blog> wblist = new List <Write_blog>();
wblist = db.Write_blog.Where(getpage).OrderByDescending(a => a.Write_blog_Id).Skip((rows - 1) * 5).Take(5).ToList();
//创建一个装评论条数的集合
List <int> bccountlist = new List <int>();
//查询所有的评论
List <Blog_Comment> bclist = db.Blog_Comment.AsNoTracking().ToList();
//遍历博客
foreach (var item in wblist)
{
//查询该博客对应的评论的条数
int count = bclist.Where(a => a.BC_ArticleID == item.Write_blog_Id).Count();
//添加到集合
bccountlist.Add(count);
}
//得到所有条数
int allcount = db.Write_blog.Where(getpage).Count();
//得到所有页数
int allpage = allcount / 5;
//判断是否除尽或页数是否为0
if (allcount % 5 != 0 || allpage == 0)
{
allpage = allpage + 1;
}
//传值到页面
ViewBag.allpage = allpage; //总页数
ViewBag.rows = rows; //第几页
ViewBag.bccountlist = bccountlist; //评论条数
ViewBag.wblist = wblist; //博客集合
ViewBag.searchcontent = searchcontent; //搜索框
ViewBag.Write_ArticleType = Write_ArticleType; //文章类型
return(View());
}
public JsonResult Register_in(string username, string password, string repassword, string code)
{
//判断手机号是否为空
if (string.IsNullOrEmpty(username))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "请输入手机号"
}, JsonRequestBehavior.AllowGet));
}
//判断手机号是否符合规则
else if (!IsMobilePhone(username))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "手机号格式不正确"
}, JsonRequestBehavior.AllowGet));
}
//判断是否输入验证码
else if (Session["sendCode"] == null || string.IsNullOrEmpty(code))
{
return(Json(new DTO_Result()
{
Result_Code = "000", Result_Title = "请输入验证码"
}, JsonRequestBehavior.AllowGet));
}
//判断是否输入密码
else if (string.IsNullOrEmpty(password))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "请输入密码"
}, JsonRequestBehavior.AllowGet));
}
//判断两次输入的密码
else if (!password.Equals(repassword))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "前后两次密码不一致"
}, JsonRequestBehavior.AllowGet));
}
//验证验证码是否输入正确
else if (!code.Equals((Session["sendCode"] as DTO_Reg).Code))
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "验证码输入错误"
}, JsonRequestBehavior.AllowGet));
}
//验证验证码是否超时
else if ((DateTime.Now - ((Session["sendCode"] as DTO_Reg).Time)).TotalSeconds > OutTime)
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "验证码超时"
}, JsonRequestBehavior.AllowGet));
}
//录入数据
else
{
//创建数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
//验证手机号是否注册
if (_db.ULogin.Where(a => a.ULogin_Phone == username).Count() <= 0)
{
//录入
Users_Details _det = _db.Users_Details.Add(new Users_Details()
{
Users_Details_Name = username, Users_Details_Follow = 0, Users_Details_Etc = 0, Users_Details_LoginDate = DateTime.Now
});
ULogin _ul = _db.ULogin.Add(new ULogin()
{
Ulogin_BlogName = username, ULogin_Password = MD5JM(password), ULogin_Phone = username, Users_Details_ID = _det.Users_Details_ID
});
if (_db.SaveChanges() >= 2)
{
return(Json(new DTO_Result()
{
Result_Code = "000000", Result_Title = "注册成功"
}));
}
else
{
_db.ULogin.Remove(_ul);
_db.Users_Details.Remove(_det);
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "注册失败"
}));
}
}
else
{
return(Json(new DTO_Result()
{
Result_Code = "0000", Result_Title = "该用户已存在，注册失败"
}));
}
}
}
public ULogin Logear(ULogin logeo, String idsesion)
{
DLogin validaUser = new DLogin();
DataTable usuarios = validaUser.Login(logeo);
ULogin log = new ULogin();
if (usuarios.Rows.Count > 0)
{
if (int.Parse(usuarios.Rows[0]["estado"].ToString()) == 1)
{
if (int.Parse(usuarios.Rows[0]["id_registro"].ToString()) > 0)
{
log.IdRegistro = Int32.Parse(usuarios.Rows[0]["id_registro"].ToString());
log.Nombre = usuarios.Rows[0]["usuario"].ToString();
log.IdRol = Int32.Parse(usuarios.Rows[0]["id_rol"].ToString());
log.Estado = Int32.Parse(usuarios.Rows[0]["estado"].ToString());
ULogin datauser = new ULogin();
MAC datosConexion = new MAC();
String ipAdress = datosConexion.ip();
String mac = datosConexion.mac();
datauser.IdRol = Int32.Parse(usuarios.Rows[0]["id_rol"].ToString());
datauser.Ip = ipAdress;
datauser.Mac = mac;
datauser.Sesion = idsesion;
validaUser.GuardarSesion(datauser);
if (log.IdRol == 1)
{
log.Script = @"<script type='text/javascript'>Redir_InicioEmpresa();</script>";
}
if (log.IdRol == 2)
{
log.Script = @"<script type='text/javascript'>Redir_InicioAspirante();</script>";
}
if (log.IdRol == 3)
{
log.Script = @"<script type='text/javascript'>Redir_InicioAdmin();</script>";
}
}
}
else
{
log.Script = "Usuario suspendido";
}
}
else
{
log.ErrorInicio = "Usuario o clave incorrecta";
}
return(log);
}
//
// GET: /PersonalBlog/
/// <summary>
/// 个人博客页面
/// </summary>
/// <param name="searchcontent"></param>
/// <returns></returns>
public ActionResult PersonalBlogIndex(string searchcontent)
{
MonkeyDBEntities db = new MonkeyDBEntities();
int rows;
//如果为""就赋值为1
if (Request["num"] == "")
{
rows = 1;
}
//如果为null就赋值为1
rows = Convert.ToInt32(Request["num"] ?? "1");
int Write_ArticleType;
if (Request["Write_ArticleType"] == "")
{
Write_ArticleType = -1;
}
Write_ArticleType = Convert.ToInt32(Request["Write_ArticleType"] ?? "-1");
ULogin ul2 = Session["ULogin"] as ULogin;//查看人的人id
ULogin ul = new ULogin {
ULogin_Id = 1
}; //该博客的id
//创建一个返回值为bool型的委托
Func <Write_blog, bool> getpage = a => a.Write_IsDel == 2 && a.Write_State == 2 && a.ULogin_IdIsManager == "否" && (Write_ArticleType == -1 || a.Write_ArticleType == Write_ArticleType) && (string.IsNullOrEmpty(searchcontent) || a.Write_Content.Contains(searchcontent.Trim()) || a.Write_Title.Contains(searchcontent.Trim()) || a.Write_Label.Contains(searchcontent.Trim()));
//创建以及博客集合
List <Write_blog> wblist = new List <Write_blog>();
//查询博主的所有文章
List <Write_blog> allwblist = db.Write_blog.AsNoTracking().Where(a => a.ULogin_Id == ul.ULogin_Id).ToList();
//判断是否为本人看的
if (ul2 == null || ul.ULogin_Id != ul2.ULogin_Id)
{
//不是本人查看时（不能查看私有的博客）
//getpage = a => a.Write_IsDel == 2 && a.Write_State == 2 && a.Write_Private == 1 && (Write_ArticleType == -1 || a.Write_ArticleType == Write_ArticleType) && (string.IsNullOrEmpty(searchcontent.Trim()) || a.Write_Content.Contains(searchcontent) || a.Write_Title.Contains(searchcontent.Trim()) || a.Write_Label.Contains(searchcontent.Trim()));
wblist = allwblist.Where(getpage).Where(a => a.Write_Private == 1).OrderByDescending(a => a.Write_blog_Id).Skip((rows - 1) * 5).Take(5).ToList();
}
else
{
//本人查看时
wblist = allwblist.Where(getpage).OrderByDescending(a => a.Write_blog_Id).Skip((rows - 1) * 5).Take(5).ToList();
}
//创建一个装评论条数的集合
List <int> bccountlist = new List <int>();
//查询所有的评论
List <Blog_Comment> bclist = db.Blog_Comment.AsNoTracking().ToList();
//遍历博客
foreach (var item in wblist)
{
//查询该博客对应的评论的条数
int count = bclist.Where(a => a.BC_ArticleID == item.Write_blog_Id).Count();
//添加到集合
bccountlist.Add(count);
}
//得到所有条数
int allcount = db.Write_blog.Where(getpage).ToList().Count();
//得到所有页数
int allpage = allcount / 5;
//判断是否除尽或页数是否为0
if (allcount % 5 != 0 || allpage == 0)
{
allpage = allpage + 1;
}
//查询所有的个人分类
List <Category> calist = DTO_Category.SelectCategory(ul.ULogin_Id);
//查询所有的博客里面的分类
List <string> caidlist = allwblist.Select(a => a.Category_Id).ToList();
//定义以个人分类编号作为键，个人分类下面的博客数作为值的数组
// int[] cateidcount = new int[calist.Count()];
Dictionary <int, int> dic_cateidcount = new Dictionary <int, int>();
//定义一个装所有博客文章里面个人分类的集合
List <int> listid = new List <int>();
//遍历所有的博客里面的分类
foreach (var item in caidlist)
{
//分割字符串
string[] id = item.Split(',');
//遍历数组
for (int i = 0; i < id.Length; i++)
{
//添加到集合
listid.Add(Convert.ToInt32(id[i]));
}
}
//遍历个人分类
foreach (var item in calist)
{
//根据跟人分类的编号查询博客的文章数
int count2 = listid.Where(a => a == item.Category_Id).Count();
//以键值对的形式添加到集合
dic_cateidcount[item.Category_Id] = count2;
}
//传值到页面
ViewBag.allpage = allpage;
ViewBag.rows = rows;
ViewBag.bccountlist = bccountlist;
ViewBag.wblist = wblist;
ViewBag.searchcontent = searchcontent;
ViewBag.Write_ArticleType = Write_ArticleType;
ViewBag.cateidcount = dic_cateidcount;
ViewBag.calist = calist;
ViewBag.LoginUser = ul2; //登陆的账号
ViewBag.WatchUser = ul; //看博客的账号
return(View());
}
