/// <summary>
/// 20200428 created
/// target 是目標的DOM id, 例如: "ContentPlaceHolder1_gvList"
/// sname 是存入SQL 的table name, 例如: med, 20200508改成 enum
/// child 是指是否有children, 僅適用於關懷名單
/// hw header want, 需要的欄位
/// </summary>
/// <param name="target"></param>
/// <param name="sname"></param>
/// <param name="child"></param>
/// <param name="hw"></param>
public Target_Table(string target, SQLTableName sname, int?child, string[] hw)
{
_targetid = target;
_sname = sname;
_children = child;
_header_want = hw;
}
public VPN_Retrieved(SQLTableName sname, string[] hw, string doc, string uid, DateTime qdate)
{
_sname = sname;
_table = doc;
_header_want = hw;
_uid = uid;
_qdate = qdate;
}
private void btnClean_Click(object sender, EventArgs e)
{
lblInfo.Text = "正在准备数据...";
Application.DoEvents();
List <SQLTableInfo> lstst1 = sQLTableInfoBindingSource.List as List <SQLTableInfo>;
List <SQLTableInfo> lstst2 = sQLTableInfoBindingSource1.List as List <SQLTableInfo>;
DBHelper <SQLTableName> dbt1 = new DBHelper <SQLTableName>(new Keel.DB.SQLServer(buildConnectString1.ConnectionString));
List <SQLTableName> lsttab1 = dbt1.GetDataViewForObjectList(null);
DBHelper <SQLTableName> dbt2 = new DBHelper <SQLTableName>(new Keel.DB.SQLServer(buildConnectString2.ConnectionString));
List <SQLTableName> lsttab2 = dbt2.GetDataViewForObjectList(null);
Keel.DBOperator <Keel.DB.SQLServer> kdb = new DBOperator <Keel.DB.SQLServer>(new Keel.DB.SQLServer(buildConnectString2.ConnectionString));
foreach (var item in lsttab2)
{
var s = from n in lsttab1 where n.name == item.name select n;
SQLTableName stn = s.SingleOrDefault();
if (stn == null)
{
//表不存在
}
else
{
var fd = from f in lstst2 where f.t_tablename == item.name select f;
foreach (var fdx in fd.ToArray())
{
var fxddd = from fx1 in lstst1 where fx1.t_fieldname == fdx.t_fieldname select fx1;
SQLTableInfo sti = fxddd.SingleOrDefault();
if (sti == null)//如果不存在
{
}
else
{//如果存在这个字段， 就对比一下
}
}
}
}
lblInfo.Text = "完成";
}
