//用户ID所有的酒店
public List<hotel_info> getHotlList(string iuId)
{
// uId = "test1";
//c = new help.HotelInfoHelp().getUId();
// uId=
using (db = new HotelDBContent())
{
var member =(from m in db.Merchant_infos where m.mobliephone == uId select m).SingleOrDefault();
//if (member != null)
//{
if (member.admin)
{
return (from h in db.hotel where h.u_id == uId && h.h_state == true select h).ToList();
}
else
{
{
string[] str = string.IsNullOrEmpty(member.limitHotelId) ? new string[] { "1" } : member.limitHotelId.Split(',');
int[] strHotelId = new int[str.Length];
for (int i = 0; i < str.Length; i++)
{
strHotelId[i] = Convert.ToInt32(str[i]);
}
return (from h in db.hotel where h.u_id == uId && h.h_state == true && strHotelId.Contains(h.hotel_id) select h).ToList();
}
}
//}
}
}
public ActionResult CreateUser(Merchant_info merchant_info)
{
merchant_info.status = true;
using (db = new HotelDBContent())
{
if (merchant_info.id > 0)
{
//if(merchant_info.password=="******")
merchant_info.updateUser(merchant_info);
}
else
{
if (ModelState.IsValid)
{
merchant_info.password = new help.HotelInfoHelp().Md5(merchant_info.password); merchant_info.ctime = DateTime.Now; merchant_info.status = true; merchant_info.guid = Guid.NewGuid().ToString(); merchant_info.operator_id = new help.HotelInfoHelp().getUId(); merchant_info.status = true;
//using (db=new HotelDBContent())
//{
db.Merchant_infos.Add(merchant_info);
result = db.SaveChanges() > 0 ? 1 : 0;
//}
}
}
}
return View("MyUser", getData());
}
//酒店的房型列表
public static List<hotel_room_info> getRooms(int hotelId)
{
using(db = new HotelDBContent())
{
return (from r in db.rooms where r.hotel_id == hotelId select r).ToList();
}
}
public int validateSASUser(string tel)
{
using (db = new HotelDBContent())
{
if ((from u in db.Merchant_infos where u.tel == tel select u.tel).Count() > 0)
return 1;
else
return 0;
}
}
//验证房型是否存在
public int IsOk(string hotelId, string text)
{
int hotel_id = Convert.ToInt32(hotelId);
using (db = new HotelDBContent())
{
if ((from h in db.rooms where h.h_r_name_cn == text && h.hotel_id == hotel_id select h).Count() > 0)
return 0;
else
return 1;
}
}
/// <summary>
/// 电话
/// </summary>
/// <param name="tel"></param>
/// <returns></returns>
public int isOkTel(string text)
{
// int hotel_id = Convert.ToInt32(hotelId);
using (db = new HotelDBContent())
{
if ((from m in db.Merchant_infos where m.tel== text select m).Count() > 0)
return 0;
else
return 1;
}
}
/// <summary>
/// 验证房型是否存在
/// </summary>
/// <param name="text"></param>
/// <param name="hotelId"></param>
/// <returns></returns>
public int isOkRoom(string text,string hotelId)
{
int hotel_id = Convert.ToInt32(hotelId);
string strRooms = string.Empty;
using (db = new HotelDBContent())
{
if ((from r in db.rooms where r.h_r_name_cn == text.Trim() && r.hotel_id == hotel_id select r).Count() > 0)
return 0;
else
return 1;
}
}
////get all Theme
//public static SelectList AllTheme()
//{
// List<SelectListItem> list = new List<SelectListItem>();
// khotel_theme_infoDBContent db = new khotel_theme_infoDBContent();
// var themes = db.Themes.ToList();
// foreach (var t in themes)
// {
// list.Add(new SelectListItem() { Text = t.hotel_theme_title, Value = t.hotel_theme_id.ToString() });
// }
// SelectList item = new SelectList(list, "Value", "Text");
// return item;
//}
//get all Theme
public static Dictionary<int,string> AllTheme()
{
Dictionary<int, string> list = new Dictionary<int, string>();
//Array array = new Array();
HotelDBContent db = new HotelDBContent();
var themes = db.themes.ToList();
foreach (var t in themes)
{
list.Add(t.hotel_theme_id, t.hotel_theme_title); ;
}
return list;
}
public static Dictionary<int, string> allCategory()
{
Dictionary<int, string> list = new Dictionary<int, string>();
//Array array = new Array();
HotelDBContent db = new HotelDBContent();
var themes = db.curents.ToList();
foreach (var t in themes)
{
list.Add(t._t_id, t._t_name); ;
}
return list;
}
public ActionResult LoginSubmit(Merchant_info merchant_info)
{
string code = Session["code"]!=null?Session["code"].ToString():"";
if (code == merchant_info.guid)
{
using (db = new HotelDBContent())
{
Merchant_info mer = (from m in db.Merchant_infos where m.mobliephone == merchant_info.tel &&m.status==true select m).SingleOrDefault();
if (mer != null)
{
// new help.HotelInfoHelp().Md5(merchant_info.password);
// if (mer.password == merchant_info.password)
if (mer.password == new help.HotelInfoHelp().Md5(merchant_info.password))
{
string limit = string.Empty;
Session["menu"] = new help.HotelInfoHelp().GetLimit(mer, out limit); Session["limit"] = limit; Session["limitHotelId"] = mer.limitHotelId;
Session["userName"] = mer.name;
Session["uid"] = mer.mobliephone;
Session.Remove("code");
return RedirectToAction("index", "home");
}
else
{
ViewBag.LoginInfo = "用户名或者密码错误";
}
}
else
{
ViewBag.LoginInfo = "用户名或者密码错误";
}
}
}else
ViewBag.LoginInfo = "验证码错误,请输入正确的验证码";
Session.Remove("code");
ViewBag.userName = merchant_info.tel; ViewBag.pass = merchant_info.password;
return View("signLogin");;
}
/// <summary>
/// 查找房型
/// </summary>
/// <param name="text"></param>
/// <param name="hotelId"></param>
/// <returns></returns>
public string qureyRoom(string text, string hotelId)
{
//text = "IW1号测试房";
int hotel_id=0;int.TryParse(hotelId,out hotel_id);
string strRooms = string.Empty;
if (string.IsNullOrEmpty(text))
return strRooms;
using (db = new HotelDBContent())
{
//var ff=(from o in db.hotel where o.hotel_id == hotel_id select o.h_name_cn).FirstOrDefault();
var f = (from helong in db.hotel where ((from o in db.hotel where o.hotel_id == hotel_id select o.h_name_cn).FirstOrDefault()).Contains(helong.h_name_cn) where helong.source_id == 4 select helong).FirstOrDefault();
if (f != null)
{
var room = from o in db.rooms where o.h_r_name_cn.Contains(text.Trim()) && o.hotel_id == f.hotel_id select o;
foreach (var r in room)
{
strRooms += string.Format("{0},{1}", r.h_r_name_cn, r.room_id) + "|";
}
}
}
return strRooms;
}
//删除担保
public ActionResult deleteG(string id)
{
int gId;
int.TryParse(id, out gId);
GuaranteeRule guran = null;
using (db = new HotelDBContent())
{
var gu = (from g in db.gu where g.id == gId select g).SingleOrDefault();
db.gu.Remove(gu);
if (db.SaveChanges() > 0)
ViewBag.sign = 1;
else
ViewBag.sign = 0;
guran = gu;
ViewBag.Id = gu.hotel_id;
GetData(gu.hotel_id.ToString());
setName();
}
guran.id = 0;
return View("MyGuarantee", guran);
}
//}
/// <summary>
/// 查询酒店
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
public string queryHotel(string text)
{
string strResult = string.Empty;
using (db = new HotelDBContent())
{
var result = from h in db.hotel join b in db.citys on h.h_city equals b.City_id where h.h_name_cn.Contains(text.Trim()) && h.source_id == 4 select new { name = h.h_name_cn, city = b.City_name, f = h.source_id };
foreach (var r in result)
{
strResult += string.Format("{0}[{1}])", r.name, r.city) + "|";
}
}
return strResult;
}
///// <summary>
///// 验证酒店名是否存在
///// </summary>
///// <param name="text"></param>
///// <returns></returns>
//public int IsOkHotel(string text)
//{
// using (db = new HotelDBContent())
// {
// if ((from h in db.hotel where h.h_name_cn == text select h).Count() > 0 || (from h in new HotelDBContent("").hotel where h.h_name_cn == text select h).Count() > 0)
// return 0;
// else
// return 1;
// }
//}
/// <summary>
/// 验证酒店名是否存在
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
public int IsOkHotel(string text)
{
string strResult = string.Empty;
using (db = new HotelDBContent())
{
if((from h in db.hotel where h.h_name_cn==text.Trim() && h.source_id==5 && h.h_state==true select h).Count()>0)
return 0;
else
return 1;
}
}
public void ProcessRequest(HttpContext context)
{
HotelDBContent db = new HotelDBContent();
string NewsFilePath = HttpContext.Current.Server.MapPath("\\") + "UploadFiles\\TitleImage\\";
string AdminFilePath = HttpContext.Current.Server.MapPath("\\") + "admin\\UploadFiles\\TitleImage\\";
context.Response.ContentType = "text/html";
HttpFileCollection files = context.Request.Files; // From中获取文件对象
string tag = Guid.NewGuid().ToString();
int roomId=Convert.ToInt32(context.Request.Form[0]);
List<Image> list1 = new List<Image>();
string count="..";
if (files.Count > 0)
{
string path = "";
string fileD = "../";
if (!Directory.Exists(AdminFilePath))
Directory.CreateDirectory(AdminFilePath);
if (!Directory.Exists(NewsFilePath))
Directory.CreateDirectory(NewsFilePath);
//路径字符串
Random rnd = new Random();
for (int i = 0; i < files.Count; i++)
{
#region
HttpPostedFile file = files[i];
//得到文件对象
if (file.ContentLength > 0)
{
int size = file.ContentLength;
string fileName = file.FileName;
Stream stream = file.InputStream;
System.Drawing.Image image = System.Drawing.Image.FromStream(stream);
int w = image.Width;
int h = image.Height;
string extension = Path.GetExtension(fileName);
int num = rnd.Next(5000, 10000); //文件名称
//// path = ;
////保存文件。
string fileI = "UploadFiles\\TitleImage\\" + num.ToString() + extension;
string thumbImgPath = context.Server.MapPath("/") + fileI;
//string AdminthumbImgPath = context.Server.MapPath("/") + "admin/" + fileI;
////thumbImg.Save();
//file.SaveAs(thumbImgPath);
//file.SaveAs(AdminthumbImgPath);
//filePath = context.Server.MapPath(filePath + "/" + fileName);
////将上传来的 文件数据 保存在 对应的 物理路径上
//hpFile.SaveAs(filePath);
string showImagePath = "..\\" + fileI;
//string showImagePath = string.Empty; ;
// && w > 500 && h > 300
string fileName1, message, oPath=string.Empty, tPath = string.Empty;
string d = DateTime.Now.ToString("yyyy-MM");
if (!new help.ImgHelper().MoreImgUpload(file, out fileName1, out message, ThumbImages_SavePath, OriginalImages_SavePath, ThumbImages_Height, ThumbImages_Wight, Images_Height, Images_Wight, ThumbImages_Size, out oPath, out tPath))
{
return;
}
string realOpath = ThumbImages_SavePath + d + "/" + "T_" + fileName1;
string realTpath = ThumbImages_SavePath + d + "/" + "T_" + fileName1;
if (size < maxSize && w >= 500 && h >= 300 )
{
// string message=
hotel_room_picture_info pic = new hotel_room_picture_info();
pic.h_r_p_pic_original_url = realOpath;
pic.h_r_p_pic_thumb_url = realTpath;
pic.souce_id = Convert.ToInt32(help.StringHelper.appSettings("source_id"));
pic.State = false;
pic.room_id = roomId;
pic.h_r_p_tag = tag;
pic.h_r_p_time = DateTime.Now;
db.roomImages.Add(pic);
db.SaveChanges();
}
else
{
Image IM = new Image();
IM.oURL = count + realOpath;
IM.tURL = count + realTpath; ;
message = string.Empty;
if (size > maxSize)
message = "图片大小小于10M";
if (w < 500 ||h < 300)
{
if (message == string.Empty)
message += "图片像素宽大于500px,高大于300px";
else
message += ",图片像素宽大于500px,高大于300px";
}
IM.Message = message;
IM.PID = 0;
list1.Add(IM);
}
}
#endregion
}
// List<hotel_picture_info> list = (from p in db.room where p.h_p_tag ==tag select new { p.h_p_pic_original_url, p.h_p_id }).ToList();
var pics = from p in db.roomImages where p.h_r_p_tag == tag select new { p.h_r_p_id, p.h_r_p_pic_original_url, p.h_r_p_pic_thumb_url, p.h_r_p_title };
foreach (var item in pics)
{
Image pic = new Image();
pic.oURL = ".." + item.h_r_p_pic_original_url;
pic.tURL = ".." + item.h_r_p_pic_thumb_url;
pic.Message ="";
pic.PID = item.h_r_p_id;
list1.Add(pic);
}
string str = JsonConvert.SerializeObject(list1, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore });
context.Response.Write(str);
//context.Response.Write(showImagePath + "$" + "1089023"); //返回文件存储后的路径，用于回显。
//context.Response.End();
}
}
//修改房价
public int uPrice(string id, string roomId, string startDate, string EndDate, string value)
{
int Id, room_id, count = 0; decimal price; decimal.TryParse(value, out price); int.TryParse(id, out Id); int.TryParse(roomId, out room_id); DateTime.TryParse(startDate, out start); DateTime.TryParse(EndDate, out end);
hotel_room_RP_price_info p = new hotel_room_RP_price_info();
using (db = new HotelDBContent())
{
count = (from r in db.rooms where r.hotel_id == Id && r.room_id == room_id select r).Count();
}
if (count > 0)
result = new Hotel_room_RP_price_batch().InsertPriceBatch(new hotel_room_RP_price_info() { hotel_id = Id, room_id = room_id, room_rp_start_time = start, room_rp_end_time = end, room_rp_price = price }) == true && DBhelp.CallProc(room_id, "proc_hotel_room_RP_price_batch_roomid") == true ? 1 : 0;
// result = new Hotel_room_RP_price_batch().InsertPriceBatch(new hotel_room_RP_price_info() { hotel_id = Id, room_id = room_id, room_rp_start_time = start, room_rp_end_time = end, room_rp_price = price }) == true && DBhelp.CallProc(room_id, "proc_hotel_room_RP_price_batch_roomid") == true ? 1 : 0;
return result;
// return View("MyPrix", getData(id, startDate, EndDate));
}
//删除公寓
public int delApart(string hotelId)
{
try
{
int.TryParse(hotelId, out hotel_id); string u_id = new HotelInfoHelp().getUId();
using (db = new HotelDBContent())
{
((from h in db.hotel where h.hotel_id == hotel_id && h.source_id == 5 && h.u_id == u_id select h).SingleOrDefault()).h_state=false;
result = db.SaveChanges() > 0 ? 1 : 0;
}
}
catch (Exception)
{
result = 0;
}
return result;
}
public ActionResult Create(GuaranteeRule guaranteerule)
{
setName();
using (db = new HotelDBContent())
{
if (guaranteerule.id > 0)
{
db.Entry(guaranteerule).State = EntityState.Modified;
}
else
{
Hotel_room_RP_info ratePlan = new Hotel_room_RP_info();
ratePlan.hotel_id = guaranteerule.hotel_id;
ratePlan.h_room_rp_name_cn = "标准价";
int ratePlanId = help.HotelInfoHelp.getRatePlanId(ratePlan);
// var rp=(from r in db.rps where r.hotel_id==guaranteerule.hotel_id && r.h_room_rp_state==true && r.h_room_rp_name_cn=="标准价"select r.h_room_rp_id).SingleOrDefault();
guaranteerule.h_room_rp_id = ratePlanId;
if (ModelState.IsValid)
{
db.gu.Add(guaranteerule);
}
db.SaveChanges();
}
}
GetData(guaranteerule.hotel_id.ToString());
return View("MyGuarantee", new GuaranteeRule() { GuaranteeType = "FirstNightCost",ChangeRule=1 });
}
//所有促销类型
public static List<DrrModes> getDrrModeList(string uId)
{
using (db = new HotelDBContent())
{
return (from h in db.drrmodes select h).ToList();
}
}
/// <summary>
/// 得到RatePlanId
/// </summary>
/// <param name="rp"></param>
/// <returns></returns>
public static int getRatePlanId(Hotel_room_RP_info rp)
{
int ratePlanId = 0;
rp.RatePlanId = Guid.NewGuid().ToString();
rp.h_room_rp_is_to_store_pay = true;
rp.h_room_rp_check_in = "00:00:00";
rp.h_room_rp_check_out = "23:59:00";
rp.h_room_rp_least_day = 1;
rp.h_room_rp_longest_day = 365;
rp.h_room_rp_ctime = DateTime.Now;
// rp.h_room_rp_name_cn = "";
using (HotelDBContent db = new HotelDBContent())
{
var tempRp = (from r in db.rps where r.h_room_rp_name_cn == rp.h_room_rp_name_cn && r.hotel_id == rp.hotel_id select r).SingleOrDefault();
if (tempRp != null)
{
ratePlanId = tempRp.h_room_rp_id; ;
}
else
{
db.rps.Add(rp);
db.SaveChanges();
//取rpId
ratePlanId = (from r in db.rps where r.RatePlanId == rp.RatePlanId select r.h_room_rp_id).SingleOrDefault();
}
}
return ratePlanId;
}
///// <summary>
///// 验证酒店名是否存在
///// </summary>
///// <param name="text"></param>
///// <returns></returns>
//public int IsOk(string text)
//{
// using (db = new HotelDBContent())
// {
// if ((from h in db.hotel where h.h_name_cn == text select h).Count() > 0 || (from h in new HotelDBContent("").hotel where h.h_name_cn == text select h).Count() > 0)
// return 0;
// else
// return 1;
// }
//}
/// <summary>
/// 模糊查询公寓
/// </summary>
/// <param name="text"></param>
/// <returns></returns>
public ActionResult FindHotel(string text)
{
// Response.Write(text);
hotel_info hotel=null;
using (db = new HotelDBContent())
{
// hotel = (from h in db.hotel where h.h_name_cn == text.Trim() && h.source_id == 4 select new { h=h.h_name_cn,name=h.h_city});
hotel = (from h in db.hotel where h.h_name_cn == text.Trim() && h.source_id == 4 select h).FirstOrDefault();
if (hotel != null)
{
hotel.hotel_id = 0;
//var tempHotel=(from h1 in db.hotel where h1.h_name_cn==text.Trim() && h1.source_id==5 select h1).Count();
// ViewBag.exit = tempHotel > 0 ? 1 : 0;
hotel.h_province = (from c in db.citys where c.City_id == hotel.h_city select c.Province_id).SingleOrDefault();
string[] serveice = hotel.GeneralAmenities.Split('、');
string[] temp = new string[serveice.Length];
for (int i = 0; i < serveice.Length; i++)
{
temp[i] = serveice[i];
}
var GeneraIds = from g in db.general where temp.Contains(g.Title) select g.Id;
string GIds = string.Empty;
foreach (var item in GeneraIds)
{
if (string.IsNullOrEmpty(GIds))
GIds += item;
else
GIds += "," + item;
}
hotel.GeneralAmenities = GIds;
hotel.IntroEditor = hotel.IntroEditor.TrimEnd();
var tempRoom = ((from o in db.hotel where o.h_name_cn == text.Trim() && o.source_id == 5 && o.h_state == true select o).Count());
ViewBag.exit = tempRoom > 0 ? 0 : 1;
}
}
getHelpData();
if(hotel!=null)
return View("Create", hotel);
else
return View("Create",new hotel_info());
}
/// <summary>
/// //匹配房型
/// </summary>
/// <param name="roomId"></param>
/// <param name="name"></param>
/// <param name="hotelId"></param>
/// <returns></returns>
public ActionResult selectedRoom(string roomId, string hotelId)
{
int room_id = 0; int.TryParse(roomId, out room_id);// int hotel_id = Convert.ToInt32(hotelId);
int hotel_Id = 0; int.TryParse(hotelId, out hotel_Id);
hotel_room_info room = new hotel_room_info();
using (db = new HotelDBContent())
{
room = (from r in db.rooms where r.room_id == room_id select r).SingleOrDefault();
room.room_id = 0; room.hotel_id = 0;
string tempBed = string.Empty;
if (!string.IsNullOrEmpty(room.h_r_bed_type))
{
string []beds= room.h_r_bed_type.Split(',');
for (int i = 0; i < beds.Length; i++)
{
tempBed += beds[i].Contains("|") ? beds[i] : beds[i] + "|" + 1+",";
}
}
room.h_r_bed_type = tempBed.LastIndexOf(",") != -1 ? tempBed.Substring(0, tempBed.Length - 1) : tempBed;
var tempRoom = ((from o in db.rooms where o.h_r_name_cn == room.h_r_name_cn.Trim() && o.hotel_id == hotel_Id select o).Count());
ViewBag.exit = tempRoom > 0 ? 0 : 1;
}
helpdata(hotel_Id);
if(room!=null)
return View("MyRoom", room);
else
return View("MyRoom", new hotel_room_info());
}
/// <summary>
/// //匹配房型
/// </summary>
/// <param name="roomId"></param>
/// <param name="name"></param>
/// <param name="hotelId"></param>
/// <returns></returns>
public ActionResult selectedRoom(string roomId, string name, string hotelId)
{
int room_id = 0; int.TryParse(roomId, out room_id);// int hotel_id = Convert.ToInt32(hotelId);
int hotel_Id = 0; int.TryParse(hotelId, out hotel_Id);
hotel_room_info room = new hotel_room_info();
using (db = new HotelDBContent())
{
room = (from r in db.rooms where r.room_id == room_id select r).SingleOrDefault();
//var tempRoom = ((from o in db.rooms where o.h_r_name_cn == name.Trim() && o.hotel_id == hotel_Id select o).Count());
//ViewBag.exit = tempRoom > 0 ? 1 : 0;
}
helpData(hotel_Id);
if (room != null)
return View("MyRoom", room);
else
return View("MyRoom", new hotel_room_info());
}
public ActionResult CreateHotel(hotel_info hotel_info)
{
try
{
//hotel_info.u_id = new HotelInfoHelp().getUId();
hotel_info.source_id = Convert.ToInt32(help.StringHelper.appSettings("source_id")); ;
hotel_info.h_id = Guid.NewGuid().ToString();
hotel_info.h_state = true;
hotel_info.h_utime = DateTime.Now;
hotel_info.CheckState = 2;
hotel_info.h_ctime = DateTime.Now;
hotel_info.decorateTime = hotel_info.decorateTime == Convert.ToDateTime("0001/1/1 0:00:00") || hotel_info.decorateTime ==null? Convert.ToDateTime("1900-01") : hotel_info.decorateTime;
hotel_info.h_opening_time = hotel_info.h_opening_time == Convert.ToDateTime("0001/1/1 0:00:00") ? Convert.ToDateTime("1900-01") : hotel_info.h_opening_time;
//hotel_info.h_room_count = hotel_info.h_room_count == 0 ? 1 : hotel_info.h_room_count;
hotel_info.u_id = hotel_info.h_mobile_phone;
using(db=new HotelDBContent())
{
if (hotel_info.hotel_id > 0)
{
db.Entry(hotel_info).State = EntityState.Modified;
}
else
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
//if (ModelState.IsValid)
//{
db.hotel.Add(hotel_info);
// result = db.SaveChanges() > 0 ? 1 : 0;
var f = (from h in db.hotel where h.h_name_cn == hotel_info.h_name_cn && h.source_id == 4 select h).FirstOrDefault();
if (f != null)
f.h_state = false; //把对应艺龙的酒店干掉
// return RedirectToAction("Room/Create/"+ddh.hotel_id);
//}
}
result = db.SaveChanges() > 0 ? 1 : 0;
if (result > 0)
{
var ddh = db.hotel.Select(h => new { h.hotel_id, h.h_id }).Single(h => h.h_id == hotel_info.h_id);
return RedirectToAction("room", "AddHotel", new { hotelId = ddh.hotel_id });
}
}
}
catch (Exception e)
{
throw e;
help.DBhelp.log("新建公寓基本信息"+e.ToString());
}
ViewBag.sign = result; getHelpData();
return View("Create", hotel_info);
}
public List<GuaranteeRule> GuraranteeList(int hotelId)
{
//用户ID所有的酒店
HotelDBContent db = new HotelDBContent();
return (from h in db.gu where h.hotel_id == hotelId select h).ToList();
}
//修改房态
public int uStatus(string id, string roomId, string startDate, string EndDate, string CanSell, string status)
{
int result = 0;
int Id, room_id, count = 0; int Rstatus; int RCanSell; int.TryParse(status, out Rstatus); int.TryParse(CanSell, out RCanSell); int.TryParse(id, out Id); int.TryParse(roomId, out room_id); DateTime.TryParse(startDate, out start); DateTime.TryParse(EndDate, out end);
using (db = new HotelDBContent())
{
count = (from r in db.rooms where r.hotel_id == Id && r.room_id == room_id select r).Count();
}
if (count > 0)
result = new RoomStatus_batch().insertStatuBatch(new RoomStatus_batch() { hotel_id = Id, room_id = room_id, r_s_time = start, EndDate = end, eBeds = RCanSell,r_s_status = Rstatus==1?true:false}) == true && DBhelp.CallProc(room_id, "proc_hotel_room_ebeds_batch_roomid") == true ? 1 : 0;
// result = new RoomStatus_batch().insertStatuBatch(new RoomStatus_batch() { hotel_id = Id, room_id = room_id, r_s_time = start, EndDate = end, eBeds = RCanSell }) == true?1 : 0;
return result;
}
//验证房型是否存在
public int IsOk(string id, string text)
{
int drrId; int.TryParse(id, out drrId);
using (db = new HotelDBContent())
{
if ((from h in db.drrs where h.DrrName == text && h.hotel_id == drrId select h).Count() > 0)
return 0;
else
return 1;
}
}
public List<Gift> GiftList(int hotelId )
{
HotelDBContent db = new HotelDBContent();
string uId = "test1";
//用户ID所有的酒店
return (from h in db.gifts where h.hotel_id==hotelId select h).ToList();
}