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