C# DataRow.ToString方法代码示例

本文整理汇总了C#中System.Data.DataRow.ToString方法的典型用法代码示例。如果您正苦于以下问题：C# DataRow.ToString方法的具体用法？C# DataRow.ToString怎么用？C# DataRow.ToString使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataRow的用法示例。

在下文中一共展示了DataRow.ToString方法的12个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: EnumToBool

        public static bool EnumToBool(DataRow Enum)
        {
            if (Enum.ToString() == "1")
            {
                return true;
            }

            return false;
        }

开发者ID:habb0，项目名称:Zazlak，代码行数:9，代码来源:Init.cs

示例2: insertaUrbanoLog

        private void insertaUrbanoLog(SqlConnection mySqlConnection, DataRow dbRow, int id_calle)
        {
            try
            {
                double terre;
                double cons;

                if (!Double.TryParse(dbRow["U_VALCATT"].ToString().Trim(), out terre))
                {
                    terre = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["U_VALCATC"].ToString().Trim(), out cons))
                {
                    cons = 0.0; // or alert, or whatever.
                }
                var cmd1 = new SqlCommand();
                cmd1.Parameters.Clear();
                cmd1.Connection = mySqlConnection;
                cmd1.CommandType = CommandType.Text;
                cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Urbano_Log] ([Id_Action],[Id_User],[Id_Date],[Clave], "
                                    + "[Id_Calle],[Frente],[Fondo],[ValorTerreno],[ValorConstruccion]) "
                                    + " VALUES (@accion,@usuario,@fecha,@Clave,@Id_Calle,@frente,@fondo,@valTerreno,@valCons) ";
                cmd1.Parameters.AddWithValue("@accion", 1);
                cmd1.Parameters.AddWithValue("@usuario", "Admin");
                cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@Id_Calle", id_calle);
                cmd1.Parameters.AddWithValue("@frente", dbRow["UE_FRENTE"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@fondo", dbRow["UE_FONDO"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@valTerreno", terre);
                cmd1.Parameters.AddWithValue("@valCons", cons);
                cmd1.ExecuteNonQuery();
            }
            catch (SqlException sex)
            {
                if (sex.Number == 2627)
                {
                    System.IO.File.AppendAllText(pathString, "Urbano_Log repetido: " + dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                //MessageBox.Show(e.ToString());

            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:48，代码来源:Program.cs

示例3: checaOpcion

 private Object checaOpcion(SqlConnection mySqlConnection, DataRow dbRow, int op, string opcion)
 {
     try
     {
         var cmd = new SqlCommand();
         cmd.Parameters.Clear();
         cmd.Connection = mySqlConnection;
         cmd.CommandType = CommandType.Text;
         cmd.CommandText = @"select Num from Tomin.TominPredial.Opcion where Nombre = @opcion and Id_Catalogo = @op";
         cmd.Parameters.AddWithValue("@opcion", dbRow[opcion].ToString().Trim());
         cmd.Parameters.AddWithValue("@op", op);
         return cmd.ExecuteScalar();
     }
     catch (Exception e)
     {
         System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
         System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
         return 0;
     }
 }

开发者ID:poz2k4444，项目名称:tomin，代码行数:20，代码来源:Program.cs

示例4: insertaSuperficiesLog

        private void insertaSuperficiesLog(SqlConnection mySqlConnection, DataRow dbRow)
        {
            //MessageBox.Show("Entro");
            try
            {
                var cmd = new SqlCommand();
                cmd.Parameters.Clear();
                cmd.Connection = mySqlConnection;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"select MAX(Num) from Tomin.TominPredial.Superficie_Log Where Clave = @Clave";
                cmd.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                var num = cmd.ExecuteScalar();

                //MessageBox.Show("" + dbRow["CPRED"].ToString().Trim());
                if (num.Equals(DBNull.Value))
                {
                    //MesageBox.Show("Cero");
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Superficie_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Superficie],[Niveles])"
                                            + " VALUES (@accion, @user, @fecha, @Clave,@Num,@super,@niv)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Num", 1);
                        cmd1.Parameters.AddWithValue("@super", dbRow["SUP"].ToString().Trim());
                        try
                        {
                            cmd1.Parameters.AddWithValue("@niv", dbRow["NIVELES"].ToString().Trim());
                        }
                        catch (System.ArgumentException)
                        {
                            cmd1.Parameters.AddWithValue("@niv", 1);
                            cmd1.Parameters[6].Value = 1;
                            //MessageBox.Show(cmd1.Parameters[3].Value.ToString());
                        }
                        finally
                        {
                            cmd1.ExecuteNonQuery();
                        }
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
                else
                {
                    //MessageBox.Show("No cero");
                    int numero = Convert.ToInt32(num);
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Superficie_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Superficie],[Niveles])"
                                            + " VALUES (@accion, @user, @fecha, @Clave,@Num,@super,@niv)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Num", numero + 1);
                        cmd1.Parameters.AddWithValue("@super", dbRow["SUP"].ToString().Trim());
                        try
                        {
                            cmd1.Parameters.AddWithValue("@niv", dbRow["NIVELES"].ToString().Trim());
                        }
                        catch (System.ArgumentException)
                        {
                            cmd1.Parameters.AddWithValue("@niv", 1);
                            cmd1.Parameters[6].Value = 1;
                            //MessageBox.Show(cmd1.Parameters[3].Value.ToString());
                        }
                        finally
                        {
                            cmd1.ExecuteNonQuery();
                        }
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                MessageBox.Show(e.ToString());

//.........这里部分代码省略.........

开发者ID:poz2k4444，项目名称:tomin，代码行数:101，代码来源:Program.cs

示例5: insertaSuperCataLog

        private void insertaSuperCataLog(SqlConnection mySqlConnection, DataRow dbRow, string tipo, int tablaOp, string tabla)
        {
            try
            {
                var cmd = new SqlCommand();
                cmd.Parameters.Clear();
                cmd.Connection = mySqlConnection;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"select MAX(Num) from Tomin.TominPredial.SuperficieCatalogo_Log where Clave = @clave AND Id_Catalogo = @cat";
                cmd.Parameters.AddWithValue("@clave", dbRow["CPRED"].ToString().Trim());
                cmd.Parameters.AddWithValue("@cat", tablaOp);
                var num = cmd.ExecuteScalar();

                if (num.Equals(DBNull.Value))
                {
                    try
                    {
                        string opcion = Convert.ToString(checaOpcion(mySqlConnection, dbRow, tablaOp, tabla));
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[SuperficieCatalogo_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Id_Catalogo],[Valor],[Id_TipoPredio])"
                                            + " VALUES (@accion,@user,@fecha, @clave, @num, @cat,@valor, @tipo)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@num", 1);
                        cmd1.Parameters.AddWithValue("@cat", tablaOp);
                        cmd1.Parameters.AddWithValue("@valor", opcion);
                        cmd1.Parameters.AddWithValue("@tipo", tipo);
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
                else
                {
                    try
                    {
                        string opcion = Convert.ToString(checaOpcion(mySqlConnection, dbRow, tablaOp, tabla));
                        int numero = Convert.ToInt32(num);
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[SuperficieCatalogo_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Id_Catalogo],[Valor],[Id_TipoPredio])"
                                            + " VALUES (@accion,@user,@fecha,@clave, @num, @cat,@valor, @tipo)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@num", numero + 1);
                        cmd1.Parameters.AddWithValue("@cat", tablaOp);
                        cmd1.Parameters.AddWithValue("@valor", opcion);
                        cmd1.Parameters.AddWithValue("@tipo", tipo);
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                MessageBox.Show(e.ToString());
            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:78，代码来源:Program.cs

示例6: insertaRusticoLog

        private void insertaRusticoLog(SqlConnection mySqlConnection, DataRow dbRow, int id_com)
        {
            try
            {
                var cmd1 = new SqlCommand();
                cmd1.Parameters.Clear();
                cmd1.Connection = mySqlConnection;
                cmd1.CommandType = CommandType.Text;
                cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Rustico_Log] ([Id_Action],[Id_User],[Id_Date],"
                                    + "[Clave],[Id_Comunidad],[Referencia2]"
                                    + ",[NumHabitantes],[ValorSupRiego],[ValorSupTemporal],[ValorSupAgostadero],[ValorSupSolar]"
                                    + ",[ValorConstruccion])"
                                    + " VALUES (@Id_Action,@Id_User,@Id_Date,@Clave,@Id_Comunidad,@Referencia2,@NumHabitantes,@ValorSupRiego,@ValorSupTemporal,"
                                    + "@ValorSupAgostadero,@ValorSupSolar,@ValorConstruccion) ";
                cmd1.Parameters.AddWithValue("@Id_Action", 1);
                cmd1.Parameters.AddWithValue("@Id_User", "Admin");
                cmd1.Parameters.AddWithValue("@Id_Date", DateTime.Now);
                cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@Id_Comunidad", id_com);
                cmd1.Parameters.AddWithValue("@Referencia2", dbRow["UBICA"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@NumHabitantes", dbRow["RE_NUMHAB"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorSupRiego", dbRow["R_RIESUP"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorSupTemporal", dbRow["R_TEMSUP"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorSupAgostadero", dbRow["R_AGOSUP"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorSupSolar", dbRow["R_SOLSUP"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorConstruccion", dbRow["R_VALCATC"].ToString().Trim());
                cmd1.ExecuteNonQuery();
            }
            catch (SqlException sex)
            {
                if (sex.Number == 2627)
                {
                    System.IO.File.AppendAllText(pathString, "Rustico_Log repetido: " + dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                //MessageBox.Show(e.ToString());

            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:43，代码来源:Program.cs

示例7: insertaRustico

        private void insertaRustico(SqlConnection mySqlConnection, DataRow dbRow, int id_com)
        {
            try
            {
                double riego;
                double temp;
                double agost;
                double sol;
                double cons;

                if (!Double.TryParse(dbRow["R_RIESUP"].ToString().Trim(), out riego))
                {
                    riego = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["R_TEMSUP"].ToString().Trim(), out temp))
                {
                    temp = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["R_AGOSUP"].ToString().Trim(), out agost))
                {
                    agost = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["R_SOLSUP"].ToString().Trim(), out sol))
                {
                    sol = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["R_VALCATC"].ToString().Trim(), out cons))
                {
                    cons = 0.0; // or alert, or whatever.
                }
                var cmd1 = new SqlCommand();
                cmd1.Parameters.Clear();
                cmd1.Connection = mySqlConnection;
                cmd1.CommandType = CommandType.Text;
                cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Rustico] ([Clave],[Id_Comunidad],[Referencia2]"
                                    + ",[NumHabitantes],[ValorSupRiego],[ValorSupTemporal],[ValorSupAgostadero],[ValorSupSolar]"
                                    + ",[ValorConstruccion])"
                                    + " VALUES (@Clave,@Id_Comunidad,@Referencia2,@NumHabitantes,@ValorSupRiego,@ValorSupTemporal,"
                                    + "@ValorSupAgostadero,@ValorSupSolar,@ValorConstruccion) ";
                cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@Id_Comunidad", id_com);
                cmd1.Parameters.AddWithValue("@Referencia2", dbRow["UBICA"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@NumHabitantes", dbRow["RE_NUMHAB"].ToString().Trim());
                cmd1.Parameters.AddWithValue("@ValorSupRiego", riego);
                cmd1.Parameters.AddWithValue("@ValorSupTemporal", temp);
                cmd1.Parameters.AddWithValue("@ValorSupAgostadero", agost);
                cmd1.Parameters.AddWithValue("@ValorSupSolar", sol);
                cmd1.Parameters.AddWithValue("@ValorConstruccion", cons);
                cmd1.ExecuteNonQuery();
            }
            catch (SqlException sex)
            {
                MessageBox.Show(sex.Number.ToString());
                MessageBox.Show(sex.ToString());
                if (sex.Number == 2627)
                {
                    System.IO.File.AppendAllText(pathString, "Rustico repetido: " + dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                MessageBox.Show(e.ToString());

            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:67，代码来源:Program.cs

示例8: insertaPredioLog

        private void insertaPredioLog(SqlConnection mySqlConnection, DataRow dbRow, string tipo)
        {
            try
            {

                double refe;
                double terre;
                double fact;
                double cat;
                double fis;

                if (!Double.TryParse(dbRow["REF_ENTRE1"].ToString().Trim(), out refe))
                {
                    refe = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["U_TERRENO"].ToString().Trim(), out terre))
                {
                    terre = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["DEM_FACTOR"].ToString().Trim(), out fact))
                {
                    fact = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["VAL_CAT"].ToString().Trim(), out cat))
                {
                    cat = 0.0; // or alert, or whatever.
                }
                if (!Double.TryParse(dbRow["VAL_FIS"].ToString().Trim(), out fis))
                {
                    fis = 0.0; // or alert, or whatever.
                }
                var cmdPredio = new SqlCommand();
                cmdPredio.Parameters.Clear();
                cmdPredio.Connection = mySqlConnection;
                cmdPredio.CommandType = CommandType.Text;
                cmdPredio.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Predio_Log]"
                    + "([Id_Action],[Id_User],[Id_Date],[Clave],[Id_SubTipoPredio],[NumeroExt],[Referencia1],[EstatusIP],[Superficie],"
                    + "[ClaveAnt],[Escritura],[FactorDemerito],[NotaDemerito],[ValorCatastral],[ValorFiscal],[ValorAvaluo])"
                    + " VALUES"
                    + "(@Id_Action,@Id_User,@Id_Date,@cvePredio,@subPredio,@numExt,@referencia1,@estatusIP,@superficie,@cveAnt,@escritura,"
                    + "@factDemerito,@notaDemerito,@valCatastral,@valorFiscal, 0)";
                cmdPredio.Parameters.AddWithValue("@Id_Action", 1);
                cmdPredio.Parameters.AddWithValue("@Id_User", "Admin");
                cmdPredio.Parameters.AddWithValue("@Id_Date", DateTime.Now);
                cmdPredio.Parameters.AddWithValue("@cvePredio", dbRow["CPRED"].ToString().Trim());
                cmdPredio.Parameters.AddWithValue("@subPredio", tipo);
                cmdPredio.Parameters.AddWithValue("@numExt", dbRow["NUMEROEXT"].ToString().Trim());
                cmdPredio.Parameters.AddWithValue("@referencia1", refe);
                cmdPredio.Parameters.AddWithValue("@estatusIP", "N");
                cmdPredio.Parameters.AddWithValue("@superficie", terre);
                cmdPredio.Parameters.AddWithValue("@cveAnt", dbRow["CPREDANT"].ToString().Trim());
                cmdPredio.Parameters.AddWithValue("@escritura", dbRow["ESCRITURA"].ToString().Trim());
                cmdPredio.Parameters.AddWithValue("@factDemerito", fact);
                cmdPredio.Parameters.AddWithValue("@notaDemerito", dbRow["DEM_NOTAS"].ToString().Trim());
                cmdPredio.Parameters.AddWithValue("@valCatastral", cat);
                cmdPredio.Parameters.AddWithValue("@valorFiscal", fis);
                cmdPredio.ExecuteNonQuery();
            }
            catch (SqlException sex)
            {
                if (sex.Number == 2627)
                {
                    System.IO.File.AppendAllText(pathString, "Predio_Log repetido: " + dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                //MessageBox.Show("predio  " + e.ToString());
            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:72，代码来源:Program.cs

示例9: insertaPredioCatalogoUso

 private void insertaPredioCatalogoUso(SqlConnection mySqlConnection, DataRow dbRow, string tipo, int tablaOp, string tabla)
 {
     try
     {
         string opcion = Convert.ToString(checaOpcion(mySqlConnection, dbRow, tablaOp, tabla));
         var cmd1 = new SqlCommand();
         cmd1.Parameters.Clear();
         cmd1.Connection = mySqlConnection;
         cmd1.CommandType = CommandType.Text;
         cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[PredioCatalogo] ([Clave],[Id_Catalogo],[Valor],[Id_SubTipoPredio])"
                         + " VALUES (@clave, @cat, @valor, @tipo)";
         cmd1.Parameters.AddWithValue("@clave", dbRow["CPRED"].ToString().Trim());
         cmd1.Parameters.AddWithValue("@cat", tablaOp);
         cmd1.Parameters.AddWithValue("@valor", opcion);
         cmd1.Parameters.AddWithValue("@tipo", tipo);
         cmd1.ExecuteNonQuery();
     }
     catch (Exception e)
     {
         System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
         System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
         //MessageBox.Show(e.ToString());
     }
 }

开发者ID:poz2k4444，项目名称:tomin，代码行数:24，代码来源:Program.cs

示例10: insertaColindanciasLog

        private void insertaColindanciasLog(SqlConnection mySqlConnection, DataRow dbRow)
        {
            //MessageBox.Show("Entro");
            try
            {
                var cmd = new SqlCommand();
                cmd.Parameters.Clear();
                cmd.Connection = mySqlConnection;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"select MAX(Num) from Tomin.TominPredial.Colindancia_Log Where Clave = @Clave";
                cmd.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                var num = cmd.ExecuteScalar();

                //MessageBox.Show("" + dbRow["CPRED"].ToString().Trim());
                if (num.Equals(DBNull.Value))
                {
                    //MesageBox.Show("Cero");
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Colindancia_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Medida],[Notas])"
                                            + " VALUES (@accion, @user, @fecha,@Clave,@Num,@Medida,@Notas)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Num", 1);
                        cmd1.Parameters.AddWithValue("@Medida", dbRow["MEDIDA"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Notas", dbRow["COL_NOTAS"].ToString().Trim());
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
                else
                {
                    //MessageBox.Show("No cero");
                    int numero = Convert.ToInt32(num);
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Colindancia_Log] ([Id_Action],[Id_User],[Id_Date],[Clave],[Num],[Medida],[Notas])"
                                            + " VALUES (@accion, @user, @fecha,@Clave,@Num,@Medida,@Notas)";
                        cmd1.Parameters.AddWithValue("@accion", 1);
                        cmd1.Parameters.AddWithValue("@user", "Admin");
                        cmd1.Parameters.AddWithValue("@fecha", DateTime.Now);
                        cmd1.Parameters.AddWithValue("@Clave", dbRow["CPRED"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Num", numero + 1);
                        cmd1.Parameters.AddWithValue("@Medida", dbRow["MEDIDA"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Notas", dbRow["COL_NOTAS"].ToString().Trim());
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                MessageBox.Show(e.ToString());

            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:78，代码来源:Program.cs

示例11: insertaColindancias

        private void insertaColindancias(SqlConnection mySqlConnection, DataRow dbRow, string buena)
        {
            //MessageBox.Show("Entro");

            try
            {

                var cmd = new SqlCommand();
                cmd.Parameters.Clear();
                cmd.Connection = mySqlConnection;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"select MAX(Num) from Tomin.TominPredial.Colindancia Where Clave = @Clave";
                cmd.Parameters.AddWithValue("@Clave", buena);
                var num = cmd.ExecuteScalar();

                //MessageBox.Show("" + dbRow["CPRED"].ToString().Trim());
                if (num.Equals(DBNull.Value))
                {

                    //MesageBox.Show("Cero");
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Colindancia] ([Clave],[Num],[Medida],[Notas])"
                                            + " VALUES (@Clave,@Num,@Medida,@Notas)";
                        cmd1.Parameters.AddWithValue("@Clave", buena);
                        cmd1.Parameters.AddWithValue("@Num", 1);
                        cmd1.Parameters.AddWithValue("@Medida", dbRow["MEDIDA"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Notas", dbRow["COL_NOTAS"].ToString().Trim());
                        cmd1.ExecuteNonQuery();
                    }
                    catch (SqlException sex)
                    {
                        if (sex.Number == 547)
                        {
                            //System.IO.File.AppendAllText(pathString, dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                            //var so = checaPredio(mySqlConnection, dbRow);
                            //string buena = Convert.ToString(checaPredio(mySqlConnection, dbRow));
                        }
                        else
                        {
                            MessageBox.Show(sex.Number.ToString());
                        }
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(dbRow["CPRED"].ToString().Trim());
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                        MessageBox.Show(e.ToString());

                    }
                }
                else
                {
                    //MessageBox.Show("No cero");
                    int numero = Convert.ToInt32(num);
                    try
                    {
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[Colindancia]([Clave],[Num],[Medida],[Notas])"
                                            + " VALUES(@Clave,@Num,@Medida,@Notas)";
                        cmd1.Parameters.AddWithValue("@Clave", buena);
                        cmd1.Parameters.AddWithValue("@Num", numero + 1);
                        cmd1.Parameters.AddWithValue("@Medida", dbRow["MEDIDA"].ToString().Trim());
                        cmd1.Parameters.AddWithValue("@Notas", dbRow["COL_NOTAS"].ToString().Trim());
                        cmd1.ExecuteNonQuery();
                    }
                    catch (SqlException sex)
                    {
                        if (sex.Number == 547)
                        {
                            //System.IO.File.AppendAllText(pathString, dbRow["CPRED"].ToString().Trim() + Environment.NewLine);
                            //var so = checaPredio(mySqlConnection, dbRow);
                            //string buena = Convert.ToString(checaPredio(mySqlConnection, dbRow));
                        }
                        else
                        {
                            MessageBox.Show(sex.Number.ToString());
                        }
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        MessageBox.Show(e.ToString());
                    }
                }

            }
            catch (Exception e)
            {
                System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
//.........这里部分代码省略.........

开发者ID:poz2k4444，项目名称:tomin，代码行数:101，代码来源:Program.cs

示例12: insertaColinCata

        private void insertaColinCata(SqlConnection mySqlConnection, DataRow dbRow, string buena)
        {
            try
            {
                var cmd = new SqlCommand();
                cmd.Parameters.Clear();
                cmd.Connection = mySqlConnection;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"select MAX(Num) from Tomin.TominPredial.ColindanciaCatalogo where Clave = @clave";
                cmd.Parameters.AddWithValue("@clave", buena);
                var num = cmd.ExecuteScalar();

                if (num.Equals(DBNull.Value))
                {
                    try
                    {
                        string opcion = Convert.ToString(checaOpcion(mySqlConnection, dbRow, 21, "ORIENTA"));
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[ColindanciaCatalogo] ([Clave],[Num],[Id_Catalogo],[Valor])"
                                            + " VALUES (@clave, @num, @cat,@valor)";
                        cmd1.Parameters.AddWithValue("@clave", buena);
                        cmd1.Parameters.AddWithValue("@num", 1);
                        cmd1.Parameters.AddWithValue("@cat", 21);
                        cmd1.Parameters.AddWithValue("@valor", opcion);
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
                else
                {
                    try
                    {
                        string opcion = Convert.ToString(checaOpcion(mySqlConnection, dbRow, 21, "ORIENTA"));
                        int numero = Convert.ToInt32(num);
                        var cmd1 = new SqlCommand();
                        cmd1.Parameters.Clear();
                        cmd1.Connection = mySqlConnection;
                        cmd1.CommandType = CommandType.Text;
                        cmd1.CommandText = @"INSERT INTO [Tomin].[TominPredial].[ColindanciaCatalogo] ([Clave],[Num],[Id_Catalogo],[Valor])"
                                            + " VALUES (@clave, @num, @cat,@valor)";
                        cmd1.Parameters.AddWithValue("@clave", buena);
                        cmd1.Parameters.AddWithValue("@num", numero + 1);
                        cmd1.Parameters.AddWithValue("@cat", 21);
                        cmd1.Parameters.AddWithValue("@valor", opcion);
                        cmd1.ExecuteNonQuery();
                    }
                    catch (Exception e)
                    {
                        System.IO.File.AppendAllText(pathString, e.ToString() + Environment.NewLine);
                        System.IO.File.AppendAllText(pathString, dbRow.ToString() + Environment.NewLine);
                        //MessageBox.Show(e.ToString());
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
        }

开发者ID:poz2k4444，项目名称:tomin，代码行数:67，代码来源:Program.cs

注：本文中的System.Data.DataRow.ToString方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。