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); }