/// <summary>
/// 获取部門信息
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.HR_Department> GetDapartment(decimal aid)
{
string sql = @"
select *
from HR_Department where AID=@AID
";
SqlParameter[] ps =
{
new SqlParameter("@AID", aid)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
// DataTable dt = SqlHelper.ExcuteTable(sql);
List <MODEL.HR_Department> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.HR_Department>();
foreach (DataRow row in dt.Rows)
{
MODEL.HR_Department c = new MODEL.HR_Department();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 获取部門信息
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.HR_Department> GetDapartment()
{
string sql = @"
select *
from HR_Department order by AID
";
// SqlParameter[] ps = {
// new SqlParameter("@CustomStyleCode",customstylecode)
// };
// DataTable dt = SqlHelper.ExcuteTable(sql, ps);
DataTable dt = SqlHelper.ExcuteTable(sql);
List <MODEL.HR_Department> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.HR_Department>();
foreach (DataRow row in dt.Rows)
{
MODEL.HR_Department c = new MODEL.HR_Department();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
///
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.HR_Department> GetAllDept()
{
string sql = @"
select* from HR_Department where(AID>=17.11111 and AID<17.99999) or(AID>=21.11111 and AID<21.99999)
or(AID>=19.1111 and AID<19.99999) and isDelete = '0'
";
//SqlParameter[] ps = {
// new SqlParameter("@AID",aid)
// };
// DataTable dt = SqlHelper.ExcuteTable(sql, ps);
DataTable dt = SqlHelper.ExcuteTable(sql);
List <MODEL.HR_Department> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.HR_Department>();
foreach (DataRow row in dt.Rows)
{
MODEL.HR_Department c = new MODEL.HR_Department();
LoadDataToList2(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 获取部門信息
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.HR_Department> GetDapartment(decimal aidfrom, decimal aidto)
{
string sql = @"
SELECT [AID] ,[UnitName],[Unit] ,[Title] ,[EmpID] ,[EmpName]
FROM [HR_Department]
where AID>=@AIDF
and AID<=@AIDT
order by AID
";
SqlParameter[] ps =
{
new SqlParameter("@AIDF", aidfrom),
new SqlParameter("@AIDT", aidto)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.HR_Department> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.HR_Department>();
foreach (DataRow row in dt.Rows)
{
MODEL.HR_Department c = new MODEL.HR_Department();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList(DataRow dr, MODEL.HR_Department department)
{
department.AID = (decimal)Convert.ToDecimal(SqlHelper.FromDbValue(dr["AID"]));
department.DeptID = (int?)(SqlHelper.FromDbValue(dr["DeptID"]));
department.Unit = (string)SqlHelper.FromDbValue(dr["Unit"]);
department.EmpName = (string)SqlHelper.FromDbValue(dr["EmpName"]);
department.UnitName = (string)SqlHelper.FromDbValue(dr["UnitName"]);
department.Apid = Convert.ToDecimal(SqlHelper.FromDbValue(dr["Apid"]));
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList2(DataRow dr, MODEL.HR_Department dep)
{
dep.AID = Convert.ToDecimal(SqlHelper.FromDbValue(dr["AID"]));
dep.Unit = (string)SqlHelper.FromDbValue(dr["Unit"]);
dep.UnitName = (string)SqlHelper.FromDbValue(dr["UnitName"]);
}
