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; }