protected void ExcelInput1_OnInput(object sender, EventArgs e)
{
org = Business.Do <IOrganization>().OrganCurrent();
if (couid_get > 0)
{
course = Business.Do <ICourse>().CourseSingle(couid_get);
}
//工作簿中的数据
DataTable dt = ExcelInput1.SheetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
//throw new Exception();
//将数据逐行导入数据库
_inputData(dt.Rows[i]);
}
catch
{
//如果出错，将错误行返回给控件
ExcelInput1.AddError(dt.Rows[i]);
}
}
Business.Do <IQuestions>().OnSave(null, EventArgs.Empty);
Business.Do <IOutline>().OnSave(null, EventArgs.Empty);
}
protected void ExcelInput1_OnInput(object sender, EventArgs e)
{
//xml配置文件
XmlDocument xmldoc = new XmlDocument();
string confing = WeiSha.Common.App.Get["ExcelInputConfig"].VirtualPath + ExcelInput1.Config;
xmldoc.Load(WeiSha.Common.Server.MapPath(confing));
XmlNodeList nodes = xmldoc.GetElementsByTagName("item");
//工作簿中的数据
DataTable dt = ExcelInput1.SheetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
//将数据逐行导入数据库
_inputData(dt.Rows[i], nodes);
}
catch (Exception ex)
{
//如果出错，将错误行返回给控件
ExcelInput1.AddError(dt.Rows[i]);
}
}
Business.Do <IOutline>().OnSave(null, EventArgs.Empty);
}
protected void ExcelInput1_OnInput(object sender, EventArgs e)
{
//工作簿中的数据
DataTable dt = ExcelInput1.SheetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
//throw new Exception();
//将数据逐行导入数据库
_inputData(dt.Rows[i]);
}
catch
{
//如果出错，将错误行返回给控件
ExcelInput1.AddError(dt.Rows[i]);
}
}
}
protected void ExcelInput1_OnInput(object sender, EventArgs e)
{
org = Business.Do <IOrganization>().OrganCurrent();
//工作簿中的数据
DataTable dt = ExcelInput1.SheetDataTable;
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
//将数据逐行导入数据库
_inputData(dt.Rows[i]);
}
catch
{
//如果出错，将错误行返回给控件
ExcelInput1.AddError(dt.Rows[i]);
}
}
}