public static Ui.DataGrid GetViewContractFeeHistoryGridByContractID(List <int> ContractIDList, bool IncludIsCharged, string orderBy, long startRowIndex, int pageSize) { long totalRows = 0; List <SqlParameter> parameters = new List <SqlParameter>(); List <string> conditions = new List <string>(); conditions.Add("1=1"); if (ContractIDList.Count > 0) { conditions.Add("[ContractID] in (" + string.Join(",", ContractIDList.ToArray()) + ")"); } if (IncludIsCharged) { conditions.Add("[ChargeState] in (1,4)"); } string fieldList = "[ViewContractFeeHistory].* "; string Statement = " from [ViewContractFeeHistory] where " + string.Join(" and ", conditions.ToArray()); ViewContractFeeHistory[] list = new ViewContractFeeHistory[] { }; list = GetList <ViewContractFeeHistory>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray(); DataAccess.Ui.DataGrid dg = new Ui.DataGrid(); dg.rows = list; dg.total = totalRows; dg.page = pageSize; return(dg); }
public static ViewContractFeeHistory[] GetViewContractFeeHistoryListByIDs(int RoomID, List <int> IDs, int PrintID) { List <SqlParameter> parameters = new List <SqlParameter>(); List <string> conditions = new List <string>(); if (RoomID > 0) { conditions.Add("[RoomID]=@RoomID"); parameters.Add(new SqlParameter("@RoomID", RoomID)); } if (IDs.Count > 0) { conditions.Add("[HistoryID] in (" + string.Join(",", IDs.ToArray()) + ")"); } if (PrintID > 0) { conditions.Add("[PrintID]=@PrintID"); parameters.Add(new SqlParameter("@PrintID", PrintID)); } ViewContractFeeHistory[] list = new ViewContractFeeHistory[] { }; list = GetList <ViewContractFeeHistory>("select * from [ViewContractFeeHistory] where " + string.Join(" and ", conditions.ToArray()) + " order by [ChargeTime] desc", parameters).ToArray(); return(list); }