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