/// <summary> /// 删除权限 /// </summary> /// <param name="listId"></param> /// <returns></returns> public bool DeleteEntities(List <int> listId) { GetCurrentSession.ActionInfoDal.LoadEntities(a => listId.Contains(a.ID)).ToList() .ForEach(a => GetCurrentSession.ActionInfoDal.DeleteEntity(a)); return(GetCurrentSession.SaveChanges()); }
/// <summary> /// 为用户分配角色 /// </summary> /// <param name="userId"></param> /// <param name="roleIdList"></param> /// <returns></returns> public bool SetUserOrderInfo(int userId, List <int> roleIdList) { var result = false; //获取要分配的用户信息 var userInfo = GetCurrentSession.UserInfoDal.LoadEntities(u => u.UserID == userId).FirstOrDefault(); if (userInfo != null) { //我的实现: //直接向中间表插入userid和roleIdList,完成角色的分配。但是这样就是直接操作数据库,和EF还有导航属性无关。 //EF的实现:直接利用导航属性来操作中间表。 //删除用户已有的角色 userInfo.RoleInfo.Clear(); foreach (var roleId in roleIdList) { var roleInfo = GetCurrentSession.RoleInfoDal.LoadEntities(r => r.ID == roleId).FirstOrDefault(); userInfo.RoleInfo.Add(roleInfo);//给用户分配角色 } //调用SaveChanges()之前,所有的操作都在内存中完成,不会操作数据库。 result = GetCurrentSession.SaveChanges(); } return(result); }
public async Task <JsonResult> Delete(int Id) { Login Obj = await Task.Run(() => db.Logins.Find(Id)); if (Obj != null) { if (Obj.Flag == "A") { Obj.Flag = "D"; } else { Obj.Flag = "A"; } Obj.UpdateDate = GetCurrentSession.CurrentDateTime(); Obj.UpdateUser = (int)GetCurrentSession.CurrentUser(); await Task.Run(() => db.Entry(Obj).State = System.Data.Entity.EntityState.Modified); await Task.Run(() => db.SaveChanges()); //await Task.Run(() => db.Logines.Remove(Obj)); //await Task.Run(() => db.SaveChanges()); } return(Json(Obj, JsonRequestBehavior.AllowGet)); }
public async Task <JsonResult> Create(LoginVM loginVM) { var loginResult = new LoginResult(); loginResult.IsError = false; loginResult.ErrorMessage = ""; Login LoginObj = new Login(); var loginList = await Task.Run(() => db.Logins.ToList()); bool Emailexists = false; if (loginVM.LoginID == 0) { var dagtaExists = loginList.Where(t => t.Email == loginVM.Email).FirstOrDefault(); if (dagtaExists != null) { Emailexists = true; loginResult.IsError = true; loginResult.ErrorMessage = "User Name already exits"; } if (!Emailexists) { LoginObj.LoginID = loginVM.LoginID; LoginObj.FirstName = loginVM.FirstName; LoginObj.LoginID = loginVM.LoginID; LoginObj.FirstName = loginVM.FirstName; LoginObj.LastName = loginVM.LastName; LoginObj.RoleID = (int)loginVM.RoleID; LoginObj.Email = loginVM.Email; LoginObj.Password = loginVM.Password; LoginObj.CreateDate = GetCurrentSession.CurrentDateTime(); LoginObj.CreateUser = (int)GetCurrentSession.CurrentUser(); LoginObj.Flag = "A"; await Task.Run(() => db.Logins.Add(LoginObj)); await Task.Run(() => db.SaveChanges()); } } else { LoginObj = await Task.Run(() => db.Logins.Where(t => t.LoginID == loginVM.LoginID).FirstOrDefault()); if (LoginObj != null) { LoginObj.FirstName = loginVM.FirstName; LoginObj.LastName = loginVM.LastName; LoginObj.RoleID = (int)loginVM.RoleID; LoginObj.Flag = "A"; LoginObj.UpdateDate = GetCurrentSession.CurrentDateTime(); LoginObj.UpdateUser = (int)GetCurrentSession.CurrentUser(); await Task.Run(() => db.Entry(LoginObj).State = System.Data.Entity.EntityState.Modified); await Task.Run(() => db.SaveChanges()); } } return(Json(loginResult, JsonRequestBehavior.AllowGet)); }
public bool DeleteEntities(List <int> list) { GetCurrentSession.RoleInfoDal .LoadEntities(c => list.Contains(c.ID)).ToList() .ForEach(k => GetCurrentSession.RoleInfoDal.DeleteEntity(k)); return(GetCurrentSession.SaveChanges()); }
public async Task <JsonResult> Create(PickUpBoyVM pickUpVM) { var loginResult = new LoginResult(); loginResult.IsError = false; loginResult.ErrorMessage = ""; var PickUpBoyList = await Task.Run(() => db.PickUpBoys.ToList()); var exits = PickUpBoyList.FirstOrDefault(t => t.PickUpBoyName == pickUpVM.PickUpBoyName && t.PickUpBoyNumber == pickUpVM.PickUpBoyNumber); if (exits != null) { loginResult.IsError = true; loginResult.ErrorMessage = "Data already exists"; } else { PickUpBoy pickUpObj = new PickUpBoy(); if (pickUpVM.PickUpBoyID == 0) { pickUpObj.PickUpBoyName = pickUpVM.PickUpBoyName; pickUpObj.PickUpBoyNumber = (decimal)pickUpVM.PickUpBoyNumber; pickUpObj.CreateDate = GetCurrentSession.CurrentDateTime(); pickUpObj.CreateUser = (int)GetCurrentSession.CurrentUser(); pickUpObj.Flag = "A"; await Task.Run(() => db.PickUpBoys.Add(pickUpObj)); await Task.Run(() => db.SaveChanges()); } else { pickUpObj = await Task.Run(() => db.PickUpBoys.Find(pickUpVM.PickUpBoyID)); if (pickUpObj != null) { { pickUpObj.PickUpBoyName = pickUpVM.PickUpBoyName; pickUpObj.PickUpBoyNumber = (decimal)pickUpVM.PickUpBoyNumber; pickUpObj.UpdateDate = GetCurrentSession.CurrentDateTime(); pickUpObj.UpdateUser = (int)GetCurrentSession.CurrentUser(); pickUpObj.Flag = "A"; await Task.Run(() => db.Entry(pickUpObj).State = System.Data.Entity.EntityState.Modified); await Task.Run(() => db.SaveChanges()); } } } } return(Json(loginResult, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 删除特殊用户权限,方法一 /// </summary> /// <param name="userId"></param> /// <param name="actionId"></param> /// <returns></returns> public bool DeleteUserActionInfo(int userId, int actionId) { var r_UserInfo_ActionInfo = GetCurrentSession.R_UserInfo_ActionInfoDal .LoadEntities(r => r.UserInfoID == userId && r.ActionInfoID == actionId) .FirstOrDefault(); if (r_UserInfo_ActionInfo != null) { GetCurrentSession.R_UserInfo_ActionInfoDal.DeleteEntity(r_UserInfo_ActionInfo); } return(GetCurrentSession.SaveChanges()); }
public async Task <JsonResult> Create(BusVM busVM) { var loginResult = new LoginResult(); loginResult.IsError = false; loginResult.ErrorMessage = ""; var busList = await Task.Run(() => db.Buses.ToList()); var exits = busList.FirstOrDefault(t => t.BusName == busVM.BusName && t.BusNumber == busVM.BusNumber); if (exits != null) { loginResult.IsError = true; loginResult.ErrorMessage = "Data already exists"; } else { Bus busObj = new Bus(); if (busVM.BusID == 0) { busObj.BusName = busVM.BusName; busObj.BusNumber = busVM.BusNumber; busObj.CreateDate = GetCurrentSession.CurrentDateTime(); busObj.CreateUser = (int)GetCurrentSession.CurrentUser(); busObj.Flag = "A"; await Task.Run(() => db.Buses.Add(busObj)); await Task.Run(() => db.SaveChanges()); } else { busObj = await Task.Run(() => db.Buses.Find(busVM.BusID)); if (busObj != null) { busObj.BusID = busVM.BusID; busObj.BusName = busVM.BusName; busObj.BusNumber = busVM.BusNumber; busObj.Flag = "A"; busObj.UpdateDate = GetCurrentSession.CurrentDateTime(); busObj.UpdateUser = (int)GetCurrentSession.CurrentUser(); await Task.Run(() => db.Entry(busObj).State = System.Data.Entity.EntityState.Modified); await Task.Run(() => db.SaveChanges()); } } } return(Json(loginResult, JsonRequestBehavior.AllowGet)); }
public async Task <JsonResult> Create(CityVM cityVM) { var loginResult = new LoginResult(); loginResult.IsError = false; loginResult.ErrorMessage = ""; var cityList = await Task.Run(() => db.Cities.ToList()); var exits = cityList.FirstOrDefault(t => t.CityName == cityVM.CityName); if (exits != null) { loginResult.IsError = true; loginResult.ErrorMessage = "Data already exists"; } else { City cityObj = new City(); if (cityVM.CityID == 0) { cityObj.CityName = cityVM.CityName; cityObj.CreateDate = GetCurrentSession.CurrentDateTime(); cityObj.CreateUser = (int)GetCurrentSession.CurrentUser(); cityObj.Flag = "A"; await Task.Run(() => db.Cities.Add(cityObj)); await Task.Run(() => db.SaveChanges()); } else { cityObj = await Task.Run(() => db.Cities.Find(cityVM.CityID)); if (cityObj != null) { cityObj.CityID = cityVM.CityID; cityObj.CityName = cityVM.CityName; cityObj.Flag = "A"; cityObj.UpdateDate = GetCurrentSession.CurrentDateTime(); cityObj.UpdateUser = (int)GetCurrentSession.CurrentUser(); await Task.Run(() => db.Entry(cityObj).State = System.Data.Entity.EntityState.Modified); await Task.Run(() => db.SaveChanges()); } } } return(Json(loginResult, JsonRequestBehavior.AllowGet)); }
public ActionResult EditProfile(LoginVM obj) { obj.LoginID = (int)GetCurrentSession.CurrentUser(); var ObjDB = db.Logins.Where(t => t.LoginID == obj.LoginID).FirstOrDefault(); if (ObjDB != null) { obj.LoginID = ObjDB.LoginID; obj.FirstName = ObjDB.FirstName; obj.LastName = ObjDB.LastName; obj.Email = ObjDB.Email; } return(View(obj)); }
/// <summary> /// 为特殊用户分配权限 /// </summary> /// <param name="userId"></param> /// <param name="actionId"></param> /// <param name="isPass"></param> /// <returns></returns> public bool SetUserActionInfo(int userId, int actionId, bool isPass) { var r_UserInfo_ActionInfo = GetCurrentSession.R_UserInfo_ActionInfoDal .LoadEntities(r => r.UserInfoID == userId && r.ActionInfoID == actionId) .FirstOrDefault(); if (r_UserInfo_ActionInfo == null)//当前用户没有添加这个权限 { var r_userInfo_actionInfo = new R_UserInfo_ActionInfo { ActionInfoID = actionId, UserInfoID = userId, IsPass = isPass }; GetCurrentSession.R_UserInfo_ActionInfoDal.AddEntity(r_userInfo_actionInfo); } else { r_UserInfo_ActionInfo.IsPass = isPass; } return(GetCurrentSession.SaveChanges()); }
/// <summary> /// 为权限分配角色 /// </summary> /// <param name="actionId"></param> /// <param name="roleIdList"></param> /// <returns></returns> public bool SetActionRoleInfo(int actionId, List <int> roleIdList) { var actionInfo = this.GetCurrentSession.ActionInfoDal .LoadEntities(a => a.ID == actionId) .FirstOrDefault(); if (actionInfo != null) { actionInfo.RoleInfo.Clear(); foreach (var roleId in roleIdList) { var roleInfo = this.GetCurrentSession.RoleInfoDal .LoadEntities(r => r.ID == roleId) .FirstOrDefault(); actionInfo.RoleInfo.Add(roleInfo); } return(GetCurrentSession.SaveChanges()); } else { return(false); } }
public bool EditEntity(T entity) { CurrentDal.EditEntity(entity); return(GetCurrentSession.SaveChanges()); }
public ActionResult ChangePassword(ChangePasswordVM obj) { obj.LoginID = (int)GetCurrentSession.CurrentUser(); return(View(obj)); }
public bool DeleteEntity(T entity) { CurrentDal.DeleteEntity(entity); return(GetCurrentSession.SaveChanges()); }
public T AddEntity(T entity) { CurrentDal.AddEntity(entity); GetCurrentSession.SaveChanges(); return(entity); }
public ActionResult Te() { int Tempoid = 1; DateTime CurrentDate = new DateTime(); CurrentDate = GetCurrentSession.CurrentDateTime(); #region Print string joindata = string.Join(", ", "1,2,3"); SqlParameter param1 = new SqlParameter("@Var", joindata); List <rptCustomer> rptCustomerList = db.Database.SqlQuery <rptCustomer>("SP_PickUpboy @Var", param1).ToList(); var LoginList = db.Logins.ToList(); string PrintBy = string.Empty; int CurrentUser = (int)GetCurrentSession.CurrentUser(); var login = LoginList.FirstOrDefault(t => t.LoginID == CurrentUser); if (login != null) { PrintBy = login.FirstName + " " + login.LastName; } //List<rptCustomer> rptCustomerList = context.Database.SqlQuery<rptCustomer>("SP_PickUpboy @Var", param1).ToList<rptCustomer>(); DataTable dtBoyName = new DataTable(); dtBoyName.Columns.Add("Name", typeof(string)); var boy = db.PickUpBoys.FirstOrDefault(t => t.PickUpBoyID == Tempoid); if (boy != null) { dtBoyName.Rows.Add("Delivery Boy:- " + boy.PickUpBoyName + "\t Print By:- " + PrintBy); } else { dtBoyName.Rows.Add(""); } DataTable dtCustomer = new DataTable(); dtCustomer.Columns.Add("LRNo", typeof(string)); dtCustomer.Columns.Add("CustomerName", typeof(string)); dtCustomer.Columns.Add("PayTypeStatus", typeof(string)); dtCustomer.Columns.Add("Amount", typeof(decimal)); dtCustomer.Columns.Add("Total", typeof(decimal)); dtCustomer.Columns.Add("Damrage", typeof(decimal)); dtCustomer.Columns.Add("Hamali", typeof(decimal)); dtCustomer.Columns.Add("NoOfParcel", typeof(int)); dtCustomer.Columns.Add("CustomerNumber", typeof(string)); foreach (var item in rptCustomerList) { dtCustomer.Rows.Add(item.LRNo, item.CustomerName, item.PayTypeStatus, item.Amount, item.Total, item.Damrage, item.Hamali * item.NoOfParcel, item.NoOfParcel, item.CustomerNumber); } DataSet1 myds = new DataSet1(); myds.Tables["DtPickupBoy"].Merge(dtCustomer); myds.Tables["DtBoyName"].Merge(dtBoyName); ReportDocument rptH = new ReportDocument(); rptH.Load(Server.MapPath("~/Reports/rptPickUpboy.rpt")); rptH.SetDataSource(myds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); string htmlfilename = DateTime.Now.ToString("yyyyMMddHHmmssfff"); string path = Server.MapPath("~/PDF"); AllClass.CreateDirectory(path); string fileName = path + "/" + htmlfilename + ".pdf"; string fileName2 = htmlfilename + ".pdf"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } rptH.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, fileName); JsonResult result = new JsonResult(); result.Data = fileName2; return(result); #endregion }