/// <summary>
/// 获取模块元素列表
/// </summary>
/// <param name="roleID">角色ID</param>
/// <param name="moduleID">模块ID</param>
/// <returns>角色模块元素列表</returns>
public CheckReturn LoadModuleElements(int roleID, int moduleID)
{
if (!CurrentRepository.IsExists(u => u.ID == roleID))
{
return(new CheckReturn
{
Message = "角色不存在",
Flag = false
});
}
var modules = ModuleElementRepository.LoadModuleElement(moduleID)
.Select(r => new
{
ID = r.ID,
Name = r.Name
}).ToDictionary(key => key.ID, value => value.Name);
int[] ids = RoleModuleElementRepository.LoadEntities(r => r.RoleID == roleID && r.ModuleID == moduleID)
.Select(r => r.ModuleElementID)
.ToArray();
return(new CheckReturn
{
Flag = true,
Message = "获取成功",
dics = modules,
IDs = ids
});
}
public IList <T> FindAll <T>(int startPage, int pageSize) where T : class
{
dynamic retObj = Activator.CreateInstance <T>();
var query = CurrentRepository.FindAll <T>(GenerateSelectQuery(retObj, null));
return(query.Skip((startPage - 1) * pageSize).Take(pageSize).ToList());
}
public OpResult UpdateIntegralRule(IntegralRule rule)
{
var model = GetIntegralRuleById(rule.Id);
model.Condition = rule.Condition;
model.ExpiryEnd = rule.ExpiryEnd;
model.ExpiryStart = rule.ExpiryStart;
model.Memo = rule.Memo;
model.ReturnValue = rule.ReturnValue;
model.RuleTypeId = rule.RuleTypeId;
model.RuleTypeValue = rule.RuleTypeValue;
model.State = rule.State;
model.UseUsers = rule.UseUsers;
model.IsStack = rule.IsStack;
var result = CurrentRepository.Update(model);
if (result)
{
return(new OpResult()
{
Successed = true, Message = "操作成功！"
});
}
else
{
return(new OpResult()
{
Successed = true, Message = "操作失败！"
});
}
}
public static OpResult ReSave(StockTaking obj)
{
var op = new OpResult();
var stock = CurrentRepository.FindById(obj.Id);
stock.ActualNumber = Math.Round(obj.ActualNumber.GetValueOrDefault(), 3);
stock.CreateUID = Sys.CurrentUser.UID;
var CheckUID = HttpContext.Current.Request["CheckUID"];
var log = new StockTakingLog()
{
Barcode = stock.Barcode,
CheckBatch = stock.CheckBatch,
CheckUID = CheckUID,
CreateUID = stock.CreateUID,
CreateDT = DateTime.Now,
Number = stock.ActualNumber.GetValueOrDefault(),
State = 1,
ActualDate = HttpContext.Current.Request["ActualDate"].ToType <DateTime>(),
CompanyId = CommonService.CompanyId,
Source = 1
};
op = BaseService <StockTakingLog> .Add(log);
return(op);
}
public static MemberInfo GetMemberInfo(string storeId, int companyId, string phone, string uid, string cardNo)
{
var memberInfo = new MemberInfo();
var member = new Members();
if (!string.IsNullOrEmpty(phone))
{
member = CurrentRepository.Find(o => o.MobilePhone == phone && o.CompanyId == companyId);
}
else if (!string.IsNullOrEmpty(cardNo))
{
var carno = MembershipCardService.CurrentRepository.Find(o => o.CardSN == cardNo);
member = CurrentRepository.Find(o => o.CompanyId == companyId && o.MemberId == carno.MemberId);
}
if (member != null)
{
memberInfo.MemberId = member.MemberId;
memberInfo.MobilePhone = member.MobilePhone;
memberInfo.RealName = member.RealName;
memberInfo.MemberCardNum = cardNo;
memberInfo.UsableIntegral = member.UsableIntegral;
return(memberInfo);
}
throw new Pos.Exceptions.PosException("未找到会员信息！");
}
/// <summary>
/// 修改备注
/// </summary>
/// <param name="ids"></param>
/// <param name="state"></param>
/// <returns></returns>
public static OpResult SetMemo(int id, string memo)
{
var list = CurrentRepository.Find(o => o.Id == id);
list.Memo = memo;
return(Update(list));
}
/// <summary>
/// 发卡
/// </summary>
/// <param name="_membershipCard"></param>
/// <returns></returns>
public OpResult BindMembershipCard(MembershipCard _membershipCard)
{
//发卡
try
{
var _oldCard = CurrentRepository.Entities.Where(o => o.Id == _membershipCard.Id).FirstOrDefault();
if (_oldCard != null)
{
var isExits = BaseService <Members> .CurrentRepository.Entities.Any(o => o.MemberId == _membershipCard.MemberId);
if (!isExits)
{
return(OpResult.Fail("会员信息异常，请刷新重试！"));
}
_oldCard.MemberId = _membershipCard.MemberId;
_oldCard.LeadTime = DateTime.Now;
_oldCard.Deposit = _membershipCard.Deposit;
CurrentRepository.Update(_oldCard);
}
return(OpResult.Success("操作成功！"));
}
catch (Exception e)
{
Log.WriteError(e);
throw;
}
}
public WikiArticleInfoViewModel(
RequestContext requestContext,
ArticleId articleId,
UserManager <WikiDownUser> userManager)
: base(requestContext, articleId, activeTab: HeaderTab.Info)
{
if (userManager == null)
{
throw new ArgumentNullException("userManager");
}
if (this.Article == null)
{
throw new ArticleNotFoundException("articleId");
}
this.userManager = userManager;
this.ActiveArticleRevisionId = this.Article.ActiveRevisionId;
var redirects = CurrentRepository.GetArticleRedirectsList(articleId);
this.Redirects = redirects.Select(x => new KeyValuePair <string, string>(x.Slug, x.Title)).ToList();
this.Tags = (this.Article.Tags ?? Enumerable.Empty <string>()).ToList();
var articleRevisions = CurrentRepository.GetArticleRevisionsList(articleId);
this.Revisions = articleRevisions.Select(x => new ArticleRevisionListItem(x, this.userManager)).ToList();
}
public void C2ViewDocument(String path, string objectId, bool openDocument)
{
D2Document doc = CurrentRepository.GetSysObjectById <D2Document>(objectId);
C2Views views = doc.getC2Views();
List <C2ViewEntry> entries = views.Entries;
C2ViewEntry entry = entries[0];
C2View view = entry.C2View;
using (Stream stream = CurrentRepository.Client.GetRaw(view.Url))
{
if (stream == null)
{
throw new Exception("Stream came back null. This is normally caused by an unreachable ACS Server (DNS problem or Method Server DOWN). ACS URL is: " + view.Url);
}
FileStream fs = File.Create(path + "\\Test.Pdf");
stream.CopyTo(fs);
fs.Dispose();
}
if (openDocument)
{
System.Diagnostics.Process.Start(path + "\\Test.pdf");
}
}
public virtual void Update(TEntityDto entityDto)
{
if (WcfCurrentContext.IsAuthenticated)
{
UserIdentity currentUser = WcfCurrentContext.CurrentUser;
var perId = int.Parse(currentUser.UserId);
AssemblyReflector.SetValue(entityDto, "UpdatePerId", perId);
}
AssemblyReflector.SetValue(entityDto, "UpdateDate", DateTime.Now);
if (entityDto.State == DtoObjectState.Updated || entityDto.State == DtoObjectState.Ignore || entityDto.State == DtoObjectState.Persisted)
{
try
{
CurrentRepository.UpdateOrCreate(entityDto);
CurrentRepository.SaveChanges();
entityDto.State = DtoObjectState.Updated;
}
catch (Exception ex)
{
entityDto.State = DtoObjectState.Ignore;
entityDto.Response.AddBusinessException(new Framework.Common.Service.Message.BusinessExceptionDto(Framework.Common.Service.Message.BusinessExceptionEnum.Operational, "در ویرایش اطلاعات از دیتابیس مشکل بوجود آمد!", ex.Message, ex.StackTrace));
ex.Data.Add("type", "db");
throw ex;
}
}
}
public static AccountCheckingDAO GetUserAccountInfos(string uid, string machineSn)
{
var startTime = PosCheckingLocalService.GetLastPosChecking();
//入款
var depositMoney = CurrentRepository
.FindList(o => o.MachineSN == machineSn && o.CreateDT >= startTime && o.CreateUID == uid && o.Type == 1).ToList()
.Select(o => (decimal?)o.Amount).Sum() ?? 0;
//出款
var takeOutMoney = CurrentRepository
.FindList(o => o.MachineSN == machineSn && o.CreateDT >= startTime && o.CreateUID == uid && o.Type == 0).ToList()
.Select(o => (decimal?)o.Amount).Sum() ?? 0;
//退货
var returnSales = SalesReturnsLocalService.GetReturnSalesForBJ(startTime, uid, machineSn);
return(new AccountCheckingDAO()
{
DepositMoney = depositMoney,
TakeOutMoney = takeOutMoney,
TotalSales = SaleOrdersLocalService.GetTotalSales(startTime, uid, machineSn), //销售总额
ChangingSales = SaleOrdersLocalService.GetChangingSales(startTime, uid, machineSn), //换货补价
AllPayWayStatistics = ConsumptionPaymentLocalService.GetOnePayWayAmount(startTime, uid, machineSn), //所有支付方式统计
SurplusCash = depositMoney - takeOutMoney + ConsumptionPaymentLocalService.GetCashPayWay(startTime, uid, machineSn) - returnSales, //当前现金
ReturnSales = returnSales
});
}
public OpResult UpdateShipCard(MakingMembershipCard _shipcard)
{
try
{
var oldShipCard = CurrentRepository.FindById(_shipcard.Id);
//if (oldShipCard == null || oldShipCard.State >= 0)
//{
// return new OpResult() { Successed = false, Message = "改制卡批次不允许修改！" };
//}
oldShipCard.MakeNumber = _shipcard.MakeNumber;
oldShipCard.CardTypeId = _shipcard.CardTypeId;
oldShipCard.ExpiryStart = _shipcard.ExpiryStart;
oldShipCard.ExpiryEnd = _shipcard.ExpiryEnd;
//oldShipCard.NumberEnd = _shipcard.NumberEnd;
//oldShipCard.NumberStart = _shipcard.NumberStart;
oldShipCard.State = _shipcard.State;
CurrentRepository.Update(oldShipCard);
return(new OpResult()
{
Successed = true, Message = "操作成功！"
});
}
catch (Exception e)
{
Log.WriteError(e);
return(new OpResult()
{
Successed = false, Message = e.Message
});
}
}
public void Delete(List <TEntityDto> entityDtoList)
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
foreach (var entityDto in entityDtoList)
{
CurrentRepository.Delete(entityDto);
}
CurrentRepository.SaveChanges();
scope.Complete();
foreach (var entityDto in entityDtoList)
{
entityDto.State = DtoObjectState.Deleted;
}
}
catch (Exception ex)
{
foreach (var entityDto in entityDtoList)
{
entityDto.State = DtoObjectState.Ignore;
entityDto.Response.AddBusinessException(new Framework.Common.Service.Message.BusinessExceptionDto(Framework.Common.Service.Message.BusinessExceptionEnum.Operational, "در حذف اطلاعات از دیتابیس مشکل بوجود آمد!", ex.Message, ex.StackTrace));
}
ex.Data.Add("type", "db");
throw ex;
}
}
}
public static OpResult Update(TEntity entity, bool isSave = true)
{
var op = new OpResult();
SqliteTrap.PushAction <TEntity>((o1) =>
{
try
{
try
{
var id = o1.GetType().GetProperty("Id").GetValue(o1, null);
var entity1 = CurrentRepository.FindById(id);
entity1 = entity1.InitEntity <TEntity, TEntity>(o1);
var result = CurrentRepository.Update(entity1);
}
catch { }
finally
{
//One of the following two is enough
CurrentRepository._context.Database.Connection.Close();
CurrentRepository._context.Database.Connection.Dispose(); //THIS OR
ContextFactory.GetCurrentContext <SqliteDbContext>(true);
}
}
catch (Exception ex)
{
File.AppendAllText("Log.txt", ex.Message + "|" + ex.StackTrace, Encoding.UTF8);
// Log.WriteError(ex);
}
}, entity);
op.Successed = true;
return(op);
}
//
public OpResult UpdateMemberCardType(CardInfo cardInfo)
{
var currentInfo = CurrentRepository.Entities.Where(o => o.CompanyId == CommonService.CompanyId && cardInfo.Id == o.Id).FirstOrDefault();
if (currentInfo != null)
{
currentInfo.CardName = cardInfo.CardName;
currentInfo.CardType = cardInfo.CardType;
//currentInfo.CardTypeId = cardInfo.CardTypeId;
currentInfo.Category = cardInfo.Category;
//currentInfo.CouponType = cardInfo.CouponType;
//currentInfo.DefaultIntegr = cardInfo.DefaultIntegr;
currentInfo.DefaultPrice = cardInfo.DefaultPrice;
//currentInfo.Discount = cardInfo.Discount;
//currentInfo.IntegrationType = cardInfo.IntegrationType;
currentInfo.Memo = cardInfo.Memo;
currentInfo.MinRecharge = cardInfo.MinRecharge;
currentInfo.State = cardInfo.State;
CurrentRepository.Update(currentInfo);
return(new OpResult()
{
Successed = true, Message = "操作成功！"
});
}
else
{
return(new OpResult()
{
Successed = false, Message = "未找到该数据！"
});
}
}
public static UserInfo GetStoreUserInfo(string account, string storeId, int companyId)
{
var query = CurrentRepository.Entities.Where(o => o.UserCode == account && o.CompanyId == companyId);
var user = query.Select(o => new UserInfo()
{
FullName = o.FullName,
LoginDT = o.LoginDT,
LoginPwd = o.LoginPwd,
OperateAuth = o.OperateAuth,
Sex = o.Sex,
UID = o.UID,
UserCode = o.UserCode
}).ToList();
var info = user.FirstOrDefault();
if (info != null)
{
//160504更新登录时间
var _queryUser = query.FirstOrDefault();
_queryUser.LoginDT = DateTime.Now;
CurrentRepository.Update(_queryUser);
//160504
var store = BaseService <Warehouse> .CurrentRepository.Entities.FirstOrDefault(o => o.StoreId == storeId && o.CompanyId == companyId);
if (store != null)
{
info.StoreName = store.Title;
}
else
{
info.StoreName = "未知门店";
}
}
return(info);
}
public static UserInfo GetStoreUserInfo(string account, string storeId, int companyId)
{
var query = CurrentRepository.Entities.Where(o => o.UserCode == account);
var user = query.Select(o => new UserInfo()
{
FullName = o.FullName,
LoginDT = o.LoginDT,
LoginPwd = o.LoginPwd,
OperateAuth = o.OperateAuth,
Sex = o.Sex,
UID = o.UID,
UserCode = o.UserCode
}).ToList();
var info = user.FirstOrDefault();
//160504更新时间
if (info != null)
{
var _queryUser = query.FirstOrDefault();
_queryUser.LoginDT = DateTime.Now;
CurrentRepository.Update(_queryUser);
info.StoreName = System.Configuration.ConfigurationManager.AppSettings["StoreName"];
}
return(info);
}
public virtual void Insert(TEntityDto entityDto)
{
try
{
if (WcfCurrentContext.IsAuthenticated)
{
UserIdentity currentUser = WcfCurrentContext.CurrentUser;
var perId = int.Parse(currentUser.UserId);
AssemblyReflector.SetValue(entityDto, "InsertPerId", perId);
}
AssemblyReflector.SetValue(entityDto, "InsertDate", DateTime.Now);
TEntity entity = CurrentRepository.Create(entityDto);
CurrentRepository.SaveChanges();
object id = AssemblyReflector.GetValue(entity, entityDto.PrimaryKeyName);
AssemblyReflector.SetValue(entityDto, entityDto.PrimaryKeyName, id);
entityDto.State = DtoObjectState.Inserted;
}
catch (Exception ex)
{
entityDto.State = DtoObjectState.Ignore;
entityDto.Response.AddBusinessException(new Framework.Common.Service.Message.BusinessExceptionDto(Framework.Common.Service.Message.BusinessExceptionEnum.Operational, "در ورود اطلاعات به دیتابیس مشکل بوجود آمد!", ex.Message, ex.StackTrace));
ex.Data.Add("type", "db");
throw ex;
}
}
public static void Save(string storeId, string machineSn, string uid, decimal money, PosIncomePayoutMode mode, int companyId, bool isTest)
{
try
{
CurrentRepository.Add(new PosIncomePayout()
{
Amount = money,
CreateDT = DateTime.Now,
CreateUID = uid,
MachineSN = machineSn,
StoreId = storeId,
Type = (short)mode,
CompanyId = companyId,
IsTest = isTest,
SyncItemId = Guid.NewGuid(),
SyncItemVersion = BitConverter.GetBytes((long)1)
});
//RedisManager.Publish("SyncDatabase", "PosIncomePayout");
StoreManager.PubEvent("SyncDatabase", "PosIncomePayout");
}
catch (Exception ex)
{
throw ex;
}
}
public Tuple <bool, string> UseSessionCode(long id)
{
try
{
var result = CurrentRepository.Find(id);
if (result != null)
{
if (result.type != 0 || result.create_datetime.AddDays(7) < DateTime.Now)
{
return(new Tuple <bool, string>(false, "expired"));
}
else
{
result.type = 1;
var success = CurrentRepository.Update(result);
return(new Tuple <bool, string>(success, string.Empty));
}
}
else
{
return(new Tuple <bool, string>(false, "not existed"));
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 分配菜单
/// </summary>
/// <param name="role_id"></param>
/// <param name="menus"></param>
/// <returns></returns>
public Result AssignmentMenu(int role_id, int[] menus)
{
Result result = new Result();
if (role_id != 0 && menus.Count() > 0)
{
List <TB_MenuRole> menurolelist = LoadEntities(s => s.role_id == role_id).ToList();
foreach (TB_MenuRole item in menurolelist)
{
CurrentRepository.DeleteEntity(item);
}
foreach (int item in menus)
{
TB_MenuRole tb_menurole = new TB_MenuRole();
tb_menurole.role_id = role_id;
tb_menurole.menu_id = item;
CurrentRepository.AddEntity(tb_menurole);
}
_dbSession.Save();
result.Code = "200";
result.Msg = "分配成功!";
}
else
{
result.Code = "400";
result.Msg = "role_id和菜单不能为空!";
}
return(result);
}
public static void UpdateState(short state, string ids)
{
var datas = CurrentRepository.Entities.Where(o => ("," + ids + ",").Contains("," + o.Id + ",")).ToList();
datas.Each(o => o.State = state);
CurrentRepository.Update(new MembershipCard());
}
/// <summary>
/// 分配角色
/// </summary>
/// <param name="user_id"></param>
/// <param name="roles"></param>
/// <returns></returns>
public Result AssigningRoles(int user_id, int[] roles)
{
Result result = new Result();
if (user_id != 0 && roles.Count() > 0)
{
List <TB_UserRole> userrolelist = LoadEntities(s => s.user_id == user_id).ToList();
foreach (TB_UserRole item in userrolelist)
{
CurrentRepository.DeleteEntity(item);
}
foreach (int item in roles)
{
TB_UserRole tb_userrole = new TB_UserRole();
tb_userrole.role_id = item;
tb_userrole.user_id = user_id;
CurrentRepository.AddEntity(tb_userrole);
}
_dbSession.Save();
result.Code = "200";
result.Msg = "分配成功!";
}
else
{
result.Code = "400";
result.Msg = "userid和角色不能为空!";
}
return(result);
}
public IEnumerator AddGraphItems(IEnumerable <IDiagramNode> items)
{
var dictionary = new Dictionary <string, IFilterItem>();
IFilterItem[] fitems = GraphData.CurrentFilter.FilterItems.ToArray <IFilterItem>();
foreach (var item in GraphData.CurrentFilter.FilterItems)
{
if (dictionary.ContainsKey(item.NodeId))
{
item.Repository.Remove(item);
continue;
}
dictionary.Add(item.NodeId, item);
}
FilterItems = dictionary;
IsLoading = true;
var connectors = new List <ConnectorViewModel>();
// var time = DateTime.Now;
foreach (var item in items)
{
// Get the ViewModel for the data
//InvertApplication.Log("B-A" + DateTime.Now.Subtract(time).TotalSeconds.ToString());
var mapping = InvertApplication.Container.RelationshipMappings[item.GetType(), typeof(ViewModel)];
if (mapping == null)
{
continue;
}
var vm = Activator.CreateInstance(mapping, item, this) as GraphItemViewModel;
//var vm =
// InvertApplication.Container.ResolveRelation<ViewModel>(item.GetType(), item, this) as
// GraphItemViewModel;
//InvertApplication.Log("B-B" + DateTime.Now.Subtract(time).TotalSeconds.ToString());
if (vm == null)
{
if (InvertGraphEditor.Platform.MessageBox("Node Error", string.Format("Couldn't find view-model for {0} would you like to remove this item?", item.GetType()), "Yes", "No"))
{
CurrentRepository.Remove(item);
}
continue;
}
vm.DiagramViewModel = this;
GraphItems.Add(vm);
//// Clear the connections on the view-model
//vm.Connectors.Clear();
//vm.GetConnectors(vm.Connectors);
//connectors.AddRange(vm.Connectors);
yield return(new TaskProgress(string.Format("Loading..."), 95f));
}
IsLoading = false;
RefreshConnectors();
//AddConnectors(connectors);
InvertApplication.SignalEvent <IGraphLoaded>(_ => _.GraphLoaded());
yield break;
}
/// <summary>
/// 获取支付方式
/// </summary>
/// <param name="ids">支付方式多个ApiCode</param>
/// <returns></returns>
public static List <ApiLibrary> GetPayWays(IEnumerable <int> ids)
{
if (ids != null)
{
return(CurrentRepository.FindList(o => ids.Contains(o.ApiCode)).ToList());
}
return(null);
}
/// <summary>
/// 根据邮箱或手机号获得实体
/// </summary>
/// <param name="userName">手机号或邮箱</param>
/// <returns></returns>
public Member Find(string userName)
{
if (RegexUtil.IsMobilePhone(userName))
{
return(CurrentRepository.Find(member => member.Phone_mob == userName));
}
return(CurrentRepository.Find(member => member.Email == userName));
}
public override IEnumerable <dynamic> Export(string storeId, string entityType)
{
var date = DateTime.Now.Date;
var list = CurrentRepository.FindList(o => o.State != 2 && o.EndDate >= date);
list.Each(o => { o.StoreId = o.StoreId.TrimStart(','); });
return(list);
}
T IEntityManager.Find <T>(object id)
{
dynamic retObj = Activator.CreateInstance <T>();
retObj.Id = Guid.Parse(id.ToString());
var result = CurrentRepository.Find <T>(GenerateSelectQueryId(retObj));
return(result);
}
public IEnumerable <interact_post> LoadPostListByPage(int pageNo, int pageSize)
{
return
(CurrentRepository.Find(it => it.state.HasValue && it.state.Value != 0).OrderByDescending(
it =>
it
.release_time)
.Skip(pageSize * Math.Max(0, pageNo - 1)).Take(pageSize));
}
public static List <ProductInfo> GetSeries(int CategorySN)
{
var ids = ProductCategoryLocalService.FindAllChild(CategorySN);
ids.Add(CategorySN);
var result = CurrentRepository.FindList(o => ids.Contains(o.CategorySN)).ToList();
return(result);
}
