public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误!"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; //验证登录 if (!new Login().isLogin(ref Trans)) { return; } switch (Trans.Command.ToString()) { //切换机构列表 case "ChangePassword": Trans.Result = ChangePassword(Row); break; case "GetUserRole": Trans.Result = GetUserRole(Row); break; case "UploadPhoneInfo": Trans.Result = AddPhoneInfo(Row); break; case "UploadPhoneToken": Trans.Result = AddPhoneToken(Row); break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { case "SubmitProposal": Trans.Result = SubmitProposal(Row); //提交建议 break; case "SetEvaluation": Trans.Result = SetEvaluation(Row); //评价 break; case "GetProposalInfo": Trans.Result = GetProposalInfo(Row); //获取建议 break; case "GetProposalInfoList": //所有建议 Trans.Result = GetProposalInfoList(Row); break; default: break; } }
public static void OperateRSA(ref Common.Transfer Trans, string MacType) { try { PubInfo Rp = (PubInfo)Assembly.Load("Business").CreateInstance("Business." + Trans.Class); //验证令牌请求 //string HashString = Trans.Attribute.ToString() + DateTime.Now.ToString("yyyyMMdd") + Rp.Token.ToString(); //解密参数 //string mac = RSAHelperBGY.getInstance(MacType).Encrypt("<attributes><LoginCode>yinlian</LoginCode><Password>yl@123</Password><ComCode>UnionPay</ComCode><Token>20180528IntelligencePOS_Y</Token></attributes>"); //new Logger().WriteLog("Mac", Trans.Mac); if (MacType == "UnionPay") { Trans.Attribute = System.Web.HttpUtility.UrlDecode(RSAHelperBGY.getInstance(MacType).Decrypt(Trans.Mac)); new Logger().WriteLog("post数据", "http://218.13.58.36:8888/Service/BGYPost.ashx?Class=" + Trans.Class + "&Command=" + Trans.Command + "&ComCode=UnionPay&Mac=" + Trans.Mac + "&Attribute=" + Trans.Attribute); } else { Trans.Attribute = System.Web.HttpUtility.UrlDecode(RSAHelperBGY_ALL.getInstance(MacType).Decrypt(Trans.Mac)); } Rp.Operate(ref Trans); } catch (Exception ex) { Trans.Error = JSONHelper.JsonConvertBGY("0001", ex.Message, ""); } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { case "SendStatusForZL": // 获取小区信息 string str = SendStatusForZL(0, 0, "", ""); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误!"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; //验证登录 if (!new Login().isLogin(ref Trans)) { return; } switch (Trans.Command.ToString()) { //报事抢单数量 case "QiangDanCount": break; // 报事分派数量 case "IncidentAssignedCount": Trans.Result = GetWaitWorkCount_Assigned(Row); break; //报事处理数量 case "IncidentCount": Trans.Result = GetWaitWorkCount_Incident(Row); break; //业务审批数量 case "BusinessCheckCount": Trans.Result = GetWaitWorkCount_Business(Row); break; //OA待办审批数量 case "OACheckCount": Trans.Result = GetWaitWorkCount_OA(Row); break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = "false:"; DataSet Ds = base.XmlToDataSet(Trans.Attribute); DataRow Row = Ds.Tables[0].Rows[0]; switch (Trans.Command) { //创建订单 case "GenerateOrder": Trans.Result = GenerateOrder(Ds); break; //创建线下订单 case "GenerateOfflineOrder": Trans.Result = GenerateOfflineOrder(Ds); break; //订单继续支付 case "GoOnGenerateOrder": Trans.Result = GoOnGenerateOrder(Ds); break; //订单确认收款成功 case "ReceBusinessOrder": Trans.Result = ReceBusinessOrder(Row["OrderId"].ToString(), AppGlobal.StrToDec(Row["RealAmount"].ToString())); break; //订单退款 case "CancelOrder": Trans.Result = CancelOrder(Row["OrderId"].ToString()); break; default: break; } }
public void ProcessRequest(HttpContext context) { Common.Transfer Trans = new Common.Transfer(); //密钥类型 //不同调用者密钥不同 string MacType = ""; HttpRequest Request = context.Request; Trans.Class = Request["Class"].ToString(); Trans.Command = Request["Command"].ToString(); Trans.Mac = Request["Mac"].ToString(); if (Request["ComCode"] != null) { MacType = Request["ComCode"].ToString(); } PubContext.OperateRSA(ref Trans, MacType); context.Response.ContentType = "text/plain"; context.Response.AddHeader("Access-Control-Allow-Origin", "*"); context.Response.Write(Trans.Output()); }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误!"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; //验证登录 if (!new Login().isLogin(ref Trans)) { return; } switch (Trans.Command.ToString()) { //切换机构列表 case "OrganList": Trans.Result = Sys_Organ_GetEntryNodes(Global_Var.LoginUserCode); break; case "GetAllCommunity": Trans.Result = GetAllCommunity(); break; } }
/// <summary> /// 获取验证码 /// </summary> /// <param name="Row"></param> /// <returns></returns> private string GetVerifyCode(DataRow Row, Common.Transfer Trans) { if (Row.Table.Columns.Contains("Mobile") && !String.IsNullOrEmpty(Row["Mobile"].ToString())) { if (Row.Table.Columns.Contains("VerifyCode") && !String.IsNullOrEmpty(Row["VerifyCode"].ToString())) { // 鸿坤 单独写接口 //// 查询该手机号是否已经注册 //using (var conn = new SqlConnection(PubConstant.UnifiedContionString)) //{ // if (conn.Query(@"SELECT * FROM Tb_User WHERE Mobile=@Mobile", new { Mobile = Row["Mobile"].ToString() }).Count() > 0) // { // return JSONHelper.FromString(false, @"该手机号已注册"); // } //} //解密验证码 int code = AppGlobal.StrToInt(RSAHelper.getInstance().Decrypt(Row["VerifyCode"].ToString())); //新增4位验证码 if (code > 0 && (code.ToString().Length == 6 || code.ToString().Length == 4))//六位字验证 { //MAC验证 DataSet ds = new Bll_Tb_SendMessageRecord().GetList(" MacCode='" + Trans.Mac + "' "); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return(JSONHelper.FromString(false, "无效操作")); } Tb_Sms_Account smsModel = SmsInfo.GetSms_Account(); string Content = "您的验证码为:" + code + "" + smsModel.Sign; Tb_SendMessageRecord m = new Tb_SendMessageRecord(); try { //记录短信 m = new Bll_Tb_SendMessageRecord().Add(Row["Mobile"].ToString(), Content, Trans.Mac, "天问验证码", ""); } catch (Exception ex) { return(JSONHelper.FromString(false, "无效操作")); } //发送短信 //int Result = Common.Sms.Send(smsModel.SmsAccount, smsModel.SmsPwd, Row["Mobile"].ToString(), Content, "", ""); int Result = Common.Sms.Send_v2(smsModel.SmsUserId, smsModel.SmsAccount, smsModel.SmsPwd, Row["Mobile"].ToString(), Content, out string strErrMsg); string Resul = ""; switch (Result) { case 0: Resul = "发送成功"; break; case -4: Resul = "手机号码格式不正确"; break; default: Resul = "发送失败:" + Result; break; } //修改状态 m.SendState = Result.ToString(); //重写短信记录状态 new Bll_Tb_SendMessageRecord().Update(m); if (Result == 0) { return(JSONHelper.FromString(true, Resul)); } else { return(JSONHelper.FromString(false, strErrMsg)); } } else { //new Bll_Tb_SendMessageRecord().Add(Row["Mobile"].ToString(), "", "", "天问验证码", ""); return(JSONHelper.FromString(false, "参数VerifyCode格式错误")); } } else { //new Bll_Tb_SendMessageRecord().Add(Row["Mobile"].ToString(), "", "", "天问验证码", ""); return(JSONHelper.FromString(false, "缺少参数VerifyCode")); } } else { return(JSONHelper.FromString(false, "缺少参数Mobile")); } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { case "RegisterUser": Trans.Result = RegisterUser(Row); //注册用户 break; case "RegisterUser_WeiXin": //微信公共号注册 Trans.Result = RegisterUser_WeiXin(Row); break; case "RegisterUser_WeiXin_hnc": //微信公共号注册,华南城 Trans.Result = RegisterUser_WeiXin_hnc(Row); break; case "GetVerifyCode": //获取验证码 Trans.Result = GetVerifyCode(Row, Trans); break; case "UserLogin": //业主登录 Trans.Result = UserLogin(Row, Trans); break; case "UserLoginLocationCommunity": //业主登录,自动定位到小区 Trans.Result = UserLoginLocationCommunity(Row, Trans); break; case "UserLogin_WeiXin": //微信公共号登录 Trans.Result = UserLogin_WeiXin(Row); break; case "CheckPayInfo": Trans.Result = CheckPayInfo(Row, Trans); break; case "CheckRedWuYeInfo": Trans.Result = CheckRedWuYeInfo(Row, Trans); break; case "GetVerifyCodeForPwd": //发送验证码---忘记密码 Trans.Result = GetVerifyCodeForPwd(Row, Trans); break; case "CheckVerifyCode": //验证修改密码的验证码 Trans.Result = CheckVerifyCode(Row); break; case "UpdateUserPwd": //修改密码 Trans.Result = UpdateUserPwd(Row); break; case "RegisterUser_WeiXin_RH": //微信公共号注册_融汇 Trans.Result = RegisterUser_WeiXin_RH(Row); break; default: break; } }
public static void Operate(ref Common.Transfer Trans) { try { PubInfo Rp = (PubInfo)Assembly.Load("Business").CreateInstance("Business." + Trans.Class); var HashString = Trans.Attribute.ToString() + DateTime.Now.ToString("yyyyMMdd") + Rp.Token; var Mac = AppPKI.getMd5Hash(HashString); #region 针对参数值带特殊字符的进行修改转义 if (Trans.Attribute.Contains("&")) { Trans.Attribute = Trans.Attribute.Replace("&", "&"); } #endregion //鸿坤第三方 不要安全验证 单独去掉 if (Trans.Class == "HKCallCenter") { Rp.Operate(ref Trans); } else if (Trans.Class == "DataVHJ") { //合景datav 大屏 去掉验证 Rp.Operate(ref Trans); } else if (Trans.Class == "ContractAuditInfo_FanWei") { //合景经营合同审核 去掉验证 Rp.Operate(ref Trans); } else if (Trans.Class == "PolyDataV") { //合景datav 大屏 去掉验证 Rp.Operate(ref Trans); } else if (Trans.Class == "CostInfoSunshineNewest") { Rp.Operate(ref Trans); } else if (Trans.Class == "HKParkCostInfo") { Rp.Operate(ref Trans); } else if (Trans.Class == "CostInfo_RS" || Trans.Class == "Meter_RS" || Trans.Class == "Material_RS") { if (Trans.Mac == Mac) { Rp.Operate(ref Trans); } else { Trans.Error = "验证令牌错误"; } } else { if (HttpContext.Current.Request.Url.Host.ToLower() == "localhost") { Rp.Operate(ref Trans); } else { if (!OperateKnownClass(ref Trans)) { if (Trans.Mac == Mac) { Rp.Operate(ref Trans); } else { Trans.Error = "验证令牌错误"; } } } } } catch (Exception ex) { PubInfo.GetLog().Error(ex); Trans.Error = new ApiResult(false, ex.Message + Environment.NewLine + ex.StackTrace).toJson(); } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误"); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; if (Row.Table.Columns.Contains("AppKey") && Row.Table.Columns.Contains("AppNum")) { app_key = Row["AppKey"].ToString(); app_num = Row["AppNum"].ToString(); } if (string.IsNullOrEmpty(app_key) || string.IsNullOrEmpty(app_num)) { Trans.Result = JSONHelper.FromString(false, "未配置AppKey或AppNum"); return; } switch (Trans.Command) { case "getUserKey": Trans.Result = GetUserKeys(Row); //获取用户开门钥匙 break; case "addCommunity": Trans.Result = AddCommunity(Row); //添加小区 break; case "getCommunity": Trans.Result = GetCommunity(Row); //获取小区 break; case "queryDevice": Trans.Result = QueryDevice(Row); //查询设备门禁PID break; case "installLock": Trans.Result = InstallLock(Row); //安装门禁登记 break; case "applyKeys": Trans.Result = ApplyKeys(Row); //申请用户钥匙凭证 break; case "wx_bindDevice": Trans.Result = WX_BindDevice(Row); //绑定微信用户 break; case "wx_getInfoKey": Trans.Result = WX_GetInfoKey(Row); //获取微信开门相关信息 break; case "wx_createMKey": Trans.Result = WX_CreateMKey(Row); //生成访客钥匙 break; case "wx_activeMkey": Trans.Result = WX_ActiveMkey(Row); //激活访客钥匙 break; case "wx_synDeviceService": Trans.Result = WX_SyncDeviceService(Row); //激活访客钥匙 break; case "wx_OpenDoor": Trans.Result = WX_OpenDoor(Row); //获取微信开门密钥 break; case "CreateShareKey": Trans.Result = CreateShareKey(Row); //获取微信开门密钥 break; default: break; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.AddHeader("Access-Control-Allow-Origin", "*"); try { Common.Transfer Trans = new Common.Transfer(); HttpRequest Request = context.Request; if (!Request.Params.AllKeys.Contains("Class")) { context.Response.Write(new ApiResult(false, "缺少参数Class").toJson()); return; } //获取要执行的类名称 Trans.Class = Request["Class"].ToString(); if (string.IsNullOrEmpty(Trans.Class)) { context.Response.Write(new ApiResult(false, "Class不能为空").toJson()); return; } if (!Request.Params.AllKeys.Contains("Command")) { context.Response.Write(new ApiResult(false, "缺少参数Command").toJson()); return; } //wlg 20191204 没有地方使用??? if (Request["QYID"] != null) { Trans.QYID = Request["QYID"].ToString(); } //wlg 20191204 没有地方使用??? if (Request["QYUnitType"] != null) { Trans.QYUnitType = Request["QYUnitType"].ToString(); } //获取命令类型 Trans.Command = Request["Command"].ToString(); if (string.IsNullOrEmpty(Trans.Command)) { context.Response.Write(new ApiResult(false, "Command不能为空").toJson()); return; } if (Request.Params.AllKeys.Contains("Agreement")) { Trans.Agreement = HttpUtility.UrlDecode(Request["Agreement"].ToString());//碧桂园 获取协议html代码 } //获取属性xml格式字符串 if (!Request.Params.AllKeys.Contains("Attribute")) { context.Response.Write(new ApiResult(false, "缺少参数Attribute").toJson()); return; } Trans.Attribute = HttpUtility.UrlDecode(Request["Attribute"].ToString()); if (string.IsNullOrEmpty(Trans.Attribute)) { context.Response.Write(new ApiResult(false, "Attribute不能为空").toJson()); return; } if (!Request.Params.AllKeys.Contains("Mac")) { context.Response.Write(new ApiResult(false, "缺少参数Mac").toJson()); return; } Trans.Mac = Request["Mac"].ToString(); if (string.IsNullOrEmpty(Trans.Mac)) { context.Response.Write(new ApiResult(false, "Mac不能为空").toJson()); return; } //如果是文件类型 if (Trans.Class == "Files") { new Files().ProcessRequest(context); } else { //wlg 20200110 增加操作日志记录 Common.Transfer tranNew = new Transfer() { Result = Trans.Result, Attribute = Trans.Attribute, Command = Trans.Command, Class = Trans.Class, Mac = Trans.Mac, QYID = Trans.QYID, QYUnitType = Trans.QYUnitType }; RecordOperationLog(tranNew); PubContext.Operate(ref Trans); } Compress(context); context.Response.Write(Trans.Output()); } catch (Exception ex) { context.Response.Write(new ApiResult(false, ex.Message + Environment.NewLine + ex.StackTrace).toJson()); } }
/// <summary> /// 提供给其他接口判断是否登录 /// </summary> /// <param name="Trans"></param> /// <returns></returns> public bool isLogin(ref Common.Transfer Trans, bool verifyPassword = true) { DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; string NetType = Row["Net"].ToString(); string Account = Row["Account"].ToString(); string LoginPwd = Row["LoginPwd"].ToString(); Global_Var.SystemType = "property"; string[] arrUser = Account.Split('-'); if (arrUser.Length > 1) { Global_Var.CorpId = arrUser[0].ToString(); Global_Var.CorpID = Global_Var.CorpId; Account = arrUser[1].ToString(); Global_Var.LoginCode = Account; } else { Trans.Result = JSONHelper.FromString(false, "用户名格式错误!"); return(false); } PubConstant.tw2bsConnectionString = Global_Fun.Tw2bsConnectionString(NetType); DbHelperSQL.ConnectionString = PubConstant.tw2bsConnectionString; //获得所在公司的数据库连接字符串 AppGlobal.GetHmWyglConnection(); string IsAd = "true"; try { IsAd = Global_Fun.AppWebSettings("IsAd"); } catch (Exception) { IsAd = "false"; } string strSQLUser = ""; if (IsAd == "true") { //AD域进行验证 string CheckResult = IsAuthenticated(Account, LoginPwd); if (CheckResult == "true") { strSQLUser = "******" + Account + "' and IsDelete = 0 "; } else { strSQLUser = "******"; } } else { // 中南版本、金辉版本及其分支、保利版本及其分支 if (LoginPwd.Length == 32) { strSQLUser = string.Format(" LoginCode='{0}' AND (PassWord='******' OR dbo.GetMD5(PassWord)='{1}') AND IsDelete = 0 ", Account, LoginPwd); } else if (Global_Var.CorpId == "1971") { //2018-1-21 新增敏捷AD域登录验证 if (NetType == "99") { strSQLUser = "******" + Account + "' AND PassWord='******' AND IsDelete = 0 "; } else { string urlmj = @"http://172.27.1.240/Api/ADLogin/Login?userName="******"&userPwd=" + LoginPwd; string mjsuss = TWRequest.HttpGet(urlmj); if (mjsuss == "\"success\"") { strSQLUser = "******" + Account + "' and IsDelete = 0 "; } else { strSQLUser = "******" + Account + "' AND PassWord='******' AND IsDelete = 0 "; } } } else { strSQLUser = string.Format(" LoginCode='{0}' AND IsDelete = 0 ", Account); // 强制要求验证密码 if (verifyPassword == true) { strSQLUser += $" AND PassWord='******'"; } } } #region 实地单点登录判断 if (SDLogin(Account, LoginPwd)) { // 如果实地单点登录成功,无需密码 strSQLUser = string.Format(" LoginCode='{0}' AND IsDelete = 0", Account); } #endregion DbHelperSQL.ConnectionString = PubConstant.hmWyglConnectionString; Bll_Tb_Sys_User Bll = new Bll_Tb_Sys_User(); DataTable dTable = Bll.GetList(strSQLUser).Tables[0]; if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; if (DRow["IsMobile"].ToString() != "1") { Trans.Result = JSONHelper.FromString(false, "不允许手机端登录!"); return(false); } else { //存在此用户,登陆成功 Global_Var.UserCode = DRow["UserCode"].ToString(); Global_Var.LoginUserCode = DRow["UserCode"].ToString(); Global_Var.UserName = DRow["UserName"].ToString(); Global_Var.LoginUserName = DRow["UserName"].ToString(); Global_Var.LoginDepCode = DRow["DepCode"].ToString(); Global_Var.LoginMobile = DRow["MobileTel"].ToString(); // 2017年6月12日16:16:01,谭洋,新增LoginSortDepCode Global_Var.LoginSortDepCode = DRow["SortDepCode"].ToString(); //WriteLog(DRow, "登陆系统"); return(true); } } else { Trans.Result = JSONHelper.FromString(false, "帐号或密码错误!"); return(false); } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = JSONHelper.FromString(false, "未知错误!"); string strEntryID = ""; string strOrganCode = ""; bool bCanEntry = false; DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; string NetType = Row["Net"].ToString(); string Account = Row["Account"].ToString(); string LoginPwd = Row["LoginPwd"].ToString(); Global_Var.SystemType = "property"; string[] arrUser = Account.Split('-'); if (arrUser.Length > 1) { Global_Var.CorpId = arrUser[0].ToString(); Global_Var.CorpID = Global_Var.CorpId; Account = arrUser[1].ToString(); Global_Var.LoginCode = Account; } else { Trans.Result = JSONHelper.FromString(false, "用户名格式错误!"); return; } PubConstant.tw2bsConnectionString = Global_Fun.Tw2bsConnectionString(NetType); DbHelperSQL.ConnectionString = PubConstant.tw2bsConnectionString; //获得所在公司的数据库连接字符串 AppGlobal.GetHmWyglConnection(); // 登出,记录登出日志 if (Trans.Command == "2") { WriteLogout(Account); return; } // 鸿坤EAC系统访问令牌 string eacToken = null; string IsAd = "true"; try { IsAd = Global_Fun.AppWebSettings("IsAd"); } catch (Exception) { IsAd = "false"; } string strSQLUser = ""; if (IsAd == "true") { //AD域进行验证 string CheckResult = IsAuthenticated(Account, LoginPwd); if (CheckResult == "true") { strSQLUser = "******" + Account + "' and IsDelete = 0 "; } else { strSQLUser = "******"; } } else { // 中南、实地 // 保利、隆泰、丽创 if (LoginPwd.Length == 32 || Global_Var.LoginCorpID == "1329" || Global_Var.LoginCorpID == "2009" || Global_Var.LoginCorpID == "2022") { strSQLUser = string.Format(" LoginCode='{0}' AND (PassWord='******' OR dbo.GetMD5(PassWord)='{2}') AND IsDelete = 0", Account, LoginPwd, LoginPwd.ToUpper()); } else if (Global_Var.CorpId == "1971") { if (NetType == "99") { strSQLUser = string.Format(" LoginCode='{0}' AND PassWord='******' AND IsDelete = 0 ", Account, LoginPwd); } else { //2018-1-21 新增敏捷AD域登录验证 string urlmj = @"http://172.27.1.240/Api/ADLogin/Login?userName="******"&userPwd=" + LoginPwd; string mjsuss = TWRequest.HttpGet(urlmj); if (mjsuss == "\"success\"") { strSQLUser = "******" + Account + "' and IsDelete = 0 "; } else { strSQLUser = "******" + Account + "' AND PassWord='******' AND IsDelete = 0 "; } } } else { strSQLUser = string.Format(" LoginCode='{0}' AND PassWord='******' AND IsDelete = 0 ", Account, LoginPwd); } } #region 实地单点登录判断 if (SDLogin(Account, LoginPwd)) { // 如果实地单点登录成功,无需密码 strSQLUser = string.Format(" LoginCode='{0}' AND IsDelete = 0 ", Account); } #endregion Bll_Tb_Sys_User Bll = new Bll_Tb_Sys_User(); DataTable dTable = Bll.GetList(strSQLUser).Tables[0]; if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; if (DRow["IsMobile"].ToString() != "1") { Trans.Result = JSONHelper.FromString(false, "不允许手机端登录!"); return; } else { //存在此用户,登陆成功 Global_Var.UserCode = DRow["UserCode"].ToString(); Global_Var.LoginUserCode = DRow["UserCode"].ToString(); Global_Var.UserName = DRow["UserName"].ToString(); Global_Var.LoginUserName = DRow["UserName"].ToString(); Global_Var.LoginDepCode = DRow["DepCode"].ToString(); Global_Var.LoginMobile = DRow["MobileTel"].ToString(); WriteLog(DRow, "登陆系统"); #region 可进入的系统 string strSQL = " AND UserCode = '" + Global_Var.LoginUserCode.ToString() + "' "; //DataTable dTableEntry = (new BusinessRule.TWBusinRule(LoginSQLConnStr)).Sys_User_RoleData_Filter(strSQL); MobileSoft.BLL.Sys.Bll_Tb_Sys_RoleData A = new Bll_Tb_Sys_RoleData(); DataTable dTableEntry = A.Sys_User_RoleData_Filter(strSQL); if (dTableEntry.Rows.Count > 0) { //查询默认项目 DataRow[] DSelRows = dTableEntry.Select(" EntryType = 1 "); if (DSelRows.Length > 0) { strEntryID = DSelRows[0]["CommID"].ToString(); strOrganCode = DSelRows[0]["OrganCode"].ToString(); } else { strEntryID = dTableEntry.Rows[0]["CommID"].ToString(); strOrganCode = dTableEntry.Rows[0]["OrganCode"].ToString(); } bCanEntry = true; } else { bCanEntry = false; } dTableEntry.Dispose(); #endregion if (bCanEntry) { int iCommID = AppGlobal.StrToInt(strEntryID); if (iCommID != 0) { #region 加载管理处信息 string strSQLComm = " IsDelete = 0 and CorpID = " + Global_Var.CorpId.ToString() + " and CommID = " + iCommID.ToString() + " "; MobileSoft.BLL.HSPR.Bll_Tb_HSPR_Community B = new MobileSoft.BLL.HSPR.Bll_Tb_HSPR_Community(); DataTable dTableComm = B.GetList(strSQLComm).Tables[0]; if (dTableComm.Rows.Count > 0) { DataRow DRowComm = dTableComm.Rows[0]; dTable.Rows[0]["CommID"] = DRowComm["CommID"]; Global_Var.LoginCommID = DRowComm["CommID"].ToString(); Global_Var.LoginCommName = DRowComm["CommName"].ToString(); Global_Var.LoginCorpID = DRowComm["CorpID"].ToString(); Global_Var.LoginBranchID = DRowComm["BranchID"].ToString(); Global_Var.LoginOrganCode = DRowComm["OrganCode"].ToString(); Global_Var.LoginCorpRegionCode = DRowComm["CorpRegionCode"].ToString(); Global_Var.LoginCommType = DRowComm["CommType"].ToString(); } dTableComm.Dispose(); #endregion //查询人员可进入小区的岗位 MobileSoft.BLL.Sys.Bll_Tb_Sys_User C = new Bll_Tb_Sys_User(); Global_Var.LoginRoles = C.Sys_User_FilterRoles(Global_Var.LoginUserCode, Global_Var.LoginOrganCode, AppGlobal.StrToInt(Global_Var.LoginCommID)); Global_Var.LoginSysTitle = Global_Var.LoginCommName; Global_Var.LoginFunType = "5";//进入管理处系统 } else { if (strOrganCode != "") { #region 查询区域 string strSQLOrgan = ""; if (strOrganCode == "" || strOrganCode == "01") { strSQLOrgan = " IsDelete = 0 and OrganCode = '01'"; Global_Var.LoginOrganCode = "01"; } else { strSQLOrgan = " IsDelete = 0 and OrganCode = '" + strOrganCode + "' and IsComp = 1 "; Global_Var.LoginOrganCode = strOrganCode; } MobileSoft.BLL.Sys.Bll_Tb_Sys_Organ D = new Bll_Tb_Sys_Organ(); DataTable dTableOrgan = D.GetList(strSQLOrgan).Tables[0]; if (dTableOrgan.Rows.Count > 0) { DataRow DRowOrgan = dTableOrgan.Rows[0]; Global_Var.LoginOrganName = DRowOrgan["OrganName"].ToString(); Global_Var.LoginCorpID = Global_Var.CorpId.ToString(); Global_Var.LoginCommID = "0"; Global_Var.LoginOrganCode = DRowOrgan["OrganCode"].ToString(); Global_Var.LoginCommType = ""; } dTableOrgan.Dispose(); #endregion //查询人员可进入小区的岗位 MobileSoft.BLL.Sys.Bll_Tb_Sys_User C = new Bll_Tb_Sys_User(); Global_Var.LoginRoles = C.Sys_User_FilterRoles(Global_Var.LoginUserCode, Global_Var.LoginOrganCode, AppGlobal.StrToInt(Global_Var.LoginCommID)); Global_Var.LoginSysTitle = Global_Var.LoginOrganName.ToString(); Global_Var.LoginFunType = "1";//进入公司系统 } } } else { Global_Var.LoginFunType = "1"; string strSQLOrgan = ""; if (strOrganCode == "" || strOrganCode == "01") { strSQLOrgan = " IsDelete = 0 and OrganCode = '01'"; Global_Var.LoginOrganCode = "01"; } else { strSQLOrgan = " IsDelete = 0 and OrganCode = '" + strOrganCode + "' and IsComp = 1 "; Global_Var.LoginOrganCode = strOrganCode; } MobileSoft.BLL.Sys.Bll_Tb_Sys_Organ D = new MobileSoft.BLL.Sys.Bll_Tb_Sys_Organ(); DataTable dTableOrgan = D.GetList(strSQLOrgan).Tables[0]; if (dTableOrgan.Rows.Count > 0) { DataRow DRowOrgan = dTableOrgan.Rows[0]; Global_Var.LoginOrganName = DRowOrgan["OrganName"].ToString(); Global_Var.LoginCorpID = Global_Var.CorpId.ToString(); Global_Var.LoginCommID = "0"; Global_Var.LoginOrganCode = DRowOrgan["OrganCode"].ToString(); Global_Var.LoginCommType = ""; } dTableOrgan.Dispose(); MobileSoft.BLL.Sys.Bll_Tb_Sys_User E = new MobileSoft.BLL.Sys.Bll_Tb_Sys_User(); Global_Var.LoginRoles = E.Sys_User_FilterRoles(Global_Var.LoginUserCode, Global_Var.LoginOrganCode, DataSecurity.StrToInt(Global_Var.LoginCommID)); Global_Var.LoginSysTitle = Global_Var.LoginOrganName.ToString(); } MobileSoft.BLL.Sys.Bll_Tb_Sys_Organ F = new MobileSoft.BLL.Sys.Bll_Tb_Sys_Organ(); Global_Var.LoginOrganCorp = F.Sys_Organ_GetComp(Global_Var.LoginOrganCode); if (Global_Var.SysVersion.ToString().ToLower() != "group") { Global_Var.LoginOrganCorp = Global_Var.LoginOrganCode.Substring(0, 2); } Trans.Result = JSONHelper.FromString(dTable); } } else { Trans.Result = JSONHelper.FromString(false, "账号或密码错误!"); return; } }