private void btnChongZhi_Click(object sender, EventArgs e)
{
DataOperator dop = new DataOperator(UccRuntime.SqlConfig);
User user = new User();
user.UserID = this.txtUserID.Text;
user = dop.SelectSingle(user) as User;
double shishou = 0;
if (double.TryParse(this.txtShiShou.Text, out shishou))
user.Money += shishou;
double zengsong = 0;
if (double.TryParse(this.txtZengSong.Text, out zengsong))
user.Money += zengsong;
//user.Money = double.Parse(this.txtMoney.Text) + double.Parse(this.txtShiShou.Text) + int.Parse(this.txtZengSong.Text);
dop.Update(user);
MoneyHistory history = new MoneyHistory();
history.UserID = this.txtUserID.Text;
history.UserName = this.txtUserName.Text;
history.MoneyID = "M" + DateTime.Now.ToString("yyyyMMdd") + dop.Count<MoneyHistory>();
history.MoneyTime = DateTime.Now;
history.ShiShouMoney = shishou;
history.ZengSongMoney = zengsong;
dop.Insert(history);
dop.Commit();
MessageBox.Show("操作成功！");
}
private void btnSearch_Click(object sender, EventArgs e)
{
User u = new User();
u.UserID = this.txtUserID.Text;
u = UccRuntime.Dop.SelectSingle(u) as User;
if(u==null)
{
MessageBox.Show("会员不存在！请输入正确的会员卡号！");
return;
}
MoneyHistory history = new MoneyHistory();
history.UserID = u.UserID;
var list = UccRuntime.Dop.SelectAll<MoneyHistory>(history);
this.Bind(list);
}
private void txtDoMoney_Click(object sender, EventArgs e)
{
User u = new User();
u.UserID = this.txtUserID.Text;
u = UccRuntime.Dop.SelectSingle(u) as User;
u.Money = u.Money - double.Parse(this.txtTicketMoney.Text);
MoneyHistory history = new MoneyHistory();
history.Money = -double.Parse(this.txtTicketMoney.Text);
history.MoneyID = "M" + DateTime.Now.ToString("yyyyMMdd") + UccRuntime.Dop.Count<MoneyHistory>();
history.ShiShouMoney = history.Money;
history.UserID = this.txtUserID.Text;
history.UserName = u.UserName;
history.BeiZhu = this.txtTicketID.Text;
history.MoneyTime = DateTime.Now;
UccRuntime.Dop.Update(u);
UccRuntime.Dop.Insert(history);
UccRuntime.Dop.Commit();
MessageBox.Show("收款成功！");
}
private void btnShouKuan_Click(object sender, EventArgs e)
{
try
{
MoneyHistory history = new MoneyHistory();
history.MoneyID = "M" + DateTime.Now.ToString("yyyyMMdd") + UccRuntime.Dop.Count<MoneyHistory>();
history.Money = string.IsNullOrEmpty(this.txtMoney.Text) ? 0 : -double.Parse(this.txtThisMoney.Text);
history.MoneyTime = DateTime.Now;
User user = new User();
if (!string.IsNullOrEmpty(this.txtUserID.Text))
{
user.UserID = this.txtUserID.Text;
user = UccRuntime.Dop.SelectSingle(user) as User;
history.BeforeMoney = user.Money;
history.UserID = user.UserID;
history.UserName = user.UserName;
user.Money += history.Money;
}
else
{
user.UserName = this.txtUserName.Text;
}
Ticket.TicketID = this.txtTicketID.Text;
Ticket = UccRuntime.Dop.SelectSingle(Ticket) as ShouYi;
Ticket.MoneyState = "已付";
this.cbxMoneyState.Text = "已付";
UccRuntime.Dop.Insert(history);
if (user != null)
UccRuntime.Dop.Update(user);
UccRuntime.Dop.Update(Ticket);
MessageBox.Show("操作成功！");
}
catch(Exception ex)
{
MessageBox.Show("操作失败！"+ex.Message);
}
}
