public bool Contains(ExpensesInfo value) { if (IndexOf(value) > -1) { return(true); } return(false); }
public static void InsertOrUpdatetoExpenses(ExpensesInfo info, out int iSuccess) { StringBuilder sb = new StringBuilder(); ExpensesInfo expenses = GetExpensesById(info.Id); if (expenses.Id > 0) { sb.Append(" update Expenses set OwnerId=@OwnerId,OwnerName=@OwnerName,SpendType=@SpendType,HowToUse=@HowToUse, "); sb.Append(" Price = @Price,Number = @Number,Amount=@Amount,SpendDate=@SpendDate,SpendMode=@SpendMode,ConsumerId=@ConsumerId,ConsumerName=@ConsumerName,Content=@Content"); sb.Append(" where Id=@Id"); } else { sb.Append(" insert into Expenses (OwnerId,OwnerName,CardId,CardNumber,BankCardNumber,SpendType,HowToUse,Price,Number,Amount,SpendDate,SpendMode,ConsumerId,ConsumerName,Content) "); sb.Append(" Values(@OwnerId,@OwnerName,@CardId,@CardNumber,@BankCardNumber, @SpendType,@HowToUse,@Price,@Number,@Amount,@SpendDate,@SpendMode,@ConsumerId,@ConsumerName,@Content)"); } MySqlParameter[] pars = new MySqlParameter[] { new MySqlParameter("@Id",MySqlDbType.Int32), new MySqlParameter("@OwnerId",MySqlDbType.Int32), new MySqlParameter("@OwnerName",MySqlDbType.String), new MySqlParameter("@CardId",MySqlDbType.Int32), new MySqlParameter("@CardNumber",MySqlDbType.String), new MySqlParameter("@BankCardNumber",MySqlDbType.String), new MySqlParameter("@SpendType",MySqlDbType.Int32), new MySqlParameter("@HowToUse",MySqlDbType.String), new MySqlParameter("@Price",MySqlDbType.Float), new MySqlParameter("@Number",MySqlDbType.Int32), new MySqlParameter("@Amount",MySqlDbType.Float), new MySqlParameter("@SpendDate",MySqlDbType.DateTime), new MySqlParameter("@SpendMode",MySqlDbType.Int32), new MySqlParameter("@ConsumerId",MySqlDbType.Int32), new MySqlParameter("@ConsumerName",MySqlDbType.String), new MySqlParameter("@Content",MySqlDbType.String) }; pars[0].Value = info.Id; pars[1].Value = info.OwnerId; pars[2].Value = info.OwnerName; pars[3].Value = info.CardId; pars[4].Value = info.CardNumber; pars[5].Value = info.BankCardNumber; pars[6].Value = info.SpendType; pars[7].Value = info.HowToUse; pars[8].Value = info.Price; pars[9].Value = info.Number; pars[10].Value = info.Amount; pars[11].Value = info.SpendDate; pars[12].Value = info.SpendMode; pars[13].Value = info.ConsumerId; pars[14].Value = info.ConsumerName; pars[15].Value = info.ConsumerName; iSuccess = MySqlDBHelper.ExecuteCommand(sb.ToString(), pars); if (expenses.Id > 0) { iSuccess = -1; } }
public int IndexOf(ExpensesInfo value) { for (int i = 0, count = this.List.Count; i < count; i++) { if (value.Equals(this.List[i] as ExpensesInfo)) { return(i); } } return(-1); }
public static ExpensesInfo GetExpensesById(int id) { ExpensesInfo expensesInfo = new ExpensesInfo(); StringBuilder sb = new StringBuilder(); sb.AppendFormat(" {0} ","select * from Expenses where id = @Id"); MySqlParameter par = new MySqlParameter("@Id", MySqlDbType.Int32); par.Value = id; using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(),par)) { while (reader.Read()) { expensesInfo = new ExpensesInfo(reader); } } return expensesInfo; }
public ExpensesInfo(ExpensesInfo expensesInfo) { this.id = expensesInfo.Id; this.ownerId = expensesInfo.OwnerId; this.ownerName = expensesInfo.OwnerName; this.cardId = expensesInfo.CardId; this.cardNumber = expensesInfo.CardNumber; this.bankCardNumber = expensesInfo.BankCardNumber; this.spendType = expensesInfo.SpendType; this.howToUse = expensesInfo.HowToUse; this.price = expensesInfo.Price; this.number = expensesInfo.Number; this.amount = expensesInfo.Amount; this.spendDate = expensesInfo.SpendDate; this.spendMode = expensesInfo.SpendMode; this.consumerId = expensesInfo.ConsumerId; this.consumerName = expensesInfo.ConsumerName; this.content = expensesInfo.Content; }
public override bool Equals(object obj) { if (!base.Equals(obj)) { return(false); } if (obj == null) { return(false); } if (this.GetType() != obj.GetType()) { return(false); } ExpensesInfo expensesInfo = obj as ExpensesInfo; return(this.id.Equals(expensesInfo.Id)); }
public static int InsertOrUpdatetoExpenses(ExpensesInfo info) { int iSuccess = 0; int uSuccess = 0; ExpensesInfo expenses = new ExpensesInfo(); if (info.Id > 0) { expenses = ExpensesDAL.GetExpensesById(info.Id); } ExpensesDAL.InsertOrUpdatetoExpenses(info, out iSuccess); if (iSuccess > 0 || iSuccess == -1) { CardInfo cardInfo = CardDAL.GetCardById(info.CardId); float amount = 0; float expenditureAmount = 0; if (info.Id > 0) { amount = cardInfo.Amount - (info.Amount - expenses.Amount); expenditureAmount = cardInfo.ExpenditureAmount + (info.Amount - expenses.Amount); } else { amount = cardInfo.Amount + info.Amount; expenditureAmount = cardInfo.ExpenditureAmount + info.Amount; } CardDAL.UpdateCardAmount(amount, expenditureAmount, info.CardId, 2, out uSuccess); } if (iSuccess > 0 && uSuccess > 0) { return 1; } else if (iSuccess == -1 && uSuccess > 0) { return -1; } else { return 0; } }
public static void AddTableRow(DataTable table, ExpensesInfo expensesInfo) { System.Data.DataRow dr = table.NewRow(); dr["Id"] = expensesInfo.id; dr["OwnerId"] = expensesInfo.ownerId; dr["OwnerName"] = expensesInfo.ownerName; dr["CardId"] = expensesInfo.cardId; dr["CardNumber"] = expensesInfo.cardNumber; dr["BankCardNumber"] = expensesInfo.bankCardNumber; dr["SpendType"] = expensesInfo.spendType; dr["HowToUse"] = expensesInfo.howToUse; dr["Price"] = expensesInfo.price; dr["Number"] = expensesInfo.number; dr["Amount"] = expensesInfo.amount; dr["SpendDate"] = expensesInfo.spendDate; dr["SpendMode"] = expensesInfo.spendMode; dr["ConsumerId"] = expensesInfo.consumerId; dr["ConsumerName"] = expensesInfo.consumerName; dr["Content"] = expensesInfo.content; table.Rows.Add(dr); }
public static int InsertOrUpdatetoExpenses(ExpensesInfo info) { return ExpensesProxy.InsertOrUpdatetoExpenses(info); }
/// <summary> /// Constructor using CcZlCzBillInfo array. /// </summary> /// <param name="value" /> public ExpensesCollection(ExpensesInfo[] value) { this.AddRange(value); }
public void Remove(ExpensesInfo value) { List.Remove(value); innerListChanged = true; }
public void Insert(int index, ExpensesInfo value) { List.Insert(index, value); innerListChanged = true; }
public int IndexOf(ExpensesInfo value) { for (int i = 0, count = this.List.Count; i < count; i++) { if (value.Equals(this.List[i] as ExpensesInfo)) return i; } return -1; }
public void CopyTo(ExpensesInfo[] array, int index) { this.List.CopyTo(array, index); }
public bool Contains(ExpensesInfo value) { if (IndexOf(value) > -1) return true; return false; }
public void AddRange(ExpensesInfo[] value) { for (int i = 0; (i < value.Length); i++) { this.Add(value[i]); } }
/// <summary> /// 新增提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExpensesAddSubmit_Click(object sender, EventArgs e) { #region 验证 ExpensesInfo expensesInfo = new ExpensesInfo(); if (Session["expensensEditFlag"].Equals("true")) { this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayExpensesEditdiv();", true); expensesInfo.Id = Convert.ToInt32(Request.QueryString["ExpensesId"]); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayExpensesAdddiv();", true); } if (string.IsNullOrEmpty(this.dropExpensesAddCardNumber.SelectedValue)) { Alert.Show(this, "请输入卡号!"); this.dropExpensesAddCardNumber.Focus(); return; } if (string.IsNullOrEmpty(this.txtExpensesAddAmount.Text.Trim())) { Alert.Show(this, "请输入支出金额!"); this.txtExpensesAddAmount.Focus(); return; } if (string.IsNullOrEmpty(this.txtExpensesAddSpendDate.Text.Trim())) { Alert.Show(this, "请输入支出日期!"); this.txtExpensesAddSpendDate.Focus(); return; } if (string.IsNullOrEmpty(this.dropExpensesAddOwner.SelectedValue)) { Alert.Show(this, "请输入资产所有者!"); this.dropExpensesAddOwner.Focus(); return; } if (string.IsNullOrEmpty(this.dropExpensesAddSpendType.SelectedValue)) { Alert.Show(this, "请输入消费方式!"); this.dropExpensesAddSpendType.Focus(); return; } if (string.IsNullOrEmpty(this.txtExpensesAddConsumerName.Text.Trim())) { Alert.Show(this, "请输入消费者!"); this.txtExpensesAddConsumerName.Focus(); return; } #endregion #region 赋值 expensesInfo.OwnerId = Convert.ToInt32(this.dropExpensesAddOwner.SelectedValue); expensesInfo.OwnerName = this.dropExpensesAddOwner.SelectedItem.Text; CardInfo cardInfo = CardMethods.GetCardById(Convert.ToInt32(this.dropExpensesAddCardNumber.SelectedValue)); expensesInfo.CardId = Convert.ToInt32(this.dropExpensesAddCardNumber.SelectedValue); expensesInfo.CardNumber = cardInfo.CardNumber; expensesInfo.BankCardNumber = this.dropExpensesAddCardNumber.SelectedItem.Text; expensesInfo.SpendType = Convert.ToInt32(this.dropExpensesAddSpendType.SelectedValue); expensesInfo.HowToUse = this.txtExpensesAddHowToUse.Text.Trim(); if (string.IsNullOrEmpty(this.txtExpensesAddPrice.Text.Trim())) { expensesInfo.Price = 0; } else { expensesInfo.Price = Convert.ToSingle(this.txtExpensesAddPrice.Text.Trim()); } if (string.IsNullOrEmpty(this.txtExpensesAddNumber.Text.Trim())) { expensesInfo.Number = 0; } else { expensesInfo.Number = Convert.ToInt32(this.txtExpensesAddNumber.Text.Trim()); } expensesInfo.Amount = Convert.ToSingle(this.txtExpensesAddAmount.Text.Trim()); expensesInfo.SpendDate = Convert.ToDateTime(this.txtExpensesAddSpendDate.Text.Trim()); expensesInfo.SpendMode = Convert.ToInt32(this.dropExpensesAddSpendMode.SelectedValue); UserInfo userInfo = UserMethods.GetUserByName(this.txtExpensesAddConsumerName.Text.Trim()); if (userInfo.Id > 0) { expensesInfo.ConsumerId = userInfo.Id; } else { expensesInfo.ConsumerId = 0; } expensesInfo.ConsumerName = this.txtExpensesAddConsumerName.Text.Trim(); expensesInfo.Content = this.txtExpensesAddContent.Text.Trim(); #endregion int iSuccess = ExpensesMethods.InsertOrUpdatetoExpenses(expensesInfo); this.ClientScript.RegisterStartupScript(this.GetType(), "", "DisplayExpensesAdddiv();", true); if (iSuccess > 0) { Alert.Show(this, "新增一条收入成功!"); } else if (iSuccess == -1) { Alert.Show(this, "修改成功!"); } else { Alert.Show(this, "操作失败!"); } InitializeExpensesAdd(new ExpensesInfo()); queryList = new List<QueryElement>(); BindExpensesListDataGrid(queryList); }
public int Add(ExpensesInfo value) { return(this.List.Add(value)); }
public int Add(ExpensesInfo value) { return this.List.Add(value); }
/// <summary> /// 新增初始化 /// </summary> /// <param name="info"></param> private void InitializeExpensesAdd(ExpensesInfo info) { InitializeDropExpensesDropControl(); if (info.Id > 0) { this.dropExpensesAddCardNumber.SelectedValue = info.CardId.ToString(); this.dropExpensesAddCardNumber.Enabled = false; this.dropExpensesAddOwner.Enabled = true; this.dropExpensesAddOwner.SelectedValue = info.OwnerId.ToString(); this.dropExpensesAddSpendMode.SelectedValue = info.SpendMode.ToString(); this.dropExpensesAddSpendType.SelectedValue = info.SpendType.ToString(); this.txtExpensesAddAmount.Text = info.Amount.ToString(); this.txtExpensesAddSpendDate.Text = info.SpendDate.ToString("yyyy-MM-dd"); this.txtExpensesAddConsumerName.Text = info.ConsumerName; this.txtExpensesAddHowToUse.Text = !string.IsNullOrEmpty(info.HowToUse) ? info.HowToUse : string.Empty; this.txtExpensesAddPrice.Text = !string.IsNullOrEmpty(info.Price.ToString()) ? info.Price.ToString() : string.Empty; this.txtExpensesAddNumber.Text = !string.IsNullOrEmpty(info.Number.ToString()) ? info.Number.ToString() : string.Empty; this.txtExpensesAddContent.Text = !string.IsNullOrEmpty(info.Content) ? info.Content : string.Empty; } else { this.dropExpensesAddCardNumber.Enabled = true; this.dropExpensesAddOwner.Enabled = false; this.dropExpensesAddCardNumber.SelectedValue = string.Empty; this.dropExpensesAddSpendMode.SelectedValue = string.Empty; this.dropExpensesAddSpendType.SelectedValue = string.Empty; this.txtExpensesAddAmount.Text = string.Empty; this.txtExpensesAddSpendDate.Text = string.Empty; this.txtExpensesAddConsumerName.Text = string.Empty; this.txtExpensesAddPrice.Text = string.Empty; this.txtExpensesAddNumber.Text = string.Empty; this.txtExpensesAddContent.Text = string.Empty; } dropExpensesAddCardNumber_SelectedIndexChanged(null, null); }