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 "IncidentAccept": // 报事提交 Trans.Result = IncidentAccept(Row); break; case "IncidentCancel": // 报事提交 Trans.Result = IncidentCancel(Row); break; case "GetIncidentHistory": // 获取报事历史 Trans.Result = GetIncidentHistory(Row); break; case "GetIncidentDetail": // 获取报事详情 Trans.Result = GetIncidentDetail(Row); break; case "IncidentEvaluate": // 获取报事详情 Trans.Result = IncidentEvaluate(Row); 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]; switch (Trans.Command) { case "Add": Trans.Result = Add(Row); break; case "Delete": Trans.Result = Delete(Row); break; case "Audit": Trans.Result = Audit(Row); break; case "WaitingAuditList": Trans.Result = WaitingAuditList(Row); break; case "AuditList": Trans.Result = AuditList(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 "GoOnGenerateOrder": Trans.Result = GoOnGenerateOrder(Ds); break; //订单确认收款成功 case "ReceBusinessOrder": Trans.Result = ReceBusinessOrder(Row["OrderId"].ToString(), AppGlobal.StrToInt(Row["RealAmount"].ToString())); break; //订单退款 case "CancelOrder": Trans.Result = CancelOrder(Row["OrderId"].ToString()); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { try { 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) { case "GetListWithState": // 审批列表 Trans.Result = GetListWithState(Row); break; case "GetEntryApprovalDetail": // 入职审批详情 Trans.Result = GetEntryApprovalDetail(Row); break; default: break; } } catch (Exception ex) { GetLog().Error(ex.Message + Environment.CommandLine + ex.StackTrace + Environment.NewLine + ex.Source + Environment.NewLine + Trans.Attribute); Trans.Result = new ApiResult(false, "接口抛出了一个异常").toJson(); } }
public override void Operate(ref Common.Transfer Trans) { try { Trans.Result = "false:"; log.Error("记录客户端信息接收到内容:" + Trans.Attribute); DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { //生成订单 case "Record": Trans.Result = RecordInfo(Row); break; case "RecordOperationLog": Trans.Result = RecordOperationLog(Row, Trans.Attribute, Trans.ClassLog, Trans.CommandLog); break; default: break; } } catch (Exception ex) { log.Error("记录客户端信息错误:" + ex); } }
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 "InviteUser": // 邀请用户 Trans.Result = InviteUser(Row); break; case "Unbinding": // 房屋解绑 Trans.Result = Unbinding(Row); break; case "BindingState": // 房屋绑定状态 Trans.Result = BindingState(Row); break; case "GetSmsCode_ManualBinding": // 手动绑定房屋,获取短信验证码 Trans.Result = GetSmsCode_ManualBinding(Row); break; default: break; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; try { Common.Transfer Trans = new Common.Transfer(); HttpRequest Request = context.Request; Trans.Class = "HKParkCostInfo"; Trans.Command = "TempPayFees"; //获取content内容 System.IO.Stream s = System.Web.HttpContext.Current.Request.InputStream; byte[] b = new byte[s.Length]; s.Read(b, 0, (int)s.Length); string ContentStr = System.Text.Encoding.UTF8.GetString(b); if (ContentStr != "") { Trans.Attribute = ContentStr; } PubContext.Operate(ref Trans); context.Response.Write(Trans.Output()); } catch (Exception ex) { context.Response.Write(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]; switch (Trans.Command) { case "CommunityNotificationTWList": //社区公告 Trans.Result = CommunityNotificationTWList(Row); break; case "CommunityCultureList": //社区文化 Trans.Result = CommunityCultureList(Row); break; case "CommunityActivitiesList": //社区活动 Trans.Result = CommunityActivitiesList(Row); break; case "ServiceInformationList": //服务指南 Trans.Result = ServiceInformationList(Row); break; case "GetAll": Trans.Result = GetAll(Row); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = "false:"; DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { //生成预存订单 case "GenerateOrder": Trans.Result = GenerateOrder(Row); break; //预存生成收款 case "ReceProperyOrder": Trans.Result = ReceProperyOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); break; //更新订单状态 case "UpdateProperyOrder": Trans.Result = UpdateProperyOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString(), Row["respCode"].ToString(), Row["respMsg"].ToString()); break; //查询银行订单状态 case "SearchBankOrder": Trans.Result = SearchBankOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); 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]; switch (Trans.Command) { case "GetFeesStatistics": // 获取欠费或预存信息 Trans.Result = GetFeesStatistics(Row); break; case "GetFeesStatistics_ZhongJi": // 获取欠费或预存信息 Trans.Result = GetFeesStatistics_ZhongJi(Row); break; case "GetDebtsFeesList": // 获取欠费列表 Trans.Result = GetDebtsFeesList(Row); break; case "GetDebtsFeesList_ZhongJi": // 获取欠费列表 Trans.Result = GetDebtsFeesList_ZhongJi(Row); break; case "GetFeesHistoryList": // 获取历史账单 Trans.Result = GetFeesHistoryList(Row); 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]; switch (Trans.Command) { case "GetCommunityInfo": // 获取小区信息 Trans.Result = GetCommunityInfo(Row); break; case "GetCommunityRedWYList": // 获取红色物业 Trans.Result = GetCommunityRedWYList(Row); break; case "GetCommunityQQTSList": // 获取亲情提示 Trans.Result = GetCommunityQQTSList(Row); break; case "GetCommunitySQZXList": // 获取社区资讯 Trans.Result = GetCommunitySQZXList(Row); break; case "GetCommunityServiceTel": // 获取楼栋管家号码 Trans.Result = GetCommunityServiceTel(Row); break; case "GetCommunityServiceTel_ZhongJi": // 获取楼栋管家号码 Trans.Result = GetCommunityServiceTel_ZhongJi(Row); break; case "GetCommunityServiceTel_Junfa": // 获取楼栋管家号码 Trans.Result = GetCommunityServiceTel_Junfa(Row); break; case "GetCommunityServices": // 获取社区服务,高端定制 Trans.Result = GetCommunityServices(Row); break; case "CommunityActivitiesList": // 社区活动(跳蚤市场) Trans.Result = CommunityActivitiesList(Row); break; case "HasUnreadNotice": // 获取是否有未读物业公告 Trans.Result = HasUnreadNotice(Row); break; case "LoadKeyDoor": // 读取小区门禁信息 Trans.Result = LoadKeyDoor(Row); break; default: break; } }
/// <summary> /// 文件上传 /// </summary> /// <param name="context"></param> /// <param name="Trans"></param> /// <returns></returns> private string SaveFiles(HttpContext context, Common.Transfer Trans) { string json = ""; try { string FileName = ""; string path = ""; DataTable dAttributeTable = XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; //上传物理路径 string FilesPath = System.Configuration.ConfigurationManager.AppSettings["FilesPath"]; //上传的绝对URL路径 string FilesPathUrl = System.Configuration.ConfigurationManager.AppSettings["FilesPathUrl"]; FileName = Guid.NewGuid().ToString(); string ExtName = Row["ExtName"].ToString(); string DirName = Row["DirName"].ToString(); byte[] bytes = new byte[context.Request.InputStream.Length]; context.Request.InputStream.Read(bytes, 0, bytes.Length); context.Request.InputStream.Seek(0, SeekOrigin.Begin);//设置当前流的位置 context.Request.InputStream.Flush(); context.Request.InputStream.Close(); context.Request.InputStream.Dispose(); Random rnd = new Random(); int n = rnd.Next(1000, 9999); FileName = FileName + "." + ExtName; string nFileDirectory = DateTime.Now.Year.ToString() + "\\" + DateTime.Now.Month.ToString().PadLeft(2, '0'); FilesPath = FilesPath + DirName + "\\" + nFileDirectory; if (Directory.Exists(FilesPath) == false) { Directory.CreateDirectory(FilesPath); } path = FilesPath + "\\" + FileName; FileStream fs = new FileStream(path, FileMode.Create); BinaryWriter bw = new BinaryWriter(fs); bw.Write(bytes); bw.Close(); fs.Close(); nFileDirectory = DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString().PadLeft(2, '0'); FilesPathUrl = FilesPathUrl + DirName + "/" + nFileDirectory + "/" + FileName.ToString(); return(JSONHelper.FromString(true, FilesPathUrl)); } catch (Exception ex) { json = JSONHelper.FromString(false, "上传失败:" + ex.Message); } return(json); }
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) { case "GetUnreadMessageCount": Trans.Result = GetUnreadMessageCount(Row); //获取用户未读消息数量 break; case "GetMessageList": Trans.Result = GetMessageList(Row); //获取用户未读消息列表 break; case "MarkMessageRead": Trans.Result = MarkMessageRead(Row); //标记短信为已读 break; case "GetMessageDetail": Trans.Result = GetMessageDetail(Row); //读取短信详情 break; case "GetDepartment": Trans.Result = GetDepartment(Row); //获取部门 break; case "GetUserListWithDep": Trans.Result = GetUserListWithDep(Row); //获取部门下员工列表 break; case "Insert": Trans.Result = Insert(Row); //插入新消息 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]; switch (Trans.Command) { case "IncidentAccept": // 报事提交 Trans.Result = IncidentAccept(Row); 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]; switch (Trans.Command) { case "GetBuildingList": // 获取小区下楼栋房屋列表 Trans.Result = GetBuildingList(Row); break; case "GetFloorRoomList": // 获取该楼层下房屋列表 Trans.Result = GetFloorRoomList(Row); break; case "GetBindingRoomList": // 获取已绑定房屋列表 Trans.Result = GetBindingRoomList(Row); break; case "GetBindingUserList": // 获取绑定了当前房屋的用户信息 Trans.Result = GetBindingUserList(Row); break; case "VerifyRoomInfo": // 绑定房屋时,验证信息 Trans.Result = VerifyRoomInfo(Row); break; case "GetIdentityAndBindingCount": // 获取该账号在当前房屋下的身份以及绑定了当前房屋的账号数量 Trans.Result = GetIdentityAndBindingCount(Row); break; case "Unbinding": // 解除绑定 Trans.Result = Unbinding(Row); break; case "LockBinding": // 锁定房屋,锁定后,绑定该账号的房屋不能再操作该房屋 Trans.Result = LockBinding(Row); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = "false:"; DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { //生成订单 case "GenerateOrder": Trans.Result = GenerateOrder(Row); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = "false:"; DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { //生成订单 case "GenerateOrder": Trans.Result = GenerateOrder(Row); break; //订单下账 case "ReceProperyOrder": Trans.Result = ReceProperyOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); break; ////刷新订单 //case "RefreshOrder": // Trans.Result = RefreshOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); // break; ////取消订单 //case "CancelOrder": // Trans.Result = CancelOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); // break; ////取消下帐 //case "NoAliUnderAccount": // Trans.Result = NoAliUnderAccount(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); // break; //更新订单状态 case "UpdateProperyOrder": Trans.Result = UpdateProperyOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString(), Row["respCode"].ToString(), Row["respMsg"].ToString()); break; ////查询银行订单状态 //case "SearchBankOrder": // Trans.Result = SearchBankOrder(Row["CommunityId"].ToString(), Row["OrderId"].ToString()); // break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { try { 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) { case "GetTaskCount": Trans.Result = GetTaskCount(Row); break; case "DownloadTask": // 新版本任务下载, Trans.Result = DownloadTask(Row); break; case "DownloadTaskWithPager": // 新版本任务下载,分页 Trans.Result = DownloadTaskWithPager(Row); break; case "DownloadTaskEquipmentLineWithPager": // 新版本任务下载, Trans.Result = DownloadTaskEquipmentLineWithPager(Row); break; default: break; } } catch (Exception ex) { GetLog().Error(ex.Message + Environment.NewLine + ex.StackTrace + Environment.NewLine + ex.Source + Environment.NewLine + Trans.Attribute); Trans.Result = ex.Message + Environment.NewLine + ex.StackTrace + Environment.NewLine; } }
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 "SaveSuggestion": // 保存投诉建议 Trans.Result = SaveSuggestion(Row); break; case "GetSuggestionSimpleList": // 投诉建议列表 Trans.Result = GetSuggestionSimpleList(Row); 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]; switch (Trans.Command) { case "GetExpressList": // 获取快递列表 Trans.Result = GetExpressList(Row); break; case "ReceiveExpress": Trans.Result = ReceiveExpress(Row); 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]; switch (Trans.Command) { case "GetCouponBalanceList": // 获取业主优惠券余额,以商家为单位 Trans.Result = GetCouponBalanceList(Row); break; case "GetCouponUsedHistoryList": // 优惠券使用历史记录 Trans.Result = GetCouponUsedHistoryList(Row); break; case "GetCanUseCouponBalanceInBuss": // 付款时,获取当前可用的优惠券余额 Trans.Result = GetCanUseCouponBalanceInBuss(Row); break; } }
public void ProcessRequest(HttpContext context) { Common.Transfer Trans = new Common.Transfer(); try { HttpRequest Request = context.Request; Trans.Class = Request["Class"].ToString(); Trans.Command = Request["Command"].ToString(); Trans.Attribute = HttpUtility.UrlDecode(Request["Attribute"].ToString()); Trans.Mac = Request["Mac"].ToString(); //验证令牌请求 string HashString = Trans.Attribute.ToString() + DateTime.Now.ToString("yyyyMMdd") + "ERPSaveFile"; string Mac = AppPKI.getMd5Hash(HashString); if (Trans.Mac == Mac) { switch (Trans.Command) { case "SaveFile": Trans.Result = SaveFiles(context, Trans); break; default: break; } } else { Trans.Error = "验证令牌错误"; } } catch (Exception E) { Trans.Error = E.Message.ToString(); } context.Response.ContentType = "text/plain"; 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]; switch (Trans.Command) { case "GetVerifyCode": //获取验证码 Trans.Result = GetVerifyCode(Row, Trans); break; case "RegisterUser": Trans.Result = RegisterUser(Row); //注册用户 break; case "UpdateUserPwd": //修改密码 Trans.Result = UpdateUserPwd(Row); break; case "InviteUser": // 邀请用户 Trans.Result = InviteUser(Row); break; case "InviteUser_jf": // 邀请用户(俊发,同泰禾) Trans.Result = InviteUser(Row); break; case "InviteUser_hnc": // 邀请用户(华南城微信,增加同时邀请多套房屋) Trans.Result = InviteUser_hnc(Row); break; default: break; } }
public override void Operate(ref Common.Transfer Trans) { Trans.Result = "false:"; DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute); DataRow Row = dAttributeTable.Rows[0]; switch (Trans.Command) { case "GetRentalTop": Trans.Result = GetRentalTop(Row); break; case "RentalList": Trans.Result = RentalList(Row); break; case "RentalList_v2": Trans.Result = RentalList_v2(Row); break; case "RentalDetail_v2": Trans.Result = RentalDetail_v2(Row); break; case "RentalNew": Trans.Result = RentalNew(Row); break; case "RentalHistoryList": Trans.Result = RentalHistoryList(Row); 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]; switch (Trans.Command) { case "GetCommunityNotice": Trans.Result = GetCommunityNotice(Row); break; case "GetCommunityActivity": Trans.Result = GetCommunityActivity(Row); break; case "ActivityApply": Trans.Result = ActivityApply(Row); break; case "MakeScore": Trans.Result = MakeScore(Row); break; case "GetApplyInfo": Trans.Result = GetApplyInfo(Row); break; case "CancelApply": Trans.Result = CancelApply(Row); 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]; switch (Trans.Command) { case "KeyDoors": // 小区门禁 Trans.Result = GetKeyDoorList(Row); break; case "GetCommunityInfo": Trans.Result = GetCommunityInfo(Row); break; case "GetCommunityEntrance": Trans.Result = GetCommunityEntrance(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; } Trans.Command = Request["Command"].ToString(); if (string.IsNullOrEmpty(Trans.Command)) { context.Response.Write(new ApiResult(false, "Command不能为空").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; } //获取content内容 System.IO.Stream s = System.Web.HttpContext.Current.Request.InputStream; byte[] b = new byte[s.Length]; s.Read(b, 0, (int)s.Length); string ContentStr = System.Text.Encoding.UTF8.GetString(b); if (ContentStr != "") { Trans.Agreement = ContentStr; } 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> private string GetVerifyCode(DataRow Row, Common.Transfer Trans) { if (!Row.Table.Columns.Contains("Mobile") || string.IsNullOrEmpty(Row["Mobile"].ToString())) { return(JSONHelper.FromString(false, "缺少Mobile参数")); } string forgetPassword = null; // 忘记密码功能时传入该参数 if (Row.Table.Columns.Contains("IsForget") && !string.IsNullOrEmpty(Row["IsForget"].ToString())) { forgetPassword = Row["IsForget"].ToString(); } int code = new Random(unchecked ((int)DateTime.Now.Ticks)).Next(100000, 999999); string Content = "您的验证码为:" + code; if (forgetPassword != "1") { DataTable dTable = new DbHelperSQLP(PubConstant.UnifiedContionString.ToString()).Query("SELECT Name FROM Tb_User where Mobile='" + Row["Mobile"].ToString() + "'").Tables[0]; if (dTable.Rows.Count > 0) { return(JSONHelper.FromString(false, "此用户已存在")); } try { if (HttpContext.Current.Request.Url.Host.Contains("tahoecn")) { // 泰禾版本 string connString = @"Connect Timeout=100;Connection Lifetime=60;Max Pool Size=2000;Min Pool Size=0;Pooling=true;data source=10.0.102.32;initial catalog=HM_wygl_new_1970;PWD=LF123SPoss;persist security info=False;user id=LFUser;packet size=4096"; if (HttpContext.Current.Request.Url.Host.ToLower() == "test.wyerp.tahoecndemo.com") { connString = @"Connect Timeout=100;Connection Lifetime=60;Max Pool Size=2000;Min Pool Size=0;Pooling=true;data source=(local);initial catalog=HM_wygl_new_1970;PWD=LF123SPoss;persist security info=False;user id=LFUser;packet size=4096"; } // 泰禾在此时需要验证是否是业主身份 using (IDbConnection conn = new SqlConnection(connString)) { string sql = @"SELECT * FROM Tb_HSPR_Customer x WHERE isnull(x.IsDelete,0)=0 AND x.LiveType1=1 AND x.MobilePhone LIKE @MobilePhone; SELECT * FROM Tb_HSPR_Customer x WHERE isnull(x.IsDelete,0)=0 AND x.LiveType2=2 AND x.MobilePhone LIKE @MobilePhone; SELECT * FROM Tb_HSPR_Household x WHERE isnull(x.IsDelete,0)=0 AND x.MobilePhone LIKE @MobilePhone; SELECT * FROM Tb_HSPR_Customer x WHERE isnull(x.IsDelete,0)=0 AND x.LiveType1=1 AND x.MobilePhone LIKE @MobilePhone AND (SELECT count(0) FROM Tb_HSPR_CustomerLive y WHERE x.CustID=y.CustID AND isnull(y.IsDelLive,0)=0 AND y.LiveType=1 AND CommID IN(SELECT CommID FROM Unified.dbo.Tb_Community))>0; SELECT * FROM Tb_HSPR_Customer x WHERE isnull(x.IsDelete,0)=0 AND x.LiveType2=2 AND x.MobilePhone LIKE @MobilePhone AND (SELECT count(0) FROM Tb_HSPR_CustomerLive y WHERE x.CustID=y.CustID AND isnull(y.IsDelLive,0)=0 AND y.LiveType=2 AND CommID IN(SELECT CommID FROM Unified.dbo.Tb_Community))>0; SELECT * FROM Tb_HSPR_Household x WHERE isnull(x.IsDelete,0)=0 AND x.MobilePhone LIKE @MobilePhone AND (SELECT count(0) FROM Tb_HSPR_CustomerLive y WHERE x.CustID=y.CustID AND isnull(y.IsDelLive,0)=0 AND y.LiveType=1 AND CommID IN(SELECT CommID FROM Unified.dbo.Tb_Community))>0;"; GridReader reader = conn.QueryMultiple(sql, new { MobilePhone = $"%{Row["Mobile"].ToString()}%" }); int[] counts = new int[] { reader.Read().Count(), reader.Read().Count(), reader.Read().Count(), reader.Read().Count(), reader.Read().Count(), reader.Read().Count() }; if (counts[0] + counts[1] + counts[2] + counts[3] + counts[4] + counts[5] == 0) { return(JSONHelper.FromString(false, "手机号未登记,请联系物管")); } if (counts[0] + counts[1] + counts[2] != 0 && counts[3] + counts[4] + counts[5] == 0) { return(JSONHelper.FromString(false, "此园区暂未开通,敬请期待")); } } } } catch { return(JSONHelper.FromString(false, "获取验证码失败")); } } Tb_Sms_Account smsModel = SmsInfo.GetSms_Account(); Tb_SendMessageRecord m = new Tb_SendMessageRecord(); string errorMessage = ""; int Result = 0; // 泰禾 try { if (HttpContext.Current.Request.Url.Host.ToLower().Contains("tahoecn")) { Result = SendShortMessage(Row["Mobile"].ToString(), Content, out errorMessage, 1970); } else { Result = SendShortMessage(Row["Mobile"].ToString(), Content, out errorMessage); } } catch (Exception ex) { GetLog().Info("验证码发送失败:" + ex.Message + ex.StackTrace); return(JSONHelper.FromString(false, "发送失败,请稍后重试")); } if (Result == 0) { return(JSONHelper.FromString(true, (code * 369).ToString())); } else { return(JSONHelper.FromString(false, errorMessage)); } }
public override void Operate(ref Common.Transfer Trans) { DataSet ds = new DataSet(); 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"; //获得所在服务器的tw2_bs数据库连接字符串 if (NetType == "1") { PubConstant.tw2bsConnectionString = Global_Fun.GetConnectionString("10Connection"); Global_Var.CommImageUrl = WebConfigurationManager.AppSettings["10ImageUrl"].ToString(); Global_Var.ServerIp = WebConfigurationManager.AppSettings["10IP"].ToString(); } if (NetType == "2") { PubConstant.tw2bsConnectionString = Global_Fun.GetConnectionString("14Connection"); //Global_Var.CommImageUrl = WebConfigurationManager.AppSettings["14ImageUrl"].ToString(); //Global_Var.ServerIp = WebConfigurationManager.AppSettings["14IP"].ToString(); } if (NetType == "3") { PubConstant.tw2bsConnectionString = Global_Fun.GetConnectionString("37Connection"); Global_Var.CommImageUrl = WebConfigurationManager.AppSettings["37ImageUrl"].ToString(); Global_Var.ServerIp = WebConfigurationManager.AppSettings["37IP"].ToString(); } string[] arrUser = Account.Split('-'); if (arrUser.Length > 1) { Global_Var.CorpId = arrUser[0].ToString(); Global_Var.LoginCode = arrUser[1].ToString(); } else { Trans.Result = JSONHelper.FromString(false, "身份认证失败,请重新登录!"); return; } AppGlobal.GetHmWyglConnection(); Bll_Tb_Sys_User Bll = new Bll_Tb_Sys_User(); DataTable dTable = Bll.GetList("LoginCode='" + Global_Var.LoginCode.ToString() + "' AND PassWord='******' AND ISNULL(IsDelete,0)=0").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(); string strSQLComm = " IsDelete = 0 and CorpID = " + Global_Var.CorpId.ToString(); MobileSoft.BLL.HSPR.Bll_Tb_HSPR_Community B = new MobileSoft.BLL.HSPR.Bll_Tb_HSPR_Community(); DataTableCollection dTablecommCollection = B.GetList(strSQLComm).Tables; for (int i = 0; i < dTablecommCollection.Count; i++) { DataTable dtTable = dTablecommCollection[i].Copy(); dtTable.TableName = "data"; ds.Tables.Add(dtTable); } Trans.Result = JSONHelper.FromString(ds, false, true); ds.Dispose(); } } else { Trans.Result = JSONHelper.FromString(false, "身份认证失败,请重新登录!"); return; } }