public List<OA_ROLE_TYPE> SelectRoleList(string RoleName)
{
Database db = DatabaseFactory.CreateDatabase(WorkFlowConnStr);
string strSql = "";
string Cmp_Code = System.Web.HttpContext.Current.Session["EPORTID"].ToString();
if (RoleName == null || RoleName.Trim() == "")
{
strSql = "SELECT ROLEGUID,ROLENAME,NOTE,OrderNo FROM OA_ROLE_TYPE WHERE CMP_CODE='" + Cmp_Code + "' ORDER BY OrderNo DESC";
}
else
{
strSql = "SELECT ROLEGUID,ROLENAME,NOTE,OrderNo FROM OA_ROLE_TYPE WHERE CMP_CODE='" + Cmp_Code + "' AND ROLENAME LIKE '%" + RoleName + "%' ORDER BY OrderNo DESC";
}
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
List<OA_ROLE_TYPE> ORTList = new List<OA_ROLE_TYPE>();
for (int i = 0; i < dv.Count; i++)
{
OA_ROLE_TYPE ORT = new OA_ROLE_TYPE();
ORT.Note = dv[i]["NOTE"].ToString();
ORT.OrderNo = Convert.ToInt32(dv[i]["OrderNo"].ToString());
ORT.RoleGuid = dv[i]["ROLEGUID"].ToString();
ORT.RoleName = dv[i]["ROLENAME"].ToString();
ORTList.Add(ORT);
}
return ORTList;
}
public OA_ROLE_TYPE SelectRole(string RoleGuid)
{
Database db = DatabaseFactory.CreateDatabase(WorkFlowConnStr);
string strSql = "SELECT ROLEGUID,ROLENAME,NOTE,OrderNo FROM OA_ROLE_TYPE WHERE ROLEGUID='" + RoleGuid + "' ORDER BY OrderNo DESC";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
OA_ROLE_TYPE ORT = new OA_ROLE_TYPE();
if (dv.Count > 0)
{
ORT.Note = dv[0]["NOTE"].ToString();
ORT.OrderNo = Convert.ToInt32(dv[0]["OrderNo"].ToString());
ORT.RoleGuid = dv[0]["ROLEGUID"].ToString();
ORT.RoleName = dv[0]["ROLENAME"].ToString();
}
return ORT;
}
