/// <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();
}
}
