/// <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
}
