コード例 #1
0
        public Control CallCreateUserControl(Action<User> createCallback=null)
        {
            var formControl = FormControlHelper.CreateFormControl();
            formControl.RenderForm(new User(),false);
            formControl.ConfirmButton.Content = "创建用户";
            formControl.SubmitCallback = (d) =>
            {
                using (var dbcontext = new WarehouseContext())
                {
                    try
                    {
                        dbcontext.Users.Add((User)d);
                        dbcontext.SaveChanges();
                        if (createCallback != null)
                            createCallback((User)d);
                    }
                    catch (Exception ex)
                    {
                        //TODO: handle exception
                        formControl.SetErrorMsgManually("Username", "此用户名已存在,请更换");
                    }
                }
            };

            return formControl;
        }
コード例 #2
0
        public Control CallAddProductControl(string productScanCode, WarehouseContext dbcontext, Action<Product> createCallback = null)
        {
            var formControl = FormControlHelper.CreateFormControl();
            var product = new Product();
            product.ScanCode = productScanCode;
            formControl.RenderForm(product, false);
            formControl.ConfirmButton.Content = "录入产品";
            formControl.SubmitCallback = (d) =>
            {
                try
                {
                    dbcontext.Products.Add((Product)d);
                    dbcontext.SaveChanges();
                    if (createCallback != null)
                        createCallback((Product)d);
                }
                catch (Exception ex)
                {
                    //TODO: handle exception
                    formControl.SetErrorMsgManually("ScanCode", "此产品扫码已存在");
                }
            };

            return formControl;
        }
コード例 #3
0
 private void ReloadUserGrid()
 {
     using (var dbcontext = new WarehouseContext())
     {
         usersdg.ItemsSource = dbcontext.Users.ToList();
     }
 }
コード例 #4
0
 private void DeleteUser_Clicked(object sender, RoutedEventArgs e)
 {
     var data = ((Button)sender).DataContext as User;
     if(data!=null){
         var result = MessageBox.Show(
             string.Format("你是否决定要删除用户'{0}'?", data.Name),
             "操作警告",
             MessageBoxButton.OKCancel,
             MessageBoxImage.Warning);
         if (result == MessageBoxResult.OK)
         {
             try
             {
                 using (var dbcontext = new WarehouseContext())
                 {
                     var deluser = dbcontext.Users.Find(((User)data).UserId);
                     dbcontext.Users.Remove(deluser);
                     dbcontext.SaveChanges();
                     edit_br.Child = null;
                     ReloadUserGrid();
                 }
             }
             catch (Exception ex)
             {
                 WindowMgr.SendNotification("删除操作失败。", NotificationLevel.Error);
             }
         }
     }
 }
コード例 #5
0
 void SelectUserControl_Loaded(object sender, RoutedEventArgs e)
 {
     using (var dbcontext = new WarehouseContext())
     {
         userlist = dbcontext.Users.ToList();
     }
 }
コード例 #6
0
        public Goods CallRegisterGoodsPopup(Product product, WarehouseContext dbcontext)
        {
            Goods newGoods = null;
            var window = new NotifyWindow();
            window.Width = 400;
            window.Height = 600;
            window.Title = "添加货物";

            var formControl = FormControlHelper.CreateFormControl();
            var goods = new Goods();
            goods.Product = product;
            goods.Name = product.Name;
            goods.State = GoodsState.Inbound;
            goods.GoodsCode = DateTime.Now.ToString("yyyyMMddHHmmss")+"001";

            formControl.CreateControlCallback = (cx, ctl) =>
            {
                if (cx.ControlType == ControlType.Editable)
                {
                    switch (cx.PropertyInfo.Name)
                    {
                        case "Product":
                            var tb = new TextBox();
                            tb.Text = product.Name;
                            tb.Style = Application.Current.Resources["editctl_TextBox"] as Style;
                            tb.IsEnabled = false;
                            CustomValidation.SetValidationOptOut(tb);
                            return tb;
                        case "GoodsCode":
                            ctl.IsEnabled = false;
                            return ctl;
                    }
                }
                return ctl;
            };

            formControl.RenderForm(goods, false);
            formControl.ConfirmButton.Content = "添加";
            formControl.SubmitCallback = d =>
            {
                try
                {
                    newGoods = d as Goods;
                    newGoods.InboundDate=DateTime.Now;
                    dbcontext.Goods.Add(newGoods);
                    window.Close();
                }
                catch (Exception ex)
                {
                    window.ShowNotificationMessage("添加货物失败,请重试。");
                }
            };
            window.MyContent = formControl;
            window.ShowDialog();
            return newGoods;
        }
コード例 #7
0
 public static JObject LoadMetadata(string name)
 {
     using (var dbcontext = new WarehouseContext())
     {
         var data = dbcontext.Metadatas.FirstOrDefault(
             m => string.Equals(m.Name, name));
         if (data != null)
             return JObject.Parse(data.Content);
         else return null;
     }
 }
コード例 #8
0
 public void CallAddProductPage()
 {
     var dbcontext = new WarehouseContext();
     var tab = WindowMgr.CreateTabPage("添加产品信息", "添加产品信息", false);
     var form = CallAddProductControl(null, dbcontext, (u) =>
     {
         WindowMgr.SendNotification("添加产品信息成功",NotificationLevel.Information);
         WindowMgr.CloseTabPage(tab);
         dbcontext.Dispose();
     });
     tab.Content = form;
 }
コード例 #9
0
        public Dashboard()
        {
            InitializeComponent();
            EnvironmentInitializer.CheckAndInitializeSQLiteDB();
            SampleData.AddSampleData();

            using (var dbcontext = new WarehouseContext())
            {
                var query = dbcontext.Database.SqlQuery<User>("select * from Users where Name like @p0","%二%");
                var list = query.ToList();
            }
        }
コード例 #10
0
 static void Initialize()
 {
     using (var dbcontext = new WarehouseContext())
     {
         var product = new Product
         {
             Name = "水果机7S",
             ScanCode = "111",
             Memo = "我们要做地球人都买得起的水果机"
         };
     }
 }
コード例 #11
0
        public Product CallAddProductPopup(string productScanCode, string notificationMsg,WarehouseContext dbcontext)
        {
            var window = new NotifyWindow();
            window.Width = 400;
            window.Height = 600;
            window.Title = "录入产品信息";

            Product newp = null;
            window.MyContent = CallAddProductControl(productScanCode, dbcontext, (p) =>
            {
                window.Close();
                newp = p;
            });

            if (!string.IsNullOrEmpty(notificationMsg))
                window.ShowNotificationMessage(notificationMsg);

            // block until dialog close
            window.ShowDialog();
            return newp;
        }
コード例 #12
0
 public static void SaveMetadata(string name, JObject jo)
 {
     using (var dbcontext = new WarehouseContext())
     {
         var data = dbcontext.Metadatas.FirstOrDefault(
             m => string.Equals(m.Name, name));
         if (data != null)
         {
             data.Content = jo.ToString();
             dbcontext.SaveChanges();
         }
         else
         {
             var newmeta = new Warehouse.DataModel.Entities.Metadata
             {
                 Name = name,
                 ContentType = "text/json",
                 Content = jo.ToString()
             };
             dbcontext.Metadatas.Add(newmeta);
             dbcontext.SaveChanges();
         }
     }
 }
コード例 #13
0
 public GoodsList(WarehouseContext dbcontext)
     : this()
 {
     this.DBContext = dbcontext;
 }
コード例 #14
0
 void ResetPassword()
 {
     using (var dbcontext = new WarehouseContext())
     {
         var updateuser = dbcontext.Users.Find(UpdateUser.UserId);
         if (updateuser != null)
         {
             updateuser.Password = pwdbox1.Password;
         }
         dbcontext.SaveChanges();
     }
 }
コード例 #15
0
        private void query_click(object sender, RoutedEventArgs e)
        {
            var filter = searchctl.BuildQueryString();
            if (string.IsNullOrEmpty(filter))
                return;

            using (var dbcontext = new WarehouseContext())
            {
                var querystr = "select * from Goods where " + filter;
                var data = dbcontext.Database.SqlQuery<Goods>(querystr);
                goodsgrid.ItemsSource = null;
                goodsgrid.ItemsSource = data.ToList();
            }
        }
コード例 #16
0
        public Control CallUpdateUserControl(User user, Action<User> updateCallback=null)
        {
            var formControl = FormControlHelper.CreateFormControl();
            // remove password
            formControl.DetermineFieldCreationCallback = (cx, s) =>
            {
                switch (cx.PropertyInfo.Name)
                {
                    case "Username":
                        return true;
                    default:
                        return s;
                }
            };

            formControl.CreateControlCallback = (cx, c) =>
            {
                if (cx.ControlType == ControlType.Editable)
                {
                    if (cx.PropertyInfo.Name == "Password")
                    {
                        return CreateResetPwdButton(user);
                    }
                    else if (cx.PropertyInfo.Name == "Username")
                    {
                        c.IsEnabled = false;
                    }
                }
                return c;
            };

            formControl.SubmitCallback = (d) =>
            {
                using (var dbcontext = new WarehouseContext())
                {
                    try
                    {
                        var selectuser = d as User;
                        var updateuser = dbcontext.Users.Find(selectuser.UserId);
                        updateuser.Name = selectuser.Name;
                        updateuser.PhoneNumber = selectuser.PhoneNumber;
                        updateuser.Memo = selectuser.Memo;
                        updateuser.IdentificationNumber = selectuser.IdentificationNumber;
                        updateuser.PermissionGroup = selectuser.PermissionGroup;
                        updateuser.Department = selectuser.Department;
                        dbcontext.SaveChanges();
                        WindowMgr.SendNotification("更新用户成功", NotificationLevel.Information);
                        if (updateCallback != null)
                            updateCallback(selectuser);
                    }
                    catch (Exception ex)
                    {
                        // TODO
                        WindowMgr.SendNotification("更新用户失败",NotificationLevel.Error);
                    }
                }
            };

            formControl.RenderForm(user, false);
            formControl.ConfirmButton.Content = "保存设置";

            return formControl;
        }
コード例 #17
0
 public ManageTags(WarehouseContext dbcontext)
     : this()
 {
     DBContext = dbcontext;
 }
コード例 #18
0
        internal FrameworkElement RenderSelectUserControl(FormItemContext context, WarehouseContext dbcontext,
			User selecteduser = null)
        {
            var options = (from u in dbcontext.Users
                select new NameValuePair
                {
                    Name = u.Name,
                    Description = u.IdentificationNumber,
                    Value = u
                }).ToList();
            var ctl = new ComboBoxSink().CreateControlForLookup(context, options);

            if (selecteduser != null)
            {
                var selectedop = options.FirstOrDefault(o => ((User) o.Value).UserId == selecteduser.UserId);
                ((ComboBox) ctl).SelectedValue = selectedop.Value;
            }
            return ctl;
        }
コード例 #19
0
 public WarehouseMap(WarehouseContext dbcontext)
     : this()
 {
     _dbcontext = dbcontext;
 }
コード例 #20
0
        public static TabItem CreateTabPageWithDBContext(string name, object title, bool isUnique, out WarehouseContext dbContext, FrameworkElement content = null)
        {
            var tab = CreateTabPage(name, title, isUnique, content);
            if (tab == null)
            {
                dbContext = null;
                return tab;
            }

            dbContext=new WarehouseContext();
            tab.Tag = dbContext;
            return tab;
        }