public override void ExecuteCommand(CancellationToken token)
{
var file = DialogManager.ShowSelectFileDialog();
if (file == null)
{
return;
}
var ok = new Action <string>((tableName) =>
{
ExcelImporter importer = new ExcelImporter();
DDLManager ddlManager = new DDLManager();
var meta = importer.GetMetaData(file.FullName);
ddlManager.CreateTable(tableName, meta);
importer.ImportToTable(file.FullName, tableName, meta);
ShellManager.AppendToEndOfSelection("SELECT * FROM " + tableName);
ShellManager.AppendToEndOfSelection("--DROP TABLE " + tableName);
});
DialogManager.GetDialogInputFromUser("Choose target table name (This table will be created)", "ExcelImport", ok);
}
public override void ExecuteCommand(CancellationToken token)
{
var file = DialogManager.ShowSelectFileDialog();
if (file == null)
{
return;
}
var ddlManager = new DDLManager();
var bulkdInsertManager = new BulkInsertManager();
String connString = ConnectionManager.GetConnectionStringForCurrentWindow();
Console.WriteLine("Start time" + DateTime.Now);
ExcelStreamReader.Execute(file.FullName, reader =>
reader.ForEachSheet(sheet =>
{
var schema = sheet.GetSchema();
ddlManager.CreateTable(schema.TableName, schema, connString);
bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString);
})
);
}
// Forza il valore della DDL se è un manager
protected void DDLManager_DataBound(object sender, EventArgs e)
{
if (!Auth.ReturnPermission("MASTERDATA", "PROJECT_ALL"))
{
DDLManager.ClearSelection();
DDLManager.Items.FindByValue(CurrentSession.Persons_id.ToString()).Selected = true;
DDLManager.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//如果第一次載入這個Page
if (!IsPostBack)
{
//讀取DB的Company表來設定下拉選單內容
DDLManager ddlManager = new DDLManager();
DataTable ddlDataTable = ddlManager.GetCompanyDDL();
this.dplCompany.DataSource = ddlDataTable;
this.dplCompany.DataValueField = "Cid";
this.dplCompany.DataTextField = "Name";
this.dplCompany.DataBind();
//宣告變數存取QueryString
string RepNumber = Request.QueryString["RepNo"];
//分為更新模式及新增模式
if (ReceiptDetailHelper.isUpdateMode())
{
this.h1Title.InnerText = "修改發票";
//讀取DB內的資料顯示在畫面
this.LoadReceipt(RepNumber);
//鎖定發票號碼
this.txtReceiptNumber.Enabled = false;
this.txtReceiptNumber.BackColor = System.Drawing.Color.LightGray;
}
else if (!string.IsNullOrEmpty(RepNumber))
{
//Uri的QueryString被更改時、直接跳回發票總覽頁面
var manager = new ReceiptManager();
if (manager.GetReceipt(RepNumber) == null)
{
Response.Redirect("~/ReceiptList.aspx");
}
}
else
{
this.h1Title.InnerText = "新增發票";
}
}
}
