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;
}
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 [email protected] AND [email protected] and s.ContractNo not like '%[_]%'
)M WHERE M.rownumber> @pagesize*(@pageindex-1) and M.rownumber<[email protected]*@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();
}
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);
}
}
}
}
}
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);
}
}
}
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;
}
}
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 [email protected] and [email protected]";
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 [email protected]) M
INNER JOIN dbo.Subscribe c ON c.TranId=M.M_id
WHERE [email protected]";
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<[email protected]";
sql = string.Format(sql, sWhere);
param.Add("p1", (PageIndex - 1) * PageSize);
param.Add("p2", PageIndex * PageSize);
return(await _context.QueryAsync <ESysUserInfo>(sql, param));
}
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));
}
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 [email protected]";
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 [email protected] 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";
}
}
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 [email protected] ";
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 [email protected]";
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 [email protected]";
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 [email protected]";
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();
}
}
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);
}
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<[email protected]";
sql = string.Format(sql, sWhere);
param.Add("p1", (PageIndex - 1) * PageSize);
param.Add("p2", PageIndex * PageSize);
return(await _context.QueryAsync <ESysRole>(sql, param));
}
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);
}
}
}
/// <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 [email protected]";
//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 [email protected]
)M WHERE M.rownumber> @pagesize*(@pageindex-1) and M.rownumber<[email protected]*@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 [email protected]";
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();
}
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 [email protected] and [email protected]";
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);
}
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<[email protected]";
sql = string.Format(sql, sWhere);
param.Add("p1", (PageIndex - 1) * PageSize);
param.Add("p2", PageIndex * PageSize);
return(await _context.QueryAsync <ESysMenu>(sql, param));
}
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<[email protected]";
sql = string.Format(sql, sWhere);
param.Add("p1", (PageIndex - 1) * PageSize);
param.Add("p2", PageIndex * PageSize);
return(await _context.QueryAsync <EMessageBox>(sql, param));
}
public static Dapper.DynamicParameters GetWIGAWaitItemDeleteParameters(long wigaUid)
{
Dapper.DynamicParameters queryParameters = new Dapper.DynamicParameters();
queryParameters.Add("@01iWIGAUID_input", wigaUid);
return(queryParameters);
}
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("您好，您的提交失败请重试！");
}
}
public IEnumerable <TEntity> ObterPorProcedimento(string nomeProcedimento, Dapper.DynamicParameters parametros)
{
return(_repositorio.ObterPorProcedimento(nomeProcedimento, parametros));
}
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 [email protected]";
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 [email protected]";
applyEducation = PublicConn.QuerySingle <ApplyEducation>(strSQL, ref dyParams);
}
else
{
borrowUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value);
strSQL = "select * from userDetailInfo with(nolock) where [email protected]";
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);
}
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();
}
}
