private void GetContractInfo()
{
string strSQL = @"SELECT a.Id as ProductId,a.ProductName, a.PlanAmount,a.ProjectTypes,a.Deadline,b.RepeatInvestType,
b.YearRate, b.MinYearRate, a.StartDate,a.UnitAmount, b.Amount as JoinAmount, b.OrderQty,
b.UserId, b.OrderDate
FROM dbo.We_Product a WITH(NOLOCK)
left JOIN dbo.We_Order b WITH(NOLOCK) on b.ProductId=a.Id
WHERE b.Id=@WeOrderId";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@WeOrderId", Key);
List <MyWeOrderInfo> list = new List <MyWeOrderInfo>();
list = PublicConn.QueryBySql <MyWeOrderInfo>(strSQL, ref dyParams);
WeOrder = list.Count > 0 ? list[0] : new MyWeOrderInfo();
if (WeOrder.OrderDate >= DateTime.Parse("2016-03-11"))
{
companyName = "东莞团贷网互联网科技服务有限公司";
Sealt_TuanDai = "images/tuandai_ss.png";
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(WeOrder.UserId);//投资人信息
switch (GetTypeWord(WeOrder.ProductId).ToLower())
{
case "b":
case "c":
RepaymentTypeDesc = "每月付息";
break;
case "a":
RepaymentTypeDesc = "每月付息或到期本息";
break;
}
}
private void GetContractInfo(string key)
{
string contactno = this.key;
string strSQL = @"SELECT a.ProductName, a.PlanAmount,a.ProjectTypes,a.Deadline,b.RepeatInvestType,
b.YearRate, b.MinYearRate, a.StartDate,a.UnitAmount, b.Amount as JoinAmount, b.OrderQty,
b.UserId, b.OrderDate, c.TypeWord, a.ProductTypeId,a.ExitLockMonth
FROM dbo.We_Product a WITH(NOLOCK)
left JOIN dbo.We_Order b WITH(NOLOCK) on b.ProductId=a.Id
inner join We_ProductType c WITH(NOLOCK) on c.Id=a.ProductTypeId
WHERE b.Id=@WeOrderId";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@WeOrderId", contactno);
model = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault <MyWeOrderInfo>(TdConfig.ApplicationName, TdConfig.DBRead, strSQL, ref dyParams);
if (model == null)
{
model = new MyWeOrderInfo();
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(model.UserId);
WeFTBBLL ftbll = new WeFTBBLL();
ftbRateList = this.GetWeFTBRateList(model.ProductTypeId, model.StartDate ?? DateTime.Today);
if (ftbRateList == null)
{
ftbRateList = new List <WeProductFTBRateInfo>();
}
}
private void GetContractInfo(string key)
{
string contactno = this.key;
string strSQL = @"SELECT a.ProductName, a.PlanAmount,a.ProjectTypes,a.Deadline,b.RepeatInvestType,
b.YearRate, b.MinYearRate, a.StartDate,a.UnitAmount, b.Amount as JoinAmount, b.OrderQty,
b.UserId, b.OrderDate,c.TypeWord
FROM dbo.We_Product a WITH(NOLOCK)
left JOIN dbo.We_Order b WITH(NOLOCK) on b.ProductId=a.Id
INNER JOIN dbo.We_ProductType c WITH(NOLOCK) ON a.ProductTypeId = c.Id
WHERE b.Id=@WeOrderId";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@WeOrderId", contactno);
model = PublicConn.QuerySingle <MyWeOrderInfo>(strSQL, ref dyParams);
if (model == null)
{
model = new MyWeOrderInfo();
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(model.UserId);
if (model.OrderDate >= DateTime.Parse("2016-03-11"))
{
strCompanyName = "东莞团贷网互联网科技服务有限公司";
Sealt_TuanDai = "images/tuandai_ss.png";
}
//this.subBasicModel.RealName = StringHandler.MaskStartPre(subBasicModel.RealName, 1);//出借人
//this.subBasicModel.IdentityCard = StringHandler.MaskCardNo(subBasicModel.IdentityCard);//出借人身份证号
this.GetRedemptionRate();
}
private void GetContractInfo(string key)
{
string contactno = this.key;
string strSQL = @"SELECT a.ProductName, a.PlanAmount,a.ProjectTypes,a.Deadline,b.RepeatInvestType,
b.YearRate, b.MinYearRate, a.StartDate,a.UnitAmount, b.Amount as JoinAmount, b.OrderQty,
b.UserId, b.OrderDate, c.TypeWord, a.ProductTypeId,a.ExitLockMonth, isnull(b.DeadType,1) as DeadType
FROM dbo.We_Product a WITH(NOLOCK)
left JOIN dbo.We_Order b WITH(NOLOCK) on b.ProductId=a.Id
inner join We_ProductType c WITH(NOLOCK) on c.Id=a.ProductTypeId
WHERE b.Id=@WeOrderId ";
var dyParams = new Dapper.DynamicParameters();
dyParams.Add("@WeOrderId", contactno);
model = PublicConn.QuerySingle <MyWeOrderInfo>(strSQL, ref dyParams);
if (model == null)
{
model = new MyWeOrderInfo();
}
this.subBasicModel = userbll.GetUserBasicInfoModelById(model.UserId);
}
