/// <summary>
/// ��ȡ��ǰ���Ŷ���
/// </summary>
/// <param name="iDeptID">��ȡ���ű��</param>
/// <returns></returns>
public DepartmentModel Department_GetModel(int iDeptID)
{
string strsql = "select * from Department where DEPT_ID=" + iDeptID.ToString();
ShineKJ.DAL.KJ128.DataBaseDAL databasedal = new ShineKJ.DAL.KJ128.DataBaseDAL();
DataSet ds = databasedal.ExecSql(strsql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DepartmentModel model = new DepartmentModel();
DataRow dr = ds.Tables[0].Rows[0];
model.DEPT_FUNC = dr["DEPT_FUNC"].ToString();
model.DEPT_ID = int.Parse(dr["DEPT_ID"].ToString());
model.DEPT_NAME = dr["DEPT_NAME"].ToString();
model.DEPT_NO = dr["DEPT_NO"].ToString();
model.DEPT_PARENT = int.Parse(dr["DEPT_PARENT"].ToString());
model.FAX_NO = dr["FAX_NO"].ToString();
model.LEADER1 = dr["LEADER1"].ToString();
model.LEADER2 = dr["LEADER2"].ToString();
model.MANAGER = dr["MANAGER"].ToString();
model.TEL_NO = dr["TEL_NO"].ToString();
return model;
}
else
return null;
}
/// <summary>
/// 获取部门列表
/// </summary>
/// <returns></returns>
public DataSet Get_DeptList()
{
ShineKJ.DAL.KJ128.DataBaseDAL dal = new ShineKJ.DAL.KJ128.DataBaseDAL();
try
{
return dal.RunProcWithOutPara("Mine_Get_DeptList");
}
catch
{
return null;
}
}
/// <summary>
/// ��ȡ��ѡ��IJ�������
/// </summary>
/// <param name="strIDs">���ű��</param>
/// <returns></returns>
public string Department_GetDeptNamestr(string strIDs)
{
if (strIDs.Equals("ALL_DEPT"))
return "ȫ�岿��";
else if (strIDs.Equals(""))
return "";
else
{
string strDeptNames = string.Empty;
string strsql = "select DEPT_NAME from Department where DEPT_ID in (" + strIDs.Remove(strIDs.LastIndexOf(",")) + ")";
ShineKJ.DAL.KJ128.DataBaseDAL databasedal = new ShineKJ.DAL.KJ128.DataBaseDAL();
DataSet ds = databasedal.ExecSql(strsql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
strDeptNames += dr["DEPT_NAME"].ToString() + ",";
}
}
return strDeptNames;
}
}
