/// <summary>
/// 向操作员工作记录插入信息
/// </summary>
/// <param name="OpertionWork">操作员工作记录实体</param>
/// <returns>受影响行数</returns>
public int InertOpertionWork(OpertionWork OpertionWork)
{
//定义参数
SqlParameter[] sqlparams = { new SqlParameter("@ManID", OpertionWork.ManId),
new SqlParameter("@ManLevel", OpertionWork.Level),
new SqlParameter("@ManName", OpertionWork.Name),
new SqlParameter("@OnDate", OpertionWork.Ondate),
new SqlParameter("@OnTime", OpertionWork.OnTime),
new SqlParameter("@UpDate", OpertionWork.Update),
new SqlParameter("@UpTime", OpertionWork.UPTime),
new SqlParameter("@Computer", OpertionWork.Computer) };
//定义SQL语句
string sql = @"insert into OpertionWork values(@ManID,@ManLevel,@ManName,@OnDate,@OnTime,@UpDate,@UpTime,@Computer)";
//接受受影响行数
int Relust = sqlHelper.ExecuteNonQuery(sql, sqlparams, CommandType.Text);
return(Relust);//返回受影响的行数
}
/// <summary>
/// 管理者退出
/// </summary>
/// <param name="ManID">管理者ID</param>
/// <returns>是否退出成功！</returns>
public void LoginOutManger(string ManID)
{
//转换成正在值班的管理者实体
UserOnWork OnWork = new UserOnWork();
OnWork.ManId = int.Parse(ManID);
//利用退出接口，和工厂创建退出的数据管理类。
LoginOutMangerIDAL idal = (LoginOutMangerIDAL)fact.CreateUser("LoginOutMangerDAL");
//接受正在值班者信息
DataTable OnWorkTable = idal.SelectOnWork(OnWork);
//判断级别
if (OnWorkTable.Rows[0][1].ToString() == "管理员")
{
//删除正在上机记录
DeleteOnWork(OnWork);
}
else if (OnWorkTable.Rows[0][1].ToString() == "操作员")
{
#region 操作员工作记录实体赋值
OpertionWork opertionWork = new OpertionWork();
opertionWork.ManId = int.Parse(OnWorkTable.Rows[0][0].ToString()); //管理者ID
opertionWork.Level = OnWorkTable.Rows[0][1].ToString(); //管理者等级
opertionWork.Name = OnWorkTable.Rows[0][2].ToString(); //管理者姓名
opertionWork.Ondate = DateTime.Parse(OnWorkTable.Rows[0][3].ToString()); //管理者登录日期
opertionWork.OnTime = OnWorkTable.Rows[0][4].ToString(); //管理者登录时间
opertionWork.Update = DateTime.Now.Date; //管理者下机日期
opertionWork.UPTime = DateTime.Now.ToShortTimeString(); //管理者下机时间
opertionWork.Computer = OnWorkTable.Rows[0][5].ToString(); //电脑名字
#endregion
//更新操作员工作记录
idal.InertOpertionWork(opertionWork);
//删除正在上机记录
DeleteOnWork(OnWork);
}
Environment.Exit(0);//退出程序
}
