private List <SQLiteParameter> fillParameters(MemberCardCategoryValue model)
{
SQLiteParameter[] parameters =
{
new SQLiteParameter("@title", DbType.Int32, 11),
new SQLiteParameter("@member_card_category_id", DbType.Int32, 10),
new SQLiteParameter("@money", DbType.Decimal, 11),
new SQLiteParameter("@vaild_value", DbType.Int32, 11),
new SQLiteParameter("@value_num", DbType.Int32, 11),
new SQLiteParameter("@vaild_unit", DbType.String, 11),
new SQLiteParameter("@goods_id", DbType.Int32, 11),
new SQLiteParameter("@created_at", DbType.Int32, 11),
new SQLiteParameter("@updated_at", DbType.Int32, 11),
};
parameters[0].Value = model.Title;
parameters[1].Value = model.MemberCardCategoryId;
parameters[2].Value = model.Money;
parameters[3].Value = model.VaildValue;
parameters[4].Value = model.ValueNum;
parameters[5].Value = model.ValidUnit;
parameters[6].Value = model.GoodsId;
parameters[7].Value = model.CreatedAt;
parameters[8].Value = model.UpdatedAt;
return(parameters.ToList());
}
private void setMoneyAndNum()
{
MemberCardCategoryValue value = this.cmbMoney.SelectedItem as MemberCardCategoryValue;
if (value == null)
{
return;
}
this.validTime.Value = this.setExpireDate(value.ValidUnit, value.VaildValue);
this.txtMoney.Text = value.Money.ToString();
}
private void btnSubmit_Click(object sender, System.EventArgs e)
{
if (String.IsNullOrEmpty(this.txtMoney.Text.Trim()))
{
MessageBox.Show("请先选择充值次数及金额!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (this.card.Record == null || this.card.Record.Status == Status.Disabled)
{
this.card.Record = new MemberCardRecord();
this.card.Record.MemberCardId = this.card.Id;
this.card.Record.CreatedAt = TimeStamp.GetNowTimeStamp();
}
MemberCardCategoryValue cat = this.cmbMoney.SelectedItem as MemberCardCategoryValue;
this.card.Record.Balance += cat.ValueNum;
this.card.Record.BeginAt = TimeStamp.ConvertDateTimeInt(DateTime.Now.Date);
this.card.Record.ExpiredAt = TimeStamp.ConvertDateTimeInt(this.validTime.Value.Date.AddHours(23));
if (this.card.Record.Id > 0 ? recordBll.EditMemberCardRecord(this.card.Record) : recordBll.AddMemberCardRecord(this.card.Record))
{
SaleLog log = new SaleLog();
log.CreatedAt = TimeStamp.ConvertDateTimeInt(DateTime.Now);
log.MemberId = this.card.Id;
log.MemberNo = this.card.CardNo;
log.GoodsId = cat.GoodsId;
log.Money = Convert.ToDecimal(this.txtMoney.Text.Trim());
log.Summary = String.Format("卡号：{0}在{1}充值{2}元", this.card.CardNo, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), cat.Money);
saleBll.AddLog(log);
Callback(log.Summary);
this.labMoney.Text = String.Format("帐户剩余次数：{0}次", this.card.Record.Balance.ToString());
}
this.btnSubmit.Enabled = false;
this.validTime.Visible = false;
this.labTip.Visible = false;
this.card = null;
this.cmbMoney.DataSource = null;
this.txtMoney.Clear();
MessageBox.Show("充值成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private MemberCardCategoryValue fillObject(SQLiteDataReader rdr)
{
MemberCardCategoryValue value = null;
if (rdr.Read())
{
value = new MemberCardCategoryValue();
value.Title = rdr["title"] == DBNull.Value ? "" : rdr["title"].ToString();
value.Id = rdr["id"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["id"]);
value.MemberCardCategoryId = rdr["member_card_category_id"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["member_card_category_id"]);
value.Money = rdr["money"] == DBNull.Value ? 0 : Convert.ToDecimal(rdr["money"]);
value.VaildValue = rdr["vaild_value"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["vaild_value"]);
value.ValueNum = rdr["value_num"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["value_num"]);
value.ValidUnit = rdr["vaild_unit"] == DBNull.Value
? 0
: (ValidUnit)Enum.Parse(typeof(ValidUnit), rdr["vaild_unit"].ToString(), false);
value.GoodsId = rdr["goods_id"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["goods_id"]);
value.CreatedAt = rdr["created_at"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["created_at"]);
value.UpdatedAt = rdr["updated_at"] == DBNull.Value ? 0 : Convert.ToInt32(rdr["updated_at"]);
}
return(value);
}
private List <MemberCardCategoryValue> query(String sql)
{
List <MemberCardCategoryValue> list = null;
using (SQLiteDataReader rdr = Tools.SQLiteHelper.ExecuteReader(Tools.SQLiteHelper.ConnectionStringLocalTransaction, CommandType.Text, sql))
{
while (true)
{
if (list == null)
{
list = new List <MemberCardCategoryValue>();
}
MemberCardCategoryValue category = fillObject(rdr);
if (category == null)
{
break;
}
list.Add(category);
}
}
return(list);
}
public bool AddMemberCardCategoryValue(MemberCardCategoryValue model)
{
throw new System.NotImplementedException();
}
