public List <StudentClass> GetAllStudentClass()
{
string sql = "select ClassId ,ClassName from StudentClass";
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <StudentClass> listStuClass = new List <StudentClass>();
while (objReader.Read())
{
listStuClass.Add(new StudentClass()
{
ClassId = Convert.ToInt32(objReader["ClassId"]),
ClassName = objReader["ClassName"].ToString()
});
}
objReader.Close();
return(listStuClass);
}
public int GetId(string email)
{
string sql = "SELECT Id From T_USER WHERE UserEmail = '{0}';";
sql = string.Format(sql, email);
int id = -1;
SqlDataReader reader = SQLHelper.GetReader(sql);
if (reader.HasRows && reader.Read())
{
id = Convert.ToInt16(reader["Id"]);
}
else
{
id = -1;
}
return(id);
}
/// <summary>
/// 通过班级名称查询课程信息打包（浏览用）
/// </summary>
/// <param name="ClassName"></param>
/// <returns></returns>
public List <Course> GetCourseBag2(string ClassName)
{
string sql = "SELECT ClassName,CourseName,Semester,Teacher,TeacherPhoneNumber FROM tbCourseInfo " +
"WHERE ClassName='" + ClassName + "'";
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <Course> list = new List <Course>();
while (objReader.Read())
{
list.Add(new Course()
{
ClassName = objReader["ClassName"].ToString(),
CourseName = objReader["CourseName"].ToString(),
Semester = objReader["Semester"].ToString(),
Teacher = objReader["Teacher"].ToString(),
TeacherPhoneNumber = objReader["TeacherPhoneNumber"].ToString(),
});
}
objReader.Close();
return(list);
}
/// <summary>
/// 通过id获取菜品
/// </summary>
/// <param name="dishId"></param>
/// <returns></returns>
public Dish GetDishById(string dishId)
{
string sql = "select DishId,DishName,UnitPrice,CategoryId from Dishes where DishId = @DishId";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DishId", dishId) };
Dish objDish = null;
SqlDataReader objReader = SQLHelper.GetReader(sql, param);
if (objReader.Read())
{
objDish = new Dish()
{
DishId = Convert.ToInt32(objReader["DishId"]),
CategoryId = Convert.ToInt32(objReader["CategoryId"]),
DishName = objReader["DishName"].ToString(),
UnitPrice = Convert.ToInt32(objReader["UnitPrice"])
};
}
objReader.Close();
return(objDish);
}
//获取全部的班级
public List <StudentClass> GetAllClasses()
{
//SQL语句
string sql = "select className,classId from StudentClass";
//接受返回值
SqlDataReader objReader = SQLHelper.GetReader(sql);
//构建接受泛型列表
List <StudentClass> list = new List <StudentClass>();
//循环接受全部列表信息
while (objReader.Read())
{
list.Add(new StudentClass()
{
ClassId = Convert.ToInt32(objReader["ClassId"]),
ClassName = objReader["ClassName"].ToString()
});
}
objReader.Close();
return(list);
}
/// <summary>
/// 获取所有的登录部门对象
/// </summary>
/// <returns></returns>
public List <Admin> GetAllDepts()
{
string sql = "select distinct deptid,org_dept.机构简称 as dept,org_dept.排序 from tbl_user";
sql += " inner join org_dept on tbl_user.deptid = org_dept.机构编号";
sql += " order by 排序";
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <Admin> list = new List <Admin>();
while (objReader.Read())
{
list.Add(new Admin()
{
dept = objReader["dept"].ToString(),
deptid = Convert.ToInt32(objReader["deptid"].ToString())
});
}
objReader.Close();
return(list);
}
public List <string> QueryAbsentList(string classId)
{
string sql = "select StudentName from Students where StudentId not in(select StudentId from ScoreList) and ClassId=@ClassId ";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ClassId", classId)
};
List <string> nameList = new List <string>();
SqlDataReader objReader = SQLHelper.GetReader(sql, param);
while (objReader.Read())
{
nameList.Add(objReader["StudentName"].ToString());
}
objReader.Close();
return(nameList);
}
//管理员登录
//public void AdminLogin(string loginId,string loginPwd)
//public void AdminLogin(int loginId, string loginPwd)//这个地方使用int作为LoginId是没有作用的，反而麻烦
//{
//}
//关于返回值：三种情况，int、bool、string、对象类型，究竟选择哪个？一定要选用一个适合当前情况的
//经过分析，我们通过验证用户信息，我们需要返回的内容：用户名、用户状态（后面还有角色...)，最后我们选择SysAdmin
/// <summary>
/// 根据账号和密码查询管理员对象
/// </summary>
/// <param name="admins">封装了LoginId和LoginPwd的SysAdmin对象</param>
/// <returns></returns>
public SysAdmin AdminLogin(SysAdmin admins)
{
//【1】定义SQL语句
string sql = $"select AdminName,AdminStatus from Admins where LoginId={admins.LoginId} and LoginPwd='{admins.LoginPwd}'";
//【2】执行查询
SqlDataReader reader = SQLHelper.GetReader(sql);
//【3】判断用户信息是否正确
if (reader.Read())
{
admins.AdminName = reader["AdminName"].ToString();
admins.AdminStatus = Convert.ToInt32(reader["AdminStatus"]);
//获取扩展：获取角色ID，根据角色ID查询对应的权限...
}
else
{
admins = null;//用户名或密码错误，我们就把当前对象的清除
}
reader.Close();
return(admins);
}
/// <summary>
/// 根据登录账号和密码登录
/// </summary>
/// <param name="objAdmin">封装了登录账号和密码的管理员对象</param>
/// <returns>返回包含管理员信息的对象</returns>
public SysAdmin AdminLogin(SysAdmin objAdmin)
{
//组合SQL语句
string sql = "select AdminName from Admins where LoginId={0} and LoginPwd='{1}'";
sql = string.Format(sql, objAdmin.LoginId, objAdmin.LoginPwd);
//从数据库中查询
SqlDataReader objReader = SQLHelper.GetReader(sql);
if (objReader.Read())
{
objAdmin.AdminName = objReader["AdminName"].ToString();
}
else
{
objAdmin = null;//如果登录不成功，则将当前对象清空
}
objReader.Close();
//返回结果
return(objAdmin);
}
public sysAdmin AdminLogin(sysAdmin objAdmin)
{
string sql = "select AdminName from Admins where LoginId={0} and LoginPwd ='{1}'";
sql = string.Format(sql, objAdmin.LoginId, objAdmin.LoginPwd);
//quary
SqlDataReader objReader = SQLHelper.GetReader(sql);
if (objReader.Read())
{
objAdmin.AdminName = objReader["AdminName"].ToString();
}
else
{
objAdmin = null;
}
objReader.Close();
//retrun
return(objAdmin);
}
//根据班级查询缺考人员列表（或全校缺考人员列表）
/// <summary>
/// 根据班级查询缺考人员列表（或全校缺考人员列表）
/// </summary>
/// <param name="classId"></param>
/// <returns>缺口人员姓名</returns>
public List <string> QueryAbsentList(string classId)
{
//查询考试总人数，C#和DB平均分
string sql = "select StudentName from Students where StudentId not in " +
"(select StudentId from ScoreList)";
//查询缺考总人数
if (classId != null && classId.Length != 0)
{
sql += string.Format(" and ClassId={0}", classId);
}
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <string> absentList = new List <string>();
while (objReader.Read())
{
absentList.Add(objReader["StudentName"].ToString());
}
objReader.Close();
return(absentList);
}
/// <summary>
/// 根据Id返回工作量对象
/// </summary>
/// <param name="workloadId"></param>
/// <returns></returns>
public DesignWorkload GetDesignWorkloadById(string workloadId)
{
string sql = "select WorkloadId,Model,WorkloadValue,ModelDesc from DesignWorkload where WorkloadId={0}";
sql = string.Format(sql, workloadId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
DesignWorkload objDesignWorkload = null;
if (objReader.Read())
{
objDesignWorkload = new DesignWorkload()
{
WorkloadId = Convert.ToInt32(objReader["WorkloadId"]),
Model = objReader["Model"].ToString(),
WorkloadValue = Convert.ToDecimal(objReader["WorkloadValue"]),
ModelDesc = objReader["ModelDesc"].ToString()
};
}
objReader.Close();
return(objDesignWorkload);
}
/// <summary>
/// 获取所有部门
/// </summary>
/// <returns></returns>
public List <Organization> GetAllDepartment()
{
string sql = "select DepartmentId, DepartmentName from Department where cyId=1";
sql = string.Format(sql);
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <Organization> list = new List <Organization>();
while (objReader.Read())
{
list.Add(new Organization()
{
DepartmentId = Convert.ToInt32(objReader["DepartmentId"]),
DepartmentName = objReader["DepartmentName"].ToString()
});
}
return(list);
}
/// <summary>
/// 获取所有一级目录编号和描述
/// </summary>
/// <returns></returns>
public List <Category> GetCategoryId()
{
string sql = "select CategoryId,CategoryDesc from Categories";
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <Category> list = new List <Category>();
while (objReader.Read())
{
string str = objReader["CategoryId"].ToString();
if (str.Substring(str.Length - 2) == "00")
{
list.Add(new Category()
{
CategoryId = Convert.ToInt32(objReader["CategoryId"]),
CategoryDesc = objReader["CategoryDesc"].ToString()
});
}
}
objReader.Close();
return(list);
}
//根据材料牌号查询热处理方式
public List <HeatType> GetHeatType(string materialCardId)
{
string sql = "select HeatingType,MaterialCardId from HeatType";
sql += " inner join MaterialId on HeatType.CardId=MaterialId.CardId";
sql += " where MaterialCardId='{0}'";
sql = string.Format(sql, materialCardId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <HeatType> list = new List <HeatType>();
while (objReader.Read())
{
list.Add(new HeatType()
{
HeatingType = objReader["HeatingType"].ToString(),
MaterialCardId = objReader["MaterialCardId"].ToString()
});
}
objReader.Close();
return(list);
}
public Qiandao GetObjByNum()
{
string sql = "select * from qd_huiyi where qdStarttime<=GETDATE() and qdEndttime >GETDATE()";
// string sql = "select * from qd_huiyi where 1=2";
SqlDataReader dr = SQLHelper.GetReader(sql);
Qiandao obj = null;
if (dr.Read())
{
obj = new Qiandao
{
// Id,qdName, qdStarttime, qdEndttime
Id = Convert.ToInt32(dr["Id"]),
qdName = dr["qdName"].ToString(),
qdStarttime = Convert.ToDateTime(dr["qdStarttime"]),
qdEndttime = Convert.ToDateTime(dr["qdEndttime"]),
};
}
return(obj);
}
public bool FindByUId(int uId)
{
string sql = "select * from jl_Info where userId=" + uId + "";
SqlDataReader dr = SQLHelper.GetReader(sql);
try
{
if (dr.Read())
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception("应用程序数据库连接出现问题" + ex.Message);
}
}
/// <summary>
/// 通过id获取房间
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public RoomCategory GetRoomById(string categoryId)
{
string sql = "SELECT * from RoomCategory where CategoryId = @CategoryId";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@CategoryId", categoryId) };
RoomCategory room = null;
SqlDataReader objReader = SQLHelper.GetReader(sql, param);
if (objReader.Read())
{
room = new RoomCategory()
{
CategoryId = Convert.ToInt32(objReader["CategoryId"]),
CategoryName = objReader["CategoryName"].ToString(),
UnitPrice = Convert.ToInt32(objReader["UnitPrice"])
};
}
objReader.Close();
return(room);
}
//Get all category information
public DataTable GetBookType()
{
//Preparing SQL statements
string sql = "Select TypeId, TypeName, ParentTypeId, TypeDESC from BookType";
//Execute and return results
try
{
SqlDataReader objReader = SQLHelper.GetReader(sql);
//Define a DataTable
DataTable dt = new DataTable();
//Load the DataReader into the DataTable
dt.Load(objReader);
//Return
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddCardNo(string cardNo)
{
string sql = "insert into Attendance(CardNo) values(@CardNo)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CardNo", cardNo)
};
try
{
SQLHelper.GetReader(sql, param);
return("success");
}
catch (Exception ex)
{
throw new Exception("Swipe card fail, please connect System admin" + ex.Message);
}
}
/// <summary>
/// 根据专业名查询专业对象
/// </summary>
/// <param name="SpecialityName"></param>
/// <returns></returns>
public Speciality GetSpecialityBySpecialityName(string SpecialityName)
{
string sql = "SELECT SpecialityID,SpecialityName,Remark,CollageName FROM tbSpecialityInfo";
sql += " WHERE SpecialityName='" + SpecialityName + "'";
SqlDataReader objReader = SQLHelper.GetReader(sql);
Speciality objSpeciality = null;
if (objReader.Read())
{
objSpeciality = new Speciality()
{
CollageName = objReader["CollageName"].ToString(),
SpecialityID = Convert.ToInt32(objReader["SpecialityID"].ToString()),
SpecialityName = objReader["SpecialityName"].ToString(),
Remark = objReader["Remark"].ToString(),
};
}
objReader.Close();
return(objSpeciality);
}
/// <summary>
/// get socreInfo
/// </summary>
/// <returns></returns>
public Dictionary <string, string> GetScoreInfo(string ClassName)
{
string sql = "select stuCount = count(*) ,avgCSharp = avg(CSharp) , avgDb = avg(SQLServer) from ScoreList ";
if (ClassName != null && ClassName.Length != 0)
{
sql += "inner join StudentClass on StudentClass.ClassId = Students.ClassId ";
sql += "inner join ScoreList on ScoreList.StudentId = Students.Studentid ";
sql += string.Format("where ClassName ='{0}' ", ClassName);
}
sql += "select absentCount = Count(*) from Students where StudentId not in (select StudentId from ScoreList ) ";
if (ClassName != null && ClassName.Length != 0)
{
sql += "inner join StudentClass on StudentClass.ClassId = Students.ClassId ";
sql += "inner join ScoreList on ScoreList.StudentId = Students.Studentid ";
sql += string.Format("where ClassName ='{0}' ", ClassName);
}
Dictionary <string, string> scoreInfo = null;
SqlDataReader reder = SQLHelper.GetReader(sql);
if (reder.Read())
{
scoreInfo = new Dictionary <string, string>();
scoreInfo.Add("stuCount", reder["stuCount"].ToString());
scoreInfo.Add("avgCSharp", reder["avgCSharp"].ToString());
scoreInfo.Add("avgDb", reder["avgDb"].ToString());
}
if (reder.NextResult())
{
if (reder.Read())
{
scoreInfo.Add("absentCount", reder["absentCount"].ToString());
}
}
reder.Close();
return(scoreInfo);
}
//Get parent Information
public BookType GetParentType(int typeId)
{
//Preparing SQL
string sql = "Select T1.TypeDESC,T2.TypeId ,T2.TypeName from BookType AS T1 Inner Join BookType AS T2 On T1.ParentTypeId = T2.TypeId Where T1.TypeId = @TypeId";
//Preparing parameters in SQL statements
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@TypeId", typeId),
};
//Perform
try
{
SqlDataReader objReader = SQLHelper.GetReader(sql, para);
if (!objReader.HasRows)
{
return(null);
}
//Read
BookType objBookType = new BookType();
if (objReader.Read())
{
objBookType = new BookType
{
DESC = objReader["TypeDESC"].ToString(),
TypeId = Convert.ToInt32(objReader["TypeId"]),
TypeName = objReader["TypeName"].ToString(),
};
}
//Close Read
objReader.Close();
//Return
return(objBookType);
}
catch (Exception ex)
{
throw ex;
}
}
public Product GetProductInfoById(string productId)
{
StringBuilder sqlBuilder = new StringBuilder(
"select ProductId, ProductName, UnitPrice, Unit, Discount, ProductCategory.CategoryId,CategoryName from Products ");
sqlBuilder.Append("inner join ProductCategory on ProductCategory.CategoryId=Products.CategoryId ");
sqlBuilder.Append("where ProductId=@ProductId");
SqlDataReader objReader = null;
Product objProduct = null;
try
{
objReader = SQLHelper.GetReader(sqlBuilder.ToString(), new SqlParameter[] { new SqlParameter("@ProductId", productId) });
if (objReader.Read())
{
objProduct = new Product()
{
ProductId = productId,
ProductName = objReader["ProductName"].ToString(),
UnitPrice = Convert.ToDecimal(objReader["UnitPrice"]),
Unit = objReader["Unit"].ToString(),
Discount = Convert.ToDecimal(objReader["Discount"]),
CategoryId = Convert.ToInt32(objReader["CategoryId"]),
CategoryName = objReader["CategoryName"].ToString()
};
}
return(objProduct);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (objReader != null)
{
objReader.Close();
}
}
}
//Get borrowBook based on borrowId
public BorrowBook GetBorrowBookByBorrowId(string borrowId)
{
//Preparing SQL statements
string sql = "Select BorrowId,MemberId,BorrowedNum,OverdueNum from BorrowBook Where BorrowId=@BorrowId";
//Prepare parameters
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BorrowId", borrowId),
};
//Read
try
{
SqlDataReader objReader = SQLHelper.GetReader(sql, para);
if (!objReader.HasRows)
{
return(null);
}
BorrowBook objBorrowBook = new BorrowBook();
if (objReader.Read())
{
objBorrowBook = new BorrowBook()
{
BorrowId = objReader["BorrowId"].ToString(),
MemberId = objReader["MemberId"].ToString(),
BorrowedNum = Convert.ToInt32(objReader["BorrowedNum"]),
OverdueNum = Convert.ToInt32(objReader["OverdueNum"]),
};
}
//Close Read
objReader.Close();
//return
return(objBorrowBook);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ZhaoPin> GetListByWord(string strWord)
{
string sql = "select * from Zp_Info where ";
sql += "zpXuqiu like '%" + strWord + "%' ";
sql += "or zpZhuti like '%" + strWord + "%' ";
sql += "or zpPhone like '%" + strWord + "%' ";
sql += "or zpArea like '%" + strWord + "%' ";
sql += "or zpUser like '%" + strWord + "%' ";
sql += "or zpGangwei like '%" + strWord + "%' order by zpAddtime desc";
SqlDataReader dr = SQLHelper.GetReader(sql);
List <ZhaoPin> list = new List <ZhaoPin>();
while (dr.Read())
{
list.Add(new ZhaoPin
{
zpId = Convert.ToInt32(dr["zpId"]),
zpXuqiu = dr["zpXuqiu"].ToString(),
zpZhuTilei = dr["zpZhuTilei"].ToString(),
zpZhuti = dr["zpZhuti"].ToString(),
zpArea = dr["zpArea"].ToString(),
zpGangwei = dr["zpGangwei"].ToString(),
zpNum = Convert.ToInt32(dr["zpNum"]),
zpPayL = dr["zpPayL"].ToString(),
zpPayH = dr["zpPayH"].ToString(),
zpFuli = dr["zpFuli"].ToString(),
zpDetail = dr["zpDetail"].ToString(),
zpUser = dr["zpUser"].ToString(),
zpPhone = dr["zpPhone"].ToString(),
zpFaburen = dr["zpFaburen"].ToString(),
zpEndtime = Convert.ToDateTime(dr["zpEndtime"]),
zpAddtime = Convert.ToDateTime(dr["zpAddtime"]),
isTuijian = Convert.ToInt32(dr["isTuijian"]),
isRemen = Convert.ToInt32(dr["isRemen"])
});
}
dr.Close();
return(list);
}
//Get information about a book
public DataTable GetBook(string isbn = "", string bookId = "", string bookName = "", string bookAuthor = "")
{
//Preparing SQL statements
string sql = "Select BookId, BookName, BookType, ISBN, BookAuthor, BookPress, BookImage, BookPublishDate, StorageInNum, StorageInDate, InventoryNum, BorrowedNum ";
sql += " from Book Where ISBN Like @ISBN And BookId Like @BookId And BookName Like @BookName And BookAuthor Like @BookAuthor ";
//Prepare the parameters to which the SQL query is
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ISBN", '%' + isbn + '%'),
new SqlParameter("@BookId", '%' + bookId + '%'),
new SqlParameter("@BookName", '%' + bookName + '%'),
new SqlParameter("@BookAuthor", '%' + bookAuthor + '%'),
};
//Execute and get the return value
try
{
//Receive results through SQLDataReader
SqlDataReader objReader = SQLHelper.GetReader(sql, para);
//Determine if it is empty
if (!objReader.HasRows)
{
return(null);
}
//Define a DataTable
DataTable dt = new DataTable();
//Load the results into the DataTable
dt.Load(objReader);
//Closed
objReader.Close();
//Return
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
{//jlId, jlName, jlPic, jlGender, jlage, jlIC, jlEdu, jlGw, jlPhone, jlEmail, jlXinzi,
//jlHunyin, jlWork, jlPingJia, jlAddtime, userID, jl_peixun, jl_jiaoyu
#region 根据关键字获取简历列表
public List <Jianli> getJlListByKword(string kword)
{
StringBuilder strb = new StringBuilder();
strb.Append(
"select *,(select userName from User_Info where userId=Jl_info.userID) as userName from Jl_info ");
strb.Append("where jlName like '%" + kword + "%' ");
strb.Append("or jlGw like '%" + kword + "%'");
strb.Append("or jlPhone like '%" + kword + "%'");
strb.Append("order by jlAddtime desc");
string sql = strb.ToString();
SqlDataReader dr = SQLHelper.GetReader(sql);
List <Jianli> list = new List <Jianli>();
while (dr.Read())
{
list.Add(new Jianli
{
jlId = Convert.ToInt32(dr["jlId"]),
jlWork = Convert.ToInt32(dr["jlWork"]),
userID = Convert.ToInt32(dr["userID"]),
jlXinzi = Convert.ToInt32(dr["jlXinzi"]),
jlName = dr["jlName"].ToString(),
jlPic = dr["jlPic"].ToString(),
jlGender = dr["jlGender"].ToString(),
jlage = dr["jlage"].ToString(),
jlIC = dr["jlIC"].ToString(),
jlEdu = dr["jlEdu"].ToString(),
jlGw = dr["jlGw"].ToString(),
jlPhone = dr["jlPhone"].ToString(),
jlEmail = dr["jlEmail"].ToString(),
jlPingJia = dr["jlPingJia"].ToString(),
jl_peixun = dr["jl_peixun"].ToString(),
jl_jiaoyu = dr["jl_jiaoyu"].ToString(),
jlAddtime = Convert.ToDateTime(dr["jlAddtime"]),
});
}
dr.Close();
return(list);
}
public List <Article> GetListByAcid(string acId)
{//--artId, artName, artImg, artContent, acId, artAuthor, artPV, artAddtime, artIsTuiJian, artIsReMen, artIsZhiDing, artType, artLink
StringBuilder sb = new StringBuilder();
sb.Append("select *,");
sb.Append("(select acName from Article_Column where acId = Article.acId) as acName,");
sb.Append("(select acPid from Article_Column where acId = Article.acId) as acPid,");
sb.Append("(select acName from Article_Column where acId=(select acPid from Article_Column where acId =Article.acId)) as acPName ");
sb.Append("from Article ");
sb.Append("where acId ={0} ");
sb.Append("order by artAddtime desc");
string sql = String.Format(sb.ToString(), acId);
SqlDataReader dr = SQLHelper.GetReader(sql);
List <Article> list = new List <Article>();
while (dr.Read())
{
list.Add(new Article
{
artId = Convert.ToInt32(dr["artId"]),
acId = Convert.ToInt32(dr["acId"]),
artIsTuiJian = Convert.ToInt32(dr["artIsTuiJian"]),
artIsReMen = Convert.ToInt32(dr["artIsReMen"]),
artIsZhiDing = Convert.ToInt32(dr["artIsZhiDing"]),
artName = dr["artName"].ToString(),
artContent = dr["artContent"].ToString(),
artImg = dr["artImg"].ToString(),
artAuthor = dr["artAuthor"].ToString(),
artPV = dr["artPV"].ToString(),
artLink = dr["artLink"].ToString(),
artType = dr["artType"].ToString(),
artAddtime = Convert.ToDateTime(dr["artAddtime"]),
acPid = Convert.ToInt32(dr["artId"]),
acName = dr["acName"].ToString(),
acPName = dr["acPName"].ToString()
});
}
dr.Close();
return(list);
}
/// <summary>
/// 获取技术部人员
/// </summary>
/// <returns></returns>
public List <User> GetUserTech()
{
string sql = "select UserId,GroupName,UserAccount from Users";
sql += " inner join UserGroups on UserGroups.UserGroupId=Users.UserGroupId";
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <User> list = new List <User>();
while (objReader.Read())
{
if (objReader["GroupName"].ToString() == "admin" || objReader["GroupName"].ToString() == "tech_user")
{
list.Add(new User()
{
UserId = Convert.ToInt32(objReader["UserId"]),
UserAccount = objReader["UserAccount"].ToString()
});
}
}
objReader.Close();
return(list);
}
