public static T_Client ToModel(this T_ClientModel node)
{
return(new T_Client()
{
Id = node.Id,
//LoginId = node.LoginId,
//Password = Encrypt.Encrypto(node.Password),
Name = node.Name,
Company = node.Company,
// RegDate = node.RegDate,
Blk = node.Blk,
BuildingName = node.BuildingName,
Nric = node.Nric,
Email = node.Email,
Fax = node.Fax,
Race = node.Race,
Mobile = node.Mobile,
Phone = node.Phone,
PostalCode = node.PostalCode,
StreetName = node.StreetName,
Unit = node.Unit,
Enable = node.Enable,
Sectors = node.Sectors,
});
}
public static T_ClientModel DTO(this T_Client node)
{
if (node == null)
{
return(null);
}
var model = new T_ClientModel()
{
Id = node.Id,
//LoginId = node.LoginId,
//Password = Encrypt.Decrypto(node.Password),
Name = node.Name,
Company = node.Company,
RegDate = node.RegDate,
Blk = node.Blk,
BuildingName = node.BuildingName,
Nric = node.Nric,
Email = node.Email,
Fax = node.Fax,
Race = node.Race,
Mobile = node.Mobile,
Phone = node.Phone,
Sectors = node.Sectors,
PostalCode = node.PostalCode,
StreetName = node.StreetName,
Unit = node.Unit,
Enable = node.Enable,
};
return(model);
}
/// <summary>
/// 复杂查询
/// </summary>
/// <param name="model">查询对象</param>
/// <param name="Orders">排序字典key:排序的字段,value:asc升序/desc降序</param>
/// <param name="PageSize">每页行数，默认15</param>
/// <param name="PageIndex">当前页码，默认100</param>
/// <returns></returns>
public DataGrid <T_ClientModel> Search(T_ClientModel model, Dictionary <string, string> Orders = null, int PageSize = 15, int PageIndex = 100)
{
Expression <Func <T_Client, bool> > where = null; //最终查询条件
var lambdaList = new List <Expression <Func <T_Client, bool> > >(); //lambda查询条件集合
int total = 0; //总行数
if (model.Name != null)
{
lambdaList.Add(c => c.Company.Contains(model.Name) || c.Name.Contains(model.Name) || c.Phone.Contains(model.Name) || c.Mobile.Contains(model.Name) || c.Email.Contains(model.Name) || c.Fax.Contains(model.Name) || c.StreetName.Contains(model.Name) || c.BuildingName.Contains(model.Name) || c.Blk.Contains(model.Name) || c.Unit.Contains(model.Name));
}
//将集合表达式树转换成Expression表达式树
MyVisitor <T_Client, T_Client> visitor = new MyVisitor <T_Client, T_Client>();
where = visitor.Modify(lambdaList);
var list = dal.Search(out total, where, Orders, PageSize, PageIndex).DTOList().ToList();
var result = new DataGrid <T_ClientModel>()
{
rows = list,
total = total
};
return(result);
}
public int DeleteData(T_ClientModel model)
{
return(this.Delete(model.Id));
}
public int EditData(T_ClientModel model)
{
return(this.Edit(model.ToModel()));
}
public int AddData(T_ClientModel model)
{
return(this.Add(model.ToModel()));
}
