static void Main(string[] args) { UserController contoller = new UserController(); BusinessController contollerCom = new BusinessController(); //insert string _guid0 = Guid.NewGuid().ToString(); var myusers = new users(){ userid = _guid0,username = "******",passwordword = "1",name = "0a",sex = "男" }; Console.WriteLine("after insert:" + _guid0); contollerCom.Insert<users>(myusers); Console.WriteLine(contoller.print(contollerCom.Get<users>("userid", _guid0))); var myuserLists = new List<users>{ new users(){userid = Guid.NewGuid().ToString(),username = "******",passwordword = "1",name = "1a"}, new users(){userid = Guid.NewGuid().ToString(),username = "******",passwordword = "1",name = "2a"} }; Console.WriteLine("after insert many:"); ; Console.WriteLine(contollerCom.InsertList<users>(myuserLists)); //update List<users> mylist = contollerCom.Get<users>(u => u.username == "0"); var curUser = mylist.First<users>(); Console.WriteLine("before update:" + curUser.userid); Console.WriteLine(contoller.print(curUser)); curUser.username = "******"; contollerCom.Update<users>(curUser, "userid"); Console.WriteLine("after update:" + curUser.userid); Console.WriteLine(contoller.print(contollerCom.Get<users>(u => u.username == "0axiugai"))); //manual update Console.WriteLine("manual update:" + curUser.userid); contoller.Modify(curUser.userid); Console.WriteLine(contoller.print(contollerCom.Get<users>(u => u.userid == curUser.userid))); //delete Console.WriteLine("delete all:" + _guid0); contollerCom.Delete<users>("userid", _guid0); Console.WriteLine(contoller.print(contollerCom.Get<users>("select * from users "))); Console.WriteLine("delete u.sex==男:"); contollerCom.Delete<users>(u=>u.sex=="男"); Console.WriteLine(contoller.print(contollerCom.Get<users>("select * from users "))); //select Console.WriteLine("select all:"); Console.WriteLine(contoller.print()); Console.WriteLine("select * from users where username='******'"); Console.WriteLine(contoller.print( contollerCom.Get<users>("select * from users where username='******'") )); Console.WriteLine("u=>u.username==1"); Console.WriteLine(contoller.print( contollerCom.Get<users>(u => u.username == "1a") )); Console.ReadKey(); }
public void Insert2() { //create an instance belong to users var myusers = new users() { userid = Guid.NewGuid().ToString(), username = "******", passwordword = "123", name = "张伟2", sex = "男" }; BusinessController contoller = new BusinessController(); contoller.Insert<users>(myusers); }
public void Insert() { //create an instance belong to users var myusers = new users() { userid=Guid.NewGuid().ToString(), username="******", passwordword="123", name="张伟2", sex="男" }; //PermissionDBEntities is entity factory ,object-myusers can be created by PermissionDBEntities with dynmaic using (var ctx = new PermissionDBEntities()) { ctx.users.AddObject(myusers); ctx.SaveChanges(); } }
public string print(users u) { return "id:" + u.userid + "\tname:" + u.name + "\tusername:" + u.username; }
private void Fixupusers(users previousValue) { if (previousValue != null && previousValue.userrole.Contains(this)) { previousValue.userrole.Remove(this); } if (users != null) { if (!users.userrole.Contains(this)) { users.userrole.Add(this); } if (userid != users.userid) { userid = users.userid; } } else if (!_settingFK) { userid = null; } }