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; }
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; }