/// <summary>
/// Get Customer By Customer ID
/// </summary>
/// <param name="customerID"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public SysModuleOperate GetSysModuleOperateById(string id, out TransactionalInformation transaction)
{
transaction = new TransactionalInformation();
if (IsExist(id))
{
try
{
SysModuleOperateDataService.CreateSession();
SysModuleOperate sysModuleOperate = SysModuleOperateDataService.GetSysModuleOperateById(id);
transaction.ReturnStatus = true;
return(sysModuleOperate);
}
catch (Exception ex)
{
transaction.ReturnMessage = new List <string>();
string errorMessage = ex.Message;
transaction.ReturnStatus = false;
transaction.ReturnMessage.Add(errorMessage);
return(null);
}
finally
{
SysModuleOperateDataService.CloseSession();
}
}
else
{
return(null);
}
}
//public List<SysModuleOperate> GetList( string mid)
//{
// List<SysModuleOperate> queryData = SysModuleOperateDataService.GetModuleOperateList().Where(a => a.ModuleId == mid);
// //paging.TotalRows = queryData.Count();
// //queryData = LinqHelper.SortingAndPaging(queryData, paging.SortExpression, paging.SortDirection, paging.TotalPages, paging.TotalRows);
// return CreateModelList(ref queryData);
//}
//private List<SysModuleOperate> CreateModelList(ref IQueryable<SysModuleOperate> queryData)
//{
// List<SysModuleOperate> modelList = (from r in queryData
// select new SysModuleOperate
// {
// Id = r.Id,
// Name = r.Name,
// KeyCode = r.KeyCode,
// ModuleId = r.ModuleId,
// IsValid = r.IsValid,
// Sort = r.Sort
// }).ToList();
// return modelList;
//}
//public List<SysModuleOperate> GetList(ref DataGridPagingInformation paging, string mid)
//{
// IQueryable<SysModuleOperate> queryData = SysModuleOperateDataService.GetModuleOperateList().Where(a => a.ModuleId == mid);
// paging.TotalRows = queryData.Count();
// queryData = LinqHelper.SortingAndPaging(queryData, paging.SortExpression, paging.SortDirection, paging.TotalPages, paging.TotalRows);
// return CreateModelList(ref queryData);
//}
//private List<SysModuleOperate> CreateModelList(ref IQueryable<SysModuleOperate> queryData)
//{
// List<SysModuleOperate> modelList = (from r in queryData
// select new SysModuleOperate
// {
// Id = r.Id,
// Name = r.Name,
// KeyCode = r.KeyCode,
// ModuleId = r.ModuleId,
// IsValid = r.IsValid,
// Sort = r.Sort
// }).ToList();
// return modelList;
//}
public void CreateSysModuleOperate(SysModuleOperate sysModuleOperate, out TransactionalInformation transaction)
{
transaction = new TransactionalInformation();
//CustomerBusinessRules customerBusinessRules = new CustomerBusinessRules();
try
{
SysModuleOperateDataService.CreateSession();
SysModuleOperateDataService.BeginTransaction();
SysModuleOperateDataService.CreateSysModuleOperate(sysModuleOperate);
SysModuleOperateDataService.CommitTransaction(true);
transaction.ReturnStatus = true;
transaction.ReturnMessage.Add("sysModuleOperate successfully created");
//transaction.ReturnMessage.Add(Suggestion.InsertSucceed);
}
catch (Exception ex)
{
SysModuleOperateDataService.RollbackTransaction(true);
transaction.ReturnMessage = new List <string>();
string errorMessage = ex.Message;
transaction.ReturnStatus = false;
transaction.ReturnMessage.Add(errorMessage);
}
finally
{
SysModuleOperateDataService.CloseSession();
}
//try
//{
// SysModuleOperate entity = SysModuleOperateDataService.GetSysModuleOperateById(sysModuleOperate.Id);
// if (entity != null)
// {
// errors.Add(Suggestion.PrimaryRepeat);
// return false;
// }
// entity = new SysModuleOperate();
// entity.Id = model.Id;
// entity.Name = model.Name;
// entity.KeyCode = model.KeyCode;
// entity.ModuleId = model.ModuleId;
// entity.IsValid = model.IsValid;
// entity.Sort = model.Sort;
// if (SysModuleOperateDataService.CreateSysModuleOperate(entity) == 1)
// {
// return true;
// }
// else
// {
// errors.Add(Suggestion.InsertFail);
// return false;
// }
//}
//catch (Exception ex)
//{
// errors.Add(ex.Message);
// //ExceptionHander.WriteException(ex);
// return false;
//}
}
public bool Create(ref ValidationErrors errors, SysModuleOperateModel model)
{
try
{
SysModuleOperate entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new SysModuleOperate();
entity.Id = model.Id;
entity.Name = model.Name;
entity.KeyCode = model.KeyCode;
entity.ModuleId = model.ModuleId;
entity.IsValid = model.IsValid;
entity.Sort = model.Sort;
if (m_Rep.Create(entity) == 1)
{
return(true);
}
else
{
errors.Add(Suggestion.InsertFail);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
//TODO 如果做成全局，就不会这样了..
ExceptionHander.WriteException(ex);
return(false);
}
}
public virtual bool Create(ref ValidationErrors errors, SysModuleOperateModel model)
{
try
{
SysModuleOperate entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Resource.PrimaryRepeat);
return(false);
}
entity = new SysModuleOperate();
entity.Id = model.Id;
entity.Name = model.Name;
entity.KeyCode = model.KeyCode;
entity.ModuleId = model.ModuleId;
entity.IsValid = model.IsValid;
entity.Sort = model.Sort;
if (m_Rep.Create(entity))
{
return(true);
}
else
{
errors.Add(Resource.Insert + Resource.Fail);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
////[SupportFilter(ActionName = "Create")]
public JsonResult CreateOpt(SysModuleOperate info)
{
if (info != null)
{
SysModuleOperate entity = operateBLL.m_Rep.Find(info.Id);
if (entity != null)
{
return(Json(JsonHandler.CreateMessage(0, Resource.PrimaryRepeat), JsonRequestBehavior.AllowGet));
}
entity = new SysModuleOperate();
entity.Name = info.Name;
entity.KeyCode = info.KeyCode;
entity.ModuleId = info.ModuleId;
entity.IsValid = info.IsValid;
entity.Sort = info.Sort;
if (operateBLL.m_Rep.Create(entity))
{
LogHandler.WriteServiceLog(GetUserId(), "Id:" + info.Id + ",Name:" + info.Name, "成功", "创建", "模块设置");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id:" + info.Id + ",Name:" + info.Name + "," + ErrorCol, "失败", "创建", "模块设置");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail), JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 保存数据
/// </summary>
public virtual void SaveImportData(IEnumerable <SysModuleOperateModel> list)
{
try
{
using (DBContainer db = new DBContainer())
{
foreach (var model in list)
{
SysModuleOperate entity = new SysModuleOperate();
entity.Id = ResultHelper.NewId;
entity.Name = model.Name;
entity.KeyCode = model.KeyCode;
entity.ModuleId = model.ModuleId;
entity.IsValid = model.IsValid;
entity.Sort = model.Sort;
db.SysModuleOperate.Add(entity);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public virtual bool Edit(ref ValidationErrors errors, SysModuleOperateModel model)
{
try
{
SysModuleOperate entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Resource.Disable);
return(false);
}
entity.Id = model.Id;
entity.Name = model.Name;
entity.KeyCode = model.KeyCode;
entity.ModuleId = model.ModuleId;
entity.IsValid = model.IsValid;
entity.Sort = model.Sort;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add("没有数据改变");
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public override bool Create(SysModule entity, bool isCommit = true)
{
Context.SysModule.Add(entity);
//创建成功--自动生成增，删，改，查，存，审核操作码(最后一项才执行)并且不是API接口的
if (entity.IsLast && entity.ParentId != "ApiInterfaceAuth")
{
string[,] arr = new string[7, 2];
arr[0, 0] = "创建";
arr[0, 1] = "Create";
arr[1, 0] = "删除";
arr[1, 1] = "Delete";
arr[2, 0] = "修改";
arr[2, 1] = "Edit";
arr[3, 0] = "保存";
arr[3, 1] = "Save";
arr[4, 0] = "审核";
arr[4, 1] = "Check";
arr[5, 0] = "反审核";
arr[5, 1] = "UnCheck";
arr[6, 0] = "查询";
arr[6, 1] = "Query";
for (int i = 0; i < 7; i++)
{
SysModuleOperate cretaeEntity = new SysModuleOperate();
cretaeEntity.Id = ResultHelper.NewId;
cretaeEntity.Name = arr[i, 0];
cretaeEntity.KeyCode = arr[i, 1];
cretaeEntity.ModuleId = entity.Id;
cretaeEntity.IsValid = true;
cretaeEntity.Sort = 1;
Context.SysModuleOperate.Add(cretaeEntity);
}
}
return(this.SaveChanges() > 0);
}
public bool Create(ref ValidationErrors errors, SysModuleOperateModel model)
{
try
{
SysModuleOperate entity = m_rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new SysModuleOperate
{
Id = model.Id,
Name = model.Name,
KeyCode = model.KeyCode,
ModuleId = model.ModuleId,
IsValid = model.IsValid,
Sort = model.Sort
};
if (m_rep.Create(entity) == 1)
{
return(true);
}
errors.Add(Suggestion.InsertFail);
return(false);
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHandler.WriteException(ex);
return(false);
}
}
public int Create(SysModuleOperate entity)
{
using (DBContainer db = new DBContainer())
{
db.SysModuleOperate.AddObject(entity);
return(db.SaveChanges());
}
}
////[SupportFilter(ActionName = "Create")]
public ActionResult CreateOpt(string moduleId)
{
SysModuleOperate sysModuleOptModel = new SysModuleOperate();
sysModuleOptModel.ModuleId = moduleId;
sysModuleOptModel.IsValid = "true";
return(View(sysModuleOptModel));
}
public int Create(SysModuleOperate entity)
{
using (AppsDBEntities db = new AppsDBEntities())
{
db.SysModuleOperate.Add(entity);
return(db.SaveChanges());
}
}
public static bool Insert(SysModuleOperate sysModuleOperate)
{
using (var context = db.Context())
{
return(context.Insert <SysModuleOperate>("SysModuleOperate", sysModuleOperate)
.Execute() > 0);
}
}
public ActionResult CreateOpt(string moduleId)
{
ViewBag.Perm = GetPermission();
SysModuleOperate sysModuleOpt = new SysModuleOperate();
sysModuleOpt.ModuleId = moduleId;
sysModuleOpt.IsValid = true;
return(View(sysModuleOpt));
}
public int DeleteSysModuleOperate(string id)
{
SysModuleOperate entity = dbConnection.SysModuleOperates.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
dbConnection.SysModuleOperates.Remove(entity);
}
return(dbConnection.SaveChanges());
}
public bool IsExists(string id)
{
SysModuleOperate sysModuleOperate = SysModuleOperateDataService.GetSysModuleOperateById(id);
if (sysModuleOperate != null)
{
return(true);
}
return(false);
}
public bool IsExist(string id)
{
SysModuleOperate sysModuleOperate = GetSysModuleOperateById(id);
if (sysModuleOperate != null)
{
return(true);
}
return(false);
}
public bool IsExist(string id)
{
SysModuleOperate entity = GetById(id);
if (entity != null)
{
return(true);
}
return(false);
}
public int Delete(string id)
{
SysModuleOperate entity = db.Set <SysModuleOperate>().SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.Set <SysModuleOperate>().Remove(entity);
}
return(db.SaveChanges());
}
public int Create(SysModuleOperate entity)
{
#region MyRegion
using (var db = new SysMgr_DBEntities())
{
db.SysModuleOperate.Add(entity);
return(db.SaveChanges());
}
#endregion
//db.Set<SysModuleOperate>().Add(entity);
//return db.SaveChanges();
}
public static bool Update(SysModuleOperate sysModuleOperate)
{
using (var context = db.Context())
{
return(context.Update <SysModuleOperate>("SysModuleOperate", sysModuleOperate)
.AutoMap(x => x.Id)
.Where("Id", sysModuleOperate.Id)
.Execute() > 0);
}
}
public bool IsExist(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
SysModuleOperate entity = GetById(id);
if (entity != null)
{
return(true);
}
return(false);
}
}
public bool IsExist(string id)
{
using (OriginEntities db = new OriginEntities())
{
SysModuleOperate entity = new SysModuleOperate();
if (entity != null)
{
return(true);
}
return(false);
}
}
public bool IsExist(string id)
{
using (DBContainer db = new DBContainer())
{
SysModuleOperate entity = GetById(id);
if (entity != null)
{
return(true);
}
return(false);
}
}
public int Delete(string id)
{
using (AppsDBEntities db = new AppsDBEntities())
{
SysModuleOperate entity = db.SysModuleOperate.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.SysModuleOperate.Remove(entity);
}
return(db.SaveChanges());
}
}
public int Delete(string id)
{
using (DBContainer db = new DBContainer())
{
SysModuleOperate entity = db.SysModuleOperate.SingleOrDefault(a => a.Id == id);
if (entity != null)
{
db.SysModuleOperate.DeleteObject(entity);
}
return(db.SaveChanges());
}
}
public SysModuleOperateModel GetById(string id)
{
if (IsExist(id))
{
SysModuleOperate entity = m_rep.GetById(id);
SysModuleOperateModel model = new SysModuleOperateModel
{
Id = entity.Id,
Name = entity.Name,
KeyCode = entity.KeyCode,
ModuleId = entity.ModuleId,
IsValid = entity.IsValid,
Sort = entity.Sort
};
return(model);
}
return(null);
}
//[SupportFilter(ActionName = "Create")]
public JsonResult CreateOpt(FormCollection postedFormData, SysModuleOperateMaintenanceDTO sysModuleOperateDTO)
{
TransactionalInformation transaction;
SysModuleOperateMaintenancViewModel sysModuleOperateMaintenancViewModel = new SysModuleOperateMaintenancViewModel();
//if (!ModelState.IsValid)
//{
// var errors = ModelState.errors();
//sysModuleOperateMaintenancViewModel.ReturnMessage = ModelStateHelper.ReturnErrorMessages(errors);
// sysModuleOperateMaintenancViewModel.ValidationErrors = ModelStateHelper.ReturnValidationErrors(errors);
// sysModuleOperateMaintenancViewModel.ReturnStatus = false;
// var badresponse = Request.CreateResponse<CustomerMaintenanceViewModel>(HttpStatusCode.BadRequest, customerMaintenanceViewModel);
// return badresponse;
//}
SysModuleOperate sysModuleOperate = new SysModuleOperate();
ModelStateHelper.UpdateViewModel(sysModuleOperateDTO, sysModuleOperate);
sysModuleOperate.Id = sysModuleOperate.ModuleId + sysModuleOperate.KeyCode;
SysModuleOperateApplicationService sysModuleOperateApplicationService = new SysModuleOperateApplicationService(sysModuleOperateDataService);
sysModuleOperateApplicationService.CreateSysModuleOperate(sysModuleOperate, out transaction);
sysModuleOperateMaintenancViewModel.SysModuleOperate = sysModuleOperate;
sysModuleOperateMaintenancViewModel.ReturnStatus = transaction.ReturnStatus;
sysModuleOperateMaintenancViewModel.ReturnMessage = transaction.ReturnMessage;
sysModuleOperateMaintenancViewModel.ValidationErrors = transaction.ValidationErrors;
if (transaction.ReturnStatus == false)
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + sysModuleOperate.Id + ",Name" + sysModuleOperate.Name + "," + ErrorCol, "失败", "创建", "SysModule");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
else
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + sysModuleOperate.Id + ",Name" + sysModuleOperate.Name, "成功", "创建", "SysModule");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed), JsonRequestBehavior.AllowGet));
}
}
public SysModuleOperateModel GetById(string id)
{
if (IsExist(id))
{
SysModuleOperate entity = m_Rep.GetById(id);
SysModuleOperateModel model = new SysModuleOperateModel();
model.Id = entity.Id;
model.Name = entity.Name;
model.KeyCode = entity.KeyCode;
model.ModuleId = entity.ModuleId;
model.IsValid = entity.IsValid;
model.Sort = entity.Sort;
return(model);
}
else
{
return(null);
}
}
public virtual async Task <SysModuleOperateModel> GetByIdAsync(object id)
{
if (IsExists(id))
{
SysModuleOperate entity = await m_Rep.GetByIdAsync(id);
SysModuleOperateModel model = new SysModuleOperateModel();
model.Id = entity.Id;
model.Name = entity.Name;
model.KeyCode = entity.KeyCode;
model.ModuleId = entity.ModuleId;
model.IsValid = entity.IsValid;
model.Sort = entity.Sort;
return(model);
}
else
{
return(null);
}
}
