Exemplo n.º 1
0
    }//Page_Load

    protected void btn_ConfirmRank_Click(object sender, EventArgs e)
    {
        //lblCount.Text = FileUpload1.PostedFile.FileName;
        //lblQty.Text = FileUpload1.TemplateSourceDirectory;
        if (this.FileUpload1.HasFile)
        {
            //ScriptManager.RegisterStartupScript(Page, this.GetType(), "VGR023.aspx", "alert(' " + FileUpload1.AppRelativeTemplateSourceDirectory + " ');", true);

            try
            {
                string[] bResult;
                string[] bResult1;


                if (FileUpload1.HasFile)
                {
                    //if (System.IO.Path.GetFileName(FileUpload1.FileName).IndexOf(ddlGroupDDD.SelectedItem.Text) == -1)
                    //{
                    //    ErrorMsgLabel.Text = "輸入之檔名非此店群統稱";
                    //    return;
                    //}

                    string tempDir = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["UploadPath"] + "VGR\\";
                    string backupDir = Server.MapPath("..\\") + System.Configuration.ConfigurationManager.AppSettings["BackPath"] + "VGR\\";
                    string strfileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();//副檔名
                    string strfileWithoutExtension = System.IO.Path.GetFileNameWithoutExtension(FileUpload1.FileName).ToLower();//檔名
                    string strFileName = strfileWithoutExtension + DateTime.Now.ToString("yyyyMMddHHmmss") + strfileExtension;

                    //FileUpload1.SaveAs(tempDir + strFileName);

                    string user = Session["UID"].ToString();

                    MaintainChanReturnData bco = new MaintainChanReturnData(ConntionDB);
                    //CAMCommon bco1 = new CAMCommon();

                    //DbTransaction transaction = bco.GetTransaction();

                    try
                    {
                        try
                        {
                            using (StreamReader sr = new StreamReader(FileUpload1.FileContent, System.Text.Encoding.GetEncoding(950)))
                            {
                                string s = null;
                                bco.DoDelImportFile();
                                while ((s = sr.ReadLine()) != null)
                                {
                                    if (s.Trim() != "")
                                        bco.DoImportFile(s);

                                    //ParameterList.Clear();
                                    //ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
                                    ////ParameterList.Add(Request.QueryString["ChanNo"].ToString());
                                    ////ParameterList.Add(Request.QueryString["Store"].ToString());
                                    //ParameterList.Add(Session["StoreChain"].ToString());
                                    //ParameterList.Add(Session["Store"].ToString());
                                    //ParameterList.Add(Request.QueryString["IsCheck"].ToString());
                                    //ParameterList.Add(Session["UID"].ToString());

                                    //if (s.Length > 52 && s.Substring(36, 10).Trim() != "" && s.Substring(46, 6).Trim() != "")
                                    //{
                                    //    ParameterList.Add(s.Substring(36,10));
                                    //    ParameterList.Add(s.Substring(46, 6));
                                    //}
                                    ////bResult = bco.DoImportCheck(ParameterList);
                                    //DataTable dtResult = bco.DoImportCheck(ParameterList);
                                    //if (dtResult.Rows.Count > 0)
                                    //{
                                    //    lblCount.Text = dtResult.Rows[0][0].ToString();
                                    //    lblQty.Text = dtResult.Rows[0][1].ToString();
                                    //    lblErrQty.Text = dtResult.Rows[0][2].ToString();
                                    //}
                                }
                                sr.Close();

                            }

                        }
                        catch (Exception ex)
                        {
                            ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + ex.Message + " ');", true);
                        }

                        #region 轉入系統

                        ////轉入
                        ParameterList.Clear();
                        ParameterList.Add(DateTime.Parse(Request.QueryString["BackWardDate"].ToString()));
                        //ParameterList.Add(Request.QueryString["ChanNo"].ToString());
                        //ParameterList.Add(Request.QueryString["Store"].ToString());
                        ParameterList.Add(Session["StoreChain"].ToString());
                        ParameterList.Add(Session["Store"].ToString());
                        ParameterList.Add(Request.QueryString["IsCheck"].ToString());
                        ParameterList.Add(Session["UID"].ToString());

                        //bResult = bco.DoImportCheck(ParameterList);
                        DataTable dtResult = bco.DoImportCheck(ParameterList);
                        if (dtResult.Rows.Count > 0)
                        {
                            lblCount.Text = dtResult.Rows[0][0].ToString();
                            lblQty.Text = dtResult.Rows[0][1].ToString();
                            lblErrQty.Text = dtResult.Rows[0][2].ToString();
                        }

                        dtForBrowse = bco.GetImpData(Session["UID"].ToString());
                        gv_Result.DataSource = dtForBrowse;
                        gv_Result.DataBind();


                        #endregion

                        //System.IO.File.Move(tempDir + strFileName, backupDir + strFileName);

                    }
                    catch (Exception ex)
                    {
                        ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + "載入失敗,請檢查檔案格式:" + ex.Message + " ');", true);
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請輸入檔案路徑 ');", true);
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' " + ex.Message + " ');", true);
            }
            finally { }
        }
        else
        {

            ScriptManager.RegisterStartupScript(Page, this.GetType(), "POP_VGR023_2.aspx", "alert(' 請先選擇檔案 ');", true);
        }
    }