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