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)); } }