Exemple #1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     var count = Code.MemberManage.Instance.Count(b => b.Id > 0);
     if (count == 0)
     {
         var m = new Code.Member() { Name = "hubro" };
         int n = Code.MemberManage.Instance.Add(m);
         var c = new CRL.ParameCollection();
         c["UserId"] = n;
         Code.ProductDataManage.Instance.Update(b => b.Id > 0, c);
     }
 }
Exemple #2
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            //创建分页存储过程sp_page.sql
            int page = 1;
            int pageSize = 15;
            int count;
            CRL.ParameCollection c = new CRL.ParameCollection();
            string where = " InterFaceUser='******'";//按标准 SQL 进行拼接
            c.SetQueryCondition(where);
            c.SetQueryPageIndex((int)page);
            c.SetQueryPageSize(pageSize);

            var list = Code.ProductDataManage.Instance.QueryListByPage(c, out count);
        }
Exemple #3
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     //要更新属性集合
     CRL.ParameCollection c = new CRL.ParameCollection();
     c["ProductName"] = "product1";
     Code.ProductDataManage.Instance.Update(b => b.Id == 4, c);
     //按对象差异更新
     var p = new Code.ProductData() { Id = 4 };
     //手动修改值时,指定修改属性以在Update时识别,分以下几种形式
     p.Change(b => b.BarCode);//表示值被更改了
     p.Change(b => b.BarCode,"123");//通过参数赋值
     p.Change(b => b.BarCode == "123");//通过表达式赋值
     Code.ProductDataManage.Instance.Update(b => b.Id == 4, p);//指定查询更新
     Code.ProductDataManage.Instance.Update(p);//按主键更新,主键值是必须的
 }
Exemple #4
0
 public ActionResult Detail(CRL.Package.RoleAuthorize.Employee u)
 {
     CRL.ParameCollection c = new CRL.ParameCollection();
     c["Name"] = u.Name;
     //c["AccountNo"] = u.Name;
     c["Mobile"] = u.Mobile;
     c["qq"] = u.QQ;
     c["Email"] = u.Email;
     c["Birthday"] = u.Birthday;
     c["Sex"] = u.Sex;
     c["IdentityNo"] = u.IdentityNo;
     c["Address"] = u.Address;
     c["RegisterIp"] = u.RegisterIp;
     c["Department"] = u.Department;
     CRL.Package.RoleAuthorize.EmployeeBusiness.Instance.Update(b => b.Id == u.Id, c);
     CRL.Package.RoleAuthorize.AccessControlBusiness.Instance.Delete(b => b.Role == u.Id && b.RoleType == CRL.Package.RoleAuthorize.RoleType.用户);
     //return Redirect("/Employee/");
     return AutoBackResult("操作成功", Request.UrlReferrer.ToString());
 }
Exemple #5
0
        public static void TestUpdate()
        {
            var instance = Code.ProductDataManage.Instance;
            #region 更新
            //要更新属性集合
            CRL.ParameCollection c = new CRL.ParameCollection();
            c["ProductName"] = "product1";
            Code.ProductDataManage.Instance.Update(b => b.Id == 4, c);
            //按对象差异更新
            var p = new Code.ProductData() { Id = 4 };
            //手动修改值时,指定修改属性以在Update时识别,分以下几种形式
            p.Change(b => b.BarCode);//表示值被更改了
            p.Change(b => b.BarCode, "123");//通过参数赋值
            p.Change(b => b.BarCode == "123");//通过表达式赋值
            Code.ProductDataManage.Instance.Update(b => b.Id == 4, p);//指定查询更新

            p = Code.ProductDataManage.Instance.QueryItem(b => b.Id > 0);
            p.UserId += 1;
            Code.ProductDataManage.Instance.Update(p);//按主键更新,主键值是必须的
            #endregion

            #region 缓存更新
            var item = Code.ProductDataManage.Instance.QueryItemFromCache(1);
            var guid = Guid.NewGuid().ToString().Substring(0,8);
            item.Change(b => b.SupplierName, guid);
            Code.ProductDataManage.Instance.Update(item);
            item = Code.ProductDataManage.Instance.QueryItemFromCache(1);
            var item2 = Code.ProductDataManage.Instance.QueryItem(1);
            var a = item.SupplierName == item2.SupplierName && item.SupplierName == guid;
            if (!a)
            {
                throw new Exception("更新缓存失败");
            }
            #endregion

            #region 事务
            string error;
            item = Code.ProductDataManage.Instance.QueryItem(1);

            var result = Code.ProductDataManage.Instance.PackageTrans((out string ex) =>
            {
                ex = "";
                var product = new ProductData();
                product.BarCode = "sdfsdf";
                product.Number = 10;
                ProductDataManage.Instance.Add(product);
                return false;
            }, out error);
            if (result)
            {
                throw new Exception("事务未回滚");
            }
            #endregion
        }
Exemple #6
0
 public ActionResult Update(CRL.Package.RoleAuthorize.Employee u)
 {
     CRL.ParameCollection c = new CRL.ParameCollection();
     if (!string.IsNullOrEmpty(u.PassWord))
     {
         c["PassWord"] = CRL.Package.RoleAuthorize.EmployeeBusiness.Instance.EncryptPass(u.PassWord);
     }
     c["Locked"] = u.Locked;
     c["Role"] = u.Role;
     c["Department"] = u.Department;
     CRL.Package.RoleAuthorize.EmployeeBusiness.Instance.Update(b => b.Id == u.Id, c);
     return Redirect(Request.UrlReferrer.ToString());
     return AutoBackResult("操作成功", Request.UrlReferrer.ToString());
 }