Esempio n. 1
0
        public static string VerifySchoolIF_CodeIsExists(string SchoolIF_Id, string SchoolIF_Code)
        {
            string strJson = string.Empty;

            try
            {
                BLL_TPSchoolIF bll      = new BLL_TPSchoolIF();
                string         strWhere = string.Format(" SchoolIF_Code='{0}' ", SchoolIF_Code.Filter());
                if (!string.IsNullOrEmpty(SchoolIF_Id))
                {
                    strWhere += string.Format(" and SchoolIF_Id!='{0}' ", SchoolIF_Id.Filter());
                }
                if (bll.GetRecordCount(strWhere) > 0)
                {
                    strJson = Newtonsoft.Json.JsonConvert.SerializeObject(new { err = "error", errMsg = "标识已添加" });
                }
                else
                {
                    strJson = Newtonsoft.Json.JsonConvert.SerializeObject(new { err = "null", errMsg = "" });
                }
            }
            catch (Exception ex)
            {
                return(Newtonsoft.Json.JsonConvert.SerializeObject(new { err = "error", errMsg = "出现异常错误" }));
            }
            return(strJson);
        }
Esempio n. 2
0
        public static string loginIndex(string userName, string passWord, string backUrl)
        {
            string strJson = string.Empty;
            string iurl    = string.Empty;

            try
            {
                HttpContext.Current.Session["UserPublicUrl"] = null;
                string loginName     = string.Empty;
                string loginPassWord = string.Empty;
                loginName     = userName.Trim();
                loginPassWord = Rc.Common.StrUtility.DESEncryptLogin.EncryptString(passWord.Trim());
                Model_F_User loginModel = new Model_F_User();
                object       objFUser   = new BLL_F_User().GetModelByUserName(loginName);
                object       objIFUser  = new BLL_TPIFUser().GetModelByUserName(loginName);
                if (objFUser == null && objIFUser == null)
                {
                    HttpContext.Current.Session.Clear();
                    strJson = JsonConvert.SerializeObject(new
                    {
                        err  = "该账号不存在,请重新登录。",
                        iurl = ""
                    });
                    return(strJson);
                }

                #region 验证第三方接口用户
                if (objIFUser != null)
                {
                    Model_TPIFUser   modelIFUser = objIFUser as Model_TPIFUser;
                    Model_TPSchoolIF modelSIF    = new BLL_TPSchoolIF().GetModelBySchoolIF_Code(modelIFUser.School);
                    if (modelSIF == null)
                    {
                        HttpContext.Current.Session.Clear();
                        strJson = JsonConvert.SerializeObject(new
                        {
                            err  = "学校接口配置不存在,请重新登录。",
                            iurl = ""
                        });
                        return(strJson);
                    }
                    Model_ConfigSchool modelCS = new BLL_ConfigSchool().GetModelBySchoolIdNew(modelSIF.SchoolId);
                    if (modelCS == null)
                    {
                        HttpContext.Current.Session.Clear();
                        strJson = JsonConvert.SerializeObject(new
                        {
                            err  = "学校配置不存在,请重新登录。",
                            iurl = ""
                        });
                        return(strJson);
                    }

                    if (modelSIF.SchoolIF_Code == ThirdPartyEnum.ahjzvs.ToString())
                    {
                        #region 安徽金寨职业学校
                        loginModel = new BLL_F_User().GetModel(modelIFUser.UserName, loginPassWord);
                        if (loginModel == null)
                        {
                            Model_F_User loginModelNew = (Model_F_User)objFUser;
                            if (loginModelNew.Password == Rc.Common.StrUtility.DESEncryptLogin.EncryptString(Rc.Common.Config.Consts.DefaultPassword))
                            {
                                HttpContext.Current.Session.Clear();
                                strJson = JsonConvert.SerializeObject(new
                                {
                                    err  = "当前密码123456,过于简单,建议在个人中心中修改。",
                                    iurl = ""
                                });
                                return(strJson);
                            }
                            HttpContext.Current.Session.Clear();
                            strJson = JsonConvert.SerializeObject(new
                            {
                                err  = "用户密码错误,请重新登录。",
                                iurl = ""
                            });
                            return(strJson);
                        }

                        HttpContext.Current.Session["FLoginUser"] = loginModel;

                        if (loginModel.UserIdentity == "T")
                        {
                            //是否带班
                            int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + loginModel.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
                            if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
                            {
                                iurl = "/teacher/cTeachPlan.aspx";
                            }
                            else
                            {
                                iurl = "/teacher/basicSetting.aspx";
                            }
                        }
                        else if (loginModel.UserIdentity == "S")
                        {
                            iurl = "/student/oHomework.aspx";
                        }
                        else if (loginModel.UserIdentity == "P")
                        {
                            iurl = "/parent/student.aspx";
                        }

                        string local_url = string.Empty; // 局域网地址
                        #region 学校配置URL
                        DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(loginModel.UserId).Tables[0];
                        if (dtUrl.Rows.Count > 0)
                        {
                            HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
                            local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
                        }
                        #endregion
                        string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
                                                    , HttpContext.Current.Server.UrlEncode(iurl)
                                                    , HttpContext.Current.Server.UrlEncode(local_url));
                        if (dtUrl.Rows.Count > 0) // 有局域网配置数据,验证是否局域网
                        {
                            iurl = rurl;
                        }
                        if (string.IsNullOrEmpty(iurl))
                        {
                            iurl = string.Format("/RE_Register/PerfectInformation.aspx?SchoolId={0}&UserId={1}"
                                                 , modelCS.School_ID, loginModel.UserId);
                        }
                        strJson = JsonConvert.SerializeObject(new
                        {
                            err  = "null",
                            iurl = iurl
                        });
                        return(strJson);

                        #endregion
                    }
                    else
                    {
                        #region 其他学校
                        if (Rc.Interface.AuthAPI_pfunction.AuthUserLoginByIF(modelCS, modelIFUser.School, userName, passWord))
                        {
                            #region 登录
                            loginModel = new BLL_F_User().GetModelByUserName(modelIFUser.School + modelIFUser.UserName);
                            HttpContext.Current.Session["FLoginUser"] = loginModel;

                            if (loginModel.UserIdentity == "T")
                            {
                                //是否带班
                                int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + loginModel.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
                                if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
                                {
                                    iurl = "/teacher/cTeachPlan.aspx";
                                }
                                else
                                {
                                    iurl = "/teacher/basicSetting.aspx";
                                }
                            }
                            else if (loginModel.UserIdentity == "S")
                            {
                                iurl = "/student/oHomework.aspx";
                            }
                            else if (loginModel.UserIdentity == "P")
                            {
                                iurl = "/parent/student.aspx";
                            }

                            string local_url = string.Empty; // 局域网地址
                            #region 学校配置URL
                            DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(loginModel.UserId).Tables[0];
                            if (dtUrl.Rows.Count > 0)
                            {
                                HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
                                local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
                            }
                            #endregion
                            string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
                                                        , HttpContext.Current.Server.UrlEncode(iurl)
                                                        , HttpContext.Current.Server.UrlEncode(local_url));
                            if (dtUrl.Rows.Count > 0) // 有局域网配置数据,验证是否局域网
                            {
                                iurl = rurl;
                            }
                            if (string.IsNullOrEmpty(iurl))
                            {
                                iurl = string.Format("/RE_Register/PerfectInformation.aspx?SchoolId={0}&UserId={1}", modelCS.School_ID, loginModel.UserId);
                            }
                            strJson = JsonConvert.SerializeObject(new
                            {
                                err  = "null",
                                iurl = iurl
                            });
                            return(strJson);

                            #endregion
                        }
                        else
                        {
                            HttpContext.Current.Session.Clear();
                            strJson = JsonConvert.SerializeObject(new
                            {
                                err  = "接口用户密码错误,请重新登录。",
                                iurl = ""
                            });
                            return(strJson);
                        }
                        #endregion
                    }
                }
                #endregion

                #region 验证作业平台用户
                if (objFUser != null)
                {
                    objFUser = new BLL_F_User().GetModel(loginName, loginPassWord);
                    if (objFUser != null)
                    {
                        #region 登录
                        loginModel = objFUser as Model_F_User;
                        HttpContext.Current.Session["FLoginUser"] = loginModel;

                        if (loginModel.UserIdentity == "T")
                        {
                            //是否带班
                            int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + loginModel.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
                            if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
                            {
                                iurl = "/teacher/cTeachPlan.aspx";
                            }
                            else
                            {
                                iurl = "/teacher/basicSetting.aspx";
                            }
                        }
                        else if (loginModel.UserIdentity == "S")
                        {
                            iurl = "/student/oHomework.aspx";
                        }
                        else if (loginModel.UserIdentity == "P")
                        {
                            iurl = "/parent/student.aspx";
                        }

                        if (!string.IsNullOrEmpty(backUrl))
                        {
                            iurl = backUrl;
                        }
                        #endregion
                        if (string.IsNullOrEmpty(loginModel.TrueName))
                        {
                            loginModel.TrueName = loginModel.UserName;
                            new BLL_F_User().Update(loginModel);
                        }

                        string local_url = string.Empty; // 局域网地址
                        #region 学校配置URL
                        DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(loginModel.UserId).Tables[0];
                        if (dtUrl.Rows.Count > 0)
                        {
                            HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
                            local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
                        }
                        #endregion
                        string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
                                                    , HttpContext.Current.Server.UrlEncode(iurl)
                                                    , HttpContext.Current.Server.UrlEncode(local_url));
                        if (dtUrl.Rows.Count > 0) // 有局域网配置数据,验证是否局域网
                        {
                            iurl = rurl;
                        }
                        strJson = JsonConvert.SerializeObject(new
                        {
                            err  = "null",
                            iurl = iurl
                        });
                    }
                    else
                    {
                        HttpContext.Current.Session.Clear();
                        strJson = JsonConvert.SerializeObject(new
                        {
                            err  = "用户密码错误,请重新登录。",
                            iurl = ""
                        });
                    }
                }
                else
                {
                    HttpContext.Current.Session.Clear();
                    strJson = JsonConvert.SerializeObject(new
                    {
                        err  = "该账号不存在,请重新登录。。",
                        iurl = ""
                    });
                }
                #endregion
            }
            catch (Exception ex)
            {
                strJson = JsonConvert.SerializeObject(new
                {
                    err  = "null",
                    iurl = "/ErrorPageF.aspx?errorType=6"
                });
                Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS("", "用户登录", ex.Message.ToString());
            }

            return(strJson);
        }
        /// <summary>
        /// 处理用户信息,返回用户登录后网页地址 18-01-03TS
        /// </summary>
        public static string HandelUserInfo(string schoolCode, string loginName, string trueName)
        {
            string iurl     = string.Empty;
            string schoolId = string.Empty;

            List <Model_TPIFUser> listIFUser  = new BLL_TPIFUser().GetModelList("UserName='******'");
            Model_TPIFUser        modelIFUser = new BLL_TPIFUser().GetModelBySchoolUserName(schoolCode, loginName);

            if (schoolCode == ThirdPartyEnum.ahjzvs.ToString())
            {
                #region 安徽金寨职业学校
                if (modelIFUser != null)//用户已登录过
                {
                    #region 登录
                    Model_F_User loginModel = new BLL_F_User().GetModelByUserName(modelIFUser.UserName);
                    HttpContext.Current.Session["FLoginUser"] = loginModel;

                    if (loginModel.UserIdentity == "T")
                    {
                        //是否带班
                        int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + loginModel.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
                        if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
                        {
                            iurl = "/teacher/cTeachPlan.aspx";
                        }
                        else
                        {
                            iurl = "/teacher/basicSetting.aspx";
                        }
                    }
                    else if (loginModel.UserIdentity == "S")
                    {
                        iurl = "/student/oHomework.aspx";
                    }
                    else if (loginModel.UserIdentity == "P")
                    {
                        iurl = "/parent/student.aspx";
                    }

                    string local_url = string.Empty; // 局域网地址
                    #region 学校配置URL
                    DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(loginModel.UserId).Tables[0];
                    if (dtUrl.Rows.Count > 0)
                    {
                        HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
                        local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
                    }
                    #endregion
                    string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
                                                , HttpContext.Current.Server.UrlEncode(iurl)
                                                , HttpContext.Current.Server.UrlEncode(local_url));
                    if (dtUrl.Rows.Count > 0) // 有局域网配置数据,验证是否局域网
                    {
                        iurl = rurl;
                    }
                    if (string.IsNullOrEmpty(iurl))
                    {
                        Model_TPSchoolIF modelSIF = new BLL_TPSchoolIF().GetModelBySchoolIF_Code(schoolCode);
                        if (modelSIF != null)
                        {
                            schoolId = modelSIF.SchoolId;
                        }
                        iurl = string.Format("/RE_Register/PerfectInformation.aspx?SchoolId={0}&UserId={1}", schoolId, loginModel.UserId);
                    }
                    #endregion
                }
                else
                {
                    #region 第一次登录,写入用户数据
                    Model_TPSchoolIF modelSIF = new BLL_TPSchoolIF().GetModelBySchoolIF_Code(schoolCode);
                    if (modelSIF != null)
                    {
                        schoolId = modelSIF.SchoolId;
                    }
                    string userId = Guid.NewGuid().ToString();
                    #region TPIFUser
                    modelIFUser = new Model_TPIFUser();
                    modelIFUser.ThirdPartyIFUser_Id = Guid.NewGuid().ToString();
                    modelIFUser.School     = schoolCode;
                    modelIFUser.UserName   = loginName;
                    modelIFUser.CreateTime = DateTime.Now;
                    new BLL_TPIFUser().Add(modelIFUser);
                    #endregion
                    #region F_User
                    Model_F_User modelFUser = new Model_F_User();
                    modelFUser.UserId     = userId;
                    modelFUser.UserName   = loginName;
                    modelFUser.TrueName   = trueName;
                    modelFUser.Password   = DESEncryptLogin.EncryptString(Rc.Common.Config.Consts.DefaultPassword);
                    modelFUser.CreateTime = DateTime.Now;
                    new BLL_F_User().Add(modelFUser);
                    #endregion
                    iurl = string.Format("/RE_Register/PerfectInformation.aspx?userId={0}&schoolId={1}", userId, schoolId);
                    #endregion
                }
                #endregion
            }
            else
            {
                #region 其他学校
                if (modelIFUser != null)//用户已登录过
                {
                    #region 登录
                    Model_F_User loginModel = new BLL_F_User().GetModelByUserName(modelIFUser.School + modelIFUser.UserName);
                    HttpContext.Current.Session["FLoginUser"] = loginModel;

                    if (loginModel.UserIdentity == "T")
                    {
                        //是否带班
                        int classCount = new BLL_UserGroup().GetRecordCount(" UserGroup_AttrEnum='Class' and UserGroup_Id in(select UserGroup_Id from UserGroup_Member where USER_ID='" + loginModel.UserId + "' and User_ApplicationStatus='passed' and UserStatus='0') ");
                        if (classCount > 0 && (Rc.Cloud.Web.Common.pfunction.GetWebMdlIsShow("cTeachPlan")))
                        {
                            iurl = "/teacher/cTeachPlan.aspx";
                        }
                        else
                        {
                            iurl = "/teacher/basicSetting.aspx";
                        }
                    }
                    else if (loginModel.UserIdentity == "S")
                    {
                        iurl = "/student/oHomework.aspx";
                    }
                    else if (loginModel.UserIdentity == "P")
                    {
                        iurl = "/parent/student.aspx";
                    }

                    string local_url = string.Empty; // 局域网地址
                    #region 学校配置URL
                    DataTable dtUrl = new BLL_ConfigSchool().GetSchoolPublicUrl(loginModel.UserId).Tables[0];
                    if (dtUrl.Rows.Count > 0)
                    {
                        HttpContext.Current.Session["UserPublicUrl"] = dtUrl.Rows[0]["publicUrl"];
                        local_url = dtUrl.Rows[0]["apiUrlList"].ToString();
                    }
                    #endregion
                    string rurl = string.Format("/onlinecheck.aspx?iurl={0}&local_url={1}"
                                                , HttpContext.Current.Server.UrlEncode(iurl)
                                                , HttpContext.Current.Server.UrlEncode(local_url));
                    if (dtUrl.Rows.Count > 0) // 有局域网配置数据,验证是否局域网
                    {
                        iurl = rurl;
                    }
                    if (string.IsNullOrEmpty(iurl))
                    {
                        Model_TPSchoolIF modelSIF = new BLL_TPSchoolIF().GetModelBySchoolIF_Code(schoolCode);
                        if (modelSIF != null)
                        {
                            schoolId = modelSIF.SchoolId;
                        }
                        iurl = string.Format("/RE_Register/PerfectInformation.aspx?SchoolId={0}&UserId={1}", schoolId, loginModel.UserId);
                    }
                    #endregion
                }
                else
                {
                    #region 第一次登录,写入用户数据
                    Model_TPSchoolIF modelSIF = new BLL_TPSchoolIF().GetModelBySchoolIF_Code(schoolCode);
                    if (modelSIF != null)
                    {
                        schoolId = modelSIF.SchoolId;
                    }
                    string userId = Guid.NewGuid().ToString();
                    #region TPIFUser
                    modelIFUser = new Model_TPIFUser();
                    modelIFUser.ThirdPartyIFUser_Id = Guid.NewGuid().ToString();
                    modelIFUser.School     = schoolCode;
                    modelIFUser.UserName   = loginName;
                    modelIFUser.CreateTime = DateTime.Now;
                    new BLL_TPIFUser().Add(modelIFUser);
                    #endregion
                    #region F_User
                    Model_F_User modelFUser = new Model_F_User();
                    modelFUser.UserId     = userId;
                    modelFUser.UserName   = schoolCode + loginName;
                    modelFUser.TrueName   = trueName;
                    modelFUser.CreateTime = DateTime.Now;
                    new BLL_F_User().Add(modelFUser);
                    #endregion
                    iurl = "/RE_Register/PerfectInformation.aspx?userId=" + userId + "&schoolId=" + schoolId;
                    #endregion
                }
                #endregion
            }
            return(iurl);
        }
Esempio n. 4
0
        public static string GetDataList(string Key, string Name, int PageIndex, int PageSize)
        {
            try
            {
                BLL_TPSchoolIF bll = new BLL_TPSchoolIF();
                Key  = Key.Filter();
                Name = Name.Filter();

                DataTable     dt         = new DataTable();
                List <object> listReturn = new List <object>();
                string        strWhere   = " 1=1 ";
                if (!string.IsNullOrEmpty(Key))
                {
                    strWhere += string.Format(" and SchoolIF_Code like '%{0}%' ", Key);
                }
                if (!string.IsNullOrEmpty(Name))
                {
                    strWhere += string.Format(" and (SchoolIF_Name like '%{0}%' or SchoolId like '%{0}%' or SchoolName like '%{0}%') ", Name);
                }

                string orderBy = "SchoolIF_Code";
                dt = bll.GetListByPageSchool(strWhere, orderBy, ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
                int rCount = bll.GetRecordCountSchool(strWhere);

                foreach (DataRow item in dt.Rows)
                {
                    string strOperate = string.Empty;
                    if (item["SchoolIF_Code"].ToString() == ThirdPartyEnum.ahjzvs.ToString())
                    {
                        strOperate = string.Format("<a href=\"javascript:;\" onclick=\"HandleUserData('{0}','{1}')\" >初始化用户</a>"
                                                   , item["SchoolIF_Code"].ToString(), item["SchoolId"].ToString());
                        if (new BLL_FileSyncExecRecord().GetRecordCount("FileSyncExecRecord_Status='0' and FileSyncExecRecord_Type='初始化用户数据" + item["SchoolIF_Code"] + "'") > 0)
                        {
                            strOperate = "<a href=\"javascript:;\">正在初始化用户</a>";
                        }
                    }
                    listReturn.Add(new
                    {
                        SchoolIF_Id   = item["SchoolIF_Id"].ToString(),
                        SchoolIF_Code = item["SchoolIF_Code"].ToString(),
                        SchoolIF_Name = item["SchoolIF_Name"].ToString(),
                        SchoolId      = item["SchoolId"].ToString(),
                        SchoolName    = item["SchoolName"].ToString(),
                        Remark        = item["Remark"].ToString(),
                        Operate       = strOperate
                    });
                }

                if (dt.Rows.Count > 0)
                {
                    return(JsonConvert.SerializeObject(new
                    {
                        err = "null",
                        PageIndex = PageIndex,
                        PageSize = PageSize,
                        TotalCount = rCount,
                        list = listReturn
                    }));
                }
                else
                {
                    return(JsonConvert.SerializeObject(new
                    {
                        err = "暂无数据"
                    }));
                }
            }
            catch (Exception ex)
            {
                return(JsonConvert.SerializeObject(new
                {
                    err = ex.Message.ToString()
                }));
            }
        }