Beispiel #1
0
 public int SaveOldType(oldType ot)
 {
     conn.Open();
     if (ot.typeID == 0)
     {
         cmd.CommandText = "insert into opTypeTB  (typeIndex,typeName) values(@typeIndex,@typeName)";
         cmd.Parameters.AddWithValue("@typeIndex", ot.typeIndex);
         cmd.Parameters.AddWithValue("@typeName", ot.typeName);
         cmd.ExecuteNonQuery();
         cmd.CommandText = "SELECT @@Identity ";
         ot.typeID = (int)cmd.ExecuteScalar();
     }
     else
     {
         cmd.CommandText = "update  opTypeTB set typeIndex=@typeIndex,typeName=@typeName  where typeID=@typeID";
         cmd.Parameters.AddWithValue("@typeIndex", ot.typeIndex);
         cmd.Parameters.AddWithValue("@typeName", ot.typeName);
         cmd.Parameters.AddWithValue("@typeID", ot.typeID);
         cmd.ExecuteNonQuery();
     }
     conn.Close();
     return ot.typeID;
 }
Beispiel #2
0
 public List<oldType> GetOldType()
 {
     List<oldType> ots = new List<oldType>();
     conn.Open();
     cmd.CommandText = "select * from opTypeTB order by typeIndex";
     dr = cmd.ExecuteReader();
     while (dr.Read())
     {
         oldType ot = new oldType();
         ot.typeID =Convert.ToInt32( dr["typeID"]);
         ot.typeIndex=Convert.ToInt32(dr["typeIndex"]);
         ot.typeName = dr["typeName"].ToString();
         ots.Add(ot);
     }
     conn.Close();
     return ots;
 }