private void ImportICB() { this.ShowMessage(""); string flds = "Industry,Supersector,Sector,Subsector,Definition"; data.importDS.icbCodeDataTable icbTbl = new data.importDS.icbCodeDataTable(); common.import.ImportFromExcel(dataFileNameEd.Text, sheetNameEd.Text, flds, true, icbTbl); ImportICB_ValidateData(icbTbl); //Add to database string sysCodeCat = sysCodeCatEd.Text.Trim(); data.baseDS.sysCodeDataTable sysCodeTbl = new data.baseDS.sysCodeDataTable(); ImportICB_AddToDb(icbTbl, icbTbl.industryColumn.ColumnName, false, sysCodeTbl, sysCodeCat, null); ImportICB_AddToDb(icbTbl, icbTbl.superSectorColumn.ColumnName, false, sysCodeTbl, sysCodeCat, icbTbl.industryColumn.ColumnName); ImportICB_AddToDb(icbTbl, icbTbl.sectorColumn.ColumnName, false, sysCodeTbl, sysCodeCat, icbTbl.superSectorColumn.ColumnName); ImportICB_AddToDb(icbTbl, icbTbl.subSectorColumn.ColumnName, true, sysCodeTbl, sysCodeCat, icbTbl.sectorColumn.ColumnName); application.DbAccess.DeleteSysCode_ByCategory(sysCodeCat); application.DbAccess.UpdateData(sysCodeTbl); this.ShowMessage("Hòan tất"); //ImportICB_AddToDb("ICB", icbTbl); //common.Export.ExportToExcel(icbTbl.DefaultView.ToTable(),"d://tmp.xls"); }
public static data.baseDS.sysCodeRow UpdateData(data.baseDS.sysCodeRow row) { data.baseDS.sysCodeDataTable tbl = new data.baseDS.sysCodeDataTable(); tbl.ImportRow(row); myClient.UpdateSysCode(ref tbl); row.AcceptChanges(); return(tbl[0]); }
//Add to database private void ImportICB_AddToDb(data.importDS.icbCodeDataTable tbl, string fldName, bool haveDefitionFld, data.baseDS.sysCodeDataTable sysCodeTbl, string category, string codeGroupFldName) { data.baseDS.sysCodeRow sysCodeRow; common.myKeyValueItem item; for (int idx = 0; idx < tbl.Count; idx++) { if (tbl[idx].RowState == DataRowState.Deleted) { continue; } item = libs.SplitKeyValue(tbl[idx][fldName].ToString(), " "); if (item == null) { common.fileFuncs.WriteLog(tbl[idx][fldName].ToString() + " not found."); continue; } if (sysCodeTbl.FindBycategorycode(category, item.Key) == null) { sysCodeRow = sysCodeTbl.NewsysCodeRow(); commonClass.AppLibs.InitData(sysCodeRow); sysCodeRow.category = category; sysCodeRow.code = item.Key; sysCodeRow.description1 = item.Value; sysCodeRow.tag1 = fldName; if (codeGroupFldName != null) { sysCodeRow.inGroup = tbl[idx][codeGroupFldName].ToString(); } if (haveDefitionFld && !tbl[idx].IsdefinitionNull()) { sysCodeRow.notes = tbl[idx].definition; } sysCodeTbl.AddsysCodeRow(sysCodeRow); } tbl[idx][fldName] = item.Key; } }
public void UpdateSysCode(ref data.baseDS.sysCodeDataTable tbl) { DbAccess.UpdateData(tbl); }
public data.baseDS.sysCodeDataTable GetSysCode(string catCode) { data.baseDS.sysCodeDataTable tbl = new data.baseDS.sysCodeDataTable(); DbAccess.LoadData(tbl, catCode); return(tbl); }
public static data.baseDS.sysCodeRow UpdateData(data.baseDS.sysCodeRow row) { data.baseDS.sysCodeDataTable tbl = new data.baseDS.sysCodeDataTable(); tbl.ImportRow(row); myClient.UpdateSysCode(ref tbl); row.AcceptChanges(); return tbl[0]; }
public data.baseDS.sysCodeDataTable GetSysCode(string catCode) { data.baseDS.sysCodeDataTable tbl = new data.baseDS.sysCodeDataTable(); DbAccess.LoadData(tbl,catCode); return tbl; }
public static void UpdateData(data.baseDS.sysCodeDataTable tbl) { sysCodeTA.Update(tbl); tbl.AcceptChanges(); }
public static void LoadData(data.baseDS.sysCodeDataTable tbl, string catCode) { sysCodeTA.ClearBeforeFill = false; sysCodeTA.FillByCat(tbl, catCode); }