/// <summary> /// 查询数据库相关列表 /// </summary> /// <param name="sqlwhere"></param> /// <returns></returns> public DataTable GetDBList(List <WhereModel> list, PgsBar pgs) { DataTable dt = new DataTable(); pgs.PgsScoroll(50, "正在查询。。。"); dt = idefdal.GetDBList(list); pgs.SetMax("查询完成"); return(dt); }
/// <summary> /// 比对流程 /// </summary> public string CompareTable(List <WhereModel> list, string tempfilename, PgsBar pgs) { try { string retmsg; List <TableCompareModel> source = isourcedal.GetTableListForModel(list); pgs.PgsScoroll(10, "源数据读取完成"); List <TableCompareModel> target = itargetdal.GetTableListForModel(list); pgs.PgsScoroll(10, "目标数据读取完成"); TableCompareList tblist = CompareTableList(source, target); pgs.PgsScoroll(10, "缺失表比对完成"); pgs.SetPgsMax(tblist.tablelist.Count + 41); foreach (TableCompareModel model in tblist.tablelist) { CompareColumn(model); pgs.PgsScoroll(1, model.Tablename + "比对完成"); } //完全匹配的表去掉 tblist.tablelist.RemoveAll(x => x.Column.Count == 0); pgs.PgsScoroll(1, "正在生成比对结果"); tblist.tablelist.AddRange(tblist.notablelist); if (CreateXmlFile(tblist.tablelist, GetXMLPath(tempfilename), out retmsg)) { pgs.SetMax("比对完成"); } else { pgs.PgsScoroll(0, retmsg); } return(retmsg); } catch (Exception ex) { return(ex.Message); } }