public void init()
{
string str0 = Request.QueryString["BuyOrderID"].ToString();
VBuyOrder vb = new VBuyOrder();
vb = Leyp.SQLServerDAL.Buy.Factory.getBuyOrderDAL().getByID(str0);
if (vb == null)
{
Response.Write("没有你要的数据");
Response.End();
}
BuyOrderID.Text = vb.BuyOrderID;
BuyOrderDate.Text = vb.BuyOrderDate;
RealName.Text = vb.RealName;
HouseName.Text = vb.HouseName + "----" + vb.SubareaName;
Delegate.Text = vb.Delegate;
SignDate.Text = vb.SignDate;
TradeDate.Text = vb.TradeDate;
TradeAddress.Text = vb.TradeAddress;
Description.Text = vb.Description;
Label1.Text = changString(vb.State.ToString());
HyperLink1.NavigateUrl = "BuyOrder_Detail_Photo.aspx?BuyOrderID=" + vb.BuyOrderID + "";
}
public List <VBuyOrder> getAdminBuyOrderByBuyOrderID(string BuyOrderID)
{
string s = "";
List <VBuyOrder> list = new List <VBuyOrder>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BuyOrderID", SqlDbType.NVarChar) };
parameters[0].Value = BuyOrderID;
SqlDataReader reader = SQLHelper.RunProcedure("p_BuyOrder_getAdminBuyOrderByBuyOrderID", parameters);
while (reader.Read())
{
VBuyOrder item = new VBuyOrder();
item.BuyOrderDate = reader.GetString(reader.GetOrdinal("BuyOrderDate"));
item.BuyOrderID = reader.GetString(reader.GetOrdinal("BuyOrderID"));
item.Delegate = reader.GetString(reader.GetOrdinal("Delegate"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID"));
item.RealName = reader.GetString(reader.GetOrdinal("RealName"));
item.SignDate = reader.GetString(reader.GetOrdinal("SignDate"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
item.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID"));
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
item.TotalPrice = float.Parse(s);
item.TradeAddress = reader.GetString(reader.GetOrdinal("TradeAddress"));
item.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.HouseName = reader.GetString(reader.GetOrdinal("HouseName"));
item.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName"));
list.Add(item);
}
reader.Close();
return(list);
}
public VBuyOrder getByID(string BuyOrderID)
{
string s = "";
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BuyOrderID", SqlDbType.NVarChar) };
parameters[0].Value = BuyOrderID;
VBuyOrder order = new VBuyOrder();
SqlDataReader reader = SQLHelper.RunProcedure("p_BuyOrder_getByID", parameters);
if (reader.Read())
{
order.BuyOrderDate = reader.GetString(reader.GetOrdinal("BuyOrderDate"));
order.BuyOrderID = reader.GetString(reader.GetOrdinal("BuyOrderID"));
order.Delegate = reader.GetString(reader.GetOrdinal("Delegate"));
order.Description = reader.GetString(reader.GetOrdinal("Description"));
order.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID"));
order.Identitys = reader.GetInt32(reader.GetOrdinal("Identitys"));
order.SignDate = reader.GetString(reader.GetOrdinal("SignDate"));
order.State = reader.GetInt32(reader.GetOrdinal("State"));
order.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID"));
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
order.TotalPrice = float.Parse(s);
order.TradeAddress = reader.GetString(reader.GetOrdinal("TradeAddress"));
order.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
order.UserName = reader.GetString(reader.GetOrdinal("UserName"));
order.HouseName = reader.GetString(reader.GetOrdinal("HouseName"));
order.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName"));
order.RealName = reader.GetString(reader.GetOrdinal("RealName"));
}
reader.Close();
return(order);
}
public List <VBuyOrder> getUserOrderList(string UserName, string beginDate, string endDate, int sideState, int Identitys)
{
string s = "";
List <VBuyOrder> list = new List <VBuyOrder>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@beginDate", SqlDbType.NVarChar), new SqlParameter("@endDate", SqlDbType.NVarChar), new SqlParameter("@sideState", SqlDbType.Int), new SqlParameter("@Identitys", SqlDbType.Int) };
parameters[0].Value = UserName;
parameters[1].Value = beginDate;
parameters[2].Value = endDate;
parameters[3].Value = sideState;
parameters[4].Value = Identitys;
SqlDataReader reader = SQLHelper.RunProcedure("p_BuyOrder_getUserBuyOrderList", parameters);
while (reader.Read())
{
VBuyOrder item = new VBuyOrder();
item.BuyOrderDate = reader.GetString(reader.GetOrdinal("BuyOrderDate"));
item.BuyOrderID = reader.GetString(reader.GetOrdinal("BuyOrderID"));
item.Delegate = reader.GetString(reader.GetOrdinal("Delegate"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID"));
item.Identitys = reader.GetInt32(reader.GetOrdinal("Identitys"));
item.SignDate = reader.GetString(reader.GetOrdinal("SignDate"));
item.State = reader.GetInt32(reader.GetOrdinal("State"));
item.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID"));
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
item.TotalPrice = float.Parse(s);
item.TradeAddress = reader.GetString(reader.GetOrdinal("TradeAddress"));
item.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.HouseName = reader.GetString(reader.GetOrdinal("HouseName"));
item.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName"));
list.Add(item);
}
reader.Close();
return(list);
}
