ORM框架--petaPoco代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 ORM框架--petaPoco
作者:kunkun0921 / 发布于2015/1/26/ 658

	using System;
	using System.Collections.Generic;
	using System.ComponentModel;
	using System.Data;
	using System.Drawing;
	using System.Linq;
	using System.Text;
	using System.Windows.Forms;
	using System.Data.SqlClient;

	namespace PetaPocoORM
	{
	 public partial class Form1 : Form
	 {
	 public Form1()
	 {
	 InitializeComponent();

	 Account account = new Account()
	 {
	 UId = 4,
	 UserName = "zkk_" + DateTime.Now.ToString("yyyyMMddHHmmss"),
	 Password = "pass_" + DateTime.Now.ToString("yyyyMMddHHmmss")
	 };

	 List<Account> list = new List<Account>() {
	 new Account(){ UId=2, Password="p@ssw0rd", UserName="zkk_2"},
	 new Account(){ UId=3, Password="p@ssw0rd", UserName="zkk_3"},
	 new Account(){ UId=4, Password="p@ssw0rd", UserName="zkk_4"}
	 };

	 SelectDB();
	 //UpdateDB(account);
	 //InsertDB(account);
	 //DeleteDB(account);
	 }

	 DatabaseDB db = new DatabaseDB();
	 int count = 0;

	 void SelectDB()
	 {
	 string sql = "select username,password from accounts ";
	 List<Account> list = new List<Account>();
	 Account entity = new Account();
	 //list = db.Fetch<Account>(sql);

	 /*
	 * 传入SQL语句，进行查询，返回泛型集合
	 * entity = db.First<Account>("select top 1 username,password from accounts ");
	 *
	 * */

	 /*
	 * SQL判断条件，传入参数不能加where
	 * bool res = db.Exists<Account>(" username='zkk_2014'");
	 *
	 * */
	

	 }

	 void DeleteDB(Account account)
	 {
	 /*
	 * 传入需要删除的对象(其实只要主键值有值即可)，返回受影响的行数
	 * count = db.Delete(account);
	 *
	 * */

	
	 /*
	 * 传入表名称、主键名称、删除对象、主键值，返回受影响的行数
	 * count = db.Delete("accounts", "uid", account, "2");
	 *
	 * */

	 /*
	 * 传入需要删除的对象(其实只要主键值有值即可)，返回受影响的行数
	 * count = db.Delete<Account>(account);
	 *
	 * */

	

	 }

	 void InsertDB(Account account)
	 {
	 /*
	 * 传入对象，返回主键值
	 * object obj = db.Insert(account);
	 *
	 * */

	 /*
	 *
	 * 传入表名称、主键名称、插入对象，返回主键值
	 * object obj = db.Insert("Accounts", "uid", account);
	 *
	 * */

	 /*
	 * 传入表名称、主键名称、 主键是否自动增长、插入对象，返回主键值
	 * object obj = db.Insert("accounts", "uid", true, account);
	 *
	 * */

	 /*
	 * 传入SQL语句，执行增加，未包含参数，返回受影响的行数
	 * string sql = "insert into accounts(username,password) values('zkk_2014','pass_2014')";
	 * count = db.Execute(sql);
	 *
	 * 传入SQL语句，执行增加，包含参数，返回受影响的行数
	 * sql = "insert into accounts(username,password) values(@user,@pass)";
	 * count = db.Execute(sql, new { user = "sample_name", pass = "sample_pass" });
	 *
	 *
	 * */

	

	 }

	 void UpdateDB(Account account)
	 {

	 /*
	 * 传入修改的对象
	 * count = db.Update(account);
	 *
	 * */

	 /*
	 * 修改主键值为4的记录
	 * count = db.Update(account, 4);
	 *
	 * */

	 /*
	 * 修改主键值为3的记录，修改字段为UserName,字段名区分大小写
	 * count = db.Update(account, 3, new string[] { "USERNAME" });
	 *
	 * */

	
	 /*
	 * 修改表名为"Accounts",主键名称为uid，修改值对象为account,主键值为的记录
	 * count = db.Update("Accounts", "uid", account, 1);
	 *
	 * */

	 /*
	 * 执行sql语句进行修改,sql中未含参数
	 * string sql = "update accounts set [password]='pAssw0rd' where [uid]=4 ";
	 * count = db.Execute(sql);
	 *
	 * 执行sql语句进行修改,sql中包含参数
	 * sql = "update accounts set [password]=@pass where [uid]=@uid ";
	 * count = db.Execute(sql, new { pass = "zkk_pass", uid = 4 });
	 *
	 *
	 * */

	 }
	 }
	}
试试其它关键字
　petaPoco　　ORM　
同语言下
可能有用的
kunkun0921贡献的其它代码(40)