public int UpdateUser()
{
DaoTemplate dao = new DaoTemplate();
T_User user = new T_User {
Nid = 1, Name = "Tommy", Address = "USA"
};
return(dao.UpdateObject <T_User>(user));
}
public int AttachDelete()
{
DaoTemplate dao = new DaoTemplate();
T_User user = new T_User {
Nid = 18, Name = "attach", Address = "BBS"
};
return(dao.DeleteObject_Attach <T_User>(user));
}
//如下面的代码所示，表达式的参数为Employee类型，而调用此方法时并没有传入参数，而是在方法内通过 参数的.Where来使用表达式的
//public ActionResult Index3(Expression<Func<Employee, bool>> predicate)
//{
// var employees = repository.Query().Where(predicate);
// return View("Index", employees);
//}
#endregion
#region Attach
public int AttachAdd()
{
DaoTemplate dao = new DaoTemplate();
T_User user = new T_User {
Name = "attach", Address = "BBS"
};
return(dao.AddObject_Attach <T_User>(user));
}
public int UpdateUsers()
{
DaoTemplate dao = new DaoTemplate();
//Expression是一个表达式，编译应该变成SQL语句
Expression <Func <T_User, T_User> > predicate = user1 => new T_User {
Name = "111"
};
return(dao.UpdateObjects <T_User>("Nid>@0", predicate, new Object[] { 2 }));
}
public ProductListQueryBuilder(ProductListSearchCriteria criteria)
: base(criteria)
{
if (criteria.CategoryId.HasValue)
{
_category = DaoTemplate.FindByID <Category>(criteria.CategoryId);
}
isNewCriteria = criteria.IsNew ? " and p.IsNew = 't' " : " ";
categories = _category == null?CategoryService.AllVisibleCategories() : _category.ThisAndSubcategories();
}
public override bool IsValid(object value)
{
PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(value);
object originalValue = properties.Find(Name, true).GetValue(value);
object o = Activator.CreateInstance(value.GetType());
properties.Find(Name, true).SetValue(o, originalValue);
DaoTemplate daoTemplate = new DaoTemplate();
DetachedCriteria criteria = DetachedCriteria.For(value.GetType()).Add(Restrictions.Eq(Name, originalValue));
IList results = daoTemplate.FindByCriteria(criteria);
return results.Count == 0;
}
public override bool IsValid(object value)
{
PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(value);
object originalValue = properties.Find(Name, true).GetValue(value);
object o = Activator.CreateInstance(value.GetType());
properties.Find(Name, true).SetValue(o, originalValue);
DaoTemplate daoTemplate = new DaoTemplate();
DetachedCriteria criteria = DetachedCriteria.For(value.GetType()).Add(Restrictions.Eq(Name, originalValue));
IList results = daoTemplate.FindByCriteria(criteria);
return(results.Count == 0);
}
public void TestTransation()
{
DaoTemplate dao = new DaoTemplate();
int i = 0;
T_User user1 = new T_User { Nid = 15, Name = "11", Address = "111" };
T_User user2 = new T_User { Nid = 15, Name = "22", Address = "222" };
T_User user3 = new T_User { Nid = 1, Name = "33", Address = "333" };
T_User[] users = new T_User[3];
users[0] = user1;
users[1] = user2;
users[2] = user3;
dao.CallMethod_TranCommit<T_User>(new Func<T_User, int>(dao.AddObject), users);
}
public void TestTransation()
{
DaoTemplate dao = new DaoTemplate();
int i = 0;
T_User user1 = new T_User {
Nid = 15, Name = "11", Address = "111"
};
T_User user2 = new T_User {
Nid = 15, Name = "22", Address = "222"
};
T_User user3 = new T_User {
Nid = 1, Name = "33", Address = "333"
};
T_User[] users = new T_User[3];
users[0] = user1;
users[1] = user2;
users[2] = user3;
dao.CallMethod_TranCommit <T_User>(new Func <T_User, int>(dao.AddObject), users);
}
public int AttachDelete()
{
DaoTemplate dao = new DaoTemplate();
T_User user = new T_User { Nid=18, Name = "attach", Address = "BBS" };
return dao.DeleteObject_Attach<T_User>(user);
}
//执行DAL中的 泛型方法
public int InsertUser(T_User user)
{
DaoTemplate dao = new DaoTemplate();
return dao.CallMethod<T_User>(new Func<T_User, int>(dao.AddObject), user);
}
public ICollection<T_User> GetUsers()
{
DaoTemplate dao = new DaoTemplate();
return dao.GetObjects<T_User>("Nid>@0", new object[] { 2 });
}
public T_User GetUser(Object keyValue)
{
DaoTemplate dao = new DaoTemplate();
return dao.GetObject<T_User>(keyValue);
}
public T_User GetUser(string filter, params object[] args)
{
DaoTemplate dao = new DaoTemplate();
return dao.GetObject<T_User>(filter, args);
}
public int DeleteUsers(Expression<Func<T_User,bool>> expression)
{
DaoTemplate dao = new DaoTemplate();
return dao.DeleteObjects<T_User>(expression);
}
public int DeleteUsers(string filter,params Object[] args)
{
DaoTemplate dao = new DaoTemplate();
return dao.DeleteObjects<T_User>(filter, args);
}
public T_User GetUser(Object keyValue)
{
DaoTemplate dao = new DaoTemplate();
return(dao.GetObject <T_User>(keyValue));
}
public int UpdateUser()
{
DaoTemplate dao = new DaoTemplate();
T_User user =new T_User{ Nid=1, Name="Tommy",Address="USA"};
return dao.UpdateObject<T_User>(user);
}
public ICollection <T_User> GetUsers()
{
DaoTemplate dao = new DaoTemplate();
return(dao.GetObjects <T_User>("Nid>@0", new object[] { 2 }));
}
//执行DAL中的 泛型方法
public int InsertUser(T_User user)
{
DaoTemplate dao = new DaoTemplate();
return(dao.CallMethod <T_User>(new Func <T_User, int>(dao.AddObject), user));
}
public int DeleteUsers(Expression <Func <T_User, bool> > expression)
{
DaoTemplate dao = new DaoTemplate();
return(dao.DeleteObjects <T_User>(expression));
}
public int DeleteUsers(string filter, params Object[] args)
{
DaoTemplate dao = new DaoTemplate();
return(dao.DeleteObjects <T_User>(filter, args));
}
public int UpdateUsers()
{
DaoTemplate dao = new DaoTemplate();
//Expression是一个表达式，编译应该变成SQL语句
Expression<Func<T_User, T_User>> predicate = user1 => new T_User { Name ="111" };
return dao.UpdateObjects<T_User>("Nid>@0", predicate, new Object[] { 2 });
}
public T_User GetUser(string filter, params object[] args)
{
DaoTemplate dao = new DaoTemplate();
return(dao.GetObject <T_User>(filter, args));
}
public int AttachAdd()
{
DaoTemplate dao = new DaoTemplate();
T_User user=new T_User{ Name="attach", Address="BBS"};
return dao.AddObject_Attach<T_User>(user);
}
protected QueryBuilder(SearchCriteria criteria)
{
_searchCriteria = criteria;
DaoTemplate = new DaoTemplate();
}
