mysql导入数据显示进度条_导入数据思路+进度条
///
///基礎數據導入///
private voidLoadBasicData()
{this.NowCount = 0;this.AllCount = 0;this.hasResult = false;try{
DelegateShowProssBar mi= newDelegateShowProssBar(ShowProcessBar);this.BeginInvoke(mi, new object[] { "導入基礎數據", "導入數據", true});
Thread.Sleep(1000);//等待進度條彈出
object[] objPar = new object[] { 0, "導入數據...\r"};objectobjReturn;this.Invoke(this.myIncrease, objPar);this.AllCount =dt.Rows.Count;this.wpf.SetMaxValue(this.AllCount);
objPar= new object[] { this.NowCount, "開始導入數據...\r"};this.Invoke(this.myIncrease, objPar);foreach (DataRow dr indt.Rows)
{this.NowCount++;//校區
XX0103BLL bll_xx0103 = newXX0103BLL();
XX0103Model.Base model_xx0103= newXX0103Model.Base();if (bll_xx0103.Exists("", dr["校區編號"].ToString(), dr["校區名稱"].ToString()) == false)
{//沒有校區添加校區
model_xx0103.XQBH = dr["校區編號"].ToString();
model_xx0103.XQMC= dr["校區名稱"].ToString();
bll_xx0103.Add(model_xx0103);
}//部門
XX0301BLL bll_xx0301 = newXX0301BLL();
XX0301Model.Base model_xx0301= newXX0301Model.Base();if (bll_xx0301.Exists("", dr["校區編號"].ToString(), dr["部門編號"].ToString(), dr["部門名稱"].ToString()) == false)
{
model_xx0301.BMBH= dr["部門編號"].ToString();
model_xx0301.BMMC= dr["部門名稱"].ToString();
model_xx0301.XQBH= dr["校區編號"].ToString();
bll_xx0301.Add(model_xx0301);
}//專業
JX01BLL bll_jx01 = newJX01BLL();
JX01Model.Base model_jx01= newJX01Model.Base();if (bll_jx01.Exists("", dr["專業編號"].ToString()) == false)
{
model_jx01.ZYBH= dr["專業編號"].ToString();
model_jx01.ZYMC= dr["專業名稱"].ToString();
model_jx01.BMBH= dr["部門編號"].ToString();
model_jx01.CC= dr["層次"].ToString();
bll_jx01.Add(model_jx01);
}//用戶
CustomerBLL bll_customer = newCustomerBLL();
CustomerModel.Base model_customer= newCustomerModel.Base();if (bll_customer.Exists("", dr["考生號"].ToString()) == false)
{
model_customer.OutID= dr["考生號"].ToString();
model_customer.CardNo= int.Parse(dr["卡號"].ToString());
model_customer.Name= dr["姓名"].ToString();
model_customer.CardSN= int.Parse(dr["換卡序號"].ToString());
model_customer.Sex= dr["性別"].ToString();
model_customer.CustomerTypeID= int.Parse(dr["客戶類別"].ToString());
model_customer.NJ= dr["年級"].ToString();
model_customer.ZYBH= dr["專業編號"].ToString();
model_customer.CardStatusID= int.Parse(dr["卡狀態碼"].ToString());
model_customer.IDCardNo= dr["身份證號"].ToString();
model_customer.CardTypeID= int.Parse(dr["卡類別碼"].ToString());
model_customer.AddTime=DateTime.Now;
bll_customer.Add(model_customer);
}if (!this.hasResult)
{
objPar= new object[] { this.NowCount, ""};
objReturn= this.Invoke(this.myIncrease, objPar);
hasResult=((WaitProcessFormEx.ResStruct)objReturn).HasResult;bool canceled =((WaitProcessFormEx.ResStruct)objReturn).Canceled;if(hasResult)
{if (this.NowCount == this.AllCount)
{//showResult(true, "完成! ");
}else{
showResult(false, canceled ? "操作被取消!" : "導入未完成!");return;
}
}
}else{
}
}
objPar= new object[] { this.NowCount, "數據導入完成!"};this.Invoke(this.myIncrease, objPar);
}catch{
Error("錯誤", "數據導入錯誤");
}
}
總結
以上是生活随笔為你收集整理的mysql导入数据显示进度条_导入数据思路+进度条的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 天玑820相当于骁龙什么处理器(天玑82
- 下一篇: mysql按加号没反应_请各位大哥给小老