/// <summary> ///添加入住信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdds_Click(object sender, EventArgs e) { CdHotelManage.Model.occu_infor model = new CdHotelManage.Model.occu_infor(); CdHotelManage.Model.occu_infor models = new CdHotelManage.Model.occu_infor(); model.occ_no = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); model.room_number = this.txt_roomid.Value; model.real_type_id = Convert.ToInt32(this.ddroomtype.SelectedValue); model.source_id = Convert.ToInt32(this.DDlkrly.SelectedValue); model.real_scheme_id = Convert.ToInt32(this.DDLfjfa.SelectedValue); model.real_price = Convert.ToDecimal(this.txt_fjPrice.Value); model.occ_with = "否"; model.real_mode_id = Convert.ToInt32(this.DDlKffs.SelectedValue); model.occ_time = Convert.ToDateTime(this.txt_rzdate.Value); model.pre_live_day = Convert.ToInt32(this.txt_Day.Value); model.depar_time = Convert.ToDateTime(this.txt_ylDate.Value); model.occ_name = this.txt_name.Value; model.sex = this.txt_Sex.Value; model.brithday = this.txt_Date2.Value; model.family_name = this.txt_mingzhu.Value; model.card_id = Convert.ToInt32(this.DDlSFz.SelectedValue);; model.card_no = (this.txt_CardId.Value); model.mem_cardno = this.txt_hycardId.Value; //会员卡号 model.remark = this.txt_Remaker.Value; model.meth_pay_id = Convert.ToInt32(DDlZffs.SelectedValue); //支付方式 model.deposit = Convert.ToInt32(txt_yjmoney.Value); model.address = txt_address.Value; //地址 CdHotelManage.BLL.occu_infor bll = new CdHotelManage.BLL.occu_infor(); CdHotelManage.Model.room_number fh = new CdHotelManage.Model.room_number(); fh.Rn_state = 2; fh.Rn_roomNum = txt_roomid.Value; string SQl = "update room_number set Rn_state=2 where Rn_roomNum='" + txt_roomid.Value + "'"; // fh.id = fhBll.GetModel(Convert.ToInt32(txt_roomid.Value), "Rn_roomNum"); fhBll.Updates(SQl); for (int i = 0; i < hidSchool.Value.Split('|').Length - 1; i++) { models.occ_name = hidSchool.Value.Split('#')[0]; models.sex = hidSchool.Value.Split('#')[1]; models.brithday = hidSchool.Value.Split('#')[2]; models.card_id = Convert.ToInt32(hidSchool.Value.Split('#')[3]); models.card_no = hidSchool.Value.Split('#')[4]; models.address = hidSchool.Value.Split('#')[5]; models.occ_time = Convert.ToDateTime(System.DateTime.Now.ToString()); models.occ_with = "是"; bll.Add(models); } if (bll.Add(model) > 0) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", ""); } else { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存失败!", ""); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CdHotelManage.Model.room_number model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update room_number set "); strSql.Append("Rn_flloeld=@Rn_flloeld,"); strSql.Append("Rn_floor=@Rn_floor,"); strSql.Append("Rn_roomNum=@Rn_roomNum,"); strSql.Append("Rn_state=@Rn_state,"); strSql.Append("Rn_room=@Rn_room,"); strSql.Append("Rn_Type=@Rn_Type,"); strSql.Append("Rn_price=@Rn_price,"); strSql.Append("Rn_remaker=@Rn_remaker,"); strSql.Append("Room_suod=@Room_suod,"); strSql.Append("Rn_Tobe=@Rn_Tobe,"); strSql.Append("Rn_suo=@Rn_suo"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@Rn_flloeld", SqlDbType.NVarChar, 50), new SqlParameter("@Rn_floor", SqlDbType.NVarChar, 10), new SqlParameter("@Rn_roomNum", SqlDbType.NVarChar, 20), new SqlParameter("@Rn_state", SqlDbType.Int, 4), new SqlParameter("@Rn_room", SqlDbType.NVarChar, 50), new SqlParameter("@Rn_Type", SqlDbType.Int, 4), new SqlParameter("@Rn_price", SqlDbType.Money, 4), new SqlParameter("@Rn_remaker", SqlDbType.NVarChar, -1), new SqlParameter("@Room_suod", SqlDbType.Char, 10), new SqlParameter("@Rn_Tobe", SqlDbType.Int, 4), new SqlParameter("@Rn_suo", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.Rn_flloeld; parameters[1].Value = model.Rn_floor; parameters[2].Value = model.Rn_roomNum; parameters[3].Value = model.Rn_state; parameters[4].Value = model.Rn_room; parameters[5].Value = model.Rn_Type; parameters[6].Value = model.Rn_price; parameters[7].Value = model.Rn_remaker; parameters[8].Value = model.Room_suod; parameters[9].Value = model.Rn_Tobe; parameters[10].Value = model.Rn_suo; parameters[11].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CdHotelManage.Model.room_number DataRowToModel(DataRow row) { CdHotelManage.Model.room_number model = new CdHotelManage.Model.room_number(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["Rn_flloeld"] != null) { model.Rn_flloeld = row["Rn_flloeld"].ToString(); } if (row["Rn_floor"] != null) { model.Rn_floor = row["Rn_floor"].ToString(); } if (row["Rn_roomNum"] != null) { model.Rn_roomNum = row["Rn_roomNum"].ToString(); } if (row["Rn_state"] != null && row["Rn_state"].ToString() != "") { model.Rn_state = int.Parse(row["Rn_state"].ToString()); } if (row["Rn_room"] != null) { model.Rn_room = row["Rn_room"].ToString(); } if (row["Rn_Type"] != null && row["Rn_Type"].ToString() != "") { model.Rn_Type = int.Parse(row["Rn_Type"].ToString()); } if (row["Rn_price"] != null && row["Rn_price"].ToString() != "") { model.Rn_price = Convert.ToDecimal(decimal.Parse(row["Rn_price"].ToString())); } if (row["Rn_remaker"] != null) { model.Rn_remaker = row["Rn_remaker"].ToString(); } if (row["Room_suod"] != null) { model.Room_suod = row["Room_suod"].ToString(); } if (row["Rn_Tobe"] != null && row["Rn_Tobe"].ToString() != "") { model.Rn_Tobe = Convert.ToInt32(row["Rn_Tobe"]); } if (row["Rn_suo"] != null && row["Rn_suo"].ToString() != "") { model.Rn_suo = row["Rn_suo"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CdHotelManage.Model.room_number model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into room_number("); strSql.Append("Rn_flloeld,Rn_floor,Rn_roomNum,Rn_state,Rn_room,Rn_Type,Rn_price,Rn_remaker,Room_suod,Rn_Tobe,Rn_suo)"); strSql.Append(" values ("); strSql.Append("@Rn_flloeld,@Rn_floor,@Rn_roomNum,@Rn_state,@Rn_room,@Rn_Type,@Rn_price,@Rn_remaker,@Room_suod,@Rn_Tobe,@Rn_suo)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Rn_flloeld", SqlDbType.NVarChar, 50), new SqlParameter("@Rn_floor", SqlDbType.NVarChar, 10), new SqlParameter("@Rn_roomNum", SqlDbType.NVarChar, 20), new SqlParameter("@Rn_state", SqlDbType.Int, 4), new SqlParameter("@Rn_room", SqlDbType.NVarChar, 50), new SqlParameter("@Rn_Type", SqlDbType.Int, 4), new SqlParameter("@Rn_price", SqlDbType.Money, 4), new SqlParameter("@Rn_remaker", SqlDbType.NVarChar, -1), new SqlParameter("@Room_suod", SqlDbType.Char, 10), new SqlParameter("@Rn_Tobe", SqlDbType.Int, 4), new SqlParameter("@Rn_suo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.Rn_flloeld; parameters[1].Value = model.Rn_floor; parameters[2].Value = model.Rn_roomNum; parameters[3].Value = model.Rn_state; parameters[4].Value = model.Rn_room; parameters[5].Value = model.Rn_Type; parameters[6].Value = model.Rn_price; parameters[7].Value = model.Rn_remaker; parameters[8].Value = model.Room_suod; parameters[9].Value = model.Rn_Tobe; parameters[10].Value = model.Rn_suo; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体2 /// </summary> public CdHotelManage.Model.room_number GetModel(int id, string TabCell) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,Rn_flloeld,Rn_floor,Rn_roomNum,Rn_state,Rn_room,Rn_Type,Rn_price,Rn_remaker,Room_suod,Rn_Tobe,Rn_suo from room_number "); strSql.Append(" where " + TabCell + "=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; CdHotelManage.Model.room_number model = new CdHotelManage.Model.room_number(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }