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