Exemplo n.º 1
0
        public static TheTableInformation FetchTableAndHistory(Guid? jobID = null, string tableName = null)
        {
            if ((jobID == null) == (string.IsNullOrWhiteSpace(tableName)))
            {
                throw new ArgumentException("Either job ID or job Name should be supplied, not both.");
            }

            var dbArgs = new Dapper.DynamicParameters();
            if (jobID != null)
            {
                dbArgs.Add("@jobID", jobID);
                tableName = (string)DapperWrapper.ExecuteScalar("SELECT [dbo].[FetchJobName](@jobID)", dbArgs);
                dbArgs.Add("@JobNamePattern", tableName);
            }
            else
            {
                dbArgs.Add("@JobNamePattern", tableName);
                jobID = (Guid?)DapperWrapper.ExecuteScalar("SELECT [dbo].[FetchJobID](@JobNamePattern)", dbArgs);
                if (jobID != null)
                {
                    dbArgs.Add("@jobID", jobID);
                }
            }

            var model = new TheTableInformation { TheName = tableName, TheData = null, TheHistory = null };
            if (jobID != null)
            {
                model.TheData = DapperWrapper.Query<TheTableEntry>("SELECT * FROM [dbo].[FetchATable](@jobID)", dbArgs).ToList();
                model.TheHistory = DapperWrapper.Query<TheTableHistoryEntry>(
                    "SELECT * FROM [dbo].[FetchJobHistory](@jobID, @JobNamePattern) ORDER BY [Completed] DESC", dbArgs).ToList();
            }
            return model;
        }
Exemplo n.º 2
0
        public void GetMyFtbInvestList()
        {
            Guid?weOrderId = SafeConvert.ToGuid(WEBRequest.GetFormString("weOrderId"));
            int  pageIndex;

            int.TryParse(Context.Request["pageIndex"], out pageIndex);
            int totalCount = 0;
            List <WeFTBWxInvestInfo> dataList = null;

            if (GlobalUtils.IsOpenSubscribeApi)//走CDC查询服务
            {
                string err  = "";
                string resp = HttpClient.HttpUtil.HttpGet(TdConfig.ApplicationName,
                                                          GlobalUtils.SubApiUrl + "/app/appGetMyFTBClaimDetail?weOrderId=" + weOrderId + "&userId=" + WebUserAuth.UserId.Value + "&pagesize=15&pageindex=" + pageIndex, "", out err);
                if (!string.IsNullOrEmpty(resp))
                {
                    var pub = JsonConvert.DeserializeObject <
                        ResponsePublicModel <ResponseGeWeFTBWxInvestInfo> >(resp);
                    if (pub != null)
                    {
                        dataList   = pub.data.dataList;
                        totalCount = pub.data.totalCount;
                    }
                }

                //dataList = service.GetDataPager<WeFTBWxInvestInfo>("/app/APPGetMyFTBClaimDetail", param,
                //    out totalCount);
            }
            else
            {
                string strSQL = @"SELECT * FROM (
                                    select SUM(1) OVER() as TotalCount, s.Id as SubscribeId,s.ContractNo,p.[Type],
                                    case when isnull(s.TotalShares,0)=0 and isnull(s.TransferedShares,0)=0 then s.Amount when  isnull(s.TransferedShares,0)>0 and (s.TotalShares=0 or s.TotalShares=s.TransferedShares)  then ISNULL(s.TranedAmount,0) else  s.Amount+isnull(s.TranedAmount,0) end Amount,p.Title,u.RealName as UserName,isnull(s.TranDate,s.AddDate) as AddDate,
                                    isnull(s.IsFromTran,0) as IsFromTran, s.TranId,
                                    ROW_NUMBER() OVER(order by s.AddDate desc) rownumber 
                                    from Subscribe s with(nolock)
                                    left join Project p with(nolock) on s.ProjectId=p.Id   
                                    left join UserBasicInfo u with(nolock) on p.UserId=u.Id
                                    where s.SubscribeUserId=@userId  AND s.WeOrderId=@weOrderId and s.ContractNo not like '%[_]%'
                                )M  WHERE M.rownumber> @pagesize*(@pageindex-1) and  M.rownumber<=@pagesize*@pageindex ";

                Dapper.DynamicParameters dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@weOrderId", weOrderId);
                dyParams.Add("@userId", WebUserAuth.UserId.Value);
                dyParams.Add("@pagesize", 15);
                dyParams.Add("@pageindex", pageIndex);

                dataList = TuanDai.DB.TuanDaiDB.Query <WeFTBWxInvestInfo>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
                if (dataList != null && dataList.Count > 0)
                {
                    totalCount = dataList[0].TotalCount;
                    foreach (var item in dataList)
                    {
                        if (item.UserName != null)
                        {
                            if (item.UserName.Length > 1)
                            {
                                item.UserName = item.UserName.Substring(0, 1) + "**";
                            }
                        }
                    }
                }
            }


            if (dataList != null && dataList.Count > 0)
            {
                WebSettingInfo ftzqSet = new WebSettingBLL().GetWebSettingInfo("BA8B8D06-A510-436C-B996-3D66D43FDF40");

                foreach (var item in dataList)
                {
                    item.IsFromTran = item.IsFromTran && item.AddDate > DateTime.Parse(ftzqSet.Param2Value);

                    if (GlobalUtils.IsOpenSubscribeApi)
                    {
                        item.ContractUrl = GetContractViewUrl(item.TypeId, item.IsFromTran, item.ContractUrl,
                                                              item.SubscribeId);
                        item.Title = item.ProjectTitle;
                        var borrowerModel = new UserBLL().GetUserBasicInfoModelById(item.BorrowerId);
                        if (borrowerModel == null)
                        {
                            borrowerModel = new UserBasicInfoInfo();
                        }
                        var relName = borrowerModel.RealName;
                        if (!string.IsNullOrEmpty(relName))
                        {
                            item.UserName = relName.Substring(0, 1) + "**";
                        }
                    }
                    else
                    {
                        item.ContractUrl = GetContractViewUrl(item.Type, item.IsFromTran, item.ContractNo,
                                                              item.SubscribeId);
                    }
                }
                if (ftzqSet.Param1Value == "1")
                {
                    DateTime checkDate = DateTime.Parse(ftzqSet.Param2Value.Trim());
                    //查询是否有承接记录
                    List <string> subIdList = dataList.Select(p => p.SubscribeId.ToString()).ToList();
                    if (subIdList != null && subIdList.Any())
                    {
                        //加开关控制
                        dataList.ForEach(p => p.IsFromTran = p.AddDate > checkDate && p.IsFromTran);
                        //string strSQL = "select UsedShares,SubscribeId, AddDate from dbo.ProjectFQBExTransfer where SubscribeId in(" + StrObj.StrToInSQL(subIdList) + ")";
                        //var dyParams = new Dapper.DynamicParameters();
                        //List<ProjectFQBExTransferInfo> fqbTranList = TuanDai.DB.TuanDaiDB.Query<ProjectFQBExTransferInfo>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
                        //if (fqbTranList == null || fqbTranList.Count == 0 || fqbTranList.Count < dataList.Count)
                        //{
                        //    //查询历史库
                        //    List<ProjectFQBExTransferInfo> fqbTranList2 = TuanDai.DB.TuanDaiDB.Query<ProjectFQBExTransferInfo>(TdConfig.ApplicationName, TdConfig.DBWePlanRead, strSQL, ref dyParams);
                        //    if (fqbTranList2 != null)
                        //    {
                        //        if (fqbTranList == null)
                        //            fqbTranList = new List<ProjectFQBExTransferInfo>();
                        //        fqbTranList.AddRange(fqbTranList2);
                        //    }
                        //}
                        string subids = "";
                        if (subIdList != null && subIdList.Count > 0)
                        {
                            foreach (var subid in subIdList)
                            {
                                if (string.IsNullOrEmpty(subids))
                                {
                                    subids = subid.ToUpper();
                                }
                                else
                                {
                                    subids += "," + subid.ToUpper();
                                }
                            }
                        }
                        List <ProjectFQBExTransferInfo> fqbTranList = GetTranList(subids);

                        if (fqbTranList != null && fqbTranList.Any())
                        {
                            foreach (var item in dataList)
                            {
                                ProjectFQBExTransferInfo findObj = fqbTranList.Where(p => p.SubscribeId == item.SubscribeId).FirstOrDefault();
                                if (findObj != null)
                                {
                                    //加开关控制
                                    item.IsHaveTranList = findObj.AddDate > checkDate && findObj.UsedShares > 0;
                                }
                            }
                        }
                    }
                }
            }

            this.Context.Response.Write(JsonConvert.SerializeObject(
                                            new
            {
                result     = totalCount > 0 ? 1 : 0,
                totalcount = totalCount,
                msg        = dataList
            }));

            this.Context.Response.End();
        }
Exemplo n.º 3
0
        private void InsertAbbreviationWord(object sender, EventArgs e)
        {
            using (NAVSymbolForm navSymbolForm = new NAVSymbolForm())
            {
                if (navSymbolForm.ShowDialog() == DialogResult.OK)
                {
                    DataGridViewRow row = AbbreviationsDataGridView.CurrentRow;

                    if (row == null)
                    {
                        return;
                    }

                    Dapper.DynamicParameters param = new Dapper.DynamicParameters();

                    param.Add("@" + Constants.COLUMN_ABBREVIATION_LANGUAGE_ID, UserHelper.UserPropertiesModel.iLanguageID);
                    param.Add("@" + Constants.COLUMN_ABBREVIATIONTYPE_ID, row.Cells[Constants.COLUMN_ABBREVIATIONTYPE_ID].Value);
                    param.Add("@" + Constants.COLUMN_ABBREVIATION_WORD, navSymbolForm.nvWord);
                    param.Add("@" + Constants.COLUMN_ABBREVIATION, navSymbolForm.nvAbbreviation);
                    param.Add("@" + Constants.COLUMN_ABBREVIATION_DESCRIPTION, navSymbolForm.nvAbbreviationDescription);
                    param.Add("@" + Constants.COLUMN_ABBREVIATION_FLAG, navSymbolForm.bAlwaysUse);
                    param.Add("@" + Constants.COLUMN_ABBREVIATION_RETURNCODE, dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.ReturnValue);

                    try
                    {
                        int returnCode = DataAccess.InsertAbbreviation(param);

                        if (returnCode > 0)
                        {
                            try
                            {
                                string nvAbbreviationType = DataAccess.GetAbbreviationType(returnCode);
                                bool   bPlural            = navSymbolForm.nvWord.Contains(" ");

                                MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_ABBREVIATION_UPDATE, System.Environment.NewLine, (bPlural ? "phrase" : "word"), (bPlural ? "words" : "word"), navSymbolForm.nvWord, navSymbolForm.nvAbbreviation, nvAbbreviationType), Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Information);
                                if (log != null)
                                {
                                    log.Info(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_ABBREVIATION_UPDATE, System.Environment.NewLine, (bPlural ? "phrase" : "word"), (bPlural ? "words" : "word"), navSymbolForm.nvWord, navSymbolForm.nvAbbreviation, nvAbbreviationType));
                                }
                            }
                            catch (System.Data.SqlClient.SqlException ex)
                            {
                                MessageBox.Show(Properties.Resources.NOTIFY_ABBREVIATION_TYPE, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Error);
                                if (log != null)
                                {
                                    log.Error(Properties.Resources.NOTIFY_ABBREVIATION_TYPE, ex);
                                }
                            }
                        }

                        GetAbbreviationDataGridView(navSymbolForm.nvWord, navSymbolForm.nvAbbreviation);
                    }
                    catch (System.Data.SqlClient.SqlException ex)
                    {
                        MessageBox.Show(Properties.Resources.NOTIFY_ABBREVIATION_INSERT, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Error);
                        if (log != null)
                        {
                            log.Error(Properties.Resources.NOTIFY_ABBREVIATION_INSERT, ex);
                        }
                    }
                }
            }
        }
Exemplo n.º 4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Guid userid = WebUserAuth.UserId.Value;
            //if (GetBankInfo(userid, 2) == 1)
            //{
            //    //if (bankmodel.Status==2)
            //    //{
            //    //Response.Write("您好,银行卡在审核中不允许充值!");
            //    ClientScript.RegisterStartupScript(this.GetType(), "ss",
            //        "<script>ShowMsg('您好,银行卡在审核中不允许充值!','1','确定');</script>");
            //    return;
            //    //}
            //}
            decimal Amount    = Tool.SafeConvert.ToDecimal(Request.Params["Amount"], 0);
            decimal tmpAmount = Math.Floor(Amount * 100) / 100;

            if (tmpAmount != Amount)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('充值金额最多只能2位小数,如106.32!','1','确定');</script>");
                return;
            }
            TuanDai.PortalSystem.Model.WebSettingInfo rechargeSet =
                new TuanDai.PortalSystem.DAL.WebSettingDAL().GetWebSettingInfo("9A89CBAE-6550-4EA1-8224-EB645F38F8FA");
            decimal minRecharge = decimal.Parse(rechargeSet.Param1Value);

            if (Amount < minRecharge)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('单次充值最少" + minRecharge.ToString("N2") + "元!','1','确定');</script>");
                return;
            }
            if (Amount > 500000)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('单次充值不能超过50万!','1','确定');</script>");
                return;
            }

            var cgtMode = new QueryClient().GetUserByPlatformUserNo(userid);

            if (cgtMode == null)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('存管通未开通,不能进行充值!','1','确定');</script>");
                return;
            }
            if (!cgtMode.isActivate)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('存管通未激活,不能进行充值!','1','确定');</script>");
                return;
            }

            NoHandler noHandler = new NoHandler();
            string    orderNo   = noHandler.OnLineRechare();

            if (orderNo == "0")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('您好,您的提交失败请重试!','1','确定');</script>");
                return;
            }

            string err        = string.Empty;
            bool   isRecharge = new CgtCheckBLL().GetUserCgtIsOper(userid, "recharge", ref err);

            if (!isRecharge)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "ss",
                                                   "<script>ShowMsg('" + err + "','1','确定');</script>");
                return;
            }
            //获取银行卡号
            string bankNo  = Request["bankno"];
            string outCode = string.Empty;

            if (!string.IsNullOrEmpty(bankNo))
            {
                try
                {
                    bankNo = Tool.DESC.Decrypt(bankNo);
                }
                catch (Exception)
                {
                    bankNo = null;
                }
            }

            BankFromJavaService bankJavaService = new BankFromJavaService();

            if (GlobalUtils.IsBankService)
            {
                var bankInfoFromJava = bankJavaService.GetBankInfo(userid, ServiceType.NotTuomin);
                if (bankInfoFromJava != null && bankInfoFromJava.respData != null)
                {
                    bankNo  = bankInfoFromJava.respData.bankNo;
                    outCode = bankInfoFromJava.respData.bankCode;
                }
            }
            else
            {
                var userInfo = new PortalSystem.BLL.UserBLL().GetUserBasicInfoModelById(userid);
                if (userInfo == null || string.IsNullOrEmpty(userInfo.BankAccountNo))
                {
                    var bankInfo = GlobalUtils.GetBankInfo(userid);
                    bankNo = bankInfo.BankNo;
                }
                else
                {
                    bankNo = userInfo.BankAccountNo;
                }
            }

            string userIP = Tool.WebFormHandler.GetIP();

            if (!GlobalUtils.IsBankService)
            {
                var sss = TuanDai.Payment.Client.BankInfo.GetPayBankInfo(userid);

                TuanDai.Payment.Models.PayRoute.RouteInfo bank = new TuanDai.Payment.Client.Recharge().GetCgtRechargeInfo(userid, sss.BankNo);
                int Sel = bank.Sel;

                int    outStatus = 0;
                string bankcode  = "";
                if (Request.Params["bankcode"] != null)
                {
                    bankcode = Request.Params["bankcode"];
                }


                var paramData = new Dapper.DynamicParameters();
                paramData.Add("@userid", userid);
                paramData.Add("@type", Sel);
                paramData.Add("@amount", Amount);
                paramData.Add("@orderNo", orderNo);
                paramData.Add("@backcode", bankcode);
                paramData.Add("@clientIp", userIP);
                paramData.Add("@from", "5");
                if (bank.RouteId.IsEmpty())
                {
                    paramData.Add("@RouteId", null);
                }
                else
                {
                    paramData.Add("@RouteId", bank.RouteId);
                }
                paramData.Add("@outStatus", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
                paramData.Add("@cmorderNo", "");
                PublicConn.ExecuteTD(PublicConn.DBWriteType.FundWrite, "p_cgt_AccountRechargeInit", ref paramData, CommandType.StoredProcedure);
                outStatus = paramData.Get <int>("@outStatus");

                int result = outStatus;
                if (result > 0)
                {
                    lock (lockstatus)
                    {
                        var isCallBackPayment =
                            System.Configuration.ConfigurationManager.AppSettings["IsCallBackPayment"];
                        var    paymentUrl  = System.Configuration.ConfigurationManager.AppSettings["PaymentUrl"];
                        string callBackUrl = paymentUrl + "/PaymentPlatform/H5/commonCallBack.aspx";
                        if (isCallBackPayment == "0")
                        {
                            callBackUrl = CgtCallBackConfig.GetCgtCallBackUrl(CgtCallBackConfig.CgtCallBackType.Recharge);
                        }
                        var recharInfo = new Payment.Client.Recharge().GetCgtRechargeInfo(userid, bankNo);
                        var url        = CunGuanTong.Client.FundClient.RECHARGE_Req(new CunGuanTong.Model.RECHARGE_Request
                        {
                            rechargeWay      = rechargeWay.SWIFT,
                            requestNo        = orderNo,
                            amount           = Amount,
                            bankcode         = recharInfo.OutCode,
                            callbackMode     = "DIRECT_CALLBACK",
                            platformUserNo   = userid.ToString(),
                            expectPayCompany = recharInfo.CgtPayCompany,
                            //callbackUrl = CgtCallBackConfig.GetCgtCallBackUrl(CgtCallBackConfig.CgtCallBackType.Recharge),
                            callbackUrl = callBackUrl,
                            userDevice  = CunGuanTong.Model.userDevice.MOBILE
                        });

                        if (string.IsNullOrEmpty(url))
                        {
                            if (Request.UrlReferrer != null)
                            {
                                url = Request.UrlReferrer.ToString();
                            }
                            else
                            {
                                url = GlobalUtils.WebURL;
                            }
                        }
                        Response.Redirect(url);
                    }
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "ss", "<script>ShowMsg('您好,充值提交失败请重试!','1','确定');</script>");
                }
            }
            else
            {  //走Java银行卡服务
                string retUrl = bankJavaService.GetCgtRechargeUrl(userid, bankNo, Amount, userIP, outCode);
                if (!string.IsNullOrEmpty(retUrl))
                {
                    Response.Redirect(retUrl);
                }
            }
        }
Exemplo n.º 5
0
        protected override async Task OnInitializedAsync()
        {
            try
            {
                DataLoaded   = false;
                ErrorMessage = string.Empty;


                UserName = await _sessionStorageService.GetItemAsync <string>("UserName");

                CompanyId = await _sessionStorageService.GetItemAsync <string>("CompanyId");


                var p = reportParams.Split("|");

                dateFrom   = DateTime.Parse(p[0]);
                dateTo     = DateTime.Parse(p[1]);
                reportType = p[2];

                // var sqlcommand = $"exec ASRCReportsDtls '{companyId.Replace("'", "''")}'";
                // var sqlcommand = $"exec ASRCReportsDtls '{companyId.Replace("'", "''")}'";
                var param = new Dapper.DynamicParameters();
                param.Add("dateFrom", dateFrom, System.Data.DbType.DateTime);
                param.Add("dateTo", dateTo, System.Data.DbType.DateTime);
                param.Add("ReportType", reportType, System.Data.DbType.String);
                param.Add("companyId", CompanyId, System.Data.DbType.String);



                //string path;
                DataTable table = new DataTable();

                if (reportType == "Employees")
                {
                    var emp = await
                              dapperManager.GetAllAsync <rptEmployee>("terminusReports", param);

                    rptEmployees = emp.OrderBy(a => a.LastName).ThenBy(a => a.FirstName).ThenBy(a => a.MiddleName).ToList();

                    //rptEmployees.OrderBy(a => a.LastName).ThenBy(a => a.FirstName).ThenBy(a => a.MiddleName);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptEmployees), (typeof(DataTable)));
                }

                if (reportType == "GLDetails")
                {
                    rptGLDVM = await
                               dapperManager.GetAllAsync <rptGLDetailViewModel>("terminusReports", param);


                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptGLDVM), (typeof(DataTable)));
                }


                if (reportType == "PropertyInventory")
                {
                    //rptPropertypeInventoryMV = await
                    //    dapperManager.GetAllAsync<rptPropertypeInventoryMV>("terminusReports", param);

                    var pti = await dapperManager.GetAllAsync <rptPropertypeInventoryMV>("terminusReports", param);

                    rptPropertypeInventoryMV = pti.OrderBy(a => a.description).ToList();

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptPropertypeInventoryMV), (typeof(DataTable)));
                }


                if (reportType == "BuildingDirectory")
                {
                    rptBuildingDirectoryVM = await
                                             dapperManager.GetAllAsync <rptBuildingDirectoryVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptBuildingDirectoryVM), (typeof(DataTable)));
                }


                if (reportType == "RentalIncomeDetails")
                {
                    rptRentalIncomeVM = await
                                        dapperManager.GetAllAsync <rptRentalIncomeVM>("terminusReports", param);


                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptRentalIncomeVM), (typeof(DataTable)));
                }

                if (reportType == "OtherIncomeDetails")
                {
                    rptOtherIncomeDetailVM = await
                                             dapperManager.GetAllAsync <rptOtherIncomeDetailVM>("terminusReports", param);



                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptOtherIncomeDetailVM), (typeof(DataTable)));
                }

                if (reportType == "Expenses")
                {
                    rptExpensesVM = await
                                    dapperManager.GetAllAsync <rptExpensesVM>("terminusReports", param);


                    //path = @"d:\Expenses" + "_" + DateTime.Today.ToString() + ".xlsx";

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptExpensesVM), (typeof(DataTable)));
                }

                if (reportType == "NetIncomeSummary")
                {
                    rptNetIncomeSummaryVM = await
                                            dapperManager.GetAllAsync <rptNetIncomeSummaryVM>("terminusReports", param);


                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptNetIncomeSummaryVM), (typeof(DataTable)));
                }

                if (reportType == "TrialBalance")
                {
                    rptTrialBalanceVM = await
                                        dapperManager.GetAllAsync <rptTrialBalanceVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptTrialBalanceVM), (typeof(DataTable)));
                }


                if (reportType == "NetIncome")
                {
                    rptNetIncomeVM = await
                                     dapperManager.GetAllAsync <rptNetIncomeVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptNetIncomeVM), (typeof(DataTable)));
                }

                if (reportType == "BalanceSheet")
                {
                    rptbalanceSheetVM = await
                                        dapperManager.GetAllAsync <rptBalanceSheetVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptbalanceSheetVM), (typeof(DataTable)));
                }

                if (reportType == "ReceiptsOverExpenses")
                {
                    rptReceiptsOverExpensesVM = await
                                                dapperManager.GetAllAsync <rptReceiptsOverExpensesVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptReceiptsOverExpensesVM), (typeof(DataTable)));
                }

                if (reportType == "Collections")
                {
                    rptCollectionVM = await
                                      dapperManager.GetAllAsync <rptCollectionVM>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptCollectionVM), (typeof(DataTable)));
                }

                if (reportType == "Revenues")
                {
                    rptRevenues = await
                                  dapperManager.GetAllAsync <rptRevenue>("terminusReports", param);

                    table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(rptRevenues), (typeof(DataTable)));
                }
                //var newpath = @"d:\"+ reportType +"" + "_" + DateTime.Today.ToString("MM/dd/yyyy").Replace("/","").Replace(" ","").Replace(":","") + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + ".xlsx";

                //string sFileName = @"" + reportType + ".xlsx";

                if (table != null && table.Rows.Count > 0)
                {
                    var tmpPath = Path.Combine(_env.WebRootPath, "Uploaded");
                    if (!Directory.Exists(tmpPath))
                    {
                        Directory.CreateDirectory(tmpPath);
                    }


                    var fileName = $"{DateTime.Today.ToString("yyyyMMdd")}{Guid.NewGuid().ToString()}.xlsx";

                    FileInfo file = new FileInfo(Path.Combine(tmpPath, fileName));

                    using (var excelPack = new ExcelPackage(file))
                    {
                        var ws           = excelPack.Workbook.Worksheets.Add("Sheet1");
                        int rowIndex     = 1;
                        int colnameindex = 1;

                        foreach (DataColumn col in table.Columns)
                        {
                            if (colnameindex != 1)
                            {
                                ws.Cells[rowIndex, colnameindex - 1].Value = col.ColumnName.ToString();
                            }
                            colnameindex += 1;
                        }

                        rowIndex = 2;

                        foreach (DataRow row in table.Rows)
                        {
                            int colIndex = 1;
                            foreach (DataColumn col in table.Columns)
                            {
                                if (colIndex != 1)
                                {
                                    ws.Cells[rowIndex, colIndex - 1].Value = row[col.ColumnName].ToString().Replace("1/1/0001 12:00:00 AM", "");
                                }
                                colIndex += 1;
                            }
                            rowIndex += 1;
                        }


                        //ws.Cells.LoadFromDataTable(table, true, OfficeOpenXml.Table.TableStyles.Light8);
                        excelPack.Save();
                    }

                    _path = $"/Uploaded/{fileName}"; //file.FullName;
                }
            }
            catch (Exception ex)
            {
                ErrorMessage = ex.Message;
            }
            finally
            {
                DataLoaded = true;
            }
        }
Exemplo n.º 6
0
        private void GetContractInfo(string key)
        {
            bool   isUndertake = false; //是否承接人
            string contactno   = key;

            this.submodel = new SubscribeBLL().GetSubscribeInfoContractNo(contactno);
            if (submodel.AddDate < Convert.ToDateTime("2016-3-11"))
            {
                companyName = "广东俊特团贷网络信息服务股份有限公司";
            }
            else
            {
                companyName = "东莞团贷网互联网科技服务有限公司";
            }

            Dapper.DynamicParameters param = new Dapper.DynamicParameters();
            param = new Dapper.DynamicParameters();
            param.Add("@BorrowerUserId", submodel.BorrowerUserId);
            param.Add("@curUserId", WebUserAuth.UserId);
            string strSQL  = "select Count(1) from project where UserId=@BorrowerUserId and UserId=@curUserId";
            bool   isExist = PublicConn.QuerySingle <int>(strSQL, ref param) > 0;

            if (this.submodel.SubscribeUserId != WebUserAuth.UserId && !isExist)
            {
                string sql = @"SELECT c.* FROM (
                           SELECT b.* FROM dbo.Subscribe a
                           RIGHT JOIN dbo.t_SubScribeTransfer  b ON a.id=b.m_FromSubscribeId
                           WHERE a.ContractNo=@ContractNo) M 
                           INNER JOIN dbo.Subscribe c ON c.TranId=M.M_id
                           WHERE c.SubscribeUserId=@SubscribeUserId";
                param = new Dapper.DynamicParameters();
                param.Add("@ContractNo", contactno);
                param.Add("@SubscribeUserId", WebUserAuth.UserId);
                var mSubscribe = PublicConn.QuerySingle <SubscribeInfo>(sql, ref param);

                if (mSubscribe == null)//判断是否是承接人查看借款人与转让人的合同
                {
                    HttpContext.Current.Response.Write("对不起,您没有权限查看此合同。");
                    HttpContext.Current.Response.End();
                    return;
                }
                isUndertake = true;
            }
            this.subBasicModel  = userbll.GetUserBasicInfoModelById(submodel.SubscribeUserId.Value); //投资人信息
            this.proModel       = projectbll.GetProjectDetailInfo(submodel.ProjectId.Value);
            this.publisherModel = userbll.GetUserBasicInfoModelById(proModel.UserId.Value);          //借款人信息


            UserEnterpriseInfo userEnterprise = new Common.Contract().GetBorrowerGuaranteeEnterprise(proModel.UserId.Value, proModel.AddDate.Value, proModel.Type.Value);

            if (userEnterprise != null)
            {
                AssureModel = new Common.Contract().GetAssureOrganizationByUserId(userEnterprise.UserId);
            }
            else
            {
                //当未指定担保机构时则退出  allen  2015-05-07
                if (string.IsNullOrEmpty(proModel.Guarantors) || proModel.Guarantors.ToInt(0) <= 0)
                {
                    HttpContext.Current.Response.Write("对不起,该项目未指定担保机构,不能查看合同!");
                    HttpContext.Current.Response.End();
                    return;
                }
                int gid = 0;
                int.TryParse(proModel.Guarantors, out gid);
                AssureModel = new Common.Contract().GetAssureOrganizationById(gid);
                if (gid == 1 && DateTime.Now < DateTime.Parse("2013-11-27"))
                {
                    AssureModel.FullName = "东莞市俊特团贷网络信息服务有限公司";
                }
            }

            //印章小图片
            this.AssureModel.image = new Common.Contract().GetSmallImage(this.AssureModel.image);

            RepaymentTypeDesc = new Common.Contract().GetRepaymentTypeDesc(proModel.RepaymentType ?? 0);

            if (WebUserAuth.UserId == publisherModel.Id)
            {
                this.subBasicModel.RealName     = StringHandler.MaskStartPre(subBasicModel.RealName, 1); //出借人
                this.subBasicModel.IdentityCard = StringHandler.MaskCardNo(subBasicModel.IdentityCard);  //出借人身份证号
            }
            else
            {
                this.publisherModel.RealName     = StringHandler.MaskStartPre(publisherModel.RealName, 1); //借款 人
                this.publisherModel.IdentityCard = StringHandler.MaskCardNo(publisherModel.IdentityCard);  //借款人身份证号
            }

            if (isUndertake)
            {
                this.subBasicModel.RealName      = StringHandler.MaskStartPre(subBasicModel.RealName, 1);  //出借人
                this.subBasicModel.IdentityCard  = StringHandler.MaskCardNo(subBasicModel.IdentityCard);   //出借人身份证号
                this.publisherModel.RealName     = StringHandler.MaskStartPre(publisherModel.RealName, 1); //借款 人
                this.publisherModel.IdentityCard = StringHandler.MaskCardNo(publisherModel.IdentityCard);  //借款人身份证号
            }
        }
        public async Task <IEnumerable <ESysUserInfo> > GetPageAsync(int PageIndex, int PageSize, string sWhere, Dapper.DynamicParameters param)
        {
            string sql = "select * from(select ROW_NUMBER() over(order by UserID desc)n,UserID,UserName,RealName,Pwd,Mobile,Wechat,OpenId,Dept,Position,Status from Sys_UserInfo where 1=1 {0} ) p where p.n>@p1 and p.n<=@p2";

            sql = string.Format(sql, sWhere);
            param.Add("p1", (PageIndex - 1) * PageSize);
            param.Add("p2", PageIndex * PageSize);
            return(await _context.QueryAsync <ESysUserInfo>(sql, param));
        }
Exemplo n.º 8
0
        public async Task <int> GetTotalCount(string sWhere, Dapper.DynamicParameters param)
        {
            string sql = string.Format("select count(1) from Sys_Menu where 1=1 {0}", sWhere);

            return(await _context.QueryFirstOrDefaultAsync <int>(sql, param));
        }
Exemplo n.º 9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            errorMsg = Request.QueryString["error"];
            var idStr = Request.QueryString["projectid"];

            if (!string.IsNullOrEmpty(idStr))
            {
                projectId = Guid.Parse(idStr);
            }
            else
            {
                Response.Redirect("/pages/invest/invest_list.aspx");
            }

            InvestType = Request.QueryString["investType"];

            var payMoneyStr = Request.QueryString["payMoney"];

            if (!string.IsNullOrEmpty(payMoneyStr))
            {
                PayMoney = decimal.Parse(payMoneyStr);
            }
            else
            {
                Response.Redirect("/pages/invest/invest_list.aspx");
            }

            if (InvestType == "project")
            {
                string sql = "select count(0) from Project with(nolock) where id=@id";
                Dapper.DynamicParameters para = new Dapper.DynamicParameters();
                para.Add("@id", projectId);
                var count = PublicConn.QuerySingle <int>(sql, ref para);
                if (count > 0)
                {
                    FinishUrl = "/pages/invest/detail.aspx?id=" + projectId;
                    GoOnUrl   = "/pages/invest/invest_list.aspx";
                }
                else
                {
                    FinishUrl = "/pages/invest/zqzr_detail.aspx?projectid=" + projectId;
                    GoOnUrl   = "/pages/invest/debt_list.aspx";
                }
            }
            else
            {
                string sql = "select count(0) from we_product with(nolock) where id=@id and iswefqb = 1";
                Dapper.DynamicParameters para = new Dapper.DynamicParameters();
                para.Add("@id", projectId);
                var count = PublicConn.QuerySingle <int>(sql, ref para);
                if (count > 0)
                {
                    FinishUrl = "/pages/invest/WE/WeFqb_detail.aspx?id=" + projectId;
                }
                else
                {
                    FinishUrl = "/pages/invest/WE/WE_detail.aspx?id=" + projectId;
                }
                GoOnUrl = "/pages/invest/WE/WE_list.aspx";
            }
        }
Exemplo n.º 10
0
        protected void GetBorrowUserInfo()
        {
            if (ProjectId != null && ProjectId != Guid.Empty)
            {
                string sql = @"select b.Id as UserId, b.Birthday, b.TelNo, b.sex, b.AddDate, b.NickName, b.BankCity, b.CreditRatingName,b.UserTypeId,b.RealName, a.Type as ProjectType from Project a
                               inner join UserBasicInfo b with(nolock)  on b.Id=a.UserId
                               where a.Id=@projectId ";
                Dapper.DynamicParameters dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@projectId", ProjectId);
                borrowerUserInfo = PublicConn.QuerySingle <BorrowUserInfo>(sql, ref dyParams);
                if (borrowerUserInfo == null)
                {
                    borrowerUserInfo = new BorrowUserInfo();
                }

                string phone = borrowerUserInfo.TelNo.ToText();
                if (!phone.IsEmpty())
                {
                    if (phone.Length > 11)
                    {
                        phone = phone.Left(11);
                    }
                }
                borrowerUserInfo.TelNo = phone;

                SimpleUserExt userBasicInfo_Ext = null;
                dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@userid", borrowerUserInfo.UserId);
                sql = @"select Marriage,Graduation,IsHasChildren, IsHaveHouse,IsHaveCar,Address from t_UserBasicInfo_Ext with(nolock) where UserId=@userid";
                userBasicInfo_Ext = PublicConn.QuerySingle <SimpleUserExt>(sql, ref dyParams);

                if (userBasicInfo_Ext != null)
                {
                    borrowerUserInfo.Marriage   = userBasicInfo_Ext.Marriage;
                    borrowerUserInfo.Graduation = userBasicInfo_Ext.Graduation;
                    if (userBasicInfo_Ext.IsHasChildren == true)
                    {
                        borrowerUserInfo.IsHasChildren = "有";
                    }
                    else
                    {
                        borrowerUserInfo.IsHasChildren = "否";
                    }
                    borrowerUserInfo.IsHasHouse = userBasicInfo_Ext.IsHaveHouse ? "有" : "无";
                    if (borrowerUserInfo.BankCity.IsEmpty())
                    {
                        borrowerUserInfo.BankCity = StringHandler.MaskStarPre3(userBasicInfo_Ext.Address);
                    }
                }
                //是否项目集标的
                if (borrowerUserInfo.ProjectType.ToString().IsIn("24", "25", "27", "28", "29", "31", "33"))
                {
                    Fq_ItemSetsProjectInfo fq_ItemSetsProjectInfo = new fq_ItemSetsProjectBLL().GetFqItemSetsProjectInfoByPorjectId(ProjectId);
                    if (fq_ItemSetsProjectInfo != null)
                    {
                        borrowerUserInfo.BankCity   = StringHandler.MaskStartPre(Tool.WebFormHandler.CutString(fq_ItemSetsProjectInfo.Address, 6), 3);
                        borrowerUserInfo.Industry   = StringHandler.MaskStartPre(fq_ItemSetsProjectInfo.CompanyIndustryTypeId, 6);
                        borrowerUserInfo.Salary     = fq_ItemSetsProjectInfo.MonthlyIncome + "元";
                        borrowerUserInfo.IsHasHouse = fq_ItemSetsProjectInfo.IsHaveHouse ? "有" : "无";
                        borrowerUserInfo.Graduation = fq_ItemSetsProjectInfo.Education;
                        borrowerUserInfo.Marriage   = fq_ItemSetsProjectInfo.MarrayStatus ? "已婚" : "未婚";
                    }
                }
                if (borrowerUserInfo.ProjectType >= 39)
                {
                    sql      = "select ext from dbo.Project_Common where ProjectId=@ProjectId";
                    dyParams = new Dapper.DynamicParameters();
                    dyParams.Add("@ProjectId", ProjectId);
                    string ext = PublicConn.QuerySingle <string>(sql, ref dyParams);
                    if (ext.IsNotEmpty())
                    {
                        var borrowExtInfo = JsonConvert.DeserializeObject <BorrowExtInfo>(ext);
                        if (borrowExtInfo != null)
                        {
                            borrowerUserInfo.Marriage   = borrowExtInfo.marriage;
                            borrowerUserInfo.Graduation = borrowExtInfo.education;
                            borrowerUserInfo.IsHasHouse = borrowExtInfo.housingSituation.IsEmpty() ? "无" : borrowExtInfo.housingSituation;
                            borrowerUserInfo.BankCity   = borrowExtInfo.city;
                        }
                    }
                }

                //查询借款人合规表信息
                string strSQL = "select * from BorrowerComplianceInfo with(nolock) where ProjectId=@projectId";
                dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@projectId", ProjectId);
                PageBorrowerComplianceInfo compInfo = PublicConn.QuerySingle <PageBorrowerComplianceInfo>(strSQL, ref dyParams);
                if (compInfo != null)
                {
                    borrowerUserInfo.IsShowExt = "1";
                    borrowerUserInfo.Industry  = compInfo.Trade;
                    if (compInfo.CompanyName.IsNotEmpty())
                    {
                        borrowerUserInfo.RealName = StringHandler.MaskStartPre(compInfo.CompanyName, 1);
                    }
                    borrowerUserInfo.Salary        = compInfo.IncomePerMonth.ToText() == "" ? "无" : compInfo.IncomePerMonth;
                    borrowerUserInfo.CurrentDebts  = compInfo.CurrentDebt.IsEmpty() ? "无" : compInfo.CurrentDebt;
                    borrowerUserInfo.OtherBorrow   = compInfo.OtherPlatformsBorrow.IsEmpty() ? "无" : compInfo.OverdueSituation;
                    borrowerUserInfo.CreditOverDue = compInfo.OverdueSituation.IsEmpty() ? "无" : compInfo.OtherPlatformsBorrow;
                    borrowerUserInfo.RegAmount     = compInfo.RegisteredCapital.IsEmpty() ? "无" : compInfo.RegisteredCapital;
                    borrowerUserInfo.RegAddress    = compInfo.RegisteredAddress.IsEmpty() ? "无" : StringHandler.MaskStartPre(compInfo.RegisteredAddress, 6);
                    borrowerUserInfo.RegDate       = compInfo.EstablishedTime.ToString("yyyy年MM月dd日");
                    borrowerUserInfo.LegalName     = compInfo.LegalPerson.IsEmpty() ? "无" : StringHandler.MaskStartPre(compInfo.LegalPerson, 1);
                }
            }
            else
            {
                borrowerUserInfo = new BorrowUserInfo();
            }
        }
Exemplo n.º 11
0
        T ISqlAdapter.Get <T>(IDbConnection connection, IDbTransaction transaction, int?commandTimeout, string sql, Dapper.DynamicParameters parameters)
        {
            var results = Dapper.SqlMapper.Query <T>(connection, sql, parameters, transaction: transaction, commandTimeout: commandTimeout).SingleOrDefault();

            return(results);
        }
Exemplo n.º 12
0
        public async Task <IEnumerable <ESysRole> > GetPageAsync(int PageIndex, int PageSize, string sWhere, Dapper.DynamicParameters param)
        {
            string sql = "select * from(select ROW_NUMBER() over(order by RoleID desc)n,RoleID,RoleName,Status,Mark from Sys_Role where 1=1 {0} ) p where p.n>@p1 and p.n<=@p2";

            sql = string.Format(sql, sWhere);
            param.Add("p1", (PageIndex - 1) * PageSize);
            param.Add("p2", PageIndex * PageSize);
            return(await _context.QueryAsync <ESysRole>(sql, param));
        }
Exemplo n.º 13
0
        private void DeleteAbbreviationWords(object sender, EventArgs e)
        {
            int selectedCellCount = AbbreviationsDataGridView.GetCellCount(DataGridViewElementStates.Selected);

            if (selectedCellCount > 0)
            {
                int iRowCount = 0;

                foreach (DataGridViewRow row in AbbreviationsDataGridView.Rows)
                {
                    foreach (DataGridViewCell cell in row.Cells)
                    {
                        if ((cell.ColumnIndex == 3) && (cell.Selected))
                        {
                            iRowCount++;
                            break;
                        }
                    }
                }

                if (iRowCount > 0)
                {
                    switch (MessageBox.Show((iRowCount == 1) ? Properties.Resources.NOTIFY_DELETE_ROW : Properties.Resources.NOTIFY_DELETE_SELECTED_ROWS, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button3))
                    {
                    case DialogResult.Yes:

                        Cursor.Current = Cursors.WaitCursor;

                        if (AbbreviationsDataGridView.AreAllCellsSelected(true))
                        {
                            throw new NotImplementedException();
                        }
                        else
                        {
                            foreach (DataGridViewRow row in AbbreviationsDataGridView.Rows)
                            {
                                foreach (DataGridViewCell cell in row.Cells)
                                {
                                    if ((cell.ColumnIndex == 3) && (cell.Selected))
                                    {
                                        Dapper.DynamicParameters param = new Dapper.DynamicParameters();

                                        param.Add("@" + Constants.COLUMN_ABBREVIATIONWORD_ID, row.Cells[Constants.COLUMN_ABBREVIATIONWORD_ID].Value);

                                        try
                                        {
                                            DataAccess.DeleteAbbreviation(param);
                                            break;
                                        }
                                        catch (System.Data.SqlClient.SqlException ex)
                                        {
                                            MessageBox.Show(Properties.Resources.NOTIFY_DELETE_ABBREVIATION, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Error);
                                            if (log != null)
                                            {
                                                log.Error(Properties.Resources.NOTIFY_DELETE_ABBREVIATION, ex);
                                            }
                                        }
                                    }
                                }
                            }

                            GetAbbreviationDataGridView();
                        }

                        break;

                    default: break;
                    }
                }
                else
                {
                    MessageBox.Show(Properties.Resources.NOTIFY_SELECT_ABBREVIATION, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Exemplo n.º 14
0
        /// <summary>
        /// 获取我的复投宝转让记录
        /// </summary>
        public void GetMyFtbTranList()
        {
            string subId = WEBRequest.GetFormString("SubId");
            int    pageIndex;

            int.TryParse(Context.Request["pageIndex"], out pageIndex);
            int totalCount = 0;
            //string strSQL = @" select Id from dbo.ProjectFQBExTransfer where SubscribeId=@subId";
            //var dyParams = new Dapper.DynamicParameters();
            //dyParams.Add("@subId", subId);
            //Guid? tranId = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault<Guid?>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
            Guid?tranId = GetTranList(subId.ToUpper()).FirstOrDefault().Id;
            List <FTBChengJieInfo> dataList = null;

            if (!tranId.HasValue)
            {
                totalCount = 0;
                dataList   = new List <FTBChengJieInfo>();
            }
            else
            {
                var strSQL   = @" select * from (select  ROW_NUMBER() OVER(order by a.TranDate desc) rownumber, isnull(a.TranDate,a.AddDate) as InvestDate, 
                    a.Amount as InvestAmount,b.TelNo,a.ContractNo,a.Id  as SubscribeId,p.Type
                    from Subscribe  a with(nolock)
                    inner join Project p with(nolock) on a.ProjectId=p.id
                    left join UserBasicInfo b with(nolock) on b.Id=a.SubscribeUserId
                    where a.TranId=@tranId
                    )M  WHERE M.rownumber> @pagesize*(@pageindex-1) and  M.rownumber<=@pagesize*@pageindex ";
                var dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@tranId", tranId);
                dyParams.Add("@pagesize", 15);
                dyParams.Add("@pageindex", pageIndex);
                dataList = TuanDai.DB.TuanDaiDB.Query <FTBChengJieInfo>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
                if (dataList != null && dataList.Count > 0)
                {
                    foreach (var item in dataList)
                    {
                        item.ContractUrl = GetContractViewUrl(item.Type, true, item.ContractNo, item.SubscribeId);
                        if (!string.IsNullOrEmpty(item.TelNo))
                        {
                            item.TelNo = BusinessDll.StringHandler.MaskTelNo(item.TelNo);
                        }
                        item.InvestDateStr = item.InvestDate.ToShortDateString();
                    }
                }
                strSQL   = "select count(1) from Subscribe where TranId=@tranId";
                dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@tranId", tranId);
                totalCount = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault <int>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
            }


            this.Context.Response.Write(JsonConvert.SerializeObject(
                                            new
            {
                result     = totalCount > 0 ? 1 : 0,
                totalcount = totalCount,
                msg        = dataList
            }));

            this.Context.Response.End();
        }
Exemplo n.º 15
0
        public void CheckPayPwd()
        {
            Guid userid = WebUserAuth.UserId.Value;

            if (userid == Guid.Empty)
            {
                PrintJson("-99", "登录已失效");
            }
            string msg          = string.Empty;
            var    isWithdrawal = new CgtCheckBLL().GetUserCgtIsOper(userid, "tixian", ref msg);

            if (!isWithdrawal)
            {
                PrintJson("-199", msg + ",不允许提现");
                return;
            }

            string  amountStr       = Context.Request.Form["amount"];
            string  couponAmountStr = Context.Request.Form["couponAmount"];
            decimal amount          = 0m;
            decimal couponAmount    = 0m;

            if (!string.IsNullOrEmpty(amountStr))
            {
                amount = Convert.ToDecimal(amountStr);
            }
            if (!string.IsNullOrEmpty(couponAmountStr))
            {
                couponAmount = Convert.ToDecimal(couponAmountStr);
            }
            string userPrizeId = Context.Request.Form["userPrizeId"];
            Guid   couponId    = new Guid();

            if (!string.IsNullOrEmpty(userPrizeId))
            {
                couponId = Guid.Parse(userPrizeId);//优惠券Id
            }
            //可提现金额
            decimal aviMoney = new UserBLL().GetDrawAviAmount(userid);

            if (amount > aviMoney)
            {
                PrintJson("-1", "申请提现金额大于可用金额");
                return;
            }

            string withdrawNo = string.Empty;

            if (GlobalUtils.IsBankService)
            {
                WXResponsePublicInfo <WXResponseWithdrawInit> init =
                    new BankFromJavaService().WithdrawalInit(new WXRequestPublicInfo <WXRequestWithdrawInit>
                {
                    serverName = TdConfig.ApplicationName,
                    reqData    = new WXRequestWithdrawInit
                    {
                        amount       = amount,
                        couponId     = couponId,
                        couponAmount = couponAmount,
                        fundType     = "USER",
                        userId       = userid,
                        withdrawType = "GATEWAY"
                    }
                });
                if (init != null)
                {
                    withdrawNo = init.respData.withdrawNo;
                }
                else
                {
                    PrintJson("-1", "生成提现申请出错");
                    return;
                }
            }
            else
            {
                string err = "";
                WithdrawResponseModel resmodel = TuanDai.Payment.Client.Withdraw.ApplyWithdraw(new WithdrawRequestModel
                {
                    Amount       = amount,
                    CouponAmount = couponAmount,
                    CouponId     = couponId,
                    FundType     = 0,
                    UserId       = userid,
                    WithdrawType = 1//1:存管通,2:定期
                }, ref err);

                if (resmodel == null)
                {
                    TuanDai.LogSystem.LogClient.LogClients.ErrorLog(TdConfig.ApplicationName, "生成提现申请出错", "", err);
                    PrintJson("-1", "生成提现申请出错");
                    return;
                }
                if (resmodel.ReturnCode != 1)
                {
                    TuanDai.LogSystem.LogClient.LogClients.ErrorLog("WXTouch", "TuanDai.Payment.Client.Withdraw.ApplyWithdraw", "提现申请错误", resmodel.ReturnMessage);
                    PrintJson("-1", resmodel.ReturnMessage);
                }

                withdrawNo = resmodel.WithdrawNo;
            }


            //申请提现金额
            //decimal handingcharge= decimal.Parse(resmodel.HandingCharge.ToString());
            //if ((aviMoney - amount - handingcharge) < 0)
            //{
            //    amount = amount - handingcharge;
            //}
            string strSQL = "SELECT TOP 1 * FROM AppWithdrewFund WHERE UserId=@UserId and WithdrawNo=@WithdrawNo";

            var dyParams = new Dapper.DynamicParameters();

            dyParams.Add("@UserId", userid);
            dyParams.Add("@WithdrawNo", withdrawNo);
            WXAppWithdrewFund fundInfo = TuanDai.DB.TuanDaiDB.QuerySingleOrDefault <WXAppWithdrewFund>(TdConfig.ApplicationName, TdConfig.DBRealRead, strSQL, ref dyParams);

            if (fundInfo == null)
            {
                PrintJson("-1", "获取提现金额失败");
                return;
            }
            var    isCallBackPayment = System.Configuration.ConfigurationManager.AppSettings["IsCallBackPayment"];
            var    paymentUrl        = System.Configuration.ConfigurationManager.AppSettings["PaymentUrl"];
            string callBackUrl       = paymentUrl + "/PaymentPlatform/H5/commonCallBack.aspx";

            if (isCallBackPayment != "1")
            {
                callBackUrl = CgtCallBackConfig.GetCgtCallBackUrl(CgtCallBackConfig.CgtCallBackType.Withdraw);
            }
            TuanDai.CunGuanTong.Model.WITHDRAW_Request info = new TuanDai.CunGuanTong.Model.WITHDRAW_Request
            {
                callbackUrl    = callBackUrl,
                platformUserNo = userid.ToString(),
                userDevice     = TuanDai.CunGuanTong.Model.userDevice.MOBILE,
                amount         = decimal.Parse(fundInfo.ActualWithdrawDeposit.Value.ToString("0.00")),
                commission     = fundInfo.HandingCharge.HasValue ? decimal.Parse(fundInfo.HandingCharge.Value.ToString("0.00")) : decimal.Zero, //,//提现手续费
                requestNo      = withdrawNo                                                                                                     //提现订单流水号
            };
            string responseStr = TuanDai.CunGuanTong.Client.FundClient.WITHDRAW_Req(info);

            PrintJson("1", responseStr);
        }
Exemplo n.º 16
0
        public async Task <IEnumerable <ESysMenu> > GetPageAsync(int PageIndex, int PageSize, string sWhere, Dapper.DynamicParameters param)
        {
            string sql = "select * from(select ROW_NUMBER() over(order by MenuID desc)n,MenuID,MenuTitle,MenuUrl,ParentID,Sort,Style,Status from Sys_Menu where 1=1 {0} ) p where p.n>@p1 and p.n<=@p2";

            sql = string.Format(sql, sWhere);
            param.Add("p1", (PageIndex - 1) * PageSize);
            param.Add("p2", PageIndex * PageSize);
            return(await _context.QueryAsync <ESysMenu>(sql, param));
        }
Exemplo n.º 17
0
        public async Task <IEnumerable <EMessageBox> > GetPageAsync(int PageIndex, int PageSize, string sWhere, Dapper.DynamicParameters param)
        {
            string sql = "select * from(select ROW_NUMBER() over(order by ID desc)n,ID,Sender,SenderID,Receiver,ReceiverID,SendTime,CreateTime,Title,Content,Type,Status from MessageBox where 1=1 {0} ) p where p.n>@p1 and p.n<=@p2";

            sql = string.Format(sql, sWhere);
            param.Add("p1", (PageIndex - 1) * PageSize);
            param.Add("p2", PageIndex * PageSize);
            return(await _context.QueryAsync <EMessageBox>(sql, param));
        }
Exemplo n.º 18
0
 public static Dapper.DynamicParameters GetWIGAWaitItemDeleteParameters(long wigaUid)
 {
     Dapper.DynamicParameters queryParameters = new Dapper.DynamicParameters();
     queryParameters.Add("@01iWIGAUID_input", wigaUid);
     return(queryParameters);
 }
Exemplo n.º 19
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Guid userid = WebUserAuth.UserId.Value;

            decimal Amount = Tool.SafeConvert.ToDecimal(Request.Params["Amount"], 0);

            //if (Amount < 100)
            //{
            //    Response.Write("您好,充值金额必须大于或者等于100!");
            //    return;
            //}

            if (Amount > 5000000)
            {
                Response.Write("单次充值不能超过500万!");
                return;
            }


            NoHandler noHandler = new NoHandler();
            string    orderNo   = noHandler.OnLineRechare();

            if (orderNo == "0")
            {
                Response.Write("您好,您的提交失败请重试!");
                return;
            }

            int  Sel        = Tool.SafeConvert.ToInt32(Request.Params["Sel"], 12);
            Guid rechargeId = Guid.NewGuid();
            int  outStatus  = 0;

            //string bankcode = "";
            //bankcode = Request.Params["bankcode"];
            ////if (Request.Params["bankcode"] != null)
            ////{

            ////}

            //if (string.IsNullOrEmpty(bankcode))
            //{
            //    Response.Write("您好,银行编号获取错误!" + Request.QueryString["bankcode"]);
            //    return;
            //}

            string userIP = Tool.WebFormHandler.GetIP();

            var paramData = new Dapper.DynamicParameters();

            paramData.Add("@userid", userid);
            paramData.Add("@type", Sel);
            paramData.Add("@amount", Amount);
            paramData.Add("@orderNo", orderNo);
            paramData.Add("@backcode", "");
            paramData.Add("@clientIp", userIP);
            paramData.Add("@from", "5");
            paramData.Add("@outStatus", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
            TuanDai.WXApiWeb.PublicConn.ExecuteTD(PublicConn.DBWriteType.FundWrite, "AccountRechargeInit",
                                                  ref paramData, CommandType.StoredProcedure);
            outStatus = paramData.Get <int>("@outStatus");

            int result = outStatus;

            //NetLog.WriteLoginHandler("宝付5-调用写入充值记录存储过AccountRechargeInit", "UserId:"+userid+",Sel:"+Sel+",Amount:"+Amount+",OrderNo:"+orderNo+",bankcode:"+bankcode+",OutStatus:"+outStatus.Value.ToString());
            if (result > 0)
            {
                //NetLog.WriteLoginHandler("宝付6","进入写入来源" );
                AccountRechareInfo ar = null;
                lock (lockstatus)
                {
                    ar = getAccountRechare(orderNo);
                }
                //1:PC
                if (null == ar)
                {
                    Response.Write("您好,您的提交失败请重试!");
                }

                ar.From = 5;
                //ar.CradNo = db.UserBasicInfo.FirstOrDefault(x => x.Id == userid).BankAccountNo;

                if (UpdateAccountRechare(ar) <= 0)
                {
                    Response.Write("您好,您的提交失败请重试!");
                    return;
                }

                //NetLog.WriteLoginHandler("宝付7", "进入跳转");
                var url = "/PaymentPlatform/Baofu/pay_post.aspx?orderno=" + orderNo + "&totalprice=" + Amount + "&PayID=";
                //NetLog.WriteLoginHandler("宝付8--跳转的URL", url);
                try
                {
                    Response.Redirect(url, false);
                }
                catch (Exception ex)
                {
                    SysLogHelper.WriteErrorLog("宝付9跳转错误", "错误详细信息:" + ex.Message + "|" + ex.StackTrace);
                }
            }
            else
            {
                Response.Write("您好,您的提交失败请重试!");
            }
        }
Exemplo n.º 20
0
 public IEnumerable <TEntity> ObterPorProcedimento(string nomeProcedimento, Dapper.DynamicParameters parametros)
 {
     return(_repositorio.ObterPorProcedimento(nomeProcedimento, parametros));
 }
Exemplo n.º 21
0
        protected bool GetData()
        {
            UserBLL userbll = new UserBLL();

            //获取项目信息
            model = bll.GetProjectDetailInfo(projectId.Value);
            if (model == null)
            {
                Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx");
                return(false);
            }
            userApply = bll.WXGetFQUserApplyInfo(projectId.Value.ToText());
            if (userApply != null)
            {
                Organization = bll.WXGetOrganizationInfo(userApply.OrgId.HasValue ? userApply.OrgId.Value.ToText() : "");
            }
            else
            {
                userApply = new WXFQUserApplyInfo();
            }

            string strFile = string.Format(" oa.OrgTypeId ={0} and (f.UserId IS NULL OR f.UserId = '{1}') ", Organization.OrgTypeId, userApply.ApplyUserId);

            Dapper.DynamicParameters dyParams = new Dapper.DynamicParameters();
            string strSQL   = string.Format(@" SELECT DISTINCT AuthName = a.Name, oa.AuthId, a.UploadedStyle,oa.SortOrder
                                             FROM fq_OrgAuthSetting oa with(nolock)
                                             INNER JOIN fq_AuthSetting a with(nolock) ON oa.AuthId = a.Id 
                                             INNER JOIN (SELECT AuthId,UserId from  dbo.fq_UserAuthFile with(nolock) WHERE (IsDelete IS NULL OR IsDelete = 0) AND IsHiddenInfo =0) f ON a.Id = f.AuthId 
                                             Where {0} Order by oa.SortOrder asc", strFile);
            var    AuthList = PublicConn.QueryBySql <AuthSet>(strSQL, ref dyParams);

            for (int i = 0; i < AuthList.Count; i++)
            {
                if (i == 0)
                {
                    AuthHtml = AuthList[i].AuthName;
                }
                else
                {
                    AuthHtml += "、" + AuthList[i].AuthName;
                }
            }

            //是否学生分期
            dyParams = new Dapper.DynamicParameters();
            dyParams.Add("@ProjectId", model.Id);
            strSQL         = "select isnull(IdentityTypeId,0) as IdentityTypeId from fq_UserApply with(nolock) where ProjectId=@ProjectId";
            IdentityTypeId = PublicConn.QuerySingle <int>(strSQL, ref dyParams);

            if (IdentityTypeId == 1)
            {
                //获取学生基本信息
                dyParams = new Dapper.DynamicParameters();
                dyParams.Add("@UserId", model.UserId);
                strSQL         = "select * from fq_ApplyEducation with(nolock) where UserId=@UserId";
                applyEducation = PublicConn.QuerySingle <ApplyEducation>(strSQL, ref dyParams);
            }
            else
            {
                borrowUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value);
                strSQL         = "select * from userDetailInfo with(nolock) where UserId=@UserId";
                dyParams       = new Dapper.DynamicParameters();
                dyParams.Add("@UserId", borrowUserInfo.Id);
                userDetai = PublicConn.QuerySingle <userDetailInfoInfo>(strSQL, ref dyParams);
            }
            //信用档案
            creditInfo = CommUtils.GetBorrowerCreditData(model.UserId.Value);

            //项目展示图
            imageList     = CommUtils.GetProjectImages(this.projectId.Value);
            finishProcess = CommUtils.GetProjectProcess(model);

            SubscribeUserCount = CommUtils.GetSubscribeUserCount(this.projectId.Value);
            //计算预期收益
            PreInterestRate  = CommUtils.CalcInvestInterest(model, 10000);
            EbaoMultiple     = int.Parse(Math.Ceiling(model.InterestRate.Value / decimal.Parse("2.5")).ToString());
            EbaoInterest     = CommUtils.GetEbaoMultipleInterest(model, 10000);
            preSubscribeList = CommUtils.GetPreSubscribeDetail(model, 10000);
            return(true);
        }
Exemplo n.º 22
0
        public void Write(LoggingLevel level, string message, Exception exception, Type source)
        {
            var connectionKey = ConnectionKey;
            var insertCommand = InsertCommand;
            var parameters = new DynamicParameters(new Dictionary<string, object>()
            {
                { "@date", DateTime.Now },
                { "@utcdate", DateTime.UtcNow },
                { "@level", EnumMapper.GetName(level) },
                { "@message", message },
                { "@exception", exception != null ? exception.ToString() : null },
                { "@source", source != null ? source.FullName : null },
                { "@thread", Thread.CurrentThread.ManagedThreadId }
            });

            lock (sync)
                queue.Enqueue(parameters);

            signal.Set();
        }
        protected async Task HandleValidSubmit()
        {
            try
            {
                ErrorMessage = string.Empty;

                if (string.IsNullOrEmpty(employeeId))
                {
                    var entity = new Employee()
                    {
                        EmployeeId       = Guid.NewGuid().ToString(),
                        Active           = employee.Active,
                        HireDate         = employee.HireDate,
                        LastName         = employee.LastName,
                        FirstName        = employee.FirstName,
                        MiddleName       = employee.MiddleName,
                        Position         = employee.Position,
                        Address          = employee.Address,
                        ContactNo        = employee.ContactNo,
                        Email            = employee.Email,
                        SSS              = employee.SSS,
                        PhilHealth       = employee.PhilHealth,
                        PagIbig          = employee.PagIbig,
                        TIN              = employee.TIN,
                        BirthDate        = employee.BirthDate,
                        Gender           = employee.Gender,
                        EndDate          = employee.EndDate,
                        Remarks          = employee.Remarks,
                        attachmentRefKey = employee.attachmentRefKey,
                        CompanyId        = CompanyId,
                        createDate       = DateTime.Now,
                        createdBy        = UserName
                    };

                    foreach (var item in employee.attachments)
                    {
                        Dapper.DynamicParameters dynamicParameters = new Dapper.DynamicParameters();
                        if (!item.isDeleted)
                        {
                            dynamicParameters.Add("id", item.id);
                            dynamicParameters.Add("displayName", item.displayName);
                            dynamicParameters.Add("fileName", item.fileName);
                            dynamicParameters.Add("documentType", item.documentType);
                            dynamicParameters.Add("refKey", employee.attachmentRefKey);

                            await dapperManager.ExecuteAsync("spInsertAttachment", dynamicParameters);
                        }
                        else
                        {
                            dynamicParameters.Add("id", item.id);
                            await dapperManager.ExecuteAsync("spDeleteAttachment", dynamicParameters);
                        }
                    }

                    appDBContext.Employees.Add(entity);
                    await appDBContext.SaveChangesAsync();

                    NavigateToList();
                }
                else
                {
                    var entity = appDBContext.Employees.Where(a => a.EmployeeId.Equals(employeeId)).FirstOrDefault();

                    entity.Active     = employee.Active;
                    entity.HireDate   = employee.HireDate;
                    entity.LastName   = employee.LastName;
                    entity.FirstName  = employee.FirstName;
                    entity.MiddleName = employee.MiddleName;
                    entity.Position   = employee.Position;
                    entity.Address    = employee.Address;
                    entity.ContactNo  = employee.ContactNo;
                    entity.Email      = employee.Email;
                    entity.SSS        = employee.SSS;
                    entity.PhilHealth = employee.PhilHealth;
                    entity.PagIbig    = employee.PagIbig;
                    entity.TIN        = employee.TIN;
                    entity.BirthDate  = employee.BirthDate;
                    entity.Gender     = employee.Gender;
                    entity.EndDate    = employee.EndDate;
                    entity.Remarks    = employee.Remarks;

                    entity.updateDate       = DateTime.Now;
                    entity.updatedBy        = UserName;
                    entity.attachmentRefKey = employee.attachmentRefKey;

                    foreach (var item in employee.attachments)
                    {
                        Dapper.DynamicParameters dynamicParameters = new Dapper.DynamicParameters();
                        if (!item.isDeleted)
                        {
                            dynamicParameters.Add("id", item.id);
                            dynamicParameters.Add("displayName", item.displayName);
                            dynamicParameters.Add("fileName", item.fileName);
                            dynamicParameters.Add("documentType", item.documentType);
                            dynamicParameters.Add("refKey", employee.attachmentRefKey);

                            await dapperManager.ExecuteAsync("spInsertAttachment", dynamicParameters);
                        }
                        else
                        {
                            dynamicParameters.Add("id", item.id);
                            await dapperManager.ExecuteAsync("spDeleteAttachment", dynamicParameters);
                        }
                    }

                    appDBContext.Employees.Update(entity);
                    await appDBContext.SaveChangesAsync();

                    NavigateToList();
                }
            }
            catch (Exception ex)
            {
                ErrorMessage = ex.ToString();
            }
        }