protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "order")
{
string s = e.CommandArgument.ToString();
ds = room.GetList("Are='" + s + "' and IfRecommend=1 and IfExamine=1");
DataList1.DataSource = ds;
DataList1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Calendar1.SelectedDate = DateTime.Now;
this.Calendar2.SelectedDate = DateTime.Now;
roomid = Int32.Parse(Request.QueryString["id"].Trim());
StringBuilder sb = new StringBuilder();
sb.Append("Id=");
sb.Append(roomid);
ds = room.GetList(sb.ToString());
DataList1.DataSource = ds;
DataList1.DataBind();
if (Session["username"] != null)
{
string uname = Session["username"].ToString();
txbOrderPersonInfo.Text = uname;
DataSet dsUser = user.GetList(uname);
if (dsUser.Tables[0].Rows[0]["Phone"].ToString() != "")
{
txbPhone.Text = dsUser.Tables[0].Rows[0]["Phone"].ToString();
}
userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]);
}
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtName.Text;
string Type = this.txtType.Text;
QPS.NEW.BLL.Room rm = new QPS.NEW.BLL.Room();
ds = rm.GetList(" Name='" + name + "' or RoomType='" + Type + "'");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtName.Text;
string Type = this.txtType.Text;
QPS.NEW.BLL.Room rm = new QPS.NEW.BLL.Room();
ds = rm.GetList(" Name='" + name + "' or RoomType='" + Type + "'");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
//查询(价格 地域)
protected void Button3_Click(object sender, EventArgs e)
{
string Price = this.TextPrice.Text;
string Are = this.TextAre.Text;
QPS.NEW.BLL.Room rm = new QPS.NEW.BLL.Room();
ds = rm.GetList(" RoomPrice='" + Price + "' or Are='" + Are + "'");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
public DataTable databind()
{
DataTable dt = new DataTable();
QPS.NEW.BLL.Enterprise user = new QPS.NEW.BLL.Enterprise();
QPS.NEW.BLL.Users u = new QPS.NEW.BLL.Users();
QPS.NEW.BLL.Room BRoom = new QPS.NEW.BLL.Room();
QPS.NEW.Model.Room Mroom = new QPS.NEW.Model.Room();
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
List <QPS.NEW.Model.Room> roomList = new List <QPS.NEW.Model.Room>();
List <QPS.NEW.Model.Orderform> orderList = new List <QPS.NEW.Model.Orderform>();
List <QPS.NEW.Model.Users> userList = new List <QPS.NEW.Model.Users>();
DataColumn dc0 = dt.Columns.Add("订单编号", typeof(int));
DataColumn dc1 = dt.Columns.Add("棋牌室名称", typeof(string));
DataColumn dc2 = dt.Columns.Add("用户", typeof(string));
DataColumn dc3 = dt.Columns.Add("酒水费", typeof(float));
DataColumn dc4 = dt.Columns.Add("是否有效", typeof(string));
dc0.ReadOnly = true;
dc1.ReadOnly = true;
dc2.ReadOnly = true;
DataSet dsUser = user.GetList("Username='******'");
uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["Id"]);
//获取RoomID
DataSet dsRoom = BRoom.GetList("OwnerID='" + uid + "' ");
for (int i = 0; i < dsRoom.Tables[0].Rows.Count; i++)
{
int roomid = Convert.ToInt32(dsRoom.Tables[0].Rows[i]["Id"]);
QPS.NEW.Model.Room r = BRoom.GetModel(roomid);
DataSet dsOrder = Border.GetList("Roomid='" + roomid + "' and IsDelete=0");
if (dsOrder.Tables[0].Rows.Count == 0)
{
continue;
}
for (int j = 0; j < dsOrder.Tables[0].Rows.Count; j++)
{
DataRow dr = dt.NewRow();
dr[1] = r.Name;
//订单ID
int orderid = Convert.ToInt32(dsOrder.Tables[0].Rows[j]["Id"]);
dr[0] = orderid;
int userid = Convert.ToInt32(dsOrder.Tables[0].Rows[j]["Userid"]);
string username = u.GetModel(userid).Username;
dr[2] = username;
dr[3] = dsOrder.Tables[0].Rows[j]["Beveragecost"];
dr[4] = dsOrder.Tables[0].Rows[j]["RoomType"];
dt.Rows.Add(dr);
}
}
return(dt);
}
public DataTable databind()
{
DataTable dt = new DataTable();
QPS.NEW.BLL.Enterprise user = new QPS.NEW.BLL.Enterprise();
QPS.NEW.BLL.Users u = new QPS.NEW.BLL.Users();
QPS.NEW.BLL.Room BRoom = new QPS.NEW.BLL.Room();
QPS.NEW.Model.Room Mroom = new QPS.NEW.Model.Room();
QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform();
List<QPS.NEW.Model.Room> roomList = new List<QPS.NEW.Model.Room>();
List<QPS.NEW.Model.Orderform> orderList = new List<QPS.NEW.Model.Orderform>();
List<QPS.NEW.Model.Users> userList = new List<QPS.NEW.Model.Users>();
DataColumn dc0 = dt.Columns.Add("订单编号", typeof(int));
DataColumn dc1 = dt.Columns.Add("棋牌室名称", typeof(string));
DataColumn dc2 = dt.Columns.Add("用户", typeof(string));
DataColumn dc3 = dt.Columns.Add("酒水费", typeof(float));
DataColumn dc4 = dt.Columns.Add("是否有效",typeof(string));
dc0.ReadOnly = true;
dc1.ReadOnly = true;
dc2.ReadOnly = true;
DataSet dsUser = user.GetList("Username='******'");
uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["Id"]);
//获取RoomID
DataSet dsRoom = BRoom.GetList("OwnerID='"+uid+"' ");
for (int i = 0; i < dsRoom.Tables[0].Rows.Count; i++)
{
int roomid =Convert.ToInt32(dsRoom.Tables[0].Rows[i]["Id"]);
QPS.NEW.Model.Room r = BRoom.GetModel(roomid);
DataSet dsOrder = Border.GetList("Roomid='" + roomid + "' and IsDelete=0");
if (dsOrder.Tables[0].Rows.Count == 0)
continue;
for (int j = 0; j < dsOrder.Tables[0].Rows.Count; j++)
{
DataRow dr = dt.NewRow();
dr[1] = r.Name;
//订单ID
int orderid = Convert.ToInt32(dsOrder.Tables[0].Rows[j]["Id"]);
dr[0] = orderid;
int userid = Convert.ToInt32(dsOrder.Tables[0].Rows[j]["Userid"]);
string username= u.GetModel(userid).Username;
dr[2]=username;
dr[3] = dsOrder.Tables[0].Rows[j]["Beveragecost"];
dr[4]=dsOrder.Tables[0].Rows[j]["RoomType"];
dt.Rows.Add(dr);
}
}
return dt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = Int32.Parse(Request.QueryString["id"].Trim());
StringBuilder sb = new StringBuilder();
sb.Append("Id=");
sb.Append(id);
ds = room.GetList(sb.ToString());
DataList2.DataSource = ds;
DataList2.DataBind();
DataList1.DataSource = ds;
DataList1.DataBind();
}
}
public void BindShow()
{
DataSet dse = new DataSet();
QPS.NEW.BLL.Room rm = new QPS.NEW.BLL.Room();
dse = rm.GetList(" id =" + tempID + " ");
this.txName.Text = dse.Tables[0].Rows[0]["Name"].ToString();
this.ddlCat.SelectedValue = dse.Tables[0].Rows[0]["roomType"].ToString();
this.Textprice.Text = dse.Tables[0].Rows[0]["roomPrice"].ToString();
this.TextAre.Text = dse.Tables[0].Rows[0]["Are"].ToString();
this.TextAddress.Text = dse.Tables[0].Rows[0]["Address"].ToString();
//图片
//this.upfile.Text = dse.Tables[0].Rows[0]["imagePath"].ToString();
this.Photo.Text = dse.Tables[0].Rows[0]["imagePath"].ToString();
this.Rec.Checked = Convert.ToInt32(dse.Tables[0].Rows[0]["IfRecommend"]) == 0 ? true : false;
this.FileContent.Value = dse.Tables[0].Rows[0]["Content"].ToString();
}
//查询(价格 地域)
protected void Button3_Click(object sender, EventArgs e)
{
string Price = this.TextPrice.Text;
string Are = this.TextAre.Text;
QPS.NEW.BLL.Room rm = new QPS.NEW.BLL.Room();
ds = rm.GetList(" RoomPrice='" + Price + "' or Are='" + Are + "'");
dgExamProj.DataSource = ds;
dgExamProj.DataBind();
}
