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