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 void NotifyAbout(IViewElement message)
{
ViewExpensesInfo expensesInfo = (ViewExpensesInfo)message;
NewExpensesId = expensesInfo.Id;
NewExpensesValue = expensesInfo.Expenditure;
NewExpensesType = EnumWorker.GetValueFromDescription(expensesInfo.ExpensesType);
NewExpensesDate = DateTime.Parse(expensesInfo.CostsDate);
NewExpensesComment = expensesInfo.Comment;
oldMoneyElement = (ExpensesInfo)message.ConvertToBO();
}
private void BindExpensesListDataGrid(List <QueryElement> list)
{
ExpensesCollection coll = ExpensesMethods.GetExpensesList(list);
this.ExpensesListDataGrid.DataSource = coll;
this.ExpensesListDataGrid.DataBind();
for (int i = 0; i < coll.Count; i++)
{
ExpensesInfo expenses = coll[i];
CardInfo cardInfo = CardMethods.GetCardByCardNumber(expenses.CardNumber, expenses.OwnerId);
string bank = StaticRescourse.DisplayBank(cardInfo.BankId);
this.ExpensesListDataGrid.Items[i].Cells[4].Text = StaticRescourse.DisplaySpendType(expenses.SpendType);
this.ExpensesListDataGrid.Items[i].Cells[6].Text = expenses.SpendDate.ToString("yyyy-MM-dd");
this.ExpensesListDataGrid.Items[i].Cells[7].Text = StaticRescourse.DisplaySpendMode(expenses.SpendMode);
}
}
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 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);
}
}
private List <IBusinessObject> ConvertCollToBO(List <DtoObject> newColl)
{
List <IBusinessObject> lstDtoItems = new List <IBusinessObject>();
foreach (DtoObject item in newColl)
{
if (item is ExpensesDto)
{
ExpensesDto dto = (ExpensesDto)item;
ExpensesInfo newExp = new ExpensesInfo(dto.Id,
MoneyWorker.ChangeCurrency(dto.AmountOfMoney,
Enum.Parse(typeof(ExchangeRateEnum), ((ExchangeRateEnum)dto.Currency).ToString()).ToString(),
DefaultValuesForControllers.Instance.DefaultExchangeRate,
DefaultValuesForControllers.Instance.DefaultDecimals),
dto.Comment, dto.DateOfOperation, (ExpensesType)dto.ExpensesType);
lstDtoItems.Add(newExp);
}
}
return(lstDtoItems);
}
/// <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);
}
public static int InsertOrUpdatetoExpenses(ExpensesInfo info)
{
return(ExpensesProxy.InsertOrUpdatetoExpenses(info));
}
/// <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);
}
