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