本文整理汇总了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;
}
示例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());
}
}
示例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;
}
}
示例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());
//.........这里部分代码省略.........
示例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());
}
}
示例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());
}
}
示例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());
}
}
示例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());
}
}
示例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());
}
}
示例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());
}
}
示例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);
//.........这里部分代码省略.........
示例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());
}
}