public string FM060102(string sortStr, int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
var dataList = Sort(dbbc1, sortStr).Take(pageSize).ToList();
return(C101.FC10107(dataList));
}
}
public string FM0601INIT(int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
var dataList = dbbc1.M0601s.ToList();
return(C101.FC10107(dataList));
}
}
public string FM020502()
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
var dataList = dbbc1.B500s.ToList();
return(C101.FC10107(dataList));
}
}
public string FM020210(int pageFrom, int pageSize, string sortStr)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
var dataList = Sort(dbbc1, sortStr).Skip(pageFrom).Take(pageSize).ToList();
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1}}}", C101.FC10107(dataList), serverStatusListStr));
}
}
public string FINIT(int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
//数据
var dataList = dbbc1.B100s.Take(pageSize).ToList();
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1}}}", C101.FC10107(dataList), serverStatusListStr));
}
}
//排序
private IEnumerable <B100> Sort(DBBC1DataContext dbbc1, string sortStr)
{
List <string> sortList = new List <string>();
sortList.Add("cancelPublishCrAmount");
sortList.Add("publishedCrAmount");
sortList.Add("cancelReserveAmount");
sortList.Add("refuseReserveAmount");
sortList.Add("reservingCrAmount");
sortList.Add("repayingCrAmount");
sortList.Add("repayedCrAmount");
string sqlWhereStr = "";
string sqlOrderByStr = "";
string[] sortStrSplit = sortStr.Split(',');
for (int i = 1; i < (sortStrSplit.Length - 1); i++)
{
string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
if (sortStrSplitSplit[0] == "1")
{
sqlWhereStr = string.Format("where userSN like '%{0}%'", sortStrSplitSplit[1]);
continue;
}
if (sqlOrderByStr == "")
{
sqlOrderByStr += "order by";
}
else
{
sqlOrderByStr += ",";
}
int orderByFieldNum = Convert.ToInt32(sortStrSplitSplit[0]) - 2;
string orderByFieldName = sortList[orderByFieldNum];
string order = sortStrSplitSplit[1] == "A" ? "" : " desc";
sqlOrderByStr += string.Format(" {0} {1}", orderByFieldName, order);
}
string sqlStr = string.Format("select * from B100 {0} {1}", sqlWhereStr, sqlOrderByStr);
IEnumerable <B100> crDataList = dbbc1.ExecuteQuery <B100>(sqlStr);
return(crDataList);
}
//排序
private IEnumerable <M0601> Sort(DBBC1DataContext dbbc1, string sortStr)
{
List <string> sortList = new List <string>();
sortList.Add("consumptionAmount");
sortList.Add("balanceAmount");
sortList.Add("needPayBillAmount");
sortList.Add("needPayAmount");
sortList.Add("overDueAmount");
string sqlWhereStr = "";
string sqlOrderByStr = "";
string[] sortStrSplit = sortStr.Split(',');
for (int i = 1; i < (sortStrSplit.Length - 1); i++)
{
string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
if (sortStrSplitSplit[0] == "1")
{
sqlWhereStr = string.Format("where userSN like '%{0}%'", sortStrSplitSplit[1]);
continue;
}
if (sqlOrderByStr == "")
{
sqlOrderByStr += "order by";
}
else
{
sqlOrderByStr += ",";
}
int orderByFieldNum = Convert.ToInt32(sortStrSplitSplit[0]) - 2;
string orderByFieldName = sortList[orderByFieldNum];
string order = sortStrSplitSplit[1] == "A" ? "" : " desc";
sqlOrderByStr += string.Format(" {0} {1}", orderByFieldName, order);
}
string sqlStr = string.Format("select * from M0601 {0} {1}", sqlWhereStr, sqlOrderByStr);
IEnumerable <M0601> crDataList = dbbc1.ExecuteQuery <M0601>(sqlStr);
return(crDataList);
}
public string FM020410(string sortStr, int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
List <B400> dataList = Sort(dbbc1, sortStr).Take(pageSize).ToList();
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
//申请状态
string applyStatusListStr = GetApplyStatusList(dbbs1, dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"applyStatusList\":{2}}}", C101.FC10107(dataList), serverStatusListStr, applyStatusListStr));
}
}
}
public string FM0203INIT(int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
//数据
var dataList = dbbc1.B300s.Take(pageSize).ToList();
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//uip
string pawnStr = C102.FC20108(dbbs1);
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"pawn\":{2}}}", C101.FC10107(dataList), serverStatusListStr, pawnStr));
}
}
}
public string FM020505(string sortStr)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
List <string> sortList = new List <string>();
sortList.Add("reg_date");
sortList.Add("clientTotalAmount");
sortList.Add("financierAmount");
sortList.Add("investorAmount");
sortList.Add("consultantAmount");
sortList.Add("sellerAmount");
sortList.Add("purchaserAmount");
string sqlOrderByStr = "";
string[] sortStrSplit = sortStr.Split(',');
for (int i = 1; i < (sortStrSplit.Length - 1); i++)
{
string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
if (sqlOrderByStr == "")
{
sqlOrderByStr += "order by";
}
else
{
sqlOrderByStr += ",";
}
int orderByFieldNum = Convert.ToInt32(sortStrSplitSplit[0]) - 2;
string orderByFieldName = sortList[orderByFieldNum];
string order = sortStrSplitSplit[1] == "A" ? "" : " desc";
sqlOrderByStr += string.Format(" {0} {1}", orderByFieldName, order);
}
string sqlStr = string.Format("select * from B500 {0}", sqlOrderByStr);
var dataList = dbbc1.ExecuteQuery <B500>(sqlStr).ToList();
return(C101.FC10107(dataList));
}
}
