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