private void button2_Click(object sender, EventArgs e) { //判空 foreach (Control con in this.Controls) { if (con.Text == "" && con is TextBox) { MessageBox.Show("请将内容填写完整", "提示"); con.Focus(); return; } } //改 Entity.BasicData basicDate = new Entity.BasicData(); basicDate.Rate = Convert.ToInt16(txtFixUser.Text); basicDate.TmpRate = Convert.ToInt16(txtTmUser.Text); basicDate.UntilTime = Convert.ToInt16(txtLeastTime.Text); basicDate.PreparyTime = Convert.ToInt16(txtReadyTime.Text); basicDate.LeastMoney = Convert.ToInt16(txtLeastMoney.Text); Facade.ModifyBasicDate modifyBasic = new Facade.ModifyBasicDate(); modifyBasic.modifyBasicFacade(basicDate); MessageBox.Show("修改成功!", "提示"); panel1.Enabled = false; return; }
public IList <Entity.BasicData> select(Entity.BasicData basicdate) { SqlParameter[] sqlparams = { null }; string sql = "select * from basicdata_info "; DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text); IList <Entity.BasicData> LBasicDate = DAL.CovertHelper <Entity.BasicData> .ConvertToModel(table); return(LBasicDate); }
public void ModifyBasicDate(Entity.BasicData basicDate) { //throw new NotImplementedException(); SqlParameter[] para = { new SqlParameter("@rate", basicDate.Rate), new SqlParameter("@tmprate", basicDate.TmpRate), new SqlParameter("@UntilTime", basicDate.UntilTime), new SqlParameter("@preparyTime", basicDate.PreparyTime), new SqlParameter("@leastmoney", basicDate.LeastMoney) }; string sql = "update basicdata_info set rate =@rate,tmpRate=@tmprate,untiltime=@UntilTime,preparytime=@preparyTime,leastmoney=@leastmoney"; DAL.sqlhelper.ExecuteNonquery(sql, CommandType.Text, para); }
private void frmBasicDate_Load(object sender, EventArgs e) { //将数据库中的内容读出来 Entity.BasicData basicDate = new Entity.BasicData(); Facade.QueryBasicDateFacade basicDatefacade = new Facade.QueryBasicDateFacade(); IList <Entity.BasicData> lbasicDate = new List <Entity.BasicData>(); lbasicDate = basicDatefacade.QueryBasicDate(basicDate); txtFixUser.Text = lbasicDate[0].Rate.ToString(); txtTmUser.Text = lbasicDate[0].TmpRate.ToString(); txtLeastTime.Text = lbasicDate[0].UntilTime.ToString(); txtReadyTime.Text = lbasicDate[0].PreparyTime.ToString(); txtLeastMoney.Text = lbasicDate[0].LeastMoney.ToString(); }
public void modifyBasicFacade(Entity.BasicData basicDate) { BLL.ModifyBasicDateBll modifyBasic = new BLL.ModifyBasicDateBll(); modifyBasic.modifyBasicDate(basicDate); }
/// <summary> /// 上机 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { Entity.Card card = new Entity.Card(); //卡号 card.CardNo = Convert.ToInt16(txtCardno.Text.Trim()); // Facade.QuerIesitCardno queryExitCardno = new Facade.QuerIesitCardno(); Facade.QueyExitCardno queryExitCardno = new Facade.QueyExitCardno(); IList <Entity.Card> lCard = new List <Entity.Card>(); lCard = queryExitCardno.queryExitCardno(card); if (lCard.Count == 0) { MessageBox.Show("请确定该卡号是否可用!"); txtCardno.Text = ""; } else { //判断上机的金额是否满足要求 Entity.BasicData basicdate = new Entity.BasicData(); Facade.QueryBasicDateFacade queryBasicDate = new Facade.QueryBasicDateFacade(); IList <Entity.BasicData> LbasicDate = queryBasicDate.QueryBasicDate(basicdate); if (lCard[0].Money < LbasicDate[0].LeastMoney) { MessageBox.Show("您的余额不满足上机条件,请充值!"); } else { //正在上机不符合条件--2017.01.20 Entity.online online = new Entity.online(); online.CardNo = Convert.ToInt16(txtCardno.Text.Trim()); Facade.IsOnlineFacade IsOnline = new Facade.IsOnlineFacade(); IList <Entity.online> lonline = new List <Entity.online>(); lonline = IsOnline.IsOnline(online); if (lonline.Count != 0) { MessageBox.Show("该卡号正在上机,请重新选择卡号!"); } else { Entity.Student student = new Entity.Student(); student.StudentNo = lCard[0].StudentNo; Facade.StudentFacade studentinfo = new Facade.StudentFacade(); IList <Entity.Student> lstudent = new List <Entity.Student>(); lstudent = studentinfo.studentfacade(student); txtStudentNo.Text = lstudent[0].StudentNo.ToString(); txtName.Text = lstudent[0].Name; txtSex.Text = lstudent[0].Sex.ToString(); txtType.Text = lstudent[0].Notes.ToString(); //将正在上机的信息读入onlie表 // Entity.online online = new Entity.online(); online.CardNo = lCard[0].CardNo; online.StudentNo = lCard[0].StudentNo; online.studentname = txtName.Text; online.studentsex = txtSex.Text; online.cardType = lCard[0].Type; online.Computer = Environment.MachineName; Facade.addOnlineFacade addOnline = new Facade.addOnlineFacade(); addOnline.addOnline(online); //获得数据库的当前时间 Facade.IsOnlineFacade Online = new Facade.IsOnlineFacade(); IList <Entity.online> Lonline = new List <Entity.online>(); Lonline = IsOnline.IsOnline(online); txtONdate.Text = Lonline[0].ondate.ToString(); txtOntime.Text = Lonline[0].ontime.ToString(); //将正在上机的信息读入line表 Entity.line line = new Entity.line(); line.CardNo = lCard[0].CardNo; //line.UserID = frmLogin.UserName; line.LoginDate = Convert.ToDateTime(txtONdate.Text); line.LoginTime = TimeSpan.Parse(txtOntime.Text); line.Status = "正常上机"; line.StudentNo = lCard[0].StudentNo; line.StudentName = txtName.Text; line.Computer = Environment.MachineName; line.sex = txtSex.Text; Facade.AddLineFacade addLine = new Facade.AddLineFacade(); addLine.addLine(line); MessageBox.Show("上机成功,感谢使用!"); } } } }
public IList <Entity.BasicData> QueryBasicDate(Entity.BasicData basicdate) { BLL.QueryBasicDate queryBasicDate = new BLL.QueryBasicDate(); return(queryBasicDate.queryBasicDate(basicdate)); }
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; } } }
public void modifyBasicDate(Entity.BasicData basicDate) { Factory.Factory modifyBasicfac = new Factory.Factory(); IDal.ModifyBasicDate modifyBasic = modifyBasicfac.modifyBasicDate(); modifyBasic.ModifyBasicDate(basicDate); }