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