/// <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); }