public bool Insert(AutoNumInfo autoNumInfo) { StringBuilder sql=new StringBuilder(); sql.Append("INSERT INTO"); sql.Append(" [AutoNum]("); sql.Append("[KeyID],"); sql.Append("[Seed],"); sql.Append("[SeedDate],"); sql.Append("[Prefix],"); sql.Append("[Summary]"); sql.Append(") VALUES("); sql.Append("@KeyID,"); sql.Append("@Seed,"); sql.Append("@SeedDate,"); sql.Append("@Prefix,"); sql.Append("@Summary"); sql.Append(")"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms=new IDbDataParameter[]{ dbhelper.CreateParameter("@KeyID",autoNumInfo.KeyID), dbhelper.CreateParameter("@Seed",autoNumInfo.Seed), dbhelper.CreateParameter("@SeedDate",autoNumInfo.SeedDate), dbhelper.CreateParameter("@Prefix",autoNumInfo.Prefix), dbhelper.CreateParameter("@Summary",autoNumInfo.Summary) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }
/// <summary> /// Convert IDataReader To AutoNumInfo /// </summary> /// <param name="reader"></param> /// <returns></returns> public static AutoNumInfo SetValue(IDataReader reader) { AutoNumInfo info = new AutoNumInfo(); int keyIDIndex = reader.GetOrdinal("KeyID"); int seedIndex = reader.GetOrdinal("Seed"); int seedDateIndex = reader.GetOrdinal("SeedDate"); int prefixIndex = reader.GetOrdinal("Prefix"); int summaryIndex = reader.GetOrdinal("Summary"); info.KeyID = reader.GetInt32(keyIDIndex); info.Seed = reader.GetInt32(seedIndex); info.SeedDate = reader.GetDateTime(seedDateIndex); if(!reader.IsDBNull(prefixIndex)) info.Prefix = reader.GetString(prefixIndex); if(!reader.IsDBNull(summaryIndex)) info.Summary = reader.GetString(summaryIndex); return info; }
public bool Update(AutoNumInfo autoNumInfo) { StringBuilder sql = new StringBuilder(); sql.Append("UPDATE"); sql.Append(" [AutoNum]"); sql.Append(" SET"); sql.Append(" [Seed]=@Seed,"); sql.Append(" [SeedDate]=@SeedDate,"); sql.Append(" [Prefix]=@Prefix,"); sql.Append(" [Summary]=@Summary"); sql.Append(" WHERE"); sql.Append(" [KeyID]=@KeyID"); using(NetShopHelper dbhelper=new NetShopHelper()) { IDbDataParameter[] p_Parms = new IDbDataParameter[]{ dbhelper.CreateParameter("@KeyID",autoNumInfo.KeyID) }; return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms); } }