public static Reser SelectReserInfoByRoomNo(string no)
{
Reser res = null;
string sql = "select * from RESER r,ROOM rm where r.ReserRoom = rm.RoomNo and r.ReserRoom = '" + no + "'";
MySqlDataReader dr = DBHelper.ExecuteReader(sql);
if (dr.Read())
{
res = new Reser();
res.ReserId = (string)dr["ReserId"];
res.CustoName = dr["CustoNo"].ToString();
res.CustoTel = (string)dr["CustoTel"];
res.ReserWay = Convert.ToString(dr["ReserWay"]);
if (!DBNull.Value.Equals(dr["ReserDate"]))
{
res.ReserDate = DateTime.Parse(dr["ReserDate"].ToString());
}
if (!DBNull.Value.Equals(dr["ReserEndDate"]))
{
res.ReserEndDay = DateTime.Parse(dr["ReserEndDate"].ToString());
}
res.ReserRemark = (string)dr["ReserRemark"];
}
dr.Close();
DBHelper.Closecon();
return(res);
}
public static List <Reser> SelectReserAll()
{
List <Reser> rss = new List <Reser>();
string sql = "select * from RESER r,ROOMTYPE t where r.ReserRoom=t.RoomType";
SqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
Reser rs = new Reser();
rs.ReserId = (string)dr["ReserId"];
rs.CustoName = dr["CustoName"].ToString();
rs.CustoTel = (string)dr["CustoTel"];
rs.ReserWay = (string)dr["ReserWay"];
rs.ReserCash = (decimal)dr["ReserCash"];
rs.ReserDate = (DateTime)dr["ReserDate"];
rs.ReserPerson = (int)dr["ReserPerson"];
rs.typeName = (string)dr["RoomName"];
if (!DBNull.Value.Equals(dr["ReserRemark"]))
{
rs.ReserRemark = dr["ReserRemark"].ToString();
}
rss.Add(rs);
}
dr.Close();
DBHelper.Closecon();
return(rss);
}
public static List <Reser> SelectReserAll()
{
List <Reser> rss = new List <Reser>();
string sql = "select * from RESER";
MySqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
Reser rs = new Reser();
rs.ReserId = (string)dr["ReserId"];
rs.CustoName = dr["CustoName"].ToString();
rs.CustoTel = (string)dr["CustoTel"];
rs.ReserWay = (string)dr["ReserWay"];
if (!DBNull.Value.Equals(dr["ReserRoom"]))
{
rs.ReserRoom = (string)dr["ReserRoom"];
}
rs.ReserDate = (DateTime)dr["ReserDate"];
if (!DBNull.Value.Equals(dr["ReserEndDate"]))
{
rs.ReserEndDay = (DateTime)dr["ReserEndDate"];
}
if (!DBNull.Value.Equals(dr["ReserRemark"]))
{
rs.ReserRemark = dr["ReserRemark"].ToString();
}
rss.Add(rs);
}
dr.Close();
DBHelper.Closecon();
return(rss);
}
public static int InserReserInfo(Reser r)
{
string sql = "insert WTINFO (CustoName,CustoTel,ReserWay,";
sql += "ReserRoomNo,ReserDate,ReserEndDay,Remark) values ";
sql += "('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
sql = string.Format(sql, r.CustoName, r.CustoTel, r.ReserWay,
r.ReserRoom, r.ReserDate, r.ReserEndDay, r.ReserRemark);
return(DBHelper.ExecuteNonQuery(sql));
}
private void btnReser_Click(object sender, EventArgs e)
{
Random random = new Random();
string reserid = "";
reserid = new CounterHelper().GetNewId("ReserId");
Reser reser = new Reser()
{
ReserId = reserid,
CustoName = txtCustoName.Text.Trim(),
CustoTel = txtCustoTel.Text.Trim(),
ReserWay = cboReserWay.Text,
ReserRoom = cboReserRoomNo.Text,
ReserDate = dtpBouDate.Value,
ReserEndDay = dtpEndDate.Value
};
Room room = new Room()
{
RoomNo = cboReserRoomNo.Text,
RoomStateId = 4
};
bool result1 = new ReserService().InserReserInfo(reser);
bool result2 = new RoomService().UpdateRoomInfoWithReser(room);
if (result1 == true && result2 == true)
{
MessageBox.Show("预约成功！请在指定时间内进行登记入住");
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = LoginInfo.WorkerClub + LoginInfo.WorkerPosition + LoginInfo.WorkerName + "于" + DateTime.Now + "帮助" + txtCustoTel.Text + "进行了预订房间操作！";
o.OperationAccount = LoginInfo.WorkerNo;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
#endregion
new OperationlogService().InsertOperationLog(o);
this.Close();
}
}
public static List <Reser> SelectReserInfoByConn(string tel)
{
List <Reser> tis = new List <Reser>();
string sql = "select * from Reser where CustoTel = '" + tel + "'";
SqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
Reser ti = new Reser();
ti.ReserId = (string)dr["ReserId"];
ti.CustoName = (string)dr["CustoName"];
ti.CustoTel = (string)dr["CustoTel"];
ti.ReserWay = (string)dr["ReserWay"];
ti.ReserCash = (decimal)dr["ReserCash"];
ti.ReserDate = DateTime.Parse(dr["ReserDate"].ToString());
ti.ReserPerson = (int)dr["ReserPerson"];
ti.ReserRemark = (string)dr["ReserRemark"];
tis.Add(ti);
}
dr.Close();
DBHelper.Closecon();
return(tis);
}
public static List <Reser> SelectReserAll()
{
List <Reser> rss = new List <Reser>();
string sql = "select * from reser";
MySqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
Reser rs = new Reser();
rs.ReserId = (string)dr["ReserId"];
rs.CustoName = (string)dr["CustoName"];
rs.CustoTel = (string)dr["CustoTel"];
rs.ReserWay = (string)dr["ReserWay"];
rs.ReserRoom = (string)dr["ReserRoom"];
rs.ReserCash = (decimal)dr["ReserCash"];
rs.ReserDate = (DateTime)dr["ReserDate"];
rs.ReserPerson = (int)dr["ReserPerson"];
rss.Add(rs);
}
dr.Close();
DBHelper.Closecon();
return(rss);
}
public static int InserReserInfo(Reser r)
{
return(ReserService.InserReserInfo(r));
}
public static Reser SelectReserInfoByRoomNo(string no)
{
Reser r = ReserService.SelectReserInfoByRoomNo(no);
return(r);
}
public bool InserReserInfo([FromBody] Reser r)
{
return(new ReserService().InserReserInfo(r));
}
