/// <summary> /// 获取变化后的商品信息 /// </summary> /// <returns></returns> public List <LocalCommodityCode> GetLocalCommodityCodeChange(InventoryChangesApo pageDataApo, out int totalCount) { totalCount = 0; List <LocalCommodityCode> data; //查询语句 var queryable = SqlSugarHelper.GetInstance().Db.Queryable <LocalCommodityCode>() .Where((lcc) => lcc.operate_type == pageDataApo.operate_type) .WhereIF(pageDataApo.startTime.HasValue, (lcc) => lcc.create_time >= pageDataApo.startTime) .WhereIF(pageDataApo.endTime.HasValue, (lcc) => lcc.create_time <= pageDataApo.endTime) .WhereIF((!string.IsNullOrEmpty(pageDataApo.name) && !string.IsNullOrWhiteSpace(pageDataApo.name)), (lcc) => lcc.CommodityName.Contains(pageDataApo.name)) .OrderBy((lcc) => lcc.create_time, OrderByType.Desc) .Select <LocalCommodityCode>(); //如果小于0,默认查全部 if (pageDataApo.PageSize > 0) { data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount); } else { data = queryable.ToList(); totalCount = data.Count(); } return(data); }
/// <summary> /// 插入扫描的所有商品信息 /// </summary> /// <param name="currentCommodityEps">当前扫描出来的所有数据</param> /// <returns></returns> public bool InsertLocalCommodityEpsInfo(HashSet <CommodityEps> currentCommodityEps) { var result = false; if (currentCommodityEps == null) { return(result); } //组装最新的扫描结果,一组数据 var localCommodityEps = new LocalCommodityEps { commodityEpsList = JsonConvert.SerializeObject(new List <CommodityEps>(currentCommodityEps)), create_time = DateTime.Now }; //事务防止多插入产生脏数据 result = SqlSugarHelper.GetInstance().Db.Ado.UseTran(() => { SqlSugarHelper.GetInstance().Db.Insertable(localCommodityEps).ExecuteCommand(); }).IsSuccess; if (!result) { LogUtils.Warn("InsertLocalCommodityEpsInfo 失败" + DateTime.Now); } return(result); }
public static void AddRoleMenu() { using (var db = SqlSugarHelper.GetInstance()) { _funcList = db.Queryable <view_sys_user_role_function>().ToList(); } }
/// <summary> /// 插入变化后的商品信息 /// </summary> /// <param name="baseDataCommodityCode">所有数据</param> /// <param name="sourceBill">业务类型</param> /// <returns></returns> public bool InsertLocalCommodityCodeInfo(BaseData <CommodityCode> baseDataCommodityCode, string sourceBill) { var result = false; //校验是否含有数据,如果含有数据,有就继续下一步 baseDataCommodityCode = HttpHelper.GetInstance().ResultCheck(baseDataCommodityCode, out bool isSuccess); if (isSuccess) { List <LocalCommodityCode> localCommodityCodes = baseDataCommodityCode.body.objects.MapToListIgnoreId <CommodityCode, LocalCommodityCode>(); var createTime = DateTime.Now; var operater = ApplicationState.GetUserInfo().name; localCommodityCodes.ForEach(it => { it.sourceBill = sourceBill; it.create_time = createTime; it.operater = operater; }); //事务防止多插入产生脏数据 result = SqlSugarHelper.GetInstance().Db.Ado.UseTran(() => { SqlSugarHelper.GetInstance().Db.Insertable(localCommodityCodes).ExecuteCommand(); }).IsSuccess; } if (!result) { LogUtils.Warn("InsertLocalCommodityCodeInfo" + sourceBill); } return(result); }
/// <summary> /// 判断是否是初次使用本地库存上次,如果是则不上传 /// </summary> /// <returns></returns> public bool isInitLocalCommodityEpsInfo() { //查询语句 var localCommodityEpsCount = SqlSugarHelper.GetInstance().Db.Queryable <LocalCommodityEps>() .Select <LocalCommodityEps>().Count(); return(localCommodityEpsCount <= 0); }
/// <summary> /// 获取变化后的商品信息的名称集合 /// </summary> /// <returns></returns> public List <string> GetLocalCommodityName() { //查询语句 var queryable = SqlSugarHelper.GetInstance().Db.Queryable <LocalCommodityCode>() .Distinct() .OrderBy((lcc) => lcc.create_time, OrderByType.Desc) .Select(it => it.CommodityName).ToList(); return(queryable); }
/// <summary> /// 获取上次扫描记录的商品信息 /// </summary> /// <returns></returns> public HashSet <CommodityEps> GetLastLocalCommodityEpsInfo() { var ret = new HashSet <CommodityEps>(); //查询语句 var localCommodityEps = SqlSugarHelper.GetInstance().Db.Queryable <LocalCommodityEps>() .OrderBy((lcc) => lcc.create_time, OrderByType.Desc) .Select <LocalCommodityEps>().First(); if (localCommodityEps.commodityEpsList != null) { ret = new HashSet <CommodityEps>(JsonConvert.DeserializeObject <List <CommodityEps> >(localCommodityEps.commodityEpsList)); } return(ret); }
// 定义私有构造函数,使外界不能创建该类实例 private ReplenishDal() { Db = SqlSugarHelper.GetInstance().Db; }
/// <summary> /// Action 执行之前 发生 /// </summary> /// <param name="filterContext"></param> public override void OnActionExecuting(ActionExecutingContext filterContext) { if (IsExecutePowerLogic || MenuID == "Home") { Console.WriteLine(filterContext.HttpContext.Request.Path.Value); var token = string.Empty; var cktoken = filterContext.HttpContext.Request.Cookies["authtoken"]; var attoken = filterContext.HttpContext.Request.Headers["authtoken"].ToString(); if (!string.IsNullOrEmpty(cktoken)) { //Console.WriteLine(cktoken); token = cktoken; } if (!string.IsNullOrEmpty(attoken)) { token = attoken; } if (!string.IsNullOrEmpty(token)) { var userid = string.Empty; var handers = new JwtSecurityTokenHandler().ReadJwtToken(token.Replace("Bearer ", "")); foreach (var item in handers.Claims) { if (item.Type == "ID") { userid = item.Value; } //Console.WriteLine(item.Type); //Console.WriteLine(item.Value); } //if (!string.IsNullOrEmpty(Convert.ToString(CacheHelper.Get(userid)))) //{ // CacheHelper.Set(userid, "1", DateTime.Now.AddMinutes(120)); using (var db = SqlSugarHelper.GetInstance()) { var model = db.Queryable <sys_user, sys_userrole>((u, ur) => new object[] { JoinType.Inner, u.User_ID == ur.UserRole_UserID } ).Where((u) => u.User_ID == userid) .Select((u, ur) => new { u.User_ID, u.User_Name, ur.UserRole_RoleID }).First(); if (model != null) { account.RoleID = model.UserRole_RoleID; account.UserID = model.User_ID; account.UserName = model.User_Name; account.IsSuperManage = model.UserRole_RoleID.ToStr().ToLower() == AppConfig.Admin_RoleID; filterContext.RouteData.Values.Add("account", account); base.OnActionExecuting(filterContext); } else { throw new MessageBox("请重新登陆", EMsgStatus.无效权限401); } } } else { throw new MessageBox("请重新登陆", EMsgStatus.无效权限401); } } else { base.OnActionExecuting(filterContext); } }
/// <summary> /// 权限逻辑 /// </summary> /// <param name="context"></param> private void PowerLogic(ActionExecutedContext context) { if (MenuID != "Home") { //Console.WriteLine(context.HttpContext.Request.Headers["X-Requested-With"].ToString()); if (!(context.HttpContext.Request.Headers["X-Requested-With"].ToString() == "XMLHttpRequest")) { using (var db = SqlSugarHelper.GetInstance()) { var _RouteValues = context.ActionDescriptor.RouteValues; var _Area = _RouteValues["area"]; var _Controller = _RouteValues["controller"]; var _Action = _RouteValues["action"]; var _func_list = db.Queryable <sys_function>().OrderBy("Function_Num asc").ToList(); var _power_list = new Dictionary <string, object>(); //这里得判断一下是否是查找带回调用页面 string findback = context.HttpContext.Request.Query["findback"]; if (string.IsNullOrEmpty(findback)) { //dynamic model = new ExpandoObject(); if (string.IsNullOrEmpty(MenuID)) { throw new MessageBox("区域(" + _Area + "),控制器(" + _Controller + "):的程序中缺少菜单ID"); } var _Menu = db.Queryable <sys_menu>().First(p => p.Menu_Num == MenuID); //if (!_Menu.Menu_Url.ToStr().StartsWith("/" + _Area + "/" + _Controller + "/")) //{ // throw new MessageBox("区域(" + _Area + "),控制器(" + _Controller + "):的程序中缺少菜单ID与该页面不匹配"); //} if (!account.IsSuperManage) { var _role_menu_func_list = db.Queryable <sys_rolemenufunction>().ToList(); _power_list = new Dictionary <string, object>(); _func_list.ForEach(item => { var ispower = _role_menu_func_list.FindAll(x => x.RoleMenuFunction_RoleID == account.RoleID && x.RoleMenuFunction_MenuID == _Menu.Menu_ID && x.RoleMenuFunction_FunctionID == item.Function_ID); _power_list.Add(item.Function_ByName, (ispower.Count > 0)); }); } else { var _menu_func_list = db.Queryable <sys_menufunction>().ToList(); _func_list.ForEach(item => { //_power_list.Add(item.Function_ByName, true); var ispower = _menu_func_list.FindAll(x => x.MenuFunction_MenuID == _Menu.Menu_ID && x.MenuFunction_FunctionID == item.Function_ID); if (ispower.Count > 0) { _power_list.Add(item.Function_ByName, true); } else { _power_list.Add(item.Function_ByName, false); } }); } } else { _power_list = new Dictionary <string, object>(); _func_list.ForEach(item => { _power_list.Add(item.Function_ByName, false); }); _power_list["Have"] = true; _power_list["Search"] = true; } this.ViewData["PowerModel"] = _power_list.SerializeObject(); } } } }
// 定义私有构造函数,使外界不能创建该类实例 private FetchOrderDal() { Db = SqlSugarHelper.GetInstance().Db; }
// 定义私有构造函数,使外界不能创建该类实例 private UserDal() { Db = SqlSugarHelper.GetInstance().Db; }
// 定义私有构造函数,使外界不能创建该类实例 private GoodsDal() { Db = SqlSugarHelper.GetInstance().Db; }
// 定义私有构造函数,使外界不能创建该类实例 private PickingDal() { Db = SqlSugarHelper.GetInstance().Db; }
static void Main(string[] args) { var option = new ConfigurationOptions(); ConnectionMultiplexer redis = ConnectionMultiplexer.Connect("localhost:6379,password=redis123"); //IDatabase dbr = redis.GetDatabase(0); //var batch = dbr.CreateBatch(); //sub.Publish("test1", "2222"); ISubscriber sub = redis.GetSubscriber(); sub.Publish("95", "JCZQ1211101950191836176274"); string vs = string.Empty; string ss = string.Empty; sub.Subscribe("messages", (channel, message) => { Console.WriteLine((string)message); }); Console.ReadKey(); return; //var db = getdb(); //var list = db.Queryable<blast_count>().ToList(); ////var model = list.Find(a => a.id == 1038); ////var model1 = list.Find(a => a.id == 1039); //blast_count model = new blast_count(); //blast_count model1 = new blast_count(); //model.typeid = 1000; //model.playedId = 10000; //model.createdate = DateTime.Now; //model.betCount = 1; //model.betAmount = 100; //model.zjAmount = 100; //try //{ // db.Ado.BeginTran(); // model1.id = 1000000; // db.Insertable<blast_count>(model).ExecuteCommand(); // //db.Insertable<blast_count>(model1).ExecuteCommand(); // //throw new Exception("3333"); // db.Ado.CommitTran(); //} //catch (Exception exp) //{ // db.Ado.RollbackTran(); //} SqlSugarClient db = SqlSugarHelper.GetInstance(); var list = db.Queryable <blast_count>().ToList(); var model = list.Find(a => a.id == 225); //var result = db.Ado.UseTran(() => //{ // model.betCount = 2; // db.Updateable<blast_count>(model).ExecuteCommand(); // db.Ado.ExecuteCommand("delete student"); // throw new Exception("error haha"); //}); //SqlSugarClient db1 = SqlSugarHelper.GetInstance(); //blast_admin_log model1 = new blast_admin_log(); //SqlSugarHelper.TranInvok(() => //{ // model.betCount = 2; // db.Updateable<blast_count>(model).ExecuteCommand(); // db.Updateable<blast_admin_log>(model1).ExecuteCommand(); // return true; //}, db, db1); Console.WriteLine("Hello World!"); Console.ReadKey(); }