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