protected void bus_add_Click(object sender, EventArgs e) { string order = orderid.Value; List <Model.goods_account> listga = bllga.GetModelList1("ga_occuid='" + order + "'"); if (listga.Count > 0) { Model.goods_account gamodel = listga[0]; string Amount = Request["Amount"]; gamodel.ga_price = Convert.ToDecimal(Amount) * -1; gamodel.ga_sum_price = 0; gamodel.ga_Type = 12; gamodel.ga_name = "积分优惠"; gamodel.ga_isys = 0; gamodel.ga_date = DateTime.Now; gamodel.ga_remker = "积分抵换" + Amount; if (bllga.Add(gamodel) > 0) { Model.mRecords modelmr = new Model.mRecords(); string mid = Request["CardNo"]; modelmr.mmid = mid; modelmr.Price = Convert.ToInt32(Amount); modelmr.Type = 4; bllmr.Add(modelmr); } Response.Write("<script>alert('兑换成功');parent.Window_Close();</script>"); } }
/// <summary> /// 根据消费金额添加一定的积分 /// </summary> private void AddJf() { int pric = Convert.ToInt32(txt_xfMoney.Value); string cardid = hycard.Value; Model.member modelmem = bllmem.GetModel(cardid); if (modelmem != null) { Model.memberType modelmt = bllmt.GetModel(Convert.ToInt32(modelmem.Mtype)); if (modelmt.IntegraIs) //如果是积分卡 { if (modelmt.IsConsump) //如果是按消费积分 { if (modelmt.XfPrice.ToString() != "" && modelmt.XfConsump.ToString() != "") { int sumzj = 0; int xfPrice = Convert.ToInt32(modelmt.XfPrice); int XfConsump = Convert.ToInt32(modelmt.XfConsump); int ds = pric / xfPrice; for (int i = 0; i < ds; i++) { sumzj += XfConsump; } Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = cardid; modelmr.Price = sumzj; modelmr.Type = 3; modelmr.Remark = "赠送消费积分"; bllmr.Add(modelmr); } } } if (modelmt.IsLive) //如果按入住天数计算 { DateTime date1 = Convert.ToDateTime(fmOc.GetModel(ids).occ_time.ToString()); DateTime date2 = System.DateTime.Now; int cc = date2.Day - date1.Day; if (cc < 0) { cc = (Convert.ToDateTime(date2.ToString("yyyy-MM-dd")) - Convert.ToDateTime(date1.ToString("yyyy-MM-dd"))).Days; } int sumzj = 0; int m = Convert.ToInt32(modelmt.LiveNum); int lp = Convert.ToInt32(modelmt.LiveConsump); int ds = cc / m; for (int i = 0; i < ds; i++) { sumzj += lp; } Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = cardid; modelmr.Price = sumzj; modelmr.Type = 3; modelmr.Remark = "赠送入住天数积分"; bllmr.Add(modelmr); } } }
/// <summary> /// 储值卡支付。要扣除该会员相应的金额 /// </summary> private void MemberAddPrice(int price) { Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = payHycard.Value; modelmr.Price = price; modelmr.Remark = ""; modelmr.Type = 3; bllmr.Add(modelmr); }
protected void btnSubmit_click(object sender, EventArgs e) { if (Request.Form["mid"].ToString() != "") { if (Request.Form["hidjf"].ToString() != "") { Model.mRecords modemr = new Model.mRecords(); modemr.mmid = Request.Form["mid"]; modemr.Price = Convert.ToInt32(Request.Form["hidjf"]); modemr.Type = 4; modemr.Remark = ""; bllmr.Add(modemr);; ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('兑换成功!!');parent.window.location.reload()</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请选择商品!!');</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请选择需要操作的会员!!');</script>"); } }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdds_Click(object sender, EventArgs e) { string strSQL = ""; string sql = ""; string Strsql = ""; int count = 0; for (int i = 0; i < GrdCostRoom.Rows.Count; i++) { CheckBox cbxCheck = GrdCostRoom.Rows[i].FindControl("cbxCheck") as CheckBox; if (cbxCheck.Checked) { if (cbxCheck.Enabled == true) { HiddenField hidNewsId = GrdCostRoom.Rows[i].FindControl("hidId") as HiddenField; if (occid == "") { occid = hidNewsId.Value; } else { occid += "," + hidNewsId.Value; } sql = " update room_number set Rn_state=4 where Rn_roomNum='" + fmOc.GetModel(Convert.ToInt32(hidNewsId.Value)).room_number + "' "; Helper.AddRoom(fmOc.GetModel(Convert.ToInt32(hidNewsId.Value)).room_number); fmroom.Updates(sql); } count++; } } strSQL = "update occu_infor set state_id=3,occ_TfTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where occ_id in (" + occid + ")"; fmOc.Updates(strSQL); if (GrdCostRoom.Rows.Count == count) { Strsql = "update goods_account set ga_sfacount='是' where ga_occuid ='" + fmOc.GetModel(ids).order_id + "' "; if (!Helper.IsJz(fmOc.GetModel(ids).order_id)) { string[] txtzffs = txt_zhfsMoney.Value.Split('|'); decimal sumprice = 0; for (int j = 0; j < txtzffs.Length - 1; j++) { Model.goods_account model = new Model.goods_account(); model.ga_people = UserNow.UserID; if (txtzffs[j].Split('#')[0] == "10") { MemberAddPrice(Convert.ToInt32(txtzffs[j].Split('#')[1])); } model.ga_zffs_id = Convert.ToInt32(txtzffs[j].Split('#')[0]); model.ga_price = Convert.ToDecimal(txtzffs[j].Split('#')[1]); sumprice += Convert.ToDecimal(model.ga_price); model.ga_sfacount = "是"; model.ga_name = "结账收款"; model.ga_occuid = fmOc.GetModel(ids).order_id; model.ga_sum_price = 0; model.ga_Type = 4; model.ga_number = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); model.ga_date = System.DateTime.Now; model.ga_roomNumber = fmOc.GetModel(ids).room_number.ToString(); fmrz.Add(model); } if (Convert.ToDecimal(xfprice.Value) < sumprice + Convert.ToDecimal(skPrice.Value)) { Model.goods_account model = new Model.goods_account(); model.ga_people = UserNow.UserID; model.ga_price = (sumprice + Convert.ToDecimal(skPrice.Value) - Convert.ToDecimal(xfprice.Value)) * -1; model.ga_sfacount = "是"; model.ga_name = "结账退款"; model.ga_occuid = fmOc.GetModel(ids).order_id; model.ga_sum_price = 0; model.ga_Type = 6; model.ga_zffs_id = 2; model.ga_number = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); model.ga_date = System.DateTime.Now; model.ga_roomNumber = fmOc.GetModel(ids).room_number.ToString(); if (fmrz.Add(model) > 0) { Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = fmOc.GetModel(ids).mem_cardno; modelmr.Price = Convert.ToInt32(model.ga_price); modelmr.Type = 1; modelmr.Remark = ""; bllmr.Add(modelmr); } } if (fmrz.Updates(Strsql)) { XieYi(); // Maticsoft.Common.MessageBox.ShowAndRedirect(this, "!", ""); string strqwl = "update occu_infor set tuifaId=2 where occ_id in (" + occid + ")"; fmOc.Updates(strqwl); Helper.AddRoom(fmOc.GetModel(ids).room_number); AddJf(); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'> MarkCard(" + orderid + ");</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>Erroc();</script>"); } } else { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "退房成功!", ""); string strqwl = "update occu_infor set tuifaId=1,continuelive=1 where occ_id in (" + ids + ")"; fmOc.Updates(strqwl); //ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('退房成功');parent.Window_Close();</script>"); } }
//冲值保存 protected void BtnSaveClick(object sender, EventArgs e) { if (Request.Form["mid"].ToString() != "") { if (BtnSave.Value == "会员充值") { if (Request.Form["PaymentAmount"].ToString() != "") { int PaymentAmount = Convert.ToInt32(Request.Form["PaymentAmount"]); int TopAmount = Convert.ToInt32(Request.Form["TopAmount"]); int GiveScore = Convert.ToInt32(Request.Form["GiveScore"]); Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = Request.Form["mid"]; modelmr.Price = TopAmount; modelmr.Remark = ""; modelmr.Type = 1; bllmr.Add(modelmr); Model.mRecords modelmr1 = new Model.mRecords(); modelmr1.mmid = Request.Form["mid"]; modelmr1.Price = GiveScore; modelmr1.Remark = ""; modelmr1.Type = 3; bllmr.Add(modelmr1); BC(TopAmount, "会员冲值收款", PayMethod.SelectedValue, 21); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('成功');parent.window.location.reload();</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请输入正确的收款金额!!');</script>"); } } else if (BtnSave.Value == "积分调整") { if (Request.Form["AdjustScore"].ToString() != "") { int AdjustScore = Convert.ToInt32(Request.Form["AdjustScore"]); Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = Request.Form["mid"]; modelmr.Price = AdjustScore; modelmr.Remark = ""; if (modelmr.Price > 0) { modelmr.Type = 3; } else { modelmr.Type = 4; modelmr.Price = modelmr.Price * -1; } bllmr.Add(modelmr); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('成功');parent.window.location.reload();</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请输入正确的积分!');</script>"); } } else if (BtnSave.Value == "会员挂失") { string mid = Request.Form["mid"]; Model.member modelmen = bllmen.GetModel(mid); modelmen.Statid = 2; bllmen.Update(modelmen); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('挂失成功');parent.window.location.reload();</script>"); } else if (BtnSave.Value == "会员换卡") { if (Request.Form["NewCard"].ToString() != "") { string mid = Request.Form["mid"]; string NewCard = Request.Form["NewCard"]; Model.member modelmen = bllmen.GetModel(NewCard); if (modelmen != null) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('新卡号已经被使用!');parent.window.location.reload();</script>"); } else { try { bllmen.Updates("update member set Mid=" + NewCard + " where Mid=" + mid + ""); List <Model.mRecords> listmr = bllmr.GetModelList("mmid='" + mid + "'"); if (listmr.Count > 0) { foreach (Model.mRecords item in listmr) { item.mmid = NewCard; bllmr.Update(item); } } string pirc = Request.Form["CardPrice"]; if (pirc != "") { BC(Convert.ToDecimal(pirc), "换卡收款", Paymethed1.SelectedValue, 21); } ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('换卡成功!!');parent.window.location.reload();</script>"); } catch (Exception) { } } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请输入正确的卡号!');</script>"); } } else if (BtnSave.Value == "会员续卡") { string mid = Request.Form["mid"]; Model.member modelmen = bllmen.GetModel(mid); Model.memberType modelty = bllmt.GetModel(Convert.ToInt32(modelmen.Mtype)); string s = GetQx(modelty); if (s == "无期限") { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('此卡是无期限的!!');parent.window.location.reload();</script>"); } else { DateTime day = Convert.ToDateTime(Request.Form["PeriodDay"]); modelmen.XqTime = day; bllmen.Update(modelmen); string pirc = Request.Form["PeriodPrice"]; if (pirc != "") { BC(Convert.ToDecimal(pirc), "续卡收款", DropDownList1.SelectedValue, 21); } ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('续卡成功!!');parent.window.location.reload();</script>"); } } else if (BtnSave.Value == "会员退卡") { string mid = Request.Form["mid"]; Model.member modelmen = bllmen.GetModel(mid); modelmen.Statid = 4; bllmen.Update(modelmen); string pirc = Request.Form["OutPrice"]; if (pirc != "") { BC(Convert.ToDecimal(pirc) * -1, "退卡退款", DropDownList1.SelectedValue, 22); } ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('退卡成功!!');parent.window.location.reload();</script>"); } else if (BtnSave.Value == "修改密码") { string mid = Request.Form["mid"]; string newpwd = Request.Form["NewPwd"]; string savpwd = Request.Form["SavePwd"]; if (newpwd != savpwd) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('两个输入密码不一样!!');parent.window.location.reload();</script>"); } else { Model.member model = bllmen.GetModel(mid); model.Pwd = savpwd; bllmen.Update(model); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('密码修改成功!!');parent.window.location.reload();</script>"); } } else if (BtnSave.Value == "会员升级") { int CategorgId = Convert.ToInt32(Request.Form["CategorgId"]); int DeductScore = Convert.ToInt32(Request.Form["DeductScore"]); if (DeductScore > 0) { Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = Request.Form["mid"]; modelmr.Price = DeductScore; modelmr.Type = 4; modelmr.Remark = ""; bllmr.Add(modelmr); } bllmen.Updates("update member set Mtype=" + CategorgId + " where Mid=" + mid.Value + ""); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('升级成功!!');parent.window.location.reload();</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('请选择需要操作的会员!!');</script>"); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSave_Click(object sender, EventArgs e) { Model.member bllmem = new Model.member(); bllmem.Mid = MemberCardNo.Value; bllmem.Name = Name.Value; bllmem.Mtype = Convert.ToInt32(CategoryId.SelectedValue); bllmem.Sex = Convert.ToBoolean(Convert.ToInt32(Sex.SelectedValue)); bllmem.Zjtype = Convert.ToInt32(CardType.SelectedValue); bllmem.ZjNumber = CardNo.Value; bllmem.sales = 0; bllmem.Phone = Phone.Value; if (BirthDay.Value == "") { bllmem.Baithday = null; } else { bllmem.Baithday = Convert.ToDateTime(BirthDay.Value); } bllmem.Pwd = Password.Text; bllmem.Likes = Love.Value; bllmem.Address = Address.Value; bllmem.Ramrek = Remark.Value; bllmem.AddUser = UserNow.UserID; if (Request.Form["GiveScore"] == "") { bllmem.Integration = 0; } else { bllmem.Integration = Convert.ToInt32(Request.Form["GiveScore"]); } bllmem.Statid = 0; if (Request.QueryString["type"] == "edit") { bllmem.Mid = Request.QueryString["id"]; bllmem.AddDate = bll.GetModel(bllmem.Mid).AddDate; bllmem.XqTime = bll.GetModel(bllmem.Mid).XqTime; if (bll.Update(bllmem)) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('更新成功');parent.window.location.reload();</script>"); } } else { bllmem.IntegraDj = Convert.ToInt32(NoCardFee.Checked); bllmem.AddDate = DateTime.Now; if (bll.Add(bllmem)) { Model.memberType modelmt = bllmt.GetModel(Convert.ToInt32(bllmem.Mtype)); bllmem.XqTime = modelmt.XqTime; bll.Update(bllmem); Model.mRecords modemr = new Model.mRecords(); modemr.mmid = bllmem.Mid; modemr.Price = Convert.ToInt32(Request.Form["TopAmount"].ToString()); modemr.Type = 1; modemr.Remark = ""; bllmr.Add(modemr); Model.mRecords modemrjf = new Model.mRecords(); modemrjf.mmid = bllmem.Mid; if (Request.Form["GiveScore"] == "") { modemrjf.Price = 0; } else { modemrjf.Price = Convert.ToInt32(Request.Form["GiveScore"]); } modemrjf.Type = 3; modemrjf.Remark = ""; bllmr.Add(modemrjf); int Amount = Convert.ToInt32(Request.Form["Amount"]); BC(Amount); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('保存成功');parent.window.location.reload();</script>"); } } }