void bs_CurrentChanged(object sender, EventArgs e) { if (bs.Current == null) { return; } string dt62id = (bs.Current as DataRowView).Row["DT62ID"].ToString(); crRoom = _data.FindRoom(dt62id); if (crRoom == null) { return; } gridControl2.DataSource = crRoom.minibar; gridControl3.DataSource = crRoom.dichvu; gridView2.OptionsBehavior.Editable = !crRoom.isCheckOut; gridView3.OptionsBehavior.Editable = !crRoom.isCheckOut; gridColumn26.OptionsColumn.AllowEdit = !crRoom.isCheckOut; }
public DataCheckOut(string MT62ID) { GetData4Rep(); string sql = "select getdate()"; ngayht = _dbData.GetValue(sql); sql = "select * from mt62 where mt62id='" + MT62ID + "' ; select * from dt62 where mt62id='" + MT62ID + "' and isCheckIn=1"; ds = _dbData.GetDataSet(sql); if (ds.Tables[0].Rows.Count == 0) { return; } ds.Tables[0].ColumnChanged += new DataColumnChangeEventHandler(DataCheckOut_ColumnChanged); mt = ds.Tables[0].Rows[0]; NgayDiOld = mt["NgayDi"]; // mt["NgayDi"] = DateTime.Now; dt = ds.Tables[1]; dt.TableNewRow += new DataTableNewRowEventHandler(dt_TableNewRow); dt.PrimaryKey = new DataColumn[] { dt.Columns["DT62ID"] }; foreach (DataRow dr in dt.Rows) { DataCheckOut1Room dtChkOut = new DataCheckOut1Room(dr, _dbData); dtChkOut.ThueSuat = double.Parse(mt["Thuesuat"].ToString()); dtChkOut.setMinibarData(); // dtChkOut.dt["NgayDi"] = DateTime.Now; dr["NgayDi"] = dtChkOut.dt["NgayDi"]; dr["SoNgay"] = dtChkOut.dt["SoNgay"]; dr["MaGia"] = dtChkOut.dt["MaGia"]; dr["GiaPhong"] = dtChkOut.dt["GiaPhong"]; dr["SoNT"] = dtChkOut.dt["SoNT"]; dr["Ps"] = dtChkOut.dt["Ps"]; lChkOut.Add(dtChkOut); dtChkOut.TTienChanged += new EventHandler(dtChkOut_TTienChanged); } TinhTongTien(); }
public bool ChuyenPhong(DataCheckOut1Room crRoom, string MaPhongDen) { DataRow rdt = dt.NewRow(); rdt["DT62ID"] = Guid.NewGuid(); rdt["MaPhong"] = MaPhongDen; rdt["MaGia"] = crRoom.dt["MaGia"]; rdt["DaChuyen"] = 0; rdt["MaLoaiPhong"] = crRoom.dt["MaLoaiPhong"]; rdt["GiaPhong"] = crRoom.dt["GiaPhong"]; rdt["GiaPhong1"] = crRoom.dt["GiaPhong1"]; rdt["NgayTT"] = crRoom.dt["NgayTT"]; rdt["NgayDen"] = DateTime.Parse(ngayht.ToString()); rdt["SoNT"] = crRoom.dt["SoNT"]; //rdt["NgayDi"] = mt["NgayDi"]; DataCheckOut1Room dtChkOut = new DataCheckOut1Room(rdt, _dbData); dtChkOut.ThueSuat = double.Parse(mt["Thuesuat"].ToString()); dtChkOut.setMinibarData(); // dtChkOut.dt["NgayDi"] = DateTime.Now; rdt["NgayDi"] = mt["NgayDi"]; rdt["isCheckOut"] = false; rdt["isCheckIn"] = true; rdt["SoNgay"] = mt["SoNgay"]; _dbData.BeginMultiTrans(); try { string sql = "insert into dt62 (MT62ID, DT62ID,MaPhong, GiaPhong,GiaPhong1,Ps,SoNT,isCheckIn,isCheckOut, NgayDen, NgayDi,MaLoaiPhong, MaGia,NgayTT,DaChuyen,SoNgay) values('" + mt["MT62ID"].ToString() + "','" + rdt["DT62ID"].ToString() + "','" + rdt["MaPhong"].ToString() + "'," + rdt["GiaPhong"].ToString() + "," + rdt["GiaPhong1"].ToString() + "," + rdt["Ps"].ToString() + "," + rdt["SoNT"].ToString() + ",1,0,'" + rdt["NgayDen"].ToString() + "','" + rdt["NgayDi"].ToString() + "','" + rdt["MaLoaiPhong"].ToString() + "'," + rdt["MaGia"].ToString() + ",'" + rdt["NgayTT"].ToString() + "',0," + rdt["SoNgay"].ToString() + ")"; _dbData.UpdateByNonQuery(sql); sql = " update dmPhong set MaTT='IN' where MaPhong='" + rdt["MaPhong"].ToString() + "'"; _dbData.UpdateByNonQuery(sql); crRoom.dt["DaChuyen"] = true; // crRoom.dt["isCheckOut"] = false; if (crRoom != null && crRoom.dt["isCheckOut"].ToString() == "False") { crRoom.dt["NgayDi"] = DateTime.Parse(ngayht.ToString()); if (this.CheckOut1RoomWithoutTrans(crRoom)) { crRoom.dt["isCheckOut"] = true; } } if (!_dbData.HasErrors) { lChkOut.Add(dtChkOut); dtChkOut.TTienChanged += new EventHandler(dtChkOut_TTienChanged); dt.Rows.Add(rdt); rdt["NgayDi"] = mt["NgayDi"]; dt.AcceptChanges(); _dbData.EndMultiTrans(); return(true); } else { dt.RejectChanges(); _dbData.RollbackMultiTrans(); return(false); } } catch { dt.RejectChanges(); _dbData.RollbackMultiTrans(); return(false); } }
public bool CheckOut1RoomWithoutTrans(DataCheckOut1Room dt1R) { dt1R.CheckOut(true); Save(true); return(true); }
public bool CheckOut1Room(DataCheckOut1Room dt1R) { dt1R.CheckOut(false); Save(false); return(true); }