public bool Insert(CustomerInfo customerInfo)
{
StringBuilder sql=new StringBuilder();
sql.Append("INSERT INTO");
sql.Append(" [Tbl_Customer](");
sql.Append("[CustomerNO],");
sql.Append("[Email],");
sql.Append("[Password],");
sql.Append("[NickName],");
sql.Append("[Telephone],");
sql.Append("[Mobile]");
sql.Append(") VALUES(");
sql.Append("@CustomerNO,");
sql.Append("@Email,");
sql.Append("@Password,");
sql.Append("@NickName,");
sql.Append("@Telephone,");
sql.Append("@Mobile");
sql.Append(")");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms=new IDbDataParameter[]{
dbhelper.CreateParameter("@CustomerNO",customerInfo.CustomerNO),
dbhelper.CreateParameter("@Email",customerInfo.Email),
dbhelper.CreateParameter("@Password",customerInfo.Password),
dbhelper.CreateParameter("@NickName",customerInfo.NickName),
dbhelper.CreateParameter("@Telephone",customerInfo.Telephone),
dbhelper.CreateParameter("@Mobile",customerInfo.Mobile)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
/// <summary>
/// Convert IDataReader To CustomerInfo
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static CustomerInfo SetValue(IDataReader reader)
{
CustomerInfo info = new CustomerInfo();
int customerNOIndex = reader.GetOrdinal("CustomerNO");
int emailIndex = reader.GetOrdinal("Email");
int passwordIndex = reader.GetOrdinal("Password");
int nickNameIndex = reader.GetOrdinal("NickName");
int telephoneIndex = reader.GetOrdinal("Telephone");
int mobileIndex = reader.GetOrdinal("Mobile");
info.CustomerNO = reader.GetString(customerNOIndex);
info.Email = reader.GetString(emailIndex);
info.Password = reader.GetString(passwordIndex);
info.NickName = reader.GetString(nickNameIndex);
if(!reader.IsDBNull(telephoneIndex))
info.Telephone = reader.GetString(telephoneIndex);
if(!reader.IsDBNull(mobileIndex))
info.Mobile = reader.GetString(mobileIndex);
return info;
}
public bool Update(CustomerInfo customerInfo)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE");
sql.Append(" [Tbl_Customer]");
sql.Append(" SET");
sql.Append(" [Email]=@Email,");
sql.Append(" [Password]=@Password,");
sql.Append(" [NickName]=@NickName,");
sql.Append(" [Telephone]=@Telephone,");
sql.Append(" [Mobile]=@Mobile");
sql.Append(" WHERE");
sql.Append(" [CustomerNO]=@CustomerNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@CustomerNO",customerInfo.CustomerNO)
};
return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
}
}
