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