コード例 #1
0
        public void BookShow()
        {
            brModel = brBll.GetModel(Convert.ToInt32(id));
            if (brModel != null)
            {
                List <Model.Book_Rdetail> list = bllbr.GetListModel("Book_no='" + brModel.book_no + "'");
                if (list != null)
                {
                    //预定人
                    this.lbname.Text = brModel.book_Name;
                    //号码
                    this.lbtele.Text = brModel.tele_no;

                    //客人来源
                    Model.guest_source gsModel = gsBll.GetModel(Convert.ToInt32(brModel.source_id));
                    this.lbsource.Text = gsModel.gs_name;

                    //房型
                    Model.room_type rtModel = rtBll.GetModel(Convert.ToInt32(list[0].Real_type_Id));
                    this.lbroomtype.Text = rtModel.room_name;

                    //房数
                    this.lbrealnum.Text = list.Count.ToString();

                    //可退订金
                    this.lbdeposit.Text = (Convert.ToDouble(brModel.deposit)).ToString();
                }
            }
        }
コード例 #2
0
        public void BookShow()
        {
            brModel = brBll.GetModel(Convert.ToInt32(id));
            //预定人
            this.lbname.Text = brModel.book_Name;
            //号码
            this.lbtele.Text = brModel.tele_no;

            //客人来源
            Model.guest_source gsModel = gsBll.GetModel(Convert.ToInt32(brModel.source_id));
            this.lbsource.Text = gsModel.gs_name;

            //房型
            Model.room_type rtModel = rtBll.GetModel(Convert.ToInt32(brModel.real_type_id));

            //可退订金
            this.lbdeposit.Text = (Convert.ToDouble(brModel.deposit)).ToString();

            //来店时间
            this.lbtimeto.Text = brModel.time_to.ToString();

            //离店时间
            this.lbtimefrom.Text = brModel.time_from.ToString();

            //绑定房型下拉
        }
コード例 #3
0
        /*
         * /// <summary>
         * /// 分页获取数据列表
         * /// </summary>
         * public DataSet GetList(int PageSize,int PageIndex,string strWhere)
         * {
         *      SqlParameter[] parameters = {
         *                      new SqlParameter("@tblName", SqlDbType.VarChar, 255),
         *                      new SqlParameter("@fldName", SqlDbType.VarChar, 255),
         *                      new SqlParameter("@PageSize", SqlDbType.Int),
         *                      new SqlParameter("@PageIndex", SqlDbType.Int),
         *                      new SqlParameter("@IsReCount", SqlDbType.Bit),
         *                      new SqlParameter("@OrderType", SqlDbType.Bit),
         *                      new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
         *                      };
         *      parameters[0].Value = "book_room";
         *      parameters[1].Value = "book_id";
         *      parameters[2].Value = PageSize;
         *      parameters[3].Value = PageIndex;
         *      parameters[4].Value = 0;
         *      parameters[5].Value = 0;
         *      parameters[6].Value = strWhere;
         *      return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
         * }*/

        #endregion  BasicMethod
        #region  ExtensionMethod

        #endregion  ExtensionMethod

        //以标识列获得对象
        public Model.book_room GetRealNum(int state_id)
        {
            string sql = "SELECT REAL_NUM FROM " + "book_room" + " WHERE state_id = @state_id";

            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@state_id", state_id));
                if (reader.Read())
                {
                    Model.book_room model = new Model.book_room();

                    model.real_num = (int)reader["real_num"];//外键

                    reader.Close();

                    return(model);
                }
                else
                {
                    reader.Close();
                    return(null);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
コード例 #4
0
        //取消按钮不做物理删除,改变状态
        protected void Button1_Click(object sender, EventArgs e)
        {
            //改变状态,先写死,到时候再具体看。

            brModel              = brBll.GetModel(Convert.ToInt32(id));
            brModel.state_id     = 5;
            brModel.back_deposit = Convert.ToDecimal(this.txtdeposit.Value);
            //判断退订金不能大于可退订金
            if (Convert.ToDecimal(txtdeposit.Value) > brModel.deposit)
            {
                MessageBox.Show(this, "退订金" + txtdeposit.Value + "不能大于" + brModel.deposit + "可退订金");
                return;
            }
            brModel.meth_pay_id = Convert.ToInt16(meth_payDdl.SelectedValue);
            brModel.remark      = this.txtremark.Value;
            if (brModel.Accounts != "")//如果是单位被取消  增加取消次数
            {
                BLL.customer   bllcuns  = new BLL.customer();
                Model.customer modelcus = bllcuns.GetAccounts(brModel.Accounts);
                if (modelcus != null)
                {
                    modelcus.xqBook += 1;
                    bllcuns.Update(modelcus);
                }
            }
            else
            {
            }
            //写入入账表
            Model.goods_account gaModel = new Model.goods_account();
            gaModel.ga_name = "退订金";
            //gaModel.ga_roomNumber = Convert.ToInt32(brModel.room_number);
            gaModel.ga_zffs_id = Convert.ToInt16(meth_payDdl.SelectedValue);
            gaModel.ga_number  = brModel.book_no;
            gaModel.ga_date    = System.DateTime.Now;
            gaModel.ga_price   = Convert.ToDecimal(txtdeposit.Value) * -1;
            gaModel.ga_people  = UserNow.UserID;
            //gaModel.ga_people = Session["UserId"].ToString();
            gabll.Add(gaModel);

            bool Result = brBll.Update(brModel);
            List <Model.Book_Rdetail> listbr = bllbr.GetListModel("book_no='" + brModel.book_no + "'");

            foreach (Model.Book_Rdetail item in listbr)
            {
                item.RoomTypeID = 5;
                bllbr.Update(item);
            }
            if (Result == true)
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script language=\"javascript\">if(confirm('取消预定成功!是否打印退款单?')){ ShowDivs(this,'" + brModel.book_no + "') }else{ ShowTabs('预定管理');}</script>");
                //Response.Redirect("BookList.aspx");
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('取消失败!');parent.Window_Close();</script>");
                //Response.Redirect("BookList.aspx");
            }
        }
コード例 #5
0
 public override void SonLoad()
 {
     id = "Y2015411111326";
     if (Request["id"] != null)
     {
         id = Request["id"].ToString();
         List <Model.book_room> listbr = bllbr.GetModelList("Book_no='" + id + "'");
         if (listbr != null)
         {
             nowModel = listbr[0];
             if (Request["desp"] != null)
             {
                 nowModel.deposit = Convert.ToDecimal(Request["desp"]);
             }
         }
         Bind();
     }
 }
コード例 #6
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            brModel = brBll.GetModel(Convert.ToInt32(id));
            //判断退订金不能大于可退订金
            if (Convert.ToDecimal(adddeposit.Value) < 0)
            {
                MessageBox.Show(this, "补交订金请输入大于0的数字");
                return;
            }
            brModel.meth_pay_id = Convert.ToInt16(meth_payDdl.SelectedValue);
            brModel.remark      = this.txtremark.Value;
            brModel.deposit     = brModel.deposit + Convert.ToDecimal(this.adddeposit.Value);


            //写入入账表
            Model.goods_account gaModel = new Model.goods_account();
            gaModel.ga_name = "补交订金";
            //gaModel.ga_roomNumber = Convert.ToInt32(brModel.room_number);
            gaModel.ga_zffs_id   = Convert.ToInt16(meth_payDdl.SelectedValue);
            gaModel.ga_date      = System.DateTime.Now;
            gaModel.ga_sum_price = brModel.deposit;
            //gaModel.ga_people = Session["UserId"].ToString();
            gabll.Add(gaModel);

            bool Result = brBll.Update(brModel);

            if (Result == true)
            {
                //Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>(\"补订金成功\", \"info\",'../','');</script>");
                // Response.Redirect("BookList.aspx");
                //待修改
                ClientScript.RegisterStartupScript(GetType(), "message", "<script language=\"javascript\">if(confirm('补交定金成功!是否打印收款单?')){ ShowDivs('" + brModel.book_no + "') }else{ ShowTabs('预定管理');}</script>");
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>(\"系统繁忙,请稍后再试!\", \"info\",'../','');</script>");
                Response.Redirect("BookList.aspx");
            }
        }
コード例 #7
0
        //把预定的信息绑定到入住信息里面
        public void bindInfo()
        {
            //房型
            Model.book_room bkmodel = bkBll.GetModel(ids);
            Model.room_type rtmodel = fxBll.GetModel(Convert.ToInt32(bkmodel.real_type_id));
            this.ddroomtype.SelectedValue = rtmodel.room_name;
            //设为不可编辑
            this.ddroomtype.Enabled = false;

            //房价
            this.txt_money.Value = (Convert.ToDouble(bkmodel.real_price)).ToString();

            //姓名
            this.txt_name.Value = bkmodel.book_Name;

            //电话
            this.txt_lxphone.Value = bkmodel.tele_no;

            //预住天数
            this.txt_Day.Value = bkmodel.real_num.ToString();

            //时间
            txt_rzdate.Value = System.DateTime.Now.ToString();
        }
コード例 #8
0
        public override void SonLoad()
        {
            Model.SysParamter modelsys = bllsys.GetModel(1);
            isok.Value = modelsys.IsCy.ToString();
            RoomTypeDdl.Attributes.Add("onchange", "selectChange(this)");
            if (!IsPostBack)
            {
                GuestSourceData();
                MethPayData();
                RoomTypeData();
                //BindHouseNumber();
                HouseShameData();
                RealPrice();
                BindOkNum(Convert.ToInt32(this.RoomTypeDdl.SelectedValue));
                maxNum.InnerText = BindMaxNum(Convert.ToInt32(this.RoomTypeDdl.SelectedValue));
                string type = Request.QueryString["type"].ToString();
                if (type == "add")
                {
                    lblmsg.Text = "新增";
                }
                else if (type == "edit")
                {
                    lblmsg.Text        = "修改";
                    deposit.Disabled   = true;
                    BookAddButton.Text = "更新";
                    id                = Convert.ToInt32(Request.QueryString["id"].ToString());
                    nowModel          = bllbr.GetModel(id);
                    book_no_hid.Value = nowModel.book_no;
                    //通过ID获得实体,然后为控件赋值
                    book_name.Value              = nowModel.book_Name;
                    tele_no.Value                = nowModel.tele_no;
                    onli_no.Value                = nowModel.onli_no;
                    real_time.Value              = nowModel.time_to.ToString();
                    time_from.Value              = Convert.ToDateTime(nowModel.time_from).ToString();
                    time_to.Value                = Convert.ToDateTime(nowModel.real_time).ToString("yyyy-MM-dd");
                    mem_cardNo.Value             = nowModel.mem_cardno;
                    GuarWayDll.SelectedValue     = nowModel.guar_way;
                    GuestSourceDdl.SelectedValue = nowModel.source_id.ToString();
                    MethPayDdl.SelectedValue     = nowModel.meth_pay_id.ToString();
                    deposit.Value                = nowModel.deposit.ToString();
                    textRemaker.Value            = nowModel.remark;
                    if (nowModel.Accounts != "" && nowModel.Accounts != null)
                    {
                        BLL.customer bllcus = new BLL.customer();
                        accounts.Value = nowModel.Accounts;//协议单位编号
                        CpId.Value     = nowModel.CpID.ToString();
                        Model.customer modelcus = bllcus.GetAccounts(nowModel.Accounts);
                        customer.Value = modelcus.cName;
                    }
                    Dictionary <int, string>  dic    = new Dictionary <int, string>();
                    List <Model.Book_Rdetail> listbr = bllrd.GetListModel("Book_no='" + nowModel.book_no + "'");

                    foreach (Model.Book_Rdetail item in listbr)
                    {
                        if (dic.ContainsKey(item.Real_type_Id))
                        {
                            continue;
                        }
                        dic.Add(item.Real_type_Id, "true");
                        List <Model.Book_Rdetail> lists = listbr.Where(d => d.Real_type_Id == item.Real_type_Id).ToList();
                        if (lists.Count > 1)
                        {
                            //item = lists[0];
                        }
                        sbDel.Append("<tr class=\"tr\"><td class=\"w30\"><span>房 型:</span></td>");
                        sbDel.Append("<td class=\"w70\"><select name=\"RoomTypeDdl\" id=\"RoomTypeDdl\" onchange=\"selectChange(this)\">");
                        GetAllType(item);
                        sbDel.Append("</select></td>");
                        sbDel.Append("<td class=\"w30\">");
                        sbDel.Append("<span>方 案:</span>");
                        sbDel.Append("</td>");
                        sbDel.Append("<td class=\"w70\">");
                        sbDel.Append("<select name=\"HouseShameDdl\" id=\"HouseShameDdl\">");
                        GetAllYh(item);
                        sbDel.Append("</select>");
                        sbDel.Append("</td>");
                        sbDel.Append("<td class=\"w30\">");
                        sbDel.Append("<span>房 价:</span>");
                        sbDel.Append("</td>");

                        sbDel.Append("<td class=\"w70\">");
                        sbDel.Append("<input name=\"real_price\" type=\"text\" id=\"real_price\" class=\"txtprice\" value=\"" + item.Real_Price + "\">");
                        sbDel.Append("</td>");
                        sbDel.Append("<td class=\"w70\">可预定数:<span  id=\"txtOkNum\" runat=\"server\" class=\"txtprice\"  >" + BindOkNum1(item.Real_type_Id) + "</span><span runat=\"server\" id=\"maxNum\" style=\" display:none;\">" + BindMaxNum(item.Real_type_Id) + "</span></td>");
                        sbDel.Append("<td class=\"w50\">");
                        sbDel.Append("<span>房间数量:</span>");
                        sbDel.Append("</td>");
                        sbDel.Append("<td class=\"w\" style=\"width:220px;\">");
                        sbDel.Append("<p onclick=\"SaleRealNum(this)\" class=\"jians\">");
                        sbDel.Append("-</p>");
                        sbDel.Append("<p style=\"float: left;\">");
                        if (lists.Count > 1)
                        {
                            sbDel.Append("  <input name=\"real_num\" type=\"text\" id=\"real_num\" value=\"" + lists.Count + "\" class=\"number fjslInp\"></p>");
                        }
                        else
                        {
                            sbDel.Append("  <input name=\"real_num\" type=\"text\" id=\"real_num\" value=\"" + item.Real_num + "\" class=\"number fjslInp\"></p>");
                        }
                        sbDel.Append("<p onclick=\"addRealNum(this)\" class=\"jia\">");
                        sbDel.Append("     +</p>");
                        sbDel.Append(" <p onclick=\"funAddTable()\" class=\"addBook\">");
                        sbDel.Append("       添加</p>");
                        sbDel.Append("  <p class=\"delBook\" onclick=\"DelTr(this)\">");
                        sbDel.Append("      删除</p>");
                        sbDel.Append("</td>");
                        sbDel.Append(" <td class=\"w30\">");
                        sbDel.Append("     <span>房 号:</span>");
                        sbDel.Append("   </td>");
                        sbDel.Append("   <td class=\"w30\" style=\"width:60px;\">");
                        if (lists.Count > 1)
                        {
                            sbDel.Append("     <span id=\"fh\">" + Geta(lists) + "</span><span class=\"yffh addBook\" onclick=\"ShowDiog(this)\" style=\" cursor:pointer;\">预 分</span>");
                        }
                        else
                        {
                            sbDel.Append("     <span id=\"fh\"><a>" + item.Room_number + "</a></span><span class=\"yffh addBook\" onclick=\"ShowDiog(this)\" style=\" cursor:pointer;\">预 分</span>");
                        }
                        sbDel.Append("     </td>");
                        sbDel.Append("    <td class=\"w70\">");
                        sbDel.Append("       <span id=\"HouseNumDdl\"></span>");
                        sbDel.Append("   </td>");
                        sbDel.Append("  </tr>");
                    }
                    if (Request["isok"] != null)
                    {
                        bool b = Convert.ToBoolean(Request["isok"]);
                        if (b)
                        {
                            BookAddButton.Style.Add("display", "none");
                        }
                    }
                }
            }
        }
コード例 #9
0
 /// <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();
     }
 }