/// <summary> /// 获得实际费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetRoomStatu(Model.Book_Rdetail model) { double price = Convert.ToDouble(model.Real_Price); double zk = Convert.ToDouble(model.Hourse_scheme_model.hs_Discount) * Convert.ToDouble(0.1); return((price * zk).ToString()); }
private string Getrum(Model.Book_Rdetail model) { System.Text.StringBuilder sba1 = new System.Text.StringBuilder(); List <Model.room_number> listbr = bllrn.GetModelList("Rn_room=" + model.Real_type_Id); foreach (var item in listbr) { sba1.Append("<li>" + item.Rn_roomNum + "</li>"); } return(sba1.ToString()); }
private void UpdateRd() { try { string book_no = context.Request.Form["book_no"].ToString(); bool rels = bllrd.DeletebyWhere("Book_no='" + book_no + "'"); if (rels) { // bllbr.DeletebyWhere("Book_no='" + book_no + "'"); } string strs = context.Request.Form["sjs"].ToString(); strs = strs.Remove(strs.Length - 1, 1); string[] strlist = strs.Split(new char[1] { '*' }, StringSplitOptions.RemoveEmptyEntries); Dictionary <string, string> dic = new Dictionary <string, string>(); foreach (string str in strlist) { dic.Clear(); string[] strdelt = str.Split(new char[1] { ',' }); foreach (string s in strdelt) { string[] strval = s.Split(new char[1] { ':' }); dic.Add(strval[0], strval[1]); } Model.Book_Rdetail modelbr = new Model.Book_Rdetail() { Book_no = book_no, Real_type_Id = Convert.ToInt32(dic["typeid"]), Room_number = dic["roomnumber"], Real_num = Convert.ToInt32(dic["number"]), Ok_num = 0, Real_Price = Convert.ToDecimal(dic["price"]), Real_Scheme_Id = Convert.ToInt32(dic["fangan"]), RoomTypeID = 1 }; bllrd.Add(modelbr); } context.Response.Write("分房成功!"); } catch (Exception) { throw; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Book_Rdetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Book_Rdetail set "); strSql.Append("Book_no=@Book_no,"); strSql.Append("Real_type_Id=@Real_type_Id,"); strSql.Append("Room_number=@Room_number,"); strSql.Append("Real_num=@Real_num,"); strSql.Append("Real_Price=@Real_Price,"); strSql.Append("Real_Scheme_Id=@Real_Scheme_Id,"); strSql.Append("Ok_num=@Ok_num,"); strSql.Append("Room_typeid=@Room_typeid,"); strSql.Append("Book_Price=@Book_Price"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Book_no", SqlDbType.NVarChar, 20), new SqlParameter("@Real_type_Id", SqlDbType.Int, 4), new SqlParameter("@Room_number", SqlDbType.NVarChar, 20), new SqlParameter("@Real_num", SqlDbType.Int, 4), new SqlParameter("@Real_Price", SqlDbType.Money, 8), new SqlParameter("@Real_Scheme_Id", SqlDbType.Int, 4), new SqlParameter("@Ok_num", SqlDbType.Int, 4), new SqlParameter("@Room_typeid", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Book_Price", SqlDbType.Money, 8) }; parameters[0].Value = model.Book_no; parameters[1].Value = model.Real_type_Id; parameters[2].Value = model.Room_number; parameters[3].Value = model.Real_num; parameters[4].Value = model.Real_Price; parameters[5].Value = model.Real_Scheme_Id; parameters[6].Value = model.Ok_num; parameters[7].Value = model.RoomTypeID; parameters[8].Value = model.ID; parameters[9].Value = model.Book_Price; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得所有优惠数据 /// </summary> private void GetAllYh(Model.Book_Rdetail modelbr) { List <Model.hourse_scheme> listrt = hsBll.GetModelList(""); foreach (Model.hourse_scheme model in listrt) { if (model.id == modelbr.Real_Scheme_Id) { sbDel.Append("<option selected=\"selected\" value=\"" + model.id + "\">" + model.hs_name + "</option>"); } else { sbDel.Append("<option value=\"" + model.id + "\">" + model.hs_name + "</option>"); } } }
/// <summary> /// 获得所有房间类型 /// </summary> private void GetAllType(Model.Book_Rdetail modelbr) { List <Model.room_type> listrt = rtBll.GetModelList(""); foreach (Model.room_type model in listrt) { if (model.id == modelbr.Real_type_Id) { sbDel.Append("<option selected=\"selected\" value=\"" + model.id + "\">" + model.room_name + "</option>"); } else { sbDel.Append("<option value=\"" + model.id + "\">" + model.room_name + "</option>"); } } }
public List <Model.Book_Rdetail> GetListModel1(string strWhere) { StringBuilder strSql = new StringBuilder(); List <Model.Book_Rdetail> list = new List <Model.Book_Rdetail>(); strSql.Append("select * "); strSql.Append(" FROM Book_Rdetail as br inner join hourse_scheme as hs on br.Real_Scheme_Id=hs.id"); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { Model.Book_Rdetail model = DataRowToModel1(dr); list.Add(model); } return(list); }
public List <Model.Book_Rdetail> GetListModel(string strWhere) { StringBuilder strSql = new StringBuilder(); List <Model.Book_Rdetail> list = new List <Model.Book_Rdetail>(); strSql.Append("select Id,Book_no,Real_type_Id,Room_number,Real_num,Real_Price,Real_Scheme_Id,Ok_num,Room_typeid,Book_Price "); strSql.Append(" FROM Book_Rdetail "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = DbHelperSQL.Query(strSql.ToString()); foreach (DataRow dr in ds.Tables[0].Rows) { Model.Book_Rdetail model = DataRowToModel(dr); list.Add(model); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Book_Rdetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Book_Rdetail("); strSql.Append("Book_no,Real_type_Id,Room_number,Real_num,Real_Price,Real_Scheme_Id,Ok_num,Room_typeid,Book_Price)"); strSql.Append(" values ("); strSql.Append("@Book_no,@Real_type_Id,@Room_number,@Real_num,@Real_Price,@Real_Scheme_Id,@Ok_num,@Room_typeid,@Book_Price)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Book_no", SqlDbType.NVarChar, 20), new SqlParameter("@Real_type_Id", SqlDbType.Int, 4), new SqlParameter("@Room_number", SqlDbType.NVarChar, 20), new SqlParameter("@Real_num", SqlDbType.Int, 4), new SqlParameter("@Real_Price", SqlDbType.Money, 8), new SqlParameter("@Real_Scheme_Id", SqlDbType.Int, 4), new SqlParameter("@Ok_num", SqlDbType.Int, 4), new SqlParameter("@Room_typeid", SqlDbType.Int, 4), new SqlParameter("@Book_Price", SqlDbType.Money, 8) }; parameters[0].Value = model.Book_no; parameters[1].Value = model.Real_type_Id; parameters[2].Value = model.Room_number; parameters[3].Value = model.Real_num; parameters[4].Value = model.Real_Price; parameters[5].Value = model.Real_Scheme_Id; parameters[6].Value = model.Ok_num; parameters[7].Value = model.RoomTypeID; parameters[8].Value = model.Book_Price; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Book_Rdetail model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Book_Rdetail model) { return(dal.Add(model)); }
/// <summary> /// 新增与修改 /// </summary> private void AddBook() { try { bool isb = true; System.Text.StringBuilder sbText = new System.Text.StringBuilder(); string book_no = string.Empty; string isUpdate = context.Request.Form["isUpdate"].ToString(); if (isUpdate == "true") { book_no = context.Request.Form["book_no"].ToString(); List <Model.Book_Rdetail> listbr = bllrd.GetListModel("Book_no='" + book_no + "'"); if (listbr.Count > 0) { Model.room_number modelrt = new Model.room_number(); foreach (Model.Book_Rdetail item in listbr) { if (item.Room_number != null) { if (item.Room_number.Trim() != "") { modelrt = bllrn.GetModelList("Rn_roomNum='" + item.Room_number + "'")[0]; modelrt.Rn_Tobe = 0; Helper.AddRoom(item.Room_number); bllrn.Update(modelrt); } } } } bool rels = bllrd.DeletebyWhere("Book_no='" + book_no + "'"); if (rels) { bllbr.DeletebyWhere("Book_no='" + book_no + "'"); } } else { book_no = "Y" + System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); } string txtname = context.Request.Form["txtname"].ToString(); string txtPhone = context.Request.Form["txtPhone"].ToString(); string txtDh = context.Request.Form["txtDh"].ToString(); string txtrz = context.Request.Form["txtrz"].ToString(); string txttf = context.Request.Form["txttf"].ToString(); string txtyd = context.Request.Form["txtyd"].ToString(); string txtmCard = context.Request.Form["txtmCard"].ToString(); string guarWayDll = context.Request.Form["guarWayDll"].ToString(); string guestSourceDdl = context.Request.Form["guestSourceDdl"].ToString(); string methPayDdl = context.Request.Form["methPayDdl"].ToString(); string txtdj = context.Request.Form["txtdj"].ToString(); string textRemaker = context.Request.Form["textRemaker"].ToString(); string accounts = context.Request.Form["accounts"].ToString(); string CpId = context.Request.Form["CpId"].ToString(); string strs = context.Request.Form["sjs"].ToString(); int? cid = null; if (CpId != "") { cid = Convert.ToInt32(CpId); } strs = strs.Remove(strs.Length - 1, 1); Model.book_room model = new Model.book_room() { book_no = book_no, book_Name = txtname, tele_no = txtPhone, onli_no = txtDh, guar_way = guarWayDll, mem_cardno = txtmCard, time_to = Convert.ToDateTime(txtrz), time_from = Convert.ToDateTime(txttf), real_time = Convert.ToDateTime(txtyd), source_id = Convert.ToInt32(guestSourceDdl), meth_pay_id = Convert.ToInt32(methPayDdl), deposit = Convert.ToDecimal(txtdj), remark = textRemaker, Userid = UserNow.UserID, Accounts = accounts, CpID = cid }; if (Math.Floor(Convert.ToDouble(txtdj)) == 0) { model.state_id = 6; } else { model.state_id = 1; } int rel = bllbr.Add(model); if (rel > 0) { string[] strlist = strs.Split(new char[1] { '*' }, StringSplitOptions.RemoveEmptyEntries); Dictionary <string, string> dic = new Dictionary <string, string>(); foreach (string str in strlist) { dic.Clear(); string[] strdelt = str.Split(new char[1] { ',' }); foreach (string s in strdelt) { string[] strval = s.Split(new char[1] { ':' }); dic.Add(strval[0], strval[1]); } Model.Book_Rdetail modelbr = new Model.Book_Rdetail() { Book_no = model.book_no, Real_type_Id = Convert.ToInt32(dic["typeid"]), Room_number = dic["roomnumber"], Real_num = Convert.ToInt32(dic["number"]), Ok_num = 0, Real_Price = Convert.ToDecimal(dic["price"]), Real_Scheme_Id = Convert.ToInt32(dic["fangan"]), RoomTypeID = Convert.ToInt32(model.state_id) }; if (!IsBook(modelbr.Room_number)) { isb = false; List <Model.room_number> list = bllrn.GetModelList("Rn_roomNum='" + modelbr.Room_number + "'"); if (list.Count > 0) { Model.room_number modelrn = list[0]; modelrn.Rn_Tobe = 1; bllrn.Update(modelrn); } if (modelbr.Room_number.Trim() != "") { Helper.AddRoom(modelbr.Room_number); } bllrd.Add(modelbr); } else { sbText.Append(modelbr.Room_number + ","); } } } if (isUpdate == "true") { context.Response.Write("更新成功!,' '"); } else { if (isb) { bllbr.Delete(rel); context.Response.Write("房间已被预定!," + book_no + ""); } else { string finalStr = "{book_no:" + book_no + "}"; Model.goods_account modelga = new Model.goods_account() { ga_name = "预定收款", ga_number = model.book_no, ga_price = Convert.ToDecimal(model.deposit), ga_zffs_id = Convert.ToInt32(methPayDdl), ga_date = DateTime.Now, ga_people = UserNow.UserID, ga_Type = 8, ga_occuid = "", ga_remker = "", ga_sum_price = Convert.ToDecimal("0.0000"), ga_sfacount = "是", ga_isjz = 0, ga_roomNumber = "0", ga_num = 0, ga_unit = "" }; bllga.Add(modelga); if (sbText.ToString() != "") { context.Response.Write("新增成功" + sbText.ToString() + "已被预定!," + book_no + ""); } else { context.Response.Write("新增成功!," + book_no + ""); } } } context.Response.End(); } catch (Exception ex) { context.Response.End(); } }