C# (CSharp) Models.clsDataGetter示例

示例#1

文件： LoginController.cs 项目： area1websites/area1websites

        private void SetDocAccess(int ContactID)
        {
            Dist23MVC.Models.clsDataGetter dg = new Models.clsDataGetter(ConfigurationManager.ConnectionStrings["Dist23Data"].ConnectionString);
            Session["isDistrict"] = false;
            SqlDataReader dr = dg.GetDataReader("SELECT * FROM ContactPosition WHERE ContactID=" + ContactID.ToString());

            while (dr.Read())
            {
                int    gID   = (int)dr["GroupID"];
                Groups group = db.Groups.FirstOrDefault(x => x.pKey == gID);
                if (group.isDistrict == true)
                {
                    Session["isDistrict"] = true;
                }
                else
                {
                    Session["userGroup"] = dr["GroupID"];
                }
            }
            dg.KillReader(dr);
            dg = null;
        }

示例#2

文件： LoginController.cs 项目： stuartmayhew/dist23mvc

 private void SetDocAccess(int ContactID)
 {
     Dist23MVC.Models.clsDataGetter dg = new Models.clsDataGetter(ConfigurationManager.ConnectionStrings["Dist23Data"].ConnectionString);
     Session["isDistrict"] = false;
     SqlDataReader dr = dg.GetDataReader("SELECT * FROM ContactPosition WHERE ContactID=" + ContactID.ToString());
     while (dr.Read())
     {
         int gID = (int)dr["GroupID"];
         Groups group = db.Groups.FirstOrDefault(x => x.pKey == gID);
         if (group.isDistrict == true)
             Session["isDistrict"] = true;
         else
             Session["userGroup"] = dr["GroupID"];
     }
     dg.KillReader(dr);
     dg = null;
 }