private void btMapIDSearch_Click(object sender, EventArgs e)
{
DBMap.ListClassificationDataTable dt = new DBMap.ListClassificationDataTable();
DBMapTableAdapters.ListClassificationTableAdapter adt = new DBMapTableAdapters.ListClassificationTableAdapter();
adt.Connection.ConnectionString = Server.ConnectionString;
adt.Fill(dt);
foreach (DBMap.ListClassificationRow dr in dt)
{
//Sửa lại ListIdSearch trong ListClassification
String listcat = "c" + dr.ID.ToString("D3");
listcat = listcat + " " + GetListCatID(dr.ID);
adt.UpdateQuery_ListIDSearch(listcat, dr.ID);
}
}
private String GetListCatID(int catID)
{
String r = "";
DBMap.ListClassificationDataTable dt = new DBMap.ListClassificationDataTable();
DBMapTableAdapters.ListClassificationTableAdapter adt = new DBMapTableAdapters.ListClassificationTableAdapter();
adt.Connection.ConnectionString = Server.ConnectionString;
int id = catID;
for (int i = 0; i < 10; i++)
{
adt.FillBy_ID(dt, id);
if (dt.Rows.Count > 0)
{
id = Common.Obj2Int(dt.Rows[0]["ParentID"]);
if (id == 0)
{
break;
}
r += "c" + id.ToString("D3") + " ";
}
}
return(r);
}
