public int Update(Tz888.Model.Card model) { int rowsAffected; SHA1 sha1 = SHA1.Create(); byte[] bytePassword = sha1.ComputeHash(Encoding.Unicode.GetBytes(model.Password)); SqlParameter[] parameters = { new SqlParameter("@CardNo", SqlDbType.BigInt, 8), new SqlParameter("@Password", SqlDbType.VarBinary, 50), new SqlParameter("@PointCount", SqlDbType.Float, 8), new SqlParameter("@IsPublish", SqlDbType.TinyInt, 1), new SqlParameter("@IsGift", SqlDbType.TinyInt, 1), new SqlParameter("@ChangeBy", SqlDbType.Char, 16), }; parameters[0].Value = model.CardNo; parameters[1].Value = bytePassword; parameters[2].Value = model.PointCount; parameters[3].Value = model.IsPublish; parameters[4].Value = model.IsGift; parameters[5].Value = model.ChangeBy; rowsAffected = DbHelperSQL.RunProcReturn("StrikeCardTab_Update", parameters); return(rowsAffected); }
public int Update(Tz888.Model.Card model) { return(dal.Update(model)); }
public int Insert(Tz888.Model.Card model) { return(dal.Insert(model)); }