示例#1
0
        protected void Import(string FilePath, string Extension)
        {
            string ip   = Request.ServerVariables["REMOTE_ADDR"];
            string VbPC = System.Net.Dns.GetHostEntry(Request.ServerVariables["remote_addr"]).HostName;

            DataRow[] Result;

            FileStream       stream = File.Open(FilePath, FileMode.Open, FileAccess.Read);
            IExcelDataReader ExcelReader;

            ExcelReader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream);

            //// para que tome la primera fila como titulo de campos
            var conf = new ExcelDataSetConfiguration
            {
                ConfigureDataTable = _ => new ExcelDataTableConfiguration
                {
                    UseHeaderRow = true
                }
            };
            var       dataSet = ExcelReader.AsDataSet(conf);
            DataTable DT      = dataSet.Tables[0];

            if (DT.Rows.Count > 0)
            {
                Cnx.SelecBD();
                using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
                {
                    sqlCon.Open();
                    string VBQuery = "AjusteSP";

                    using (SqlCommand SC = new SqlCommand(VBQuery, sqlCon))
                    {
                        try
                        {
                            string PMensj = "";
                            SC.CommandType = CommandType.StoredProcedure;
                            SqlParameter Prmtrs1  = SC.Parameters.AddWithValue("@Ajuste", DT);
                            SqlParameter Prmtrs2  = SC.Parameters.AddWithValue("@Usu", Session["C77U"].ToString());
                            SqlParameter Prmtrs3  = SC.Parameters.AddWithValue("@IdCia", Session["!dC!@"]);
                            SqlParameter Prmtrs4  = SC.Parameters.AddWithValue("@NIT", Session["Nit77Cia"]);
                            SqlParameter Prmtrs5  = SC.Parameters.AddWithValue("@NomMaquina", VbPC.Trim());
                            SqlParameter Prmtrs6  = SC.Parameters.AddWithValue("@FecAjuste", Convert.ToDateTime(TxtFech.Text));
                            SqlParameter Prmtrs7  = SC.Parameters.AddWithValue("@CodMvto", DdlMvto.Text.Trim());
                            SqlParameter Prmtrs8  = SC.Parameters.AddWithValue("@CodAlma", DdlAlmac.SelectedItem.Text.Trim());
                            SqlParameter Prmtrs9  = SC.Parameters.AddWithValue("@CCost", DdlCcost.Text.Trim());
                            SqlParameter Prmtrs10 = SC.Parameters.AddWithValue("@Mtv", TxtMotvo.Text.Trim());
                            Prmtrs1.SqlDbType = SqlDbType.Structured;
                            using (SqlDataAdapter SDA = new SqlDataAdapter())
                            {
                                using (DataSet DST = new DataSet())
                                {
                                    SDA.SelectCommand = SC; SDA.Fill(DST); ViewState["DST"] = DST;
                                    PMensj            = DST.Tables[1].Rows[0]["Mensj"].ToString().Trim();
                                    if (!PMensj.Trim().Equals(""))
                                    {
                                        Result = Idioma.Select("Objeto= '" + PMensj.ToString().Trim() + "'");
                                        foreach (DataRow row in Result)
                                        {
                                            PMensj = row["Texto"].ToString().Trim();
                                        }                                           //LblTitIncosistnc.Text = PMensj;

                                        ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + PMensj + "');", true);
                                        LblTitInconsist.Text          = PMensj;
                                        GrdInconsist.DataSource       = DST.Tables[0]; GrdInconsist.DataBind();
                                        BtnCargarInvIni.OnClientClick = "";
                                        return;
                                    }
                                    PMensj = DST.Tables[0].Rows[0]["Mensj"].ToString().Trim();
                                    Result = Idioma.Select("Objeto= '" + PMensj.ToString().Trim() + "'");
                                    foreach (DataRow row in Result)
                                    {
                                        LblTitInconsist.Text = row["Texto"].ToString().Trim();
                                    }                                                         //LblTitIncosistnc.Text = PMensj;
                                    GrdInconsist.DataSource = null; GrdInconsist.DataBind();
                                    BtnCargarInvIni.Visible = false; BtnSubirInventario.Visible = true;
                                }
                            }
                        }
                        catch (Exception Ex)
                        {
                            BtnCargarInvIni.OnClientClick = "";
                            Result = Idioma.Select("Objeto= 'MensAjt03'");// Inconvenientes con el archivos, verifique si tiene la estructura requerida.
                            foreach (DataRow row in Result)
                            {
                                ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                            }                                                                                                                                       //
                            string VbcatUs = Session["C77U"].ToString(), VbcatNArc = ViewState["PFileName"].ToString(), VbcatVer = Session["77Version"].ToString(), VbcatAct = Session["77Act"].ToString();
                            Cnx.UpdateErrorV2(VbcatUs, VbcatNArc, "Import Detalle Sol Pedido", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, VbcatVer, VbcatAct);
                        }
                    }
                }
            }
        }
示例#2
0
        protected void BtnCargarInvIni_Click(object sender, EventArgs e)
        {
            Idioma     = (DataTable)ViewState["TablaIdioma"];
            Page.Title = ViewState["PageTit"].ToString().Trim();
            DataRow[] Result;
            if (DdlMvto.Text.Equals(""))
            {
                Result = Idioma.Select("Objeto= 'MensAjt01'");//Debe ingresar un tipo de movimiento.
                foreach (DataRow row in Result)
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                }
                return;
            }
            if (DdlAlmac.Text.Equals("0"))
            {
                Result = Idioma.Select("Objeto= 'MstrMens19'");//Debe ingresar el almacén.
                foreach (DataRow row in Result)
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                }
                return;
            }
            if (DdlCcost.Text.Equals(""))
            {
                Result = Idioma.Select("Objeto= 'MensAjt02'");//Debe ingresar un centro de costo.
                foreach (DataRow row in Result)
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                }
                return;
            }
            if (TxtFech.Text.Equals(""))
            {
                Result = Idioma.Select("Objeto= 'MstrMens08'");//Fecha inválida.
                foreach (DataRow row in Result)
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                }
                TxtFech.Focus(); return;
            }
            string FechI  = Cnx.ReturnFecha(Convert.ToString(DateTime.UtcNow));
            string VbMnsj = Cnx.ValidarFechas2(TxtFech.Text.Trim(), FechI, 2);

            if (!VbMnsj.ToString().Trim().Equals(""))
            {
                Result = Idioma.Select("Objeto= '" + VbMnsj.ToString().Trim() + "'");
                foreach (DataRow row in Result)
                {
                    VbMnsj = row["Texto"].ToString().Trim();
                }
                ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + VbMnsj + "');", true);
                Page.Title = ViewState["PageTit"].ToString(); TxtFech.Focus();
                return;
            }

            if (TxtMotvo.Text.Equals(""))
            {
                Result = Idioma.Select("Objeto= 'MstrMens22'");//Debe ingresar una observación.
                foreach (DataRow row in Result)
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                }
                TxtMotvo.Focus(); return;
            }
            if (FUpCargaInvIni.Visible == false)
            {
                FUpCargaInvIni.Visible = true; LblTitInconsist.Text = ""; GrdInconsist.Visible = true; GrdInconsist.DataSource = null; GrdInconsist.DataBind();
            }
            else
            {
                try
                {
                    Result = Idioma.Select("Objeto= 'MensAjt23'");
                    foreach (DataRow row in Result)
                    {
                        BtnCargarInvIni.OnClientClick = "return confirm('" + row["Texto"].ToString().Trim() + "');";
                    }

                    DataTable DT = new DataTable();
                    if (FUpCargaInvIni.Visible == false)
                    {
                        FUpCargaInvIni.Visible = true;
                    }
                    else
                    {
                        if (FUpCargaInvIni.HasFile == true)
                        {
                            //BtnCargarInvIni.CssClass = "btn btn-success";
                            string FolderPath;
                            string FileName = Path.GetFileName(FUpCargaInvIni.PostedFile.FileName);
                            string VblExt   = Path.GetExtension(FUpCargaInvIni.PostedFile.FileName);
                            if (Cnx.GetProduccion().Trim().Equals("Y"))
                            {
                                FolderPath = ConfigurationManager.AppSettings["FolderPath"];
                            }                                                                                                           //Azure
                            else
                            {
                                FolderPath = ConfigurationManager.AppSettings["FoldPathLcl"];
                            }

                            VblExt = VblExt.Substring(VblExt.LastIndexOf(".") + 1).ToLower();
                            string[] formatos = new string[] { "xls", "xlsx" };
                            if (Array.IndexOf(formatos, VblExt) < 0)
                            {
                                BtnCargarInvIni.OnClientClick = "";
                                Result = Idioma.Select("Objeto= 'RteMens40'");//Archivo inválido
                                foreach (DataRow row in Result)
                                {
                                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                                }
                                return;
                            }
                            string FilePath = FolderPath + FileName;
                            FUpCargaInvIni.SaveAs(FilePath);
                            Import(FilePath, VblExt);
                            FUpCargaInvIni.Visible = false;
                        }
                        else
                        {
                            Result = Idioma.Select("Objeto= 'MstrMens34'");//Debe seleccionar un archivo.
                            foreach (DataRow row in Result)
                            {
                                ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                            }
                            return;
                        }
                    }
                }
                catch (Exception Ex)
                {
                    BtnCargarInvIni.OnClientClick = "";
                    Result = Idioma.Select("Objeto= 'MensErrMod'");
                    foreach (DataRow row in Result)
                    {
                        ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
                    }                                                                                                                                       //
                    string VbcatUs = Session["C77U"].ToString(), VbcatNArc = ViewState["PFileName"].ToString(), VbcatVer = Session["77Version"].ToString(), VbcatAct = Session["77Act"].ToString();
                    Cnx.UpdateErrorV2(VbcatUs, VbcatNArc, "Cargar Masiva Ajuste", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, VbcatVer, VbcatAct);
                }
                FUpCargaInvIni.Visible = false;
            }
        }