/// <summary>
/// 取得商品資訊
/// </summary>
/// <param name="productId">商品編號</param>
/// <returns></returns>
public ProductVM GetOrderItem(int productId)
{
string sqlStatement = "select Name, Price, Cost, ProductDesc from TB_Product " +
" where ProductID = @in_prodid";
var data = new DynamicParameters();
data.Add("@in_prodid", productId, System.Data.DbType.Int32);
return(_databaseService.SingleQuery <ProductVM>(new DatabaseObject(_dbConfig.GetLocalDBConnStr(), sqlStatement, data)));
}
/// <summary>
/// 新增帳號
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public int AddUser(AccountForm account)
{
// 取得字尾
string salt = PasswordTools.GetRandomString(10);
// 取得加密字串
string encryptPassword = PasswordTools.GetSHA256Encrypt(account.password + salt);
UserData userData = new UserData()
{
Account = account.account,
Password = encryptPassword,
Salt = salt
};
string sqlStatement = " insert into TB_User (Account, Password, Salt, CreateDate, Status) " +
" values (@Account, @Password, @Salt, now(), 1)";
return(_databaseService.Insert(
new DatabaseObject(_dbConfig.GetLocalDBConnStr(), sqlStatement, userData)));
}
