public void Insert(IDbConnection cn, YZSoft.Web.BPA.SpriteIdentity spriteIdentity)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = cn as OracleConnection;
cmd.BindByName = true;
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO BPASpriteIdentity(");
sb.Append("FileID,");
sb.Append("SpriteID,");
sb.Append("Name) ");
sb.Append("VALUES(");
sb.Append(":FileID,");
sb.Append(":SpriteID,");
sb.Append(":Name)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add(":FileID", OracleDbType.NVarchar2).Value = this.Convert(spriteIdentity.FileID, false);
cmd.Parameters.Add(":SpriteID", OracleDbType.NVarchar2).Value = this.Convert(spriteIdentity.SpriteID, false);
cmd.Parameters.Add(":Name", OracleDbType.NVarchar2).Value = this.Convert(spriteIdentity.Name, true);
cmd.ExecuteNonQuery();
}
}
public void Insert(IDbConnection cn, YZSoft.Web.BPA.SpriteIdentity spriteIdentity) //uu1uu
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn as SqlConnection;
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO BPASpriteIdentity(");
sb.Append("FileID,");
sb.Append("SpriteID,");
sb.Append("Name) ");
sb.Append("VALUES(");
sb.Append("@FileID,");
sb.Append("@SpriteID,");
sb.Append("@Name)");
cmd.CommandText = sb.ToString();
cmd.Parameters.Add("@FileID", SqlDbType.NVarChar).Value = this.Convert(spriteIdentity.FileID, false);
cmd.Parameters.Add("@SpriteID", SqlDbType.NVarChar).Value = this.Convert(spriteIdentity.SpriteID, false);
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = this.Convert(spriteIdentity.Name, true);
cmd.ExecuteNonQuery();
}
}