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