public IList <Entity.line> CountMoney(Entity.line line)
{
//得到上机记录的数据
Factory.Factory fact = new Factory.Factory();
IDal.IQueryline QueryLine = fact.IqueryLine();
IList <Entity.line> Lline = QueryLine.select(line);
//得到basicdate的数据
Factory.Factory factBasic = new Factory.Factory();
IDal.IqueryBasicdate QueryBasicDate = factBasic.IqueryBasicDate();
IList <Entity.BasicData> LbasicDate = QueryBasicDate.select(basicDate);
//计算时间差
int ConsumeTime;
int ConsumeMoney;
TimeSpan date = Lline[0].OffDate - Lline[0].LoginDate;
TimeSpan time = Lline[0].OffTime - Lline[0].LoginTime;
int min = Convert.ToInt16(date.TotalMinutes) + Convert.ToInt16(time.TotalMinutes);
//比较准备时间
if (min < LbasicDate[0].PreparyTime)
{
ConsumeTime = 0;
}
else
{
if ((min - LbasicDate[0].PreparyTime) < 30)
{
ConsumeTime = 30;
}
else
{
ConsumeTime = min - LbasicDate[0].PreparyTime;
}
}
//计算钱
if (Lline[0].Status == "固定用户")
{
ConsumeMoney = LbasicDate[0].Rate / 2 * (ConsumeTime / 30);
}
else
{
//if (Lline[0].Status == "临时用户")
ConsumeMoney = LbasicDate[0].TmpRate / 2 * (ConsumeTime / 30);
}
//将金额放入line表中，同时显示到窗体上。
line.ConsumeMoney = ConsumeMoney;
line.ConsumeTime = ConsumeTime;
line.Money = (Convert.ToInt16(line.Money) - (Convert.ToInt16(ConsumeMoney)));
Factory.Factory factLineMoney = new Factory.Factory();
IDal.IAddLine AddLineMoney = factLineMoney.addLine();
AddLineMoney.IaddLineOffMoney(line);
IList <Entity.line> lineAll = QueryLine.select(line);
return(lineAll);
}
public IList <Entity.line> select(Entity.line line)
{
SqlParameter[] sqlparams = { new SqlParameter("@cardno", line.CardNo),
new SqlParameter("@loginDate", line.LoginDate),
new SqlParameter("@logintime", line.LoginTime), };
string sql = "select * from line_info where cardno = @cardno and logindate = @loginDate and logintime =@logintime ";
DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, sqlparams);
IList <Entity.line> Lline = DAL.CovertHelper <Entity.line> .ConvertToModel(table);
return(Lline);
}
//下机时添加学生信息 --添加时间
public void iaddLineOff(Entity.line line)
{
SqlParameter[] sqlparas =
{
new SqlParameter("@Cardno", line.CardNo),
new SqlParameter("@loginDate", line.LoginDate),
new SqlParameter("@logintime", line.LoginTime),
new SqlParameter("@status", line.Status)
};
string sql = "update line_info set offdate = getdate(),offtime = getdate(), status =@status where cardno = @Cardno and logindate = @loginDate and logintime=@logintime";
sqlhelper.ExecuteNoquery(sql, CommandType.Text, sqlparas);
}
//上机时添加学生信息
public void IaddLine(Entity.line line)
{
SqlParameter[] sqlparas = { new SqlParameter("@cardno", line.CardNo),
new SqlParameter("@ondate", line.LoginDate),
new SqlParameter("@ontime", line.LoginTime),
// new SqlParameter ("@userId",line.UserID ), //暂时去掉了，因为登录窗体没有使用,zhuyi后来考虑不合适删了
new SqlParameter("@Status", line.Status),
new SqlParameter("@studentno", line.StudentNo),
new SqlParameter("@studentname", line.StudentName),
new SqlParameter("@computer", line.Computer),
new SqlParameter("@sex", line.sex) };
string sql = "insert into line_info(cardno,logindate,logintime,status,studentno,studentname,computer,sex) values(@cardno,@ondate,@ontime,@Status,@studentno,@studentname,@computer,@sex)";
sqlhelper.ExecuteNoquery(sql, CommandType.Text, sqlparas);
}
//下机时添加学生信息--添加金额--2017.01.24
public void IaddLineOffMoney(Entity.line line)
{
SqlParameter[] sqlparas =
{
new SqlParameter("@Cardno", line.CardNo),
new SqlParameter("@loginDate", line.LoginDate),
new SqlParameter("@logintime", line.LoginTime),
new SqlParameter("@ConsumeTime", line.ConsumeTime),
new SqlParameter("@consumeMoney", line.ConsumeMoney),
new SqlParameter("@money", line.Money)
};
string sql = "update line_info set consumetime=@ConsumeTime,consumemoney=@consumeMoney,money =@money where cardno = @Cardno and logindate = @loginDate and logintime=@logintime";
sqlhelper.ExecuteNoquery(sql, CommandType.Text, sqlparas);
}
private void 全部ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount < 1)
{
MessageBox.Show("当前没有人员上机！", "提示");
}
else
{
for (int i = 0; i < dataGridView1.RowCount; i++)
{
//根据卡号，找到正在上机的卡号,给line实体赋值
Entity.online online = new Entity.online();
online.CardNo = Convert.ToInt16(dataGridView1.Rows[i].Cells[0].Value);
Facade.IsOnlineFacade Isonline = new Facade.IsOnlineFacade();
IList <Entity.online> lonline = new List <Entity.online>();
lonline = Isonline.IsOnline(online);
//将line实体的值补全
Entity.line line = new Entity.line();
line.CardNo = lonline[0].CardNo; //之前line表有的一些参数,根据这些信息找到缺失信息的表
line.LoginDate = lonline[0].ondate;
line.LoginTime = lonline[0].ontime;
line.Status = "强制下机";
Facade.AddLineFacade addLineOff = new Facade.AddLineFacade();
addLineOff.addLineOff(line);
//计算金额，显示消费时间和金额
Facade.CountMoneyFacade countMoneyfacade = new Facade.CountMoneyFacade();
IList <Entity.line> LineAll = new List <Entity.line>();
LineAll = countMoneyfacade.CountMoney(line);
//将正在上机表下机
Facade.deleteFacade deleteOnlineFacade = new Facade.deleteFacade();
deleteOnlineFacade.DeleteOnline(online);
}
MessageBox.Show("下机成功！", "提示");
this.online_infoTableAdapter.Fill(this.onlineDataSet.online_info);
}
}
public void addLineOff(Entity.line line)
{
BLL.AddLineBll addLineoff = new BLL.AddLineBll();
addLineoff.addLineOff(line);
}
public void addLine(Entity.line line)
{
BLL.AddLineBll AddLine = new BLL.AddLineBll();
AddLine.addLine(line);
}
public IList <Entity.line> CountMoney(Entity.line line)
{
BLL.OffLineBLL Countmoney = new BLL.OffLineBLL();
return(Countmoney.CountMoney(line));
}
/// <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("上机成功，感谢使用！");
}
}
}
}
/// <summary>
/// 下机
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
//给实体online装参数--正在上机才可以下机
Entity.online online = new Entity.online();
online.CardNo = Convert.ToInt16(txtCardno.Text);
Facade.IsOnlineFacade Isonline = new Facade.IsOnlineFacade();
IList <Entity.online> lonline = new List <Entity.online>();
lonline = Isonline.IsOnline(online);
if (lonline.Count == 0)
{
MessageBox.Show("该卡号下没有学生上机，请选择正在上机的卡号！");
txtCardno.Text = "";
txtCardno.Focus();
}
else
{
//将剩余参数带给line实体
//补充，这里给line传入金额--2017-02-11
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);
Entity.line line = new Entity.line();
//line.OffDate =Convert .ToDateTime (DateTime.Now.Date.ToShortDateString ());
//line.OffTime = TimeSpan.Parse(DateTime.Now.ToLongTimeString());
//line.ConsumeTime =Convert.ToInt16 (lbConsumer.Text); //不合理，为啥，因为可以让好多人上机，但是呢？只能显示最后一个上机的人的时间
line.CardNo = lonline[0].CardNo; //之前line表有的一些参数,根据这些信息找到缺失信息的表
line.LoginDate = lonline[0].ondate;
line.LoginTime = lonline[0].ontime;
line.Money = lCard[0].Money;
line.Status = "正常下机";
Facade.AddLineFacade addLineOff = new Facade.AddLineFacade();
addLineOff.addLineOff(line);
//计算金额，显示消费时间和金额
Facade.CountMoneyFacade countMoneyfacade = new Facade.CountMoneyFacade();
IList <Entity.line> LineAll = new List <Entity.line>();
LineAll = countMoneyfacade.CountMoney(line);
txtConsumeMoney.Text = LineAll[0].ConsumeMoney.ToString();
txtConsumeTime.Text = LineAll[0].ConsumeTime.ToString();
txtName.Text = LineAll[0].StudentName;
txtoffDate.Text = LineAll[0].OffDate.ToString();
txtoffTime.Text = LineAll[0].OffTime.ToString();
txtONdate.Text = LineAll[0].OffDate.ToString();
txtOntime.Text = LineAll[0].LoginTime.ToString();
txtSex.Text = LineAll[0].sex;
txtStudentNo.Text = LineAll[0].StudentNo.ToString();
txtType.Text = LineAll[0].Status;
//从card实体中获得消费的剩余金额,同时更新card表
Entity.Card Card = new Entity.Card();
Card.CardNo = Convert.ToInt16(txtCardno.Text);
IList <Entity.Card> LCard = new List <Entity.Card>();
Facade.StudentMoneyFacade CardMoney = new Facade.StudentMoneyFacade();
LCard = CardMoney.StudentMoney(Card);
//余额的填充
txtMoney.Text = (Convert.ToInt16(LCard[0].Money) - Convert.ToInt16(LineAll[0].ConsumeMoney)).ToString(); //////
//更新表card
Card.Money = Convert.ToInt16(txtMoney.Text);
Facade.UpdateMoneyFacade UpdateMoney = new Facade.UpdateMoneyFacade();
UpdateMoney.UpdateMoney(Card);
//判断余额，如果余额花完的话需要充点钱
IList <Entity.Card> IfCardmomey = new List <Entity.Card>();
IfCardmomey = CardMoney.StudentMoney(Card);
if (IfCardmomey[0].Money < 0)
{
MessageBox.Show("您需要充值现金" + IfCardmomey[0].Money.ToString() + "元！");
}
txtMoney.Text = IfCardmomey[0].Money.ToString();
//将正在上机表下机
Facade.deleteFacade deleteOnlineFacade = new Facade.deleteFacade();
deleteOnlineFacade.DeleteOnline(online);
}
}
//下机时
public void addLineOff(Entity.line line)
{
Factory.Factory fact = new Factory.Factory();
IDal.IAddLine addlineoff = fact.addLine();
addlineoff.iaddLineOff(line);
}
public void addLine(Entity.line line)
{
Factory.Factory fact = new Factory.Factory();
IDal.IAddLine addline = fact.addLine();
addline.IaddLine(line);
}
