public void IdelOnworker(Entity.onWork onwork)
{
SqlParameter[] para = { new SqlParameter("@userID", onwork.UserID) };
string sql = "delete from onwork_info where userID=@userID";
sqlhelper.ExecuteNoquery(sql, CommandType.Text, para);
}
public bool IaddonWorker(Entity.onWork onwork)
{
//throw new NotImplementedException();
SqlParameter[] para =
{
new SqlParameter("@userID", onwork.UserID),
new SqlParameter("@level", onwork.Level),
new SqlParameter("@computer", onwork.Computer)
};
string sql = "insert into onwork_info(userID,level,computer) values(@userID,@level,@computer)";
return(sqlhelper.ExecuteNonquery(sql, CommandType.Text, para));
}
public IList <Entity.onWork> select(Entity.onWork onwork)
{
//throw new NotImplementedException();
SqlParameter[] para =
{
new SqlParameter("@userID", onwork.UserID)
};
string sql = "select * from onwork_info where userID=@userID ";
DataTable table = DAL.sqlhelper.GetDatable(sql, CommandType.Text, para);
IList <Entity.onWork> lOnwork = DAL.CovertHelper <Entity.onWork> .ConvertToModel(table);
return(lOnwork);
}
private void frmMain_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult.OK == MessageBox.Show("你确定要关闭应用程序吗？", "关闭提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
//补充完整值班记录
Entity.onWork onwork = new Entity.onWork();
onwork.UserID = frmLogin.UserName;
//查询onwork表
Facade.QueryOnworkFac queryOnwork = new Facade.QueryOnworkFac();
IList <Entity.onWork> lonwork = new List <Entity.onWork>();
lonwork = queryOnwork.queryOnwork(onwork);
//补充完整值班记录
Entity.WorkLog worklog = new Entity.WorkLog();
worklog.UserID = lonwork[0].UserID;
worklog.Level = lonwork[0].Level;
worklog.LogDate = lonwork[0].logindate;
worklog.LogTime = lonwork[0].logintime;
worklog.Computer = lonwork[0].Computer;
Facade.AddWorkerFacade addworkerlog = new Facade.AddWorkerFacade();
addworkerlog.addWorkLogTime(worklog);
//删除正在值班教师
Facade.AddWorkerFacade delOnwork = new Facade.AddWorkerFacade();
delOnwork.delonWorkFac(onwork);
this.FormClosing -= new FormClosingEventHandler(this.frmMain_FormClosing); //为保证Application.Exit();时不再弹出提示，所以将FormClosing事件取消
Application.Exit(); //退出整个程序
}
else
{
e.Cancel = true; //取消关闭事件
}
}
public void delonWorkFac(Entity.onWork onwork)
{
BLL.AddWorkerBLL delONwork = new BLL.AddWorkerBLL();
delONwork.delonwork(onwork);
}
public bool addOnwork(Entity.onWork onwork)
{
BLL.AddWorkerBLL addonwork = new BLL.AddWorkerBLL();
return(addonwork.addonWork(onwork));
}
public void delonwork(Entity.onWork onwork)
{
Factory.Factory delonWorkfac = new Factory.Factory();
IDal.IaddWorker delOnwork = delonWorkfac.addWorker();
delOnwork.IdelOnworker(onwork);
}
public bool addonWork(Entity.onWork onwork)
{
Factory.Factory addonworkfac = new Factory.Factory();
IDal.IaddWorker addonwork = addonworkfac.addWorker();
return(addonwork.IaddonWorker(onwork));
}
public IList <Entity.onWork> queryOnwork(Entity.onWork onwork)
{
BLL.QueryOnworkBll queryonwork = new BLL.QueryOnworkBll();
return(queryonwork.queryOnworkbll(onwork));
}
private void btlogin_Click(object sender, EventArgs e)
{
UserName = txtUserName.Text.Trim(); //全局变量
//传递用户输入的参数
string UserID = txtUserName.Text.Trim();
// string PWD = txtUserPWD.Text.Trim();
//定义外观层对象
Facade.LoginFacade loginfacade = new Facade.LoginFacade();
Entity.User userinfo = new Entity.User();
//将文本框的值给实体层对象，让实体层对象带上参数
userinfo.UserID = txtUserName.Text;
userinfo.PassWord = txtUserPWD.Text;
string strResult;
strResult = loginfacade.loginfacade(userinfo);
switch (strResult)
{
case "无用户": MessageBox.Show("用户不存在，请重新输入");
break;
case "登录成功": //MessageBox.Show("登录成功 ");
this.Visible = false;
//查找user的信息
Entity.User userInfo = new Entity.User();
userinfo.UserID = txtUserName.Text;
Facade.QueryUserFacade queryUser = new Facade.QueryUserFacade();
IList <Entity.User> lUser = new List <Entity.User>();
lUser = queryUser.QueryUser(userinfo);
//将正在上班的信息，传到当值 表
Facade.AddWorkerFacade addonwork = new Facade.AddWorkerFacade();
Entity.onWork onwork = new Entity.onWork();
onwork.UserID = lUser[0].UserID;
onwork.Level = lUser[0].Level;
onwork.Computer = Environment.MachineName; //获得计算机名称
bool flag;
flag = addonwork.addOnwork(onwork);
//传到上机记录表
Entity.WorkLog worklog = new Entity.WorkLog();
worklog.UserID = lUser[0].UserID;
worklog.Level = lUser[0].Level;
worklog.Computer = Environment.MachineName;
worklog.Status = "正常上机";
flag = addonwork.addWorkLog(worklog);
frmMain frmmain = new frmMain();
frmmain.StartPosition = FormStartPosition.CenterParent;
frmmain.Show();
break;
case "密码不正确": MessageBox.Show("用户密码不正确，请重新输入 ");
break;
}
}
