public void update(HttpContext context) { string Hotelid = context.Request["Hotelid"].Trim(); string Pay = context.Request["Pay"].Trim(); string Hypay = context.Request["Hypay"].Trim(); string Jfpay = context.Request["Jfpay"].Trim(); string Qtpay = context.Request["Qtpay"].Trim(); string JFZhoumo = context.Request["JFZhoumo"].Trim(); string JFJieri = context.Request["JFJieri"].Trim(); string yhqzhoumo = context.Request["yhqzhoumo"].Trim(); string yhqjieri = context.Request["yhqjieri"].Trim(); string mrzf = context.Request["mrzf"].Trim(); string is_dj_Coupon = context.Request["is_dj_Coupon"].Trim(); string is_xz_Coupon = context.Request["is_xz_Coupon"].Trim(); Hashtable ht = new Hashtable(); ht["Pay"] = Pay; ht["Hypay"] = Hypay; ht["Jfpay"] = Jfpay; ht["Qtpay"] = Qtpay; ht["JFZhoumo"] = JFZhoumo; ht["JFJieri"] = JFJieri; ht["yhqzhoumo"] = yhqzhoumo; ht["yhqjieri"] = yhqjieri; ht["mrzf"] = mrzf; ht["is_dj_Coupon"] = is_dj_Coupon; ht["is_xz_Coupon"] = is_xz_Coupon; if (DataFactory.SqlDataBase().Submit_AddOrEdit("Hotel", "ID", Hotelid, ht)) { try { string bz = ""; bz += (Pay == "1" ? "微信支付," : ""); bz += (Hypay == "1" ? "会员卡支付," : ""); bz += (Jfpay == "1" ? "积分兑换," : ""); bz += (Qtpay == "1" ? "前台付款" : ""); bz = bz.Trim(','); CommonMethod.Base_Log("修改支付方式", "Hotel", Hotelid, "修改支付方式", bz);//操作记录 } catch { } context.Response.Write("ok"); } else { context.Response.Write("error"); } }
/// <summary> /// 编辑按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { Hashtable hss = new Hashtable(); hss["TypeName"] = txtTypeName.Value; hss["Instructions"] = txtInstructions.Value; hss["AdminHotelid"] = RequestSession.GetSessionUser().AdminHotelid.ToString(); hss["Hotelid"] = Request["HotelId"]; if (Request["ID"] != null) { //处理 int a = DataFactory.SqlDataBase().UpdateByHashtable("BookType", "id", Request["ID"], hss); if (a > 0) { CommonMethod.Base_Log("修改", "BookType", Request["ID"], "类型管理", "修改[" + txtTypeName.Value + "]");//操作日志 ShowMsgHelper.AlertMsg("编辑成功"); } else { ShowMsgHelper.Alert_Error("编辑失败!"); } } else { string sql = string.Format("select sort from BookType order by Sort desc"); DataTable ds = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sql)); if (ds != null && ds.Rows.Count > 0) { sort = Convert.ToInt32(ds.Rows[0]["Sort"].ToString()) + 1; } else { sort = 1; } hss["Sort"] = sort; //添加 int a = DataFactory.SqlDataBase().InsertByHashtable("BookType", hss); if (a > 0) { CommonMethod.Base_Log("添加", "BookType", "", "类型管理", "添加[" + txtTypeName.Value + "]");//操作日志 ShowMsgHelper.AlertMsg("添加成功"); } else { ShowMsgHelper.Alert_Error("添加失败!"); } } }
/// <summary> /// 编辑按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSumit_Click(object sender, EventArgs e) { Hashtable hss = new Hashtable(); hss["Name"] = txtKindName.Value; hss["AdminHotelid"] = RequestSession.GetSessionUser().AdminHotelid.ToString(); if (Request["ID"] != null) { //修改 int a = DataFactory.SqlDataBase().UpdateByHashtable("CouponType", "ID", Request["ID"], hss); if (a > 0) { ShowMsgHelper.AlertReloadClose("修改成功!", "ListGrid()"); CommonMethod.Base_Log("卡券管理", "CouponType", "AdminHotelid:" + hss["AdminHotelid"], "修改卡券类型信息", "修改卡券类型信息");//操作记录 } else { ShowMsgHelper.AlertReloadClose("修改失败!", "ListGrid()"); } } else { //添加 int a = DataFactory.SqlDataBase().InsertByHashtable("CouponType", hss); if (a > 0) { ShowMsgHelper.AlertReloadClose("添加成功!", "ListGrid()"); CommonMethod.Base_Log("卡券管理", "CouponType", "AdminHotelid:" + hss["AdminHotelid"], "添加卡券类型信息", "添加卡券类型信息");//操作记录 } else { ShowMsgHelper.AlertReloadClose("添加失败!", "ListGrid()"); } } }
protected void btnSumit_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append(@" select * from Finance where id= @ID "); SqlParam[] param = new SqlParam[] { new SqlParam("@ID", hdId.Value) }; DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb, param); if (dt != null && dt.Rows.Count > 0) { string adminHotelid = dt.Rows[0]["AdminHotelid"].ToString(); int hotelid = CommonHelper.GetInt(dt.Rows[0]["HotelId"].ToString()); string orderNum = dt.Rows[0]["Number"].ToString(); string name = dt.Rows[0]["Name"].ToString(); string phone = dt.Rows[0]["Phone"].ToString(); string memberId = dt.Rows[0]["MemberId"].ToString(); string openid = dt.Rows[0]["openid"].ToString(); int money = CommonHelper.GetInt(dt.Rows[0]["Monery"].ToString());//订单金额 double cancel_money = CommonHelper.GetDouble(txtMoney.Text);//取消金额 if (cancel_money > money) { ShowMsgHelper.Alert_Error("操作失败,退回金额不能大于订单支付金额!"); return; } if (cancel_money > 0)//退回金额 { switch (hdPayType.Value) { case "1": //到店支付 break; case "2": //积分兑换 break; case "3": //会员卡支付 break; case "4": //微信支付 #region ******** 微信原路退回 ******** try { string transaction_id = dt.Rows[0]["wxddh"].ToString(); if (transaction_id == "") { ShowMsgHelper.Alert_Error("操作失败,未找到微信支付单号!"); return; } string ssl_path = WxPayConfig.SSLCERT_PATH(adminHotelid, hotelid); if (ssl_path == "") { ShowMsgHelper.Alert_Error("操作失败,请联系开发人员配置API证书!"); return; } //判断文件的存在 if (System.IO.File.Exists(HttpContext.Current.Server.MapPath("~" + ssl_path))) { //存在文件 } else { ShowMsgHelper.Alert_Error("操作失败,API证书不存在!"); return; } string total_fee = (money * 100).ToString(); string refund_fee = (cancel_money * 100).ToString(); string result = Refund.Run(transaction_id, orderNum, total_fee, refund_fee, adminHotelid, hotelid); WxPayData data = new WxPayData(); data.FromXml(result); //把XML转换成对象 string GetReturnCode = data.GetValue("return_code").ToString(); if (GetReturnCode == "SUCCESS") { string GetResultCode = data.GetValue("result_code").ToString(); if (GetResultCode == "SUCCESS") { string refund_id = data.GetValue("refund_id").ToString(); Dictionary <string, object> datas = new Dictionary <string, object>(); datas.Add("transaction_id", data.GetValue("transaction_id")); //微信订单号 datas.Add("out_trade_no", data.GetValue("out_trade_no")); //商户订单号 datas.Add("out_refund_no", data.GetValue("out_refund_no")); //商户退款单号 datas.Add("refund_id", data.GetValue("refund_id")); //微信退款单号 //财务记录 int iVal = CommonClass.InsertFinance(orderNum, name, phone, cancel_money, 41, "充值退款", memberId, transaction_id, adminHotelid, hotelid, refund_id, openid); if (iVal > 0) { try { Hashtable hs = new Hashtable(); hs["vipkh"] = dt.Rows[0]["Phone"]; hs["bmcode"] = "99"; hs["yddh"] = orderNum; hs["je"] = CommonHelper.GetDouble(cancel_money); //hs["fhcs"] = "T"; hs["OUT_fhcs"] = null; Hashtable rs = new Hashtable(); DataFactory.SqlDataBase(adminHotelid).ExecuteByProcReturn("PROC_WXCZKK", hs, ref rs); } catch (Exception ex) { } CommonMethod.Base_Log("充值退款", "Reservation", "ID:" + hdId.Value, "退款金额:" + cancel_money + "," + txtReason.Text, "订单编号:" + orderNum); } } else { //https://pay.weixin.qq.com/wiki/doc/api/micropay.php?chapter=9_4 if (GetResultCode == "NOTENOUGH") //余额不足 { ShowMsgHelper.ShowScript("cancelTips()"); return; } ShowMsgHelper.Alert_Error("操作失败," + data.GetValue("err_code_des") + "!"); return; } } else { ShowMsgHelper.Alert_Error("签名验证失败!"); return; } } catch (Exception ex) { ShowMsgHelper.Alert_Error("操作错误,签名验证失败"); return; } #endregion break; default: ShowMsgHelper.Alert_Error("操作失败!"); return; break; } } Hashtable ht = new Hashtable(); //ht["CancelNumber"] = cancel_night; ht["CancelTime"] = DateTime.Now; //string qxtxt = cancel_night + "间夜"; CommonMethod.Base_Log("充值退款", "Finance", "ID:" + hdId.Value, "退款原因:" + txtReason.Text, "订单编号:" + orderNum); //int val = DataFactory.SqlDataBase().UpdateByHashtable("Reservation", "id", hdId.Value, ht); //if (val > 0) //{ ShowMsgHelper.OpenClose("退款成功!"); //} } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Buffer = true; context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1); context.Response.AddHeader("pragma", "no-cache"); context.Response.AddHeader("cache-control", ""); context.Response.CacheControl = "no-cache"; string Action = context.Request["action"]; //提交动作 string user_ID = context.Request["user_ID"]; //用户主键 Hashtable ht = new Hashtable(); int Return = -1; switch (Action) { case "accredit": //用户信息启用 ht["DeleteMark"] = 1; Return = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", user_ID, ht); context.Response.Write(Return.ToString()); break; case "lock": //锁定用户信息 ht["DeleteMark"] = 2; Return = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", user_ID, ht); context.Response.Write(Return.ToString()); break; case "Dimission": //离职 ht["DeleteMark"] = 0; ht["LeaveDate"] = DateTime.Now.ToString("yyyy-MM-dd"); Return = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", user_ID, ht); string name = context.Request["user_name"]; CommonMethod.Base_Log("离职", "Base_UserInfo", user_ID, "办理离职", "员工[" + name + "]离职"); //操作日志 context.Response.Write(Return > 0); break; case "UntieById": //解绑 ht["openid"] = ""; ht["WX_Nickname"] = ""; Return = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", user_ID, ht); string jb_name = context.Request["user_name"]; CommonMethod.Base_Log("解绑", "Base_UserInfo", user_ID, "解绑微信", "员工[" + jb_name + "]微信解绑"); context.Response.Write(Return > 0); break; case "Entry": //重新入职 ht["DeleteMark"] = 1; string data_val = context.Request["data_val"]; //删除以前下线关系 string gx_msg = "关联回以前下线关系"; if (data_val == "0") { gx_msg = "永久删除以前下线关系"; Hashtable ht_del = new Hashtable(); ht_del["UserId"] = user_ID; DataFactory.SqlDataBase().ExecuteByProc("P_UserEntryDelSource", ht_del); } Return = DataFactory.SqlDataBase().UpdateByHashtable("Base_UserInfo", "User_ID", user_ID, ht); string rz_name = context.Request["user_name"]; CommonMethod.Base_Log("入职", "Base_UserInfo", user_ID, "重新入职", "员工[" + rz_name + "]重新入职," + gx_msg); context.Response.Write(Return > 0); break; case "GetInfoList": GetInfoList(context); break; case "GetUserRoleList": GetUserRoleList(context); break; case "GetRoleList": GetRoleList(context); break; case "GetRoleGroup": GetRoleGroup(context); break; case "DefaultRole": //默认角色 DefaultRole(context); break; case "GetOrgSelect": //获取部门信息 GetOrgSelect(context); break; case "GetParentIds": //获取上级 GetParentIds(context); break; case "CheckOrg": //验证是否有部门 CheckOrg(context); break; default: break; } }
/// <summary> /// 公共一般处理程序 /// </summary> /// <param name="context"></param> public void ProcessRequest(HttpContext context) { string Action = context.Request["action"]; //提交动作 string module = context.Request["module"]; //业务模块 string tableName = context.Request["tableName"]; //数据库表 string pkName = context.Request["pkName"]; //字段主键 string pkVal = context.Request["pkVal"]; //字段值 int Return = -1; RM_System_IDAO systemidao = new RM_System_Dal(); switch (Action) { case "DeleteP": //删除多条记录 1,2,3,4,5,6 Return = DataFactory.SqlDataBase().BatchDeleteData(tableName.Trim(), pkName.Trim(), pkVal.Split(',')); if (Return > 0) { CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal); //操作记录 } context.Response.Write(Return.ToString()); break; case "AdminDelete": //删除多条记录 1,2,3,4,5,6 Return = DataFactory.SqlDataBase().BatchDeleteData(tableName.Trim(), pkName.Trim(), pkVal.Split(',')); if (Return > 0) { //CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal);//操作记录 } context.Response.Write(Return.ToString()); break; case "ISDelete": //逻辑删除数据 string[] s = pkVal.Split(','); for (int i = 0; i < s.Length; i++) { Hashtable ht = new Hashtable(); ht["DeleteMark"] = 0; Return = DataFactory.SqlDataBase().UpdateByHashtable(tableName.Trim(), pkName.Trim(), s[i], ht); } if (Return > 0) { CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal); //操作记录 } context.Response.Write(Return.ToString()); break; case "GetMenus": string ru = "0"; if (RequestSession.GetSessionUser() == null) { context.Response.Write(0); } else { RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal(); ru = user_idao.InitUserRight(RequestSession.GetSessionUser().UserId.ToString(), pkName); //获取用户对应菜单的权限 } context.Response.Write(ru); break; default: break; } }
/// <summary> /// 添加,修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSumit_Click(object sender, EventArgs e) { string BiginTime, EndinTime = null; if (hfEffectiveType.Value == "1") { BiginTime = DateTime.Now.ToString("yyyy-MM-dd"); EndinTime = DateTime.Now.AddYears(100).ToString("yyyy-MM-dd"); } else if (hfEffectiveType.Value == "2") { BiginTime = DateTime.Now.ToString("yyyy-MM-dd"); EndinTime = DateTime.Now.AddDays(Convert.ToDouble(txtDay.Value)).ToString("yyyy-MM-dd"); } else { BiginTime = B_sj.Value; EndinTime = E_sj.Value; } Hashtable hs = new Hashtable(); hs["CouponName"] = txtName.Value; hs["Par"] = Convert.ToInt32(txtPar.Value); hs["UsedMin"] = Convert.ToInt32(txtUsedMin.Value); hs["BiginTime"] = BiginTime; hs["EndinTime"] = EndinTime; hs["ServiceRange"] = sumhotel.Value; hs["ProductRange"] = txtInstructions.Value; hs["Mode"] = Convert.ToInt32(DDLmode.SelectedValue); hs["Membergrade"] = loadaddMembergrade(labelhtml.Value.ToString()); hs["FirstMoney"] = txtFirstMoney.Value; hs["SecondMoney"] = txtcz.Value; hs["IsEnable"] = hfsfqy.Value; hs["Isgiving"] = hfsfzs.Value; hs["hytype"] = hhytype.Value; hs["EffectiveType"] = hfEffectiveType.Value; hs["EffectiveDay"] = txtDay.Value; hs["AdminHotelid"] = RequestSession.GetSessionUser().AdminHotelid.ToString(); hs["yxrq"] = hyxrq.Value; hs["jjr"] = hjjr.Value; hs["count"] = txtNum.Value; hs["ishy"] = hishy.Value; hs["Is_Day_ok"] = hfIs_Day_ok.Value; hs["Total"] = txtTotal.Value; hs["Open_Hotel"] = HOpen_Hotel.Value; hs["ConsumptionType"] = HConsumptionType.Value; hs["TypeID"] = ddltype.SelectedValue; hs["BirthdaySendType"] = hdSendType.Value; if (hfdID.Value == "0") { //添加 int x = DataFactory.SqlDataBase().InsertByHashtableReturnPkVal("Coupon", hs); if (x <= 0) { ShowMsgHelper.Alert_Error("添加失败!"); } else { if (hfsfzs.Value == "1") { Gift(x); } //赠送优惠券 CommonMethod.Base_Log("添加", "Coupon", "", "优惠券管理", "添加[" + txtName.Value + "]"); //操作日志 ShowMsgHelper.AlertReloadClose("添加成功!", "ListGrid()"); } } else { //修改 if (DataFactory.SqlDataBase().UpdateByHashtable("Coupon", "ID", hfdID.Value, hs) <= 0) { ShowMsgHelper.Alert_Error("修改失败!"); } else { if (hfsfzs.Value == "1") { Gift(Convert.ToInt32(hfdID.Value)); } //赠送优惠券 CommonMethod.Base_Log("修改", "Coupon", hfdID.Value, "优惠券管理", "修改[" + txtName.Value + "]"); //操作日志 ShowMsgHelper.AlertReloadClose("修改成功!", "ListGrid()"); } } }