public MockDataHelper()
{
//生成模拟数据
mockCustomers = new CustomerDataSet.BasicInfoDataTable();
CustomerDataSet.BasicInfoRow dr;
string[] addrs = new string[] { "浙江", "浙江杭州", "浙江宁波", "浙江台州", "浙江温州", "浙江嘉兴", "浙江湖州" };
string[] emails = new string[] { "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**" };
Random rand = new Random();
for (int i = 1; i <= 1000; i++)
{
dr = mockCustomers.NewBasicInfoRow();
dr.Addr = addrs[rand.Next(0, addrs.Length - 1)];
dr.CustomerID = i;
dr.Email = emails[rand.Next(0, emails.Length - 1)];
dr.Level = (i % 3 + 1).ToString();
dr.Name = "Name " + dr.CustomerID;
dr.OfficeTel = "0571-2882" + rand.Next(0, 1000).ToString().PadLeft(4, '0');
dr.Phone = "1666666" + rand.Next(0, 1000).ToString().PadLeft(3, '0') + '6';
dr.Type = (i % 3 + 1).ToString();
dr.TradeDate = DateTime.Now.Subtract(new TimeSpan(i % 100, 0, 0, 0));
dr.TradeMoney = (i % 100 + 1) * rand.Next(100, 1000);
mockCustomers.Rows.Add(dr);
}
mockCustomers.AcceptChanges();
}
/// <summary>
/// 初始化界面
/// </summary>
void InitForm()
{
//如果是新做状态初始化一空行
if (this.formState == FormState.Add)
{
CustomerDataSet.BasicInfoDataTable dt = new CustomerDataSet.BasicInfoDataTable();
this.basicRow = dt.NewBasicInfoRow();
this.basicRow.TradeDate = DateTime.Today;
}
//初始化数据绑定
this.InitDataBindings();
//绑定界面数据&设置标题
this.SetUIState();
}
/// <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);
}
