void bgw_DoWork(object sender, DoWorkEventArgs e) { List <SortInfo> lstSortInfo = e.Argument as List <SortInfo>; DYDAB01Service dyDab01Service = new DYDAB01Service(); DataTable dt = dyDab01Service.GetDataTable(data.ID); List <DYDAB01Row> lstDyDab01 = new List <DYDAB01Row>(); foreach (DataRow dr in dt.Rows) { DYDAB01Row dyDab01 = DYDAB01Row.GetModel(dr); lstDyDab01.Add(dyDab01); } e.Result = GetLstDYDAB01Row(lstSortInfo, lstDyDab01); }
/// <summary> /// 填充数据,刚开始数据不全时调用 /// </summary> private void FillData() { DYDAB01Service dyDab01Service = new DYDAB01Service(); DataTable dt = dyDab01Service.GetDataTable(null); Random rd = new Random(); //遍历行 foreach (DataRow dr in dt.Rows) { string filedName; //遍历排序类型 foreach (SortType item in Enum.GetValues(typeof(SortType))) { int curIndex; Array array; filedName = item.ToString(); switch (item) { case SortType.YQCLX: array = Enum.GetValues(typeof(EnumYQCLX)); curIndex = rd.Next(array.Length); EnumYQCLX yqclx = (EnumYQCLX)curIndex; dr[filedName] = EnumDictionary <EnumYQCLX> .Instance.GetDescription(yqclx); break; case SortType.QDLX: array = Enum.GetValues(typeof(EnumQDLX)); curIndex = rd.Next(array.Length); EnumQDLX qdlx = (EnumQDLX)curIndex; dr[filedName] = EnumDictionary <EnumQDLX> .Instance.GetDescription(qdlx); break; case SortType.QBLX: array = Enum.GetValues(typeof(EnumQBLX)); curIndex = rd.Next(array.Length); EnumQBLX qblx = (EnumQBLX)curIndex; dr[filedName] = EnumDictionary <EnumQBLX> .Instance.GetDescription(qblx); break; case SortType.KFFS: array = Enum.GetValues(typeof(EnumKFFS)); curIndex = rd.Next(array.Length); EnumKFFS kffs = (EnumKFFS)curIndex; dr[filedName] = EnumDictionary <EnumKFFS> .Instance.GetDescription(kffs); break; case SortType.CLLB: array = Enum.GetValues(typeof(EnumCLLB)); curIndex = rd.Next(array.Length); EnumCLLB cllb = (EnumCLLB)curIndex; dr[filedName] = EnumDictionary <EnumCLLB> .Instance.GetDescription(cllb); break; case SortType.KFZT: array = Enum.GetValues(typeof(EnumKFZT)); curIndex = rd.Next(array.Length); EnumKFZT kfzt = (EnumKFZT)curIndex; dr[filedName] = EnumDictionary <EnumKFZT> .Instance.GetDescription(kfzt); break; default: break; } } } dyDab01Service.DBAccess.UpdateDateTable(dt, "select * from DYDAB01"); }