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>");
}
}
}
