protected void SaveForm(object sender, EventArgs e) { try { FieldModel modelField = new FieldModel(); modelField.SQLField = SqlField; modelField.FieldName = FieldName.Text; modelField.ExcelColomn = Convert.ToInt32(ExcelColomn.Text); modelField.ExcelFieldType = (WebMain.Common.BaseEnum.Enumeration.FieldTypes)Convert.ToInt32(ExcelFieldType.SelectedValue); modelField.SQLField = SQLField.Text; modelField.SQLFieldType = (WebMain.Common.BaseEnum.Enumeration.FieldTypes)Convert.ToInt32(SQLFieldType.SelectedValue); modelField.IsForeignKey = IsForeignKey.SelectedValue == "0" ? false : true; modelField.ForeignTable = ForeignTable.Text; modelField.ForeignKey = ForeignKey.Text; modelField.LinkField = LinkField.Text; ConfigOperater.AddOrUpdateField(modelField); Response.Redirect("/Excel/ExcelImport.aspx"); } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void BindGrid() { ConfigModel configModel = ConfigOperater.GetConfigModel(); SqlConnectionString.Text = configModel.SqlConnectionString; TableName.Text = configModel.TableName; UploadPath.Text = configModel.UploadPath; StartRow.Text = configModel.StartRow.ToString(); }
protected void UploadExcel(object sender, EventArgs e) { if (ExcelFile.HasFile) { string fileName = ExcelFile.FileName; FileInfo fileInfo = new FileInfo(fileName); if (fileInfo.Extension == ".xls" || fileInfo.Extension == ".xlsx") { fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + fileName; ConfigModel modelConfig = ConfigOperater.GetConfigModel(); string filePath = Server.MapPath("/" + modelConfig.UploadPath + "/" + fileName); ExcelFile.SaveAs(filePath); try { DataTable dt = ExcelHelper.GetExcelToDataTable(url: filePath, startRow: (modelConfig.StartRow > 0?modelConfig.StartRow - 1:0)); string errorStr = ""; string result = SetExcelToSQL.RenderDataTableToSQLResult(dt, modelConfig, ref errorStr); if (errorStr != "") { RegisterScript("alert('导入错误!" + errorStr.Replace("\n", "").Replace("\r", "").Replace("'", "\"") + "')"); } else { Context.Items.Add("ResultSQL", result); Context.Items.Add("SQLConnection", modelConfig.SqlConnectionString); Server.Transfer("/Excel/Result.aspx"); } } catch (Exception ex) { RegisterScript("alert('导入错误!" + ex.ToString().Replace("\n", "").Replace("\r", "").Replace("'", "\"") + "')"); } finally { File.Delete(filePath); } } else { RegisterScript("alert('错误的文件!')"); } } else { RegisterScript("alert('请选择文件!')"); } }
private void BindGrid() { ConfigModel configModel = ConfigOperater.GetConfigModel(); SqlConnectionString.Text = configModel.SqlConnectionString; TableName.Text = configModel.TableName; UploadPath.Text = configModel.UploadPath; StartRow.Text = configModel.StartRow.ToString(); RepeaterItem.DataSource = configModel.ListField; RepeaterItem.DataBind(); }
protected void UploadExcel(object sender, EventArgs e) { if (ExcelFile.HasFile) { string fileName = ExcelFile.FileName; FileInfo fileInfo = new FileInfo(fileName); if (fileInfo.Extension == ".xls" || fileInfo.Extension == ".xlsx") { fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + fileName; ConfigModel modelConfig = ConfigOperater.GetConfigModel(); string filePath = Server.MapPath("/" + modelConfig.UploadPath + "/" + fileName); ExcelFile.SaveAs(filePath); try { DataTable dt = ExcelHelper.GetExcelToDataTable(url: filePath, startRow: (modelConfig.StartRow > 0 ? modelConfig.StartRow - 1 : 0)); Session["DataTable"] = dt; //Context.Items.Add("SQLConnection", modelConfig.SqlConnectionString); Response.Redirect("/Excel/StepOne.aspx"); } catch (Exception ex) { RegisterScript("alert('导入错误!" + ex.ToString().Replace("\n", "").Replace("\r", "").Replace("'", "\"") + "')"); } finally { File.Delete(filePath); } } else { RegisterScript("alert('错误的文件!')"); } } else { RegisterScript("alert('请选择文件!')"); } }
protected void SaveForm(object sender, EventArgs e) { try { ConfigModel configModel = ConfigOperater.GetConfigModel(); configModel.SqlConnectionString = SqlConnectionString.Text; configModel.TableName = TableName.Text; configModel.UploadPath = UploadPath.Text; configModel.StartRow = Convert.ToInt32(StartRow.Text); ConfigOperater.UpdateConfigModel(configModel); } catch (Exception ex) { Response.Write(ex); } }
protected void Page_Load(object sender, EventArgs e) { ConfigModel model = ConfigOperater.GetConfigModel(); if (SqlField != "") { FieldModel modelField = model.ListField.Find(u => u.SQLField == SqlField); if (modelField != null) { model.ListField.Remove(modelField); ConfigOperater.UpdateConfigModel(model); } } Response.Redirect("/excel/excelimport.aspx"); }
private void BindData() { if (SqlField != "") { ConfigModel confModel = ConfigOperater.GetConfigModel(); FieldModel modelField = confModel.ListField.Find(u => u.SQLField == SqlField); if (modelField != null) { FieldName.Text = modelField.FieldName; ExcelColomn.Text = modelField.ExcelColomn.ToString(); ExcelFieldType.SelectedValue = ((int)modelField.ExcelFieldType).ToString(); SQLField.Text = modelField.SQLField.ToString(); SQLFieldType.SelectedValue = ((int)modelField.SQLFieldType).ToString(); IsForeignKey.SelectedValue = (modelField.IsForeignKey == false?0:1).ToString(); ForeignTable.Text = modelField.ForeignTable; ForeignKey.Text = modelField.ForeignKey.ToString(); LinkField.Text = modelField.LinkField.ToString(); } } }