13,347
社区成员
发帖
与我相关
我的任务
分享
--用户类 表脚本创建 for SQL SERVER
Create Table TB_User
(
ID int identity(1,1) primary key,
Name varchar(50) not null,
Birthday datetime
);
/*
本类由PWMIS 实体类生成工具(Ver 1.1)自动生成
http://www.pwmis.com/sqlmap
使用前请先在项目工程中引用 PWMIS.Core.dll
2010-2-26 17:45:06
*/
using System;
using PWMIS.DataMap.Entity;
namespace MyNameSpace
{
[Serializable()]
public partial class User : Entity
{
public User()
{
TableName = "tb_user";
//IdentityName = "标识字段名";
IdentityName="ID";
//PrimaryKeys.Add("主键字段名");
PrimaryKeys.Add("ID");
AddProperty("ID", default(System.Int32));
AddProperty("Name", default(System.String));
AddProperty("Birthday", default(System.DateTime));
}
public System.Int32 ID
{
get{return (System.Int32)getProperty("ID");}
set{setProperty("ID",value );}
}
public System.String Name
{
get{return (System.String)getProperty("Name");}
set{setProperty("Name",value ,50);}
}
public System.DateTime Birthday
{
get{return (System.DateTime)getProperty("Birthday");}
set{setProperty("Birthday",value );}
}
}
}
Console.WriteLine("rn实体对象持久化测试:");
User zhang_san = new User();
//zhang_san.Uid = 5;
EntityQuery<User> query = new EntityQuery<User>(zhang_san,true );
zhang_san.Name = "张三1";
query.Save();// 新增
Console.WriteLine("新增实体对象OK");
zhang_san.Birthday = new DateTime (1977,3,10);
query.Save();// 修改
Console.WriteLine("修改实体对象OK");
this.txtOQL.Text = "";
User u = new User();
OQL q = new OQL(u);
q.Select().Where(q.Condition.IN(u.Uid, new object []{1,3,5}));
this.txtOQL.Text += q.ToString()+"rn------------------rn";
q.Select().Where(q.Condition.IN(u.Name, new object[] { "张三","李四"}));
this.txtOQL.Text += q.ToString() + "rn------------------rn";
q.Select().Where(q.Condition.IN(u.Uid, new object []{1,3,5})).OrderBy (u.Name ,"desc");
OQL q = new OQL(u);
q.TopCount = 10;
q.Select().Where(q.Condition.IN(u.Uid, new object []{1,3,5})).OrderBy (u.Name ,"desc");
PFT_FundReviews p = new PFT_FundReviews();
OQL q = new OQL(p);
p.BankCode = "20";
p.FundCode = "KF001";
p.CityCode = "0210";
//修改语法
q.Update( p.CityCode,p.BankCode ).Where (p.FundCode );
//也可以使用下面的格式
// .Where(q.Condition .AND (p.FundCode ,"=",p.FundCode ));
Console.WriteLine("SQL=" + q.ToString());
// 删除语法
q.Delete().Where(p.FundCode);
Console.WriteLine("SQL=" + q.ToString());
Console.Read();
PFT_FundReviews p = new PFT_FundReviews();
OQL q = new OQL(p); //OQL实例定义
p.BankCode = "20";
p.FundCode = "KF001";
p.CityCode = "0210";
//调用OQL的统计函数
q.Select().Count(p.FundCode, "CountField1").GroupBy (p.BankCode ).OrderBy (p.BankCode,"desc" );
Console.WriteLine("SQL=" + q.ToString());
Console.Read();
PFT_FundReviews p = new PFT_FundReviews();
OQL q = new OQL(p);
p.BankCode = "20";
p.FundCode = "KF001";
p.CityCode = "0210";
OQLCompare cmp = new OQLCompare(p);
OQLCompare cmpResult = (cmp.Comparer(p.CityCode) | cmp.Comparer(p.BankCode))
& ( cmp.Comparer(p.FundCode) | cmp.Comparer(p.BankCode));
q.Select().Where(cmpResult);
Console.WriteLine("SQL=" + q.ToString());
PFT_FundReviews p = new PFT_FundReviews();
OQL q = new OQL(p);
p.BankCode = "20";
p.FundCode = "KF001";
p.CityCode = "0210";
OQLCompare cmp = new OQLCompare(p);
OQLCompare cmpResult = (cmp.Comparer(p.CityCode, OQLCompare.CompareType.Equal, "021")
| cmp.Comparer(p.BankCode, OQLCompare.CompareType.Equal, "008"))
& (cmp.Comparer(p.FundCode, OQLCompare.CompareType.Equal, "KF008")
| cmp.Comparer(p.BankCode, OQLCompare.CompareType.Equal, "008"));
q.Select().Where(cmpResult);
Console.WriteLine("SQL=" + q.ToString());
SQL=SELECT *
FROM PFT_FundReviews
Where ( (CityCode=@CP1 OR BankCode=@CP2) AND (FundCode=@CP3 OR BankCode=@CP4) )
Sop_TodoList todolist = new Sop_TodoList();
return EntityQuery<Sop_TodoList>.QueryList(OQL.From(todolist)
.Select().Where(q.condition.AND(todolist.Lcjl_Username,"=",username)
.AND(todolist.Todo_date,"=",dt)
));