62,242
社区成员




protected string GetPosition(object id)
{
try
{
string positon="";
string sql = "select b.title from A_RoleEmpRelation a ,A_Role b where a.roleid=b.id and a.empid='" + id.ToString() + "' group by b.title";
DataTable dt = Class1.ExecSel(sql);
if (dt.Rows.Count > 0)
{
int i = dt.Rows.Count;
positon += dt.Rows[0]["title"].ToString() + ",";
positon = positon.Substring(0, positon.Length - 1);
return positon;
}
else
return null;
}
catch
{
return null;
}
}