protected void Button1_Click(object sender, EventArgs e)
{
var item = new Code.ProductData()
{
InterFaceUser = "******", ProductName = "product2", BarCode = "1212122", UserId = 1, Number = 10
};
Code.ProductDataManage.Instance.Add(item);
}
protected void Button2_Click(object sender, EventArgs e)
{
var data = new Code.ProductData();
data.Id = 1;
string remark = System.IO.File.ReadAllText(Server.MapPath("code.txt"));
data.Change(b => b.Remark, remark);
Code.ProductDataManage.Instance.Update(data);
}
protected void Button1_Click(object sender, EventArgs e)
{
var item = new Code.ProductData()
{
InterFaceUser = "******", ProductName = "product2" + DateTime.Now.Second, BarCode = "1212122", UserId = 1, Number = 10
};
item.Object2 = DateTime.Now;
Code.ProductDataManage.Instance.Add(item, false);
}
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);//按主键更新,主键值是必须的
}
protected void Page_Load(object sender, EventArgs e)
{
var name = Request["name"];
var manage = Code.ProductDataManage.Instance;
Code.ProductData data = null;
var time = DateTime.Now;
var query = manage.GetLambdaQuery();
query.Where(b => b.Number > time.Second);
//var result = query.SelectV(b => new { b.TransType, b.UserId }).ToList();
var result = query.ToList();
Response.Write(query.PrintQuery());
//Code.TestAll.TestUpdate();
//return;
//Update.TestModified();
}
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); //按主键更新,主键值是必须的
}
protected void Button1_Click(object sender, EventArgs e)
{
//ProductData 限定了 BarCode不能为空
//这里设为空,提交时会抛出异常
var item = new Code.ProductData() { InterFaceUser = "******", ProductName = "product2", BarCode = "" };
var msg = item.CheckData();
if (!string.IsNullOrEmpty(msg))//手动判断对象数据是否合法
{
Response.Write(msg);
}
try
{
Code.ProductDataManage.Instance.Add(item);
}
catch(Exception ero)//捕获异常
{
Response.Write(ero.Message);
}
}
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);
//按匿名对象
Code.ProductDataManage.Instance.Update(b => b.Id == 4, new { ProductName = "product1" });
//按对象差异更新
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"); //通过表达式赋值
p.Cumulation(b => b.ProductName, "1"); //表示按字段累加
Code.ProductDataManage.Instance.Update(b => b.Id == 4, p); //指定查询更新
//当对象是查询创建则能自动识别
p = Code.ProductDataManage.Instance.QueryItem(b => b.Id > 0);
p.UserId += 1; //只会更新UserId
p.ProductName = "2342342";
Code.ProductDataManage.Instance.Update(p); //按主键更新,主键值是必须的
//使用完整查询关联更新
var query = Code.OrderManage.Instance.GetLambdaQuery();
query.Join <Code.ProductData>((a, b) => a.Id == b.Id && b.Number > 10);
c = new CRL.ParameCollection();
c["UserId"] = "$UserId"; //order.userid=product.userid
c["Remark"] = "2222"; //order.remark=2222
Code.OrderManage.Instance.Update(query, c);
//等效语句为 update order set userid=ProductData.userid,remark='2222' from ProductData where order.id=ProductData.id and ProductData.number<10
}
protected void Button1_Click(object sender, EventArgs e)
{
//ProductData 限定了 BarCode不能为空
//这里设为空,提交时会抛出异常
var item = new Code.ProductData()
{
InterFaceUser = "******", ProductName = "product2", BarCode = ""
};
var msg = item.CheckData();
if (!string.IsNullOrEmpty(msg))//手动判断对象数据是否合法
{
Response.Write(msg);
}
try
{
Code.ProductDataManage.Instance.Add(item);
}
catch (Exception ero)//捕获异常
{
Response.Write(ero.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var item = new Code.ProductData() { InterFaceUser = "******", ProductName = "product2", BarCode = "1212122",UserId=1,Number=10 };
Code.ProductDataManage.Instance.Add(item);
}
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
}
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);//按主键更新,主键值是必须的
//关联更新
var query = Code.OrderManage.Instance.GetLambdaQuery();
query.Join <ProductData>((a, b) => a.Id == b.Id && b.Number > 10);
c = new CRL.ParameCollection();
c["UserId"] = "$UserId"; //order.userid=product.userid
c["Remark"] = "2222"; //order.remark=2222
Code.OrderManage.Instance.Update(query, c);
#endregion
#region 除
//关联删除
var query2 = Code.ProductDataManage.Instance.GetLambdaQuery();
query2.Where(b => b.Id == 10);
query2.Join <Code.Member>((a, b) => a.SupplierId == "10" && b.Name == "123");
Code.ProductDataManage.Instance.Delete(query2);
Code.ProductDataManage.Instance.Delete(999);
#endregion
#region 缓存更新
//按编号为1的数据
var item = Code.ProductDataManage.Instance.QueryItemFromCache(b => b.Id > 0);
item.CheckNull("item");
var guid = Guid.NewGuid().ToString().Substring(0, 8);
item.Change(b => b.SupplierName, guid);
Code.ProductDataManage.Instance.Update(item);
item = Code.ProductDataManage.Instance.QueryItemFromCache(item.Id);
var item2 = Code.ProductDataManage.Instance.QueryItem(item.Id);
var a2 = item.SupplierName == item2.SupplierName && item.SupplierName == guid;
if (!a2)
{
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
}
