Example #1
0
        protected override void OnInit(EventArgs e)
        {
            base.OnInit(e);
            var products = new SlmScr033Biz().GetProductList();

            cmbProduct.DataSource     = products;
            cmbProduct.DataValueField = "ValueField";
            cmbProduct.DataTextField  = "TextField";
            cmbProduct.DataBind();
            cmbProduct.Items.Insert(0, new ListItem("", "0"));
        }
Example #2
0
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbProduct.SelectedValue == "0")
                {
                    lblPdError.Text = "กรุณาระบุผลิตภัณฑ์"; return;
                }

                if (fuData.HasFile)
                {
                    var ext = Path.GetExtension(fuData.FileName).ToLower();
                    if (ext != ".xls")
                    {
                        lblUploadError.Text = "กรุณาระบุไฟล์ให้ถูกต้อง (.xls)";
                        return;
                    }
                    lblFilename.Text = fuData.FileName;
                    using (OleDbConnection conn = new OleDbConnection())
                    {
                        DataTable dt       = new DataTable();
                        string    filename = Path.GetTempFileName();
                        fuData.SaveAs(filename);
                        fuData.ClearAllFilesFromPersistedStore();

                        conn.ConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=No;IMEX=0;'", filename);
                        OleDbCommand cmd = new OleDbCommand();
                        cmd.Connection  = conn;
                        cmd.CommandType = CommandType.Text;
                        cmd.CommandText = "SELECT * FROM [Sheet1$]";

                        OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
                        adp.Fill(dt);
                        adp.Dispose();
                        cmd.Dispose();

                        List <ControlListData> errLst;
                        tbResult.Visible = false;

                        // save data
                        SlmScr033Biz bz = new SlmScr033Biz();
                        int          total, succ, fail;
                        if (!bz.SaveData(cmbProduct.SelectedValue, dt, out total, out succ, out fail, out errLst, Page.User.Identity.Name))
                        {
                            AppUtil.ClientAlert(this, bz.ErrorMessage);
                        }
                        else
                        {
                            if (errLst.Count == 0)
                            {
                                pnlError.Visible = false;
                                AppUtil.ClientAlert(this, "นำเข้าข้อมูลเรียบร้อย");
                            }
                            else
                            {
                                ErrorList         = errLst;
                                gvError.PageIndex = 0;
                                BindError();
                                AppUtil.ClientAlert(this, "ข้อมูลไม่ถูกนำเข้า กรุณาตรวจสอบข้อผิดพลาด");
                            }

                            tbResult.Visible = true;
                            lblSucc.Text     = succ.ToString("#,##0");
                            lblFail.Text     = fail.ToString("#,##0");
                            lblTotal.Text    = total.ToString("#,##0");
                        }
                    }
                }
                else
                {
                    lblUploadError.Text = "กรุณาระบุไฟล์ที่ต้องการนำเข้า";
                }
            }
            catch (Exception ex)
            {
                var msg = ex.Message;
                if (msg.Contains("Sheet1") && msg.Contains("not a valid"))
                {
                    msg = "ไม่พบข้อมูลในชีท 'Sheet1'";
                }
                _log.Error(msg);
                AppUtil.ClientAlert(this, msg);
            }
        }