private void DataExport()
{
string SessionIDName = "IVM10_Error" + PageTimeStamp.Value;
ParameterList.Clear();
ParameterList.Add(this.txtRemoveNo.Text);
ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value);
ParameterList.Add(this.SLP_User1.Text);
IVMModel.MaintainRemoveImport bco = new IVMModel.MaintainRemoveImport(ConntionDB);
DataTable dt = bco.GetErrorDataSheet(ParameterList);
if (dt == null || (dt != null && dt.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
}
Session[SessionIDName] = dt;
}
protected void btnImport_Click(object sender, EventArgs e)
{
try
{
ErrorMsgLabel.Text = "";
UpdatePanel6.Update();
int RemoveID = -1;
string V_OK = "";
int ErrorCnt = 0;
string V_Msg = "";
if (GridView1.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "alert('明細區有資料時不允許執行檔案匯入');", true);
return;
}
string strUploadPath = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["UploadPath"]).Replace("IVM\\", "") + "\\IVM\\";
string strUploadMessage = FileUpload(strUploadPath, this.FileUpload1, Session["UID"].ToString());
string[] strMsg = strUploadMessage.Split('|');
if (strMsg[0].ToString() == "1")
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(UpdatePanel), "隨便寫", "alert('" + strMsg[1].ToString() + "');", true);
return;
}
//將檔案資料讀取進TEMP_TABLE
IVMModel.MaintainRemoveImport BCO = new IVMModel.MaintainRemoveImport(ConntionDB);
ArrayList ErrorRows = new ArrayList();
BCO.FileToTmp(Session["UID"].ToString() + PageTimeStamp.Value, DateTime.Now.ToString("yyyyMMddHHmmss"),
Session["UID"].ToString(), strMsg[1].ToString(), this.SLP_CodeFile1.Text,
null, out ErrorRows, out V_OK, out RemoveID, out ErrorCnt, out V_Msg);
if (ErrorRows.Count > 0)
{
string strErrRow = "";
for (int i = 0; i < ErrorRows.Count; i++)
{
strErrRow += ErrorRows[i].ToString() + ",";
}
strErrRow = strErrRow.Substring(0, strErrRow.Length - 1);
ErrorMsgLabel.Text = "第" + strErrRow + "筆資料格式錯誤";
UpdatePanel6.Update();
return;
}
if (V_Msg == "0")
{
if (V_OK == "0")
{
ErrorMsgLabel.Text = "無可建單資料";
UpdatePanel6.Update();
}
else
{
if (RemoveID != -1)
{
ArrayList IDList = new ArrayList();
IDList.Add(RemoveID);
Session["IVM10QueryID"] = IDList;
Response.Redirect(string.Format("IVM102.aspx?ID={0}&PageMode=1&Code=IVM10&ErrorCnt={1}", RemoveID, ErrorCnt));
}
else
{
ErrorMsgLabel.Text = V_Msg;
UpdatePanel6.Update();
}
}
if (ErrorCnt > 0)
{
btnError.Visible = true;
UpdatePanel5.Update();
}
}
else
{
ErrorMsgLabel.Text = V_Msg;
UpdatePanel6.Update();
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
UpdatePanel6.Update();
}
}