private static void AddInfoToDataSet(DataSet data, IUserInfo info, string source,
bool isModule, Guid guid, string tkx, string sessionId)
{
DataTable infoTable = DataSetUtil.CreateDataTable(INFO_TABLE_NAME, INFO_ARRAY);
DataTableCollection tables = data.Tables;
if (!tables.Contains(infoTable.TableName))
{
DataRow row = infoTable.NewRow();
DataSetUtil.SetRowValues(row, INFO_ARRAY, info.UserId, info.MainOrgId,
source, isModule ? 1 : 0, 0, guid, tkx, sessionId);
infoTable.Rows.Add(row);
tables.Add(infoTable);
}
}
public static DataSet ExcelImport(string strFileName, Tk5ListMetaData metaInfos, ImportError importError)
{
DataSet dataSet = new DataSet();
DataTable dataTable = DataSetUtil.CreateDataTable(metaInfos.Table.TableName, metaInfos.Table.TableList);
dataTable.Columns.Add("OriginalRowNum", typeof(int));
IWorkbook workbook;
ISheet sheet;
ExcelUtil.ReadExcle(strFileName, metaInfos.Table.TableDesc, out workbook, out sheet);
SheetImport(metaInfos, dataTable, sheet, importError);
dataSet.Tables.Add(dataTable);
return(dataSet);
}
public ImportResultData(Tk5ListMetaData metaData)
{
Key = Guid.NewGuid().ToString();
ImportDataSet = new DataSet(ToolkitConst.TOOLKIT)
{
Locale = ObjectUtil.SysCulture
};
ImportTable = DataSetUtil.CreateDataTable(metaData.Table.TableName,
metaData.Table.TableList);
ImportTable.Columns.Add(ROW_INDEX, typeof(string));
ImportDataSet.Tables.Add(ImportTable);
var tableList = (from item in metaData.Table.TableList select item.NickName).ToArray();
ErrorTable = DataSetUtil.CreateDataTable(metaData.Table.TableName, tableList);
ErrorTable.Columns.Add(ROW_INDEX, typeof(string));
fErrors = new Dictionary <Tuple <int, string>, string>();
}
private static void AddUrlToDataSet(DataSet data, Uri retUrl, Uri selfUrl, Uri encodeSelfUrl)
{
DataTable urlTable = DataSetUtil.CreateDataTable(URL_TABLE_NAME, URL_ARRAY);
DataTableCollection tables = data.Tables;
if (!tables.Contains(urlTable.TableName))
{
DataRow row = urlTable.NewRow();
string returl = GetUrlValue(retUrl);
string selfurl = GetUrlValue(selfUrl);
string encodeUrl = GetUrlValue(encodeSelfUrl);
DataSetUtil.SetRowValues(row, URL_ARRAY, returl, selfurl,
HttpUtility.UrlEncode(returl, Encoding.UTF8),
HttpUtility.UrlEncode(encodeUrl, Encoding.UTF8));
urlTable.Rows.Add(row);
tables.Add(urlTable);
}
}
public static DataSet ExcelImport(string strFileName, Tk5ListMetaData metaInfos, ResultHolder resultHolder)
{
DataSet dataSet = new DataSet();
DataTable dataTable = DataSetUtil.CreateDataTable(metaInfos.Table.TableName, metaInfos.Table.TableList);
string sheetName = metaInfos.Table.TableDesc;
HSSFWorkbook hssfworkbook = null;
XSSFWorkbook xssfworkbook = null;
ISheet sheet = null;
string fileExt = Path.GetExtension(strFileName);
using (FileStream file = new FileStream(strFileName, FileMode.Open, FileAccess.Read))
{
if (fileExt == ".xls")
{
hssfworkbook = new HSSFWorkbook(file);
}
else if (fileExt == ".xlsx")
{
xssfworkbook = new XSSFWorkbook(file);
}
}
if (hssfworkbook != null)
{
sheet = hssfworkbook.GetSheet(sheetName);
}
else if (xssfworkbook != null)
{
sheet = xssfworkbook.GetSheet(sheetName);
}
SheetImport(metaInfos, dataTable, sheet, resultHolder);
dataSet.Tables.Add(dataTable);
return(dataSet);
}