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 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 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);
}
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);
}
/// <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 void Remove(ExpensesInfo value)
{
List.Remove(value);
innerListChanged = true;
}
public void Insert(int index, ExpensesInfo value)
{
List.Insert(index, value);
innerListChanged = true;
}
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);
}
