/// <summary>
/// 获得代用券信息
/// </summary>
/// <param name="voucherbatchid"></param>
/// <returns></returns>
public static Flamingo.Entity.Para_Voucher GetVoucherSubstitute(string voucherbatchid)
{
MySqlParameter[] parameters =
{
new MySqlParameter("@_VoucherBatchId", MySqlDbType.VarChar, 10)
};
parameters[0].Value = voucherbatchid;
DataTable dt = DbHelperMySQL.RunProcedure("proc_voucherbatch_getByVoucherBatchId", parameters, "getByVoucherBatchId").Tables[0];
Flamingo.Entity.Para_Voucher model = new Entity.Para_Voucher();
if (dt.Rows.Count > 0)
{
model.VoucherBatchId = dt.Rows[0]["VoucherBatchId"].ToString();
model.VoucherName = dt.Rows[0]["VoucherName"].ToString();
model.VoucherTypeId = Int32.Parse(dt.Rows[0]["VoucherTypeId"].ToString());
model.VoucherType = dt.Rows[0]["VoucherTypeName"].ToString();
model.BeginDate = DateTime.Parse(dt.Rows[0]["ReleaseDate"].ToString());
model.EndDate = DateTime.Parse(dt.Rows[0]["ExpireDate"].ToString());
model.Price = float.Parse(dt.Rows[0]["UnitPrice"].ToString());
model.SerialScope = dt.Rows[0]["SerialScope"].ToString();
model.VoucherPrice = float.Parse(dt.Rows[0]["VoucherPrice"].ToString());
model.VoucherSubTypeId = Int32.Parse(dt.Rows[0]["VoucherSubTypeId"].ToString());
model.VoucherSubType = dt.Rows[0]["VoucherSubTypeName"].ToString();
model.AllowUse = true;
model.ErrorMsg = string.Empty;
}
return(model);
}
/// <summary>
/// 获得票券信息(优惠券/兑换券)
/// </summary>
/// <param name="voucherid">票券ID(编号)</param>
/// <returns></returns>
public static Flamingo.Entity.Para_Voucher GetVoucher(string voucherid)
{
MySqlParameter[] parameters =
{
new MySqlParameter("@_VoucherId", MySqlDbType.VarChar, 16),
new MySqlParameter("@_HasUsed", MySqlDbType.Bit)
};
parameters[0].Value = voucherid;
parameters[1].Direction = ParameterDirection.Output;
DataTable dt = DbHelperMySQL.RunProcedure("proc_voucherbatch_getByVoucherId", parameters, "getByVoucherId").Tables[0];
bool tf = parameters[1].Value.ToString().Trim() == "1" ? true : false;
Flamingo.Entity.Para_Voucher model = new Entity.Para_Voucher();
if (dt.Rows.Count > 0)
{
model.VoucherBatchId = dt.Rows[0]["VoucherBatchId"].ToString();
model.VoucherId = voucherid;
model.VoucherName = dt.Rows[0]["VoucherName"].ToString();
model.VoucherTypeId = Int32.Parse(dt.Rows[0]["VoucherTypeId"].ToString());
model.VoucherType = dt.Rows[0]["VoucherTypeName"].ToString();
model.BeginDate = DateTime.Parse(dt.Rows[0]["ReleaseDate"].ToString());
model.EndDate = DateTime.Parse(dt.Rows[0]["ExpireDate"].ToString());
model.Price = float.Parse(dt.Rows[0]["UnitPrice"].ToString());
model.SerialScope = dt.Rows[0]["SerialScope"].ToString();
model.TemplateId = 0;// Int32.Parse(dt.Rows[0]["TemplateId"].ToString());
model.VoucherPrice = float.Parse(dt.Rows[0]["VoucherPrice"].ToString());
model.VoucherSubTypeId = Int32.Parse(dt.Rows[0]["VoucherSubTypeId"].ToString());
model.VoucherSubType = dt.Rows[0]["VoucherSubTypeName"].ToString();
model.AllowUse = true;
model.ErrorMsg = string.Empty;
if (tf == true)
{
model.AllowUse = false;
model.ErrorMsg = "票券已被使用";
}
}
return(model);
}
