/// <summary>
/// 得到查询的客户列表
/// </summary>
/// <param name="basicRow"></param>
/// <returns></returns>
internal DataTable GetMockCustomers(string customerID, string Name, string type, string phone)
{
StringBuilder sb = new StringBuilder();
//拼接过滤串
if (!string.IsNullOrWhiteSpace(customerID))
{
sb.AppendFormat("CustomerID ={0}", customerID);
sb.AppendFormat(" And ");
}
if (!string.IsNullOrWhiteSpace(Name))
{
sb.AppendFormat("Name like '{0}'", Name);
sb.AppendFormat(" And ");
}
if (!string.IsNullOrWhiteSpace(phone))
{
sb.AppendFormat("Phone like '{0}'", phone);
sb.AppendFormat(" And ");
}
if (!string.IsNullOrWhiteSpace(type))
{
sb.AppendFormat("Type = '{0}'", type);
sb.AppendFormat(" And ");
}
//删除 And
if (sb.Length > 0)
{
sb.Remove(sb.Length - 5, 5);
}
//设置过滤串
//mockCustomers.DefaultView.RowFilter = sb.ToString();
//return mockCustomers.DefaultView;
var drs = mockCustomers.Select(sb.ToString(), "CustomerID desc");
var dt = new CustomerDataSet.BasicInfoDataTable();
foreach (var dr in drs)
{
dt.ImportRow(dr);
}
return(dt);
}
