/// <summary>
/// 删除用户信息
/// </summary>
/// <param name="UserID">用户ID</param>
/// <param name="form">添加删除窗体</param>
/// <returns></returns>
public string DeleteUserManInfo(string UserID)
{
//用于返回信息
string strMsger = "";
//接受判断用户id和年龄是否是数字
bool isNumberUserID = IsNull.IsNumber(UserID);
//判断UserID是否为空
if (UserID.Trim() == "")//说明UserID为空
{
strMsger = "用户ID不能为空！";
}
else
{
//判断userid是否是数字
if (isNumberUserID == true)//是数字
{
#region 除用户
//调用添加删除用户接口，和创建DAL层工厂实例化具体的DAL层类
AddandDeleteUserIDAL addanddeleteIDAL = (AddandDeleteUserIDAL)fact.CreateUser("AddandDeleteUserDAL");
//转换为实体
Managerial manager = new Managerial();
manager.ManId = int.Parse(UserID);
DataTable SelectManagerTable = addanddeleteIDAL.SelectManagerial(manager);
//判断用户是否存在
if (SelectManagerTable.Rows.Count != 0)//不等于零说明存在
{
//判断是否是最后一个管理员
if (SelectManagerTable.Rows.Count <= 2 && SelectManagerTable.Rows[0][2].ToString() == "管理员")
{
strMsger = "最后一个管理员不可以删除";
}
else
{
//删除登录表信息
UserLevel user = new Enitity.UserLevel();
user.UserID = int.Parse(UserID);
addanddeleteIDAL.DeleteUserLogin(user);
//删除管理者信息
addanddeleteIDAL.DeletetManagerial(manager);
//删除管理者身份信息
ManIDcardno manidcardno = new ManIDcardno();
manidcardno.Manid = int.Parse(UserID);
addanddeleteIDAL.DeleteManIDcardno(manidcardno);
strMsger = "删除成功！";
}
}
else
{
strMsger = "用户不存在，请从新输入！";
}
#endregion
}
else
{
strMsger = "用户ID请输入数字！";
}
}
return(strMsger);
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="userlevel">用户</param>
/// <returns>是否登录成功！</returns>
public override string UserLogin(UserLevel userlevel, Form form)
{
//返回信息
string StrMesg = "";
//调用接口实例化D层查询类
LoginIDAL idal = (LoginIDAL)fact.CreateUser("LoginDal");
//实例化管理者实体和赋值
Managerial Manageria = new Managerial();
Manageria.ManId = userlevel.UserID;//登录id赋值给管理者ID
//接受管理者信息
DataTable ManTable = idal.SelectState(Manageria);
//判断账号是否使用
if (ManTable.Rows[0][3].ToString().Trim() == "使用")
{
#region 判断管理者是否已经登录
//实例化值班实体与赋值
UserOnWork userOnWork = new UserOnWork();
userOnWork.ManId = userlevel.UserID;//值班实体的管理者id赋值
//接受接口的返回值,返回整个值班表的信息。
DataTable OnWorkTable = idal.SelectOnUser(userOnWork);
//判断管理者是否已经登录
if (OnWorkTable.Rows.Count == 0) //没有登录
{
form.Hide(); //隐藏窗体
#region 向值班表插入信息
//给值班实体赋值
userOnWork.Level = userlevel.Userlevel; //管理者级别
userOnWork.Name = ManTable.Rows[0][1].ToString().Trim(); //管理者姓名
userOnWork.Ondate = DateTime.Now.Date; //登录日期
userOnWork.OnTime = DateTime.Parse(DateTime.Now.ToShortTimeString()); //登录时间
userOnWork.Computer = Computer.GetMachineName(); //计算机名
//调用插入方法
InserUserOnWork(userOnWork);
#endregion
//给全局ID赋值
UserLevel.UserIdall = userlevel.UserID;
StrMesg = "登录成功！";
//显示管理员窗体
Form CreatForm = CreatfactForm.CreatFrom("AdminMain"); //实例化管理员窗体
CreatForm.Show(); //显示窗体
}
else
{
StrMesg = "此账号已登录！";
}
#endregion
}
else
{
StrMesg = "此账号未使用,请激活使用！";
}//end if
return(StrMesg);
}
/// <summary>
/// 查询操作员信息
/// </summary>
/// <param name="managerial"></param>
/// <returns></returns>
public DataTable SelectManagerial(Managerial managerial)
{
//定义参数
SqlParameter[] sqlpams = { new SqlParameter("@Level", managerial.Level) };
//定义SQL语句
string sql = @"select * from Managerial where Level=@Level";
//接受查询的返回值
DataTable SelectManagerialTable = sqlHelper.ExecuteQuery(sql, sqlpams, CommandType.Text);
return(SelectManagerialTable);
}
/// <summary>
/// 查询管理者信息
/// </summary>
/// <param name="manager">管理者实体</param>
/// <returns>以表形式返回，管理者信息。</returns>
public DataTable SelectManagerial(Managerial manager)
{
//定义参数
SqlParameter[] sqlams = { new SqlParameter("@ManId", manager.ManId) };
//定义SQL语句
string sql = @"select * from Managerial where ManId=@ManId";
//接受查询结果
DataTable SelectUserLogingTable = sqlHelper.ExecuteQuery(sql, sqlams, CommandType.Text);
return(SelectUserLogingTable);
}
/// <summary>
/// 删除管理者信息
/// </summary>
/// <param name="manager">管理者实体</param>
/// <returns>受影响行数</returns>
public int DeletetManagerial(Managerial manager)
{
//定义参数
SqlParameter[] sqlams = { new SqlParameter("@ManId", manager.ManId) };
//定义SQL语句
string sql = @"delete Managerial where ManId=@ManId";
//执行SQL语句
int Relst = sqlHelper.ExecuteNonQuery(sql, sqlams, CommandType.Text);
return(Relst);
}
/// <summary>
/// 管理者使用状态
/// </summary>
/// <param name="ManageState">管理者信息</param>
/// <returns>整个表的管理者信息</returns>
public DataTable SelectState(Managerial ManageState)
{
//定义参数
SqlParameter[] sqlparams = { new SqlParameter("@ManID", ManageState.ManId) };
//定义SQL语句
string sql = @"select * from Managerial where ManID=@ManID";
//把查询结果储存到临时表
DataTable ManTable = sqlHelper.ExecuteQuery(sql, sqlparams, CommandType.Text);
//返回整个表的信息
return(ManTable);
}
/// <summary>
/// 向管理者表插入信息
/// </summary>
/// <param name="manager">管理者实体</param>
/// <returns>受影响行数</returns>
public int InsertManagerial(Managerial manager)
{
//定义参数
SqlParameter[] sqlams = { new SqlParameter("@ManId", manager.ManId)
, new SqlParameter("@Name", manager.Name)
, new SqlParameter("@Level", manager.Level)
, new SqlParameter("@State", manager.State) };
//定义SQL语句
string sql = @"insert into Managerial values(@ManId,@Name,@Level,@State)";
//执行SQL语句
int Relust = sqlHelper.ExecuteNonQuery(sql, sqlams, CommandType.Text);
return(Relust);
}
/// <summary>
/// 查询操作员信息
/// </summary>
/// <param name="OperLevel">操作员</param>
/// <returns></returns>
public DataTable SelectOpertionInfo(string OperLevel, out string StrMsg)
{
DataTable OpertionTable = new DataTable();//返回表信息
//调用接口和工厂创建DAL层具体类
SettleAccountsIDAL setteAcounIDAL = (SettleAccountsIDAL)fact.CreateUser("SettleAccountsDAL");
Managerial manger = new Managerial();//管理者实体
manger.Level = OperLevel;
OpertionTable = setteAcounIDAL.SelectManagerial(manger);//获取操作员信息
//判断是否有操作员
if (OpertionTable.Rows.Count != 0)
{
StrMsg = "查询完毕！";
}
else
{
StrMsg = "没有可查询的操作员！";
}
return(OpertionTable);
}
public double TestSubordinateBonus(Managerial Manager)
{
return(Manager.CalcCurrentPay());
}
public double TestSalesPay(Managerial salesMan)
{
return(salesMan.CalcCurrentPay());
}
public double TestSalesBonus(Managerial salesMan)
{
return(salesMan.GetAnnualBonus());
}
public double TestSalesYears(Managerial salesMan)
{
return(salesMan.GetFullYears());
}
/// <summary>
/// 查询管理者是否存在
/// </summary>
/// <param name="manager">管理者实体</param>
/// <returns></returns>
public DataTable ActivateManagerial(Managerial manager)
{
throw new NotImplementedException();
}
public double TestManagerPay(Managerial Manager)
{
return(Manager.CalcCurrentPay());
}
public double TestManagerBonus(Managerial manager)
{
return(manager.GetAnnualBonus());
}
public int TestManagerYearYears(Managerial manager)
{
return(manager.GetFullYears());
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="UserID">用户DI</param>
/// <param name="UserLevel">用户级别</param>
/// <param name="UserPwd">用户密码</param>
/// <param name="UserName">用户姓名</param>
/// <param name="State">使用状态</param>
/// <param name="PhonNumber">手机号</param>
/// <param name="Sex">性别</param>
/// <param name="Age">年龄</param>
/// <param name="form">添加删除窗体</param>
/// <returns>是否添加成功！</returns>
public string AddUserManInfo(string UserID, string UserLevel, string UserPwd, string UserName, string State, string PhonNumber, string Sex, string Age, Form form)
{
//用于返回信息
string strMsger = "";
//接受判空返回值，判断文本框是否为空。
string isNull = IsNull.isNull(form);
//接受判断用户id和年龄是否是数字
bool isNumberUserID = IsNull.IsNumber(UserID);
bool isNumberAge = IsNull.IsNumber(Age);
//判断文本框是否为空
if (isNull == "")//没有返回值，说明文本框不为空。
{
#region 添加用户
//判断年龄和管理者id是否为数字
if (isNumberUserID == true && isNumberAge == true)//如果都是true，说明都是数字。
{
//调用添加删除用户接口，和创建DAL层工厂实例化具体的DAL层类
AddandDeleteUserIDAL addanddeleteIDAL = (AddandDeleteUserIDAL)fact.CreateUser("AddandDeleteUserDAL");
//转换为实体
Managerial manager = new Managerial();
manager.ManId = int.Parse(UserID);
DataTable SelectManagerTable = addanddeleteIDAL.SelectManagerial(manager); //获取管理者信息
//判断用户是否已经存在
if (SelectManagerTable.Rows.Count != 0) //不等于零，说明已经存在
{
strMsger = "此管理者已存在，请从新输入！";
}
else
{
UserLevel ManLevel = new Enitity.UserLevel();
ManLevel.UserID = int.Parse(UserID);
DataTable SelectLevel = addanddeleteIDAL.SelectUserLevel(ManLevel);
//判断是否和卡号冲突
if (SelectLevel.Rows.Count == 0)//等于零说明不冲突
{
#region 添加管理者
//向登录表插入信息
UserLevel user = new Enitity.UserLevel();
user.UserID = int.Parse(UserID);
user.Userlevel = UserLevel;
user.UserPwd = UserPwd;
addanddeleteIDAL.InsertUserLogin(user);
//向管理者插入信息
manager.Level = UserLevel;
manager.Name = UserName;
manager.State = State;
addanddeleteIDAL.InsertManagerial(manager);
//向管理者身份信息插入信息
ManIDcardno manidcardno = new ManIDcardno();
manidcardno.Manid = int.Parse(UserID);
manidcardno.Age = int.Parse(Age);
manidcardno.PhoneNumber = PhonNumber;
manidcardno.Sex = Sex;
addanddeleteIDAL.InsertManIDcardno(manidcardno);
#endregion
strMsger = "用户添加成功！";
}
else
{
strMsger = "管理者与卡号冲突，请从新输入！";
}
}
}
else
{
strMsger = "用户ID或者年龄不是数字，请输入数字！";
}
#endregion
}
else
{
strMsger = isNull;
}
return(strMsger);
}
/// <summary>
/// 更新管理者使用状态
/// </summary>
/// <param name="manager">管理者实体</param>
/// <returns>受影响行数</returns>
public int UpdateManagerial(Managerial manager)
{
throw new NotImplementedException();
}
public double TestSubordinateCount(Managerial Manager)
{
return(Manager.GetSubordinateCount());
}
