//对充值表的操作
public IList <Entity.Charge> CheckCharge(Entity.Charge charge)
{
Factory.Factory checkOutchargefac = new Factory.Factory();
IDal.CheckOut checkOutCharge = checkOutchargefac.checkOut();
IList <Entity.Charge> Lcharge = checkOutCharge.select(charge);
return(Lcharge);
}
public IList <Entity.Charge> select(Entity.Charge charge)
{
//throw new NotImplementedException();
SqlParameter[] para = { new SqlParameter("@UserID", charge.UserID),
new SqlParameter("@Ischeck", "未结账") };
string sql = "select * from charge_info where userID =@UserID and ischeck =@Ischeck";
DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, para);
IList <Entity.Charge> LCharge = DAL.CovertHelper <Entity.Charge> .ConvertToModel(table);
return(LCharge);
}
public bool IaddMoney(Entity.Charge charge)
{
//throw new NotImplementedException();
SqlParameter[] para = { new SqlParameter("@cardno", charge.CardNo),
new SqlParameter("@studentNO", charge.StudentNo),
new SqlParameter("@UserID", charge.UserID),
new SqlParameter("@Addmoney", charge.AddMoney),
new SqlParameter("@ischeck", "未结账") };
string sql = "insert into charge_info(cardno1,studentno,userid,addmoney,ischeck) values(@cardno,@studentNO,@UserID,@Addmoney,@ischeck)";
return(sqlhelper.ExecuteNonquery(sql, CommandType.Text, para));
}
public bool addCharge(Entity.Charge charge)
{
//对卡片金额的修改
Entity.Card card = new Entity.Card();
card.CardNo = Convert.ToInt16(charge.CardNo);
//查出来
Factory.Factory fact = new Factory.Factory();
IDal.IqueryCard queryCardno = fact.IExitCardno();
IList <Entity.Card> lCard = queryCardno.Select(card);
//修改
card.Money = lCard[0].Money + charge.AddMoney;
Factory.Factory factUpdateMoney = new Factory.Factory();
IDal.UpdateMoney UpdateMoneyBll = factUpdateMoney.Updatemoney();
UpdateMoneyBll.modify(card);
//在charge实体添加数据
Factory.Factory addChargefac = new Factory.Factory();
IDal.IaddMoney addCharge = addChargefac.addChargeAndReturn();
return(addCharge.IaddMoney(charge));
}
public bool addCharge(Entity.Charge charge)
{
BLL.AddChargeAndReturn addCharge = new BLL.AddChargeAndReturn();
return(addCharge.addCharge(charge));
}
//对充值表的操作
public IList <Entity.Charge> checkOutCharge(Entity.Charge charge)
{
BLL.CheckOutBLL checkOutcharge = new BLL.CheckOutBLL();
return(checkOutcharge.CheckCharge(charge));
}
private void txtregistered_Selected(object sender, TabControlEventArgs e)
{
if (e.TabPage == tabPage1)
{
try
{
this.card_infoTableAdapter.queryUserID(this.check_buyCard.Card_info, paraToolStripTextBox.Text);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
if (e.TabPage == tabPage2)
{
try
{
this.charge_infoTableAdapter1.queryCharge1(this.chargeDataSet3check_chargeCard.Charge_info, userIDToolStripTextBox.Text, ischeckToolStripTextBox.Text);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
if (e.TabPage == tabPage3)
{
try
{
this.returnCard_infoTableAdapter.QueryReturnCard(this.check_returnCard.ReturnCard_info, userIDToolStripTextBox1.Text, isCheckToolStripTextBox1.Text);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
if (e.TabPage == tabPage4)
{
if (CbUserID.Text == "")
{
MessageBox.Show("请选择用户名");
btCheckOut.Enabled = false;
return;
}
btCheckOut.Enabled = true;
Facade.CheckOutFacade Checkout = new Facade.CheckOutFacade();
//得到售卡张数
Entity.Card card = new Entity.Card();
card.UserID = CbUserID.Text.Trim();
IList <Entity.Card> Lcard = new List <Entity.Card>();
Lcard = Checkout.checkOutCard(card);
txtSellCard.Text = Lcard.Count.ToString();
//退卡张数
Entity.ReturnCard returnCard = new Entity.ReturnCard();
returnCard.UserID = CbUserID.Text.Trim();
IList <Entity.ReturnCard> LreturnCard = new List <Entity.ReturnCard>();
LreturnCard = Checkout.CheckOutReturnCard(returnCard);
txtReturnCard.Text = LreturnCard.Count.ToString();
//总售卡数
txtSumCount.Text = (Lcard.Count - LreturnCard.Count).ToString();
//退卡金额
int sumReturnMoney;
sumReturnMoney = 0;
for (int i = 0; i < LreturnCard.Count; i++)
{
sumReturnMoney += LreturnCard[i].ReturnMoney;
}
txtReturnMoney.Text = sumReturnMoney.ToString();
//充值金额
Entity.Charge Charge = new Entity.Charge();
Charge.UserID = CbUserID.Text.Trim();
Facade.CheckOutFacade charge = new Facade.CheckOutFacade();
IList <Entity.Charge> LchargeMoney = new List <Entity.Charge>();
LchargeMoney = charge.checkOutCharge(Charge);
int SumChargeMoney;
SumChargeMoney = 0;
for (int i = 0; i < LchargeMoney.Count; i++)
{
SumChargeMoney += LchargeMoney[i].AddMoney;
}
txtChargeMoney.Text = SumChargeMoney.ToString();
//应收金额
txtMoney.Text = (SumChargeMoney - sumReturnMoney).ToString();
if (e.TabPage == tabPage5)
{
this.Dispose();
}
}
}
private void button3_Click(object sender, EventArgs e)
{
//判空
if (txtStudentNo.Text == "")
{
txtStudentNo.Focus();
MessageBox.Show("请输入查询的内容~", "提示");
return;
}
if (txtCardNo.Text == "")
{
txtCardNo.Focus();
MessageBox.Show("请输入查询的内容~", "提示");
return;
}
if (txtMoney.Text == "")
{
txtMoney.Focus();
MessageBox.Show("请输入查询的内容~", "提示");
return;
}
if (comboBox1.Text == "")
{
comboBox1.Focus();
MessageBox.Show("请输入查询的内容~", "提示");
return;
}
//注册金额，不得小于最小的上机金额----------
//的金额是否满足要求
Entity.BasicData basicdate = new Entity.BasicData();
Facade.QueryBasicDateFacade queryBasicDate = new Facade.QueryBasicDateFacade();
IList <Entity.BasicData> LbasicDate = queryBasicDate.QueryBasicDate(basicdate);
if (Convert.ToInt16(txtMoney.Text) < LbasicDate[0].LeastMoney)
{
MessageBox.Show("您的注册余额不满足上使用条件，请修改！", "提示");
txtMoney.Focus();
return;
}
//显示学生的信息，确保有学生
//txtStudent 给到实体
Entity.Student student = new Entity.Student();
student.StudentNo = Convert.ToInt32(txtStudentNo.Text);
Facade.StudentFacade studentfacade = new Facade.StudentFacade();
IList <Entity.Student> Student = new List <Entity.Student>();
Student = studentfacade.studentfacade(student);
if (Student.Count == 0)
{
MessageBox.Show("没有该生的信息哦，可以选择添加该生的信息~");
return;
}
else
{
txtInfo.Text = "姓名：" + Student[0].Name + "\r\n" + "性别：" + Student[0].Sex + "\r\n" + "年级：" + Student[0].Grade + "\r\n" + "班级：" + Student[0].Class + "\r\n" + "专业：" + Student[0].Department + "\r\n";
}
//将卡号的信息传给实体card，然后和数据库绑定
Entity.Card card = new Entity.Card();
card.StudentNo = Convert.ToInt32(txtStudentNo.Text);
card.CardNo = Convert.ToInt32(txtCardNo.Text);
card.Money = Convert.ToInt32(txtMoney.Text);
//card.Type = listbox.Text .ToString();
card.Type = comboBox1.Text.Trim();
card.Notes = "使用";
card.Status = "未结账";
card.UserID = frmLogin.UserName;
//card.UserID = "YY";
//实体带给外观，返回该学号是否注册
Facade.QuerIesitCardno Queryisexit = new Facade.QuerIesitCardno();
IList <Entity.Card> QueryCardExit = new List <Entity.Card>();
QueryCardExit = Queryisexit.QuerIsexitcardno(card);
if (QueryCardExit.Count != 0)
{
MessageBox.Show("该学生已注册，无需注册", "提示");
//获取学生已注册的信息
card.CardNo = QueryCardExit[0].CardNo;
Facade.StudentMoneyFacade QueryCardno = new Facade.StudentMoneyFacade();
IList <Entity.Card> card_info = new List <Entity.Card>();
card_info = QueryCardno.StudentMoney(card);
txtInfo.Clear();
// txtInfo.Text = "姓名：" + card_info [0].StudentNo + "\r\n" + "性别：" + Student[0].Sex + "\r\n" + "年级：" + Student[0].Grade + "\r\n" + "班级：" + Student[0].Class + "\r\n" + "专业：" + Student[0].Department + "\r\n";
txtInfo.Text = "姓名：" + Student[0].Name + "\r\n" + "性别：" + Student[0].Sex + "\r\n" + "年级：" + Student[0].Grade + "\r\n" + "班级：" + Student[0].Class + "\r\n" + "专业：" + Student[0].Department + "\r\n" + "卡号：" + card_info[0].CardNo.ToString() + "\r\n";
txtCardNo.Text = "";
txtMoney.Text = "";
comboBox1.Text = "";
return;
}
else
{
//实体带给外观，返回是否有学号
Facade.StudentMoneyFacade QueryCardno = new Facade.StudentMoneyFacade();
IList <Entity.Card> card_info = new List <Entity.Card>();
card_info = QueryCardno.StudentMoney(card);
if (card_info.Count != 0)
{
MessageBox.Show("该卡号已被使用，请重新输入！");
return;
}
else
{
//实体带参给facade,完成添加
Facade.addCardFacade addCard = new Facade.addCardFacade();
bool falg;
falg = addCard.addCard(card);
if (falg == true)
{
MessageBox.Show("注册成功，您可以正常使用", "温馨提示");
}
//将注册的金额放到充值卡中
Entity.Charge charge = new Entity.Charge();
charge.CardNo = txtCardNo.Text;
charge.UserID = frmLogin.UserName;
charge.StudentNo = student.StudentNo;
charge.AddMoney = Convert.ToInt16(txtMoney.Text);
Facade.AddChargeAndReturn addMoney = new Facade.AddChargeAndReturn();
addMoney.addCharge(charge);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
//判空
if (txtcardno.Text == "")
{
MessageBox.Show("请输入卡号", "提示");
txtcardno.Focus();
return;
}
if (txtMoney.Text == "")
{
MessageBox.Show("请输入金额", "提示");
txtMoney.Focus();
return;
}
//金额是否满足充值条件
//的金额是否满足要求
Entity.BasicData basicdate = new Entity.BasicData();
Facade.QueryBasicDateFacade queryBasicDate = new Facade.QueryBasicDateFacade();
IList <Entity.BasicData> LbasicDate = queryBasicDate.QueryBasicDate(basicdate);
if (Convert.ToInt16(txtMoney.Text) < LbasicDate[0].LeastMoney)
{
MessageBox.Show("你的充值金额太少，请修改！", "提示");
txtMoney.Focus();
return;
}
//查询卡号是否存在，可以使用
Entity.Card card = new Entity.Card();
card.CardNo = Convert.ToInt16(txtcardno.Text);
Facade.QuerIesitCardno Queryisexit = new Facade.QuerIesitCardno();
IList <Entity.Card> QueryCardExit = new List <Entity.Card>();
QueryCardExit = Queryisexit.QuerIsexitcardno(card);
if (QueryCardExit.Count == 0)
{
MessageBox.Show("没有该卡号，请核对后充值！", "提示");
txtcardno.Text = "";
txtMoney.Text = "";
txtcardno.Focus();
return;
}
//可以充值，并在b层做逻辑判断，更新cardno中的money
else
{
Entity.Charge charge = new Entity.Charge();
charge.CardNo = txtcardno.Text;
charge.StudentNo = QueryCardExit[0].StudentNo;
charge.UserID = frmLogin.UserName; //----------------------------
//charge.UserID = "YY";
charge.AddMoney = Convert.ToInt16(txtMoney.Text);
Facade.AddChargeAndReturn addCharge = new Facade.AddChargeAndReturn();
bool flag;
flag = addCharge.addCharge(charge);
if (flag == true)
{
MessageBox.Show("充值成功！", "提示");
//txt.Text = "姓名：" + Student[0].Name + "\r\n" + "性别：" + Student[0].Sex + "\r\n" + "年级：" + Student[0].Grade + "\r\n" + "班级：" + Student[0].Class + "\r\n" + "专业：" + Student[0].Department + "\r\n";
//txt.Text ="学号："+ QueryCardExit[0].StudentNo +"\r\n"+"卡号:"+QueryCardExit[0].CardNo +"\r\n"+
return;
}
}
}
