/// <summary>
/// 网站公告
/// </summary>
/// <returns></returns>
public ActionResult NoticeList(int p = 1, int pageSize = 10)
{
StringBuilder str = new StringBuilder();
string TableName = "V_type_news";
string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm ";
string fldName = " newid desc";
string Sort = "desc";
string strWhere = "web_Type_menu_id=17";
DataTable dt = new DataTable();
B_PublicPageList o = new B_PublicPageList();
var RecordCount = 0;
dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount);
ResponsePage rp = new ResponsePage();
rp.dataBody = dt;
rp.pageSize = pageSize;
rp.recordCount = RecordCount;
rp.pageCount = (RecordCount + pageSize - 1) / pageSize;
rp.currentCount = p;
return(View(rp));
}
/// <summary>
/// 网站公告
/// </summary>
/// <returns></returns>
public ActionResult HelpList(string path1 = "Login_register", int p = 1, int pageSize = 10)
{
StringBuilder str = new StringBuilder();
string TableName = "V_type_news";
string strFields = "newid,web_Type_menu_id,News_title,News_Key,news_Des,context,createtime,menu_name,path1,topmenuname,listcomm ";
string fldName = " newid desc";
string Sort = "desc";
string strWhere = " path1='" + path1 + "'";
DataTable dt = new DataTable();
B_PublicPageList o = new B_PublicPageList();
var RecordCount = 0;
dt = o.GetListByPage(TableName, strFields, fldName, pageSize, p, strWhere, out RecordCount);
string srtitle = "注册与登录";
if (dt.Rows.Count > 0)
{
srtitle = dt.Rows[0]["menu_name"].ToString();
}
ResponsePage rp = new ResponsePage();
rp.dataBody = dt;
rp.pageSize = pageSize;
rp.recordCount = RecordCount;
rp.pageCount = (RecordCount + pageSize - 1) / pageSize;
rp.currentCount = p;
ViewBag.srtitle = srtitle;
ViewBag.path1 = path1;
return(View(rp));
}
public ActionResult GetInvestList(int arp = 0, int repayment = 0, int account = 0, int schedule = 0, int status = 0, int project = 0, int sort = 0, int Page = 1, int pageSize = 12)
{
string TableName = "V_borrowing_target_addlist";
string strFields = "targetid,loan_number,borrowing_title,borrowing_thumbnail,annual_interest_rate,borrowing_balance,life_of_loan,unit_day,release_date,month_payment_date,repayment_date,end_time,minimum,company_name,guarantee_way_name,fundraising_amount,tender_state,start_time,sys_time,IsUse,companyid,indexorder,payment_options ";
string fldName = "tender_state asc,indexorder desc,targetid desc";
switch (sort)
{
case 1: //期 限
fldName = "unit_day asc,life_of_loan desc,indexorder desc,tender_state asc,targetid desc";
break;
case 2: //发标时间
fldName = "start_time desc,indexorder desc,tender_state asc,targetid desc";
break;
case 3: //预期年化收益
fldName = "annual_interest_rate desc,indexorder desc,tender_state asc,targetid desc";
break;
default:
break;
}
string strWhere = " targetid >0 and tender_state>=2 and annual_interest_rate<=15 AND project_type_id!=6 ";//显示利率小于15 类型不是新手标的项目
DataTable dt = new DataTable();
if (arp > 0)
{
string[] sta = getarray(arp);
if (sta.Length > 0)
{
if (sta[1].ToString() == "0")
{
strWhere += " and tender_state =" + sta[0].ToString() + " ";
}
else
{
strWhere += " and annual_interest_rate between " + sta[0].ToString() + " and " + sta[1].ToString() + " ";
}
}
}
else
{
strWhere += " and tender_state between 2 and 5 ";
}
if (repayment > 0)
{
string[] sta = getarray(repayment);
if (sta.Length > 0)
{
//strWhere += " and DATEDIFF(MONTH,release_date,repayment_date) between " + sta[0].ToString() + " and " + sta[1].ToString() + " ";
if (repayment == 5)//3个月以下
{
strWhere += " AND (life_of_loan BETWEEN " + sta[0].ToString() + " AND " + sta[1].ToString() + " AND unit_day=1 OR life_of_loan <90 AND unit_day=3) ";
}
else
{
strWhere += " AND life_of_loan BETWEEN " + sta[0].ToString() + " AND " + sta[1].ToString() + " AND unit_day=1 ";
}
}
}
if (account > 0)
{
string[] sta = getarray(account);
if (sta.Length > 0)
{
strWhere += " and borrowing_balance between " + int.Parse(sta[0].ToString()) * 10000 + " and " + int.Parse(sta[1].ToString()) * 10000 + " ";
}
}
if (schedule > 0)
{
string[] sta = getarray(schedule);
if (sta.Length > 0)
{
strWhere += " and fundraising_amount/borrowing_balance*100 between " + sta[0].ToString() + " and " + sta[1].ToString() + " ";
}
}
if (status > 0)
{
string[] sta = getarray(status);
if (sta.Length > 0)
{
strWhere += " and tender_state =" + sta[0].ToString() + " ";
}
}
if (project > 0)
{
strWhere += " and project_type_id =" + project.ToString() + " ";
}
int RecordCount = 0;
B_PublicPageList o = new B_PublicPageList();
dt = o.GetListByPage(TableName, strFields, fldName, pageSize, Page, strWhere, out RecordCount);
//计算总页数
var pagecount = RecordCount / pageSize;
if ((RecordCount % pageSize) > 0)
{
pagecount++;
}
StringBuilder json = new StringBuilder();
json.Append("{");
json.AppendFormat("\"ret\":1,\"pagecount\":{0},\"data\":[", pagecount);
int _index = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (_index > 0)
{
json.Append(",");
}
_index++;
json.Append("{");
json.AppendFormat("\"targetid\":{0}", dr["targetid"].ToString());
json.AppendFormat(",\"borrowing_title\":\"{0}\"", dr["borrowing_title"].ToString());
json.AppendFormat(",\"companyid\":\"{0}\"", dr["companyid"].ToString());
json.AppendFormat(",\"company_name\":\"{0}\"", dr["company_name"].ToString());
json.AppendFormat(",\"borrowing_thumbnail\":\"{0}\"", dr["borrowing_thumbnail"].ToString());
json.AppendFormat(",\"annual_interest_rate\":\"{0}\" ", decimal.Parse(dr["annual_interest_rate"].ToString()).ToString("0.0"));
json.AppendFormat(",\"tender_state\":{0}", dr["tender_state"].ToString());
json.AppendFormat(",\"IsUse\":{0}", Convert.ToInt32(dr["IsUse"].ToString()));
//借款期限
DateTime rpdt = DateTime.Parse(dr["repayment_date"].ToString());
DateTime rest = DateTime.Parse(dr["release_date"].ToString());
long diffdays = Utils.DateDiff("Day", DateTime.Parse(rest.ToString("yyyy-MM-dd")), DateTime.Parse(rpdt.ToString("yyyy-MM-dd")));
int unit_day = dr["unit_day"].ToInt();
json.AppendFormat(",\"jkqx\":\"{0}\"", dr["life_of_loan"].ToString());
if (unit_day == 3)
{
json.AppendFormat(",\"jkday\":\"天\"");
}
else if (unit_day == 1)
{
json.AppendFormat(",\"jkday\":\"个月\"");
}
//else if (diffdays < 60)
//{
// int daysr = int.Parse(diffdays.ToString());
// if (daysr == 30 || daysr == 31)
// {
// json.AppendFormat(",\"jkday\":\"天\"", Utils.GetLife_of_loans(dr["life_of_loan"].ToString(), dr["unit_day"].ToString()));
// }
// else
// {
// json.AppendFormat(",\"jkqx\":\"{0}天\"", daysr);
// }
//}
//else
//{
// json.AppendFormat(",\"jkqx\":\"{0}\"", Utils.GetLife_of_loans(dr["life_of_loan"].ToString(), dr["unit_day"].ToString()));
//}
string str1 = "";
string str2 = "";
if (int.Parse(dr["tender_state"].ToString()) > 2)
{
str1 = Utils.Getpayment_options(int.Parse(dr["payment_options"].ToString()));
}
else
{
str2 = DateTime.Parse(dr["repayment_date"].ToString()).ToString("yyyy-MM-dd");
}
json.AppendFormat(",\"payment_options\":\"{0}\"", str1); //还款方式
json.AppendFormat(",\"repayment_date\":\"{0}\"", str2); //还款日期
json.AppendFormat(",\"borrowing_balance\":\"{0}\"", RMB.GetWebConvertdisp(decimal.Parse(dr["borrowing_balance"].ToString()), 2, true));
decimal borrowing_balance = decimal.Parse(dr["borrowing_balance"].ToString());
decimal fundraising_amount = decimal.Parse(dr["fundraising_amount"].ToString());
decimal Percentage = fundraising_amount / borrowing_balance * 100;
if (Percentage > 100.00M)
{
Percentage = 100.00M;
}
decimal Difference = borrowing_balance - fundraising_amount;
if (Difference < 0.00M)
{
Percentage = 0.00M;
}
//还需金额
var needMoney = "0";
if (dr["tender_state"].ToString() == "2")
{
needMoney = RMB.GetWebConvertdisp(Difference, 2, true);
}
json.AppendFormat(",\"needMoney\":\"{0}\"", needMoney);
json.AppendFormat(",\"Percentage\":\"{0}\"", Percentage.ToString("0.00")); //融资进度
json.AppendFormat(",\"minimum\":\"{0}\"", decimal.Parse(dr["minimum"].ToString()).ToString("0"));
DateTime Endtime = DateTime.Parse(dr["end_time"].ToString());
DateTime Stime = DateTime.Parse(dr["start_time"].ToString());
DateTime online = DateTime.Parse(dr["sys_time"].ToString());
json.AppendFormat(",\"systime\":\"{0}\"", online.ToString("yyyy-MM-dd HH:mm:ss"));
int operState = 0;
if (dr["tender_state"].ToString() == "2")
{
if (Stime <= online && online > DateTime.Now)
{
//str.Append("<a href=\"javascript:void(0);\" class=\"grey_btn\">未开始</a>");
operState = 11;
}
else
{
if (DateTime.Compare(Endtime, DateTime.Now) <= 0 && Percentage < 100.00M)
{
//str.Append("<a href=\"javascript:void(0);\" class=\"grey_btn\">项目已结束</a>");
operState = 12;
}
else if (Percentage >= 100.00M)
{
//str.Append("<a href=\"javascript:void(0);\" class=\"grey_btn\">满标</a>");
operState = 13;
}
else
{
//str.Append("<a href=\"invest_borrow_" + dt.Rows[i]["targetid"].ToString() + ".html\" title=\"" + dt.Rows[i]["borrowing_title"].ToString() + "\">立即投资</a>");
operState = 14;
}
}
}
else if (dr["tender_state"].ToString() == "3")
{
//str.Append("<a href=\"invest_borrow_" + dt.Rows[i]["targetid"].ToString() + ".html\" title=\"" + dt.Rows[i]["borrowing_title"].ToString() + "\" class=\"grey_btn\">满标</a>");
operState = 3;
}
else if (dr["tender_state"].ToString() == "4")
{
//str.Append("<a href=\"invest_borrow_" + dt.Rows[i]["targetid"].ToString() + ".html\" title=\"" + dt.Rows[i]["borrowing_title"].ToString() + "\" class=\"grey_btn\">还款中</a>");
operState = 4;
}
else if (dr["tender_state"].ToString() == "5")
{
//str.Append("<a href=\"invest_borrow_" + dt.Rows[i]["targetid"].ToString() + ".html\" title=\"" + dt.Rows[i]["borrowing_title"].ToString() + "\" class=\"grey_btn\">已还清</a>");
operState = 5;
}
json.AppendFormat(",\"operState\":\"{0}\"", operState);
var actFanXian = ef.hx_ActivityTable.Where(c => c.ActName == "12月投资立得返现奖励").OrderByDescending(c => c.ActEndtime).FirstOrDefault();
bool isShow = actFanXian == null ? false : TActivity_Luck.GetCurJiaoBiao(Convert.ToDateTime(actFanXian.ActStarttime), Convert.ToDateTime(actFanXian.ActEndtime), online, Convert.ToInt32(dr["tender_state"]), Convert.ToDateTime(dr["end_time"]));
json.AppendFormat(",\"isShowJiaoBiao\":\"{0}\"", isShow);
json.Append("}");
}
}
json.Append("]}");
return(Content(json.ToString(), "text/json"));
}