コード例 #1
0
    public string GetAllUsersHTMLForAdmin()
    {
        string RetVal;
        int Counter;
        diworldwide_userinfo.UserLoginInformation Service;
        DIConnection DIConnection = null;
        DataTable DtUsers = null;

        RetVal = string.Empty;
        Counter = 0;

        try
        {
            if (ConfigurationManager.AppSettings[Constants.WebConfigKey.IsGlobalAllow].ToLower() == "true")
            {
                Service = new diworldwide_userinfo.UserLoginInformation();
                Service.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.UserLoginService;
                DtUsers = Service.GetAllUsersGridHTML(Global.GetAdaptationGUID());
            }
            else
            {
                DIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("~//stock//Database.mdb"),
                          string.Empty, string.Empty);

                DtUsers = DIConnection.ExecuteDataTable("SELECT NId, User_Email_Id as Email, User_First_Name as [First Name], User_Country as [User Country], User_Is_Admin as [Admin User], User_Is_Provider as [Provider User] FROM Users Where User_Is_Admin = 'False'");
            }

            DtUsers = this.Replace_AreaNIds_With_Names(DtUsers);

            RetVal = "<table id=\"tblUsers\" style=\"width:100%;float:left\" border=\"0\" cellSpacing=\"0\" cellPadding=\"0\" class=\"roundedcorners\">";
            RetVal += "<tbody>";

            RetVal += "<tr class=\"HeaderRowStyle\">";

            RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanEmail\"></span></td>";
            RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanName\"></span></td>";
            RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanCountry\"></span></td>";
            RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanProvider\"></span></td>";

            RetVal += "</tr>";

            foreach (DataRow DrUsers in DtUsers.Rows)
            {
                Counter++;

                if (Counter % 2 == 0)
                {
                    RetVal += "<tr class=\"SelectedDataRowStyle\">";
                }
                else
                {
                    RetVal += "<tr class=\"DataRowStyle\">";
                }

                RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["Email"].ToString() + "</td>";
                RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["First Name"].ToString() + "</td>";
                RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["User Country"].ToString() + "</td>";

                if (DrUsers["Provider User"].ToString().ToLower() == "true")
                {
                    RetVal += "<td class=\"CheckBoxDataColumnStyle\"><input type=\"checkbox\" id=\"chkUser_" + DrUsers["NId"].ToString() + "\" value=\"" + DrUsers["NId"].ToString() + "\" checked=\"checked\"/></td>";
                }
                else
                {
                    RetVal += "<td class=\"CheckBoxDataColumnStyle\"><input type=\"checkbox\" id=\"chkUser_" + DrUsers["NId"].ToString() + "\" value=\"" + DrUsers["NId"].ToString() + "\"/></td>";
                }

                RetVal += "</tr>";
            }

            RetVal += "</tbody>";
            RetVal += "</table>";
        }
        catch (Exception ex)
        {
            Global.CreateExceptionString(ex, null);
            throw ex;
        }
        finally
        {
        }

        return RetVal;
    }