/// <summary> /// datagrid分页 传入 5个人参数 /// </summary> /// <param name="index"></param> /// <param name="count"></param> /// <param name="orderid"></param> /// <param name="begin"></param> /// <param name="end"></param> /// <param name="dataid"></param> /// <returns></returns> public static List <t_BuyOrder> getIDdataa(int index, int count, string orderid, string begin, string end, int dataid) { string sql = ""; sql = string.Format(@"select top {0} BuyOrderID,b.State,BuyOrderDate,HouseName,TotalPrice, SubareaName,UserName,t.StateName from t_BuyOrder b ,t_StoreHouse st ,t_Ste t ,t_StoreHouseDetail sh where b.StoreHouseID=st.HouseID and t.StateID=b.State and b.HouseDetailID=sh.ID and BuyOrderID not in(select top {1} BuyOrderID from t_BuyOrder) and (BuyOrderDate between '{2}' and '{3}' and BuyOrderID= '{4}' and b.State={5} )", count, (index - 1) * count, begin, end, orderid, dataid); DataTable dt = DBHelper.GetDatatable(sql); List <t_BuyOrder> list = new List <t_BuyOrder>(); foreach (DataRow item in dt.Rows) { t_BuyOrder e = new t_BuyOrder(); e.BuyOrderID = item["BuyOrderID"].ToString(); e.BuyOrderDate = item["BuyOrderDate"].ToString(); e.HouseName = item["HouseName"].ToString(); e.SubareaName = item["SubareaName"].ToString(); e.TotalPrice = Convert.ToDouble(item["TotalPrice"]); e.StateName = item["StateName"].ToString(); e.UserName = item["UserName"].ToString(); list.Add(e); } return(list); }
public static List <t_BuyOrder> GetEmp(int index, int count) { string sql = string.Format(@"select top {0} BuyOrderID,BuyOrderDate,HouseName,TotalPrice, SubareaName,UserName,t.StateName from t_BuyOrder b ,t_StoreHouse st ,t_Ste t ,t_StoreHouseDetail sh where b.StoreHouseID=st.HouseID and t.StateID=b.State and b.HouseDetailID=sh.ID and BuyOrderID not in(select top {1} BuyOrderID from t_BuyOrder) ", count, (index - 1) * count); DataTable dt = DBHelper.GetDatatable(sql); List <t_BuyOrder> list = new List <t_BuyOrder>(); foreach (DataRow item in dt.Rows) { t_BuyOrder e = new t_BuyOrder(); e.BuyOrderID = item["BuyOrderID"].ToString(); e.BuyOrderDate = item["BuyOrderDate"].ToString(); e.HouseName = item["HouseName"].ToString(); e.SubareaName = item["SubareaName"].ToString(); e.TotalPrice = Convert.ToDouble(item["TotalPrice"]); e.StateName = item["StateName"].ToString(); e.UserName = item["UserName"].ToString(); list.Add(e); } return(list); }