//排序
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 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));
}
}