public static bool InsertCheckOutRoomInfo(Mouse_2017101992.CheckOutRoom checkOutRoomInfo) { string sqlInsert = @"INSERT INTO CheckOutRoom VALUES(@outId, @inId, @outTime, @roomId, @clientName, @inTime,@price, @foregift, @total, @account, @note, @oper)"; string sqlUpdateRegister = @"UPDATE RegisterRoom SET delMark=1 WHERE inId=@inId"; string sqlUpdateRoom = @"UPDATE Room SET inPerson=0 WHERE roomId=@roomId"; SqlParameter p1 = new SqlParameter("@outId", checkOutRoomInfo.OutId); SqlParameter p2 = new SqlParameter("@inId", checkOutRoomInfo.InId); SqlParameter p3 = new SqlParameter("@roomId", checkOutRoomInfo.RoomId); SqlParameter p4 = new SqlParameter("@price", double.Parse(Convert.ToString(checkOutRoomInfo.Price))); SqlParameter p5 = new SqlParameter("@foregift", double.Parse(Convert.ToString(checkOutRoomInfo.Foregift))); SqlParameter p6 = new SqlParameter("@total", double.Parse(Convert.ToString(checkOutRoomInfo.Total))); SqlParameter p7 = new SqlParameter("@account", double.Parse(Convert.ToString(checkOutRoomInfo.Account))); SqlParameter p8 = new SqlParameter("@inTime", checkOutRoomInfo.InTime); SqlParameter p9 = new SqlParameter("@outTime", checkOutRoomInfo.OutTime); SqlParameter p10 = new SqlParameter("@clientName", checkOutRoomInfo.ClientName); SqlParameter p11 = new SqlParameter("@oper", checkOutRoomInfo.Oper); SqlParameter p12 = new SqlParameter("@note", checkOutRoomInfo.Note); Mouse_2017101992.RegisterRoom registerInfo = new Mouse_2017101992.RegisterRoom(); registerInfo.InId = checkOutRoomInfo.InId; SqlParameter n1 = new SqlParameter("@inId", registerInfo.InId); SqlParameter n2 = new SqlParameter("@roomId", checkOutRoomInfo.RoomId.ToString()); if (DAL.DBOper.ExecuteCommmand(sqlInsert, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12) == 1 && DAL.DBOper.ExecuteCommmand(sqlUpdateRegister, n1) == 1 && DAL.DBOper.ExecuteCommmand(sqlUpdateRoom, n2) == 1) { return(true); } else { return(false); } }
//保存入住信息 public static bool InsertRoomInfo(Mouse_2017101992.RegisterRoom registerRoomInfo) { //向RegisterRoom 表中插入数据 string sqlInsert = @"INSERT INTO RegisterRoom VALUES (@roomId,@price,@forgift,@inTime,@outTime,@clientName, @sex,@phone,@certType,@certId,@address,@personNum,@Oper,@delMark)"; string sqlUpdate = @"UPDATE Room SET inPerson=@inPerson WHERE roomId=@roomId"; SqlParameter p1 = new SqlParameter("@roomId", registerRoomInfo.RoomId); SqlParameter p2 = new SqlParameter("@price", registerRoomInfo.Price); SqlParameter p3 = new SqlParameter("@forgift", registerRoomInfo.Foregift); SqlParameter p4 = new SqlParameter("@inTime", registerRoomInfo.InTime); SqlParameter p5 = new SqlParameter("@outTime", registerRoomInfo.OutTime); SqlParameter p6 = new SqlParameter("@clientName", registerRoomInfo.ClientName); SqlParameter p7 = new SqlParameter("@sex", registerRoomInfo.Sex); SqlParameter p8 = new SqlParameter("@phone", registerRoomInfo.Phone); SqlParameter p9 = new SqlParameter("@certType", registerRoomInfo.CertType); SqlParameter p10 = new SqlParameter("@certId", registerRoomInfo.CertId); SqlParameter p11 = new SqlParameter("@address", registerRoomInfo.Address); SqlParameter p12 = new SqlParameter("@personNum", registerRoomInfo.PersonNum); SqlParameter p13 = new SqlParameter("@Oper", registerRoomInfo.Oper); SqlParameter p14 = new SqlParameter("@delMark", registerRoomInfo.DelMark); SqlParameter[] paramArray = new SqlParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14 }; Mouse_2017101992.RoomInfo roomInfo = new Mouse_2017101992.RoomInfo(); roomInfo.InPerson = registerRoomInfo.PersonNum; SqlParameter n1 = new SqlParameter("@roomId", registerRoomInfo.RoomId); SqlParameter n2 = new SqlParameter("@inPerson", roomInfo.InPerson); if (DAL.DBOper.ExecuteCommmand(sqlInsert, paramArray) == 1 && DAL.DBOper.ExecuteCommmand(sqlUpdate, n1, n2) == 1) { return(true); } else { return(false); } }
private void SaveBtn_Click(object sender, EventArgs e) { //获取当前时间 string strTimeNow = string.Format("{0:T}", DateTime.Now); //获取入住时间 string inTime = dtpInTime.Text.ToString() + strTimeNow; //获取离开时间 string outTime = dtpOutTime.Text.ToString() + strTimeNow; //获取时间 bool sex = default(bool); //获取性别 if (rbMale.Checked) { sex = false; } else { sex = true; } //定义Mouser对像 Mouse_2017101992.RegisterRoom registerInfo = new Mouse_2017101992.RegisterRoom(); registerInfo.RoomId = IdBox.Text.ToString(); registerInfo.Price = double.Parse(ciMoneyBox.Text.ToString()); registerInfo.Foregift = double.Parse(riaMoneyBox.Text.ToString()); registerInfo.InTime = DateTime.Parse(inTime); registerInfo.OutTime = DateTime.Parse(outTime); registerInfo.ClientName = personNameBox.Text.ToString(); registerInfo.Sex = sex; registerInfo.Phone = PhoneBox.Text.ToString(); registerInfo.CertType = IdTypeBox.Text.ToString(); registerInfo.ClientName = IdBox.Text.ToString(); registerInfo.PersonNum = int.Parse(personNameBox.Text.ToString()); registerInfo.Oper = OpBox.Text.ToString(); registerInfo.Address = AddressBox.Text.ToString(); registerInfo.DelMark = 0; //插入数据 //if (checkdata()) //{ //} }