public System.Data.DataTable GetModel(Model.tab_emps tem)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select tab_emps.*,tab_roles.roleName from tab_emps join tab_roles on tab_emps.roleID=tab_roles.roleID where ");
strsql.AppendFormat("empName='{0}' ", tem.empName);
strsql.AppendFormat("and empPwd='{0}'", tem.empPwd);
return(sql.ExecuteDataSet(strsql.ToString()).Tables[0]);
}
public int insert(Model.tab_emps mopower)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("insert into tab_emps(empName,empPwd,roleID) values(");
strsql.AppendFormat("'{0}',", mopower.empName);
strsql.AppendFormat("'{0}',", mopower.empPwd);
strsql.AppendFormat("'{0}')", mopower.Roles);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public int Update(Model.tab_emps mopower)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("update tab_emps set ");
strsql.AppendFormat("empName='{0}',", mopower.empName);
strsql.AppendFormat("empPwd='{0}',", mopower.empPwd);
strsql.AppendFormat("roleID='{0}'", mopower.Roles);
strsql.AppendFormat("where empID='{0}'", mopower.empID);
return(sql.ExecuteNonQuery(strsql.ToString()));
}
public DataTable GetModel(Model.tab_emps tem)
{
return(itu.GetModel(tem));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="tem"></param>
/// <returns></returns>
public int insert(Model.tab_emps tem)
{
return(itu.insert(tem));
}
/// <summary>
/// 修改拥护
/// </summary>
/// <param name="tem"></param>
/// <returns></returns>
public int Update(Model.tab_emps tem)
{
return(itu.Update(tem));
}
