/// <summary>
/// 清空txt数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void hlkempty_Click1(object sender, EventArgs e)
{
string filepath = ConfigHelper.GetAppSettings("LogFilePath") + "\\" + _FileName;
FileStream fs = new FileStream(filepath, FileMode.Create, FileAccess.Write); fs.Close();
ShowMsgHelper.ShowScript("Alert_Ok()");
}
/// <summary>
/// 清空txt数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void hlkempty_Click1(object sender, EventArgs e)
{
string filepath = _FilePath;
FileStream fs = new FileStream(filepath, FileMode.Create, FileAccess.Write); fs.Close();
ShowMsgHelper.ShowScript("Alert_Ok()");
}
/// <summary>
/// 验证
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Landing_Click_Click(object sender, EventArgs e)
{
string connectstring = "";
string sql = string.Format("select name from sys.databases");
if (Authentication.Value == "1")
{
connectstring = string.Format(" data source={0}; initial catalog=master;integrated security=sspi", ServerName.Value);
}
else
{
connectstring = string.Format(" data source={0}; initial catalog=master;user id={1};password={2}", ServerName.Value, LoginName.Value, Password.Value);
}
try
{
DataTable dt = DataFactory.SqlHelper(connectstring.ToString()).GetDataTableBySQL(new StringBuilder(sql));
if (dt != null)
{
Session["connectstring"] = connectstring;
Session["DBServerName"] = ServerName.Value;
Session["DBLoginName"] = LoginName.Value;
Session["DBPassword"] = Password.Value;
ShowMsgHelper.ShowScript("Callback()");
}
else
{
ShowMsgHelper.Alert_Error("用户登录失败（请检查用户名和密码）");
}
}
catch
{
ShowMsgHelper.Alert_Error("用户登录失败（请检查用户名和密码）");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ShowMsgHelper.ShowScript("top.TopLoading('注意：为了确保体验站点的完整性，您的部分操作将被限制执行!', 8000);");
this._UserName = RequestSession.GetSessionUser().UserName.ToString();
this.InitShortcouData();
this.BindLogin_Info();
}
protected void Page_Load(object sender, EventArgs e)
{
connectstring = Session["connectstring"];
if (connectstring != null)
{
InitDBInfo();
}
else
{
ShowMsgHelper.ShowScript("LoginForm()");
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
string str = item_hidden.Value;
bool IsAllto = user_idao.Add_UserGroupAllotAuthority(str.Split(','), _UserGroup_ID);
if (IsAllto)
{
ShowMsgHelper.ShowScript("back();showTipsMsg('操作成功！','2500','4');");
}
else
{
ShowMsgHelper.Alert_Error("操作失败！");
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
string str = item_hidden.Value;
bool IsAllto = system_idao.Add_RoleAllotAuthority(str.Split(','), _key);
if (IsAllto)
{
ShowMsgHelper.ShowScript("back();showTipsMsg('Success！','2500','4');");
}
else
{
ShowMsgHelper.Alert_Error("Error！");
}
}
protected void Save_Click(object sender, EventArgs e)
{
string str = this.item_hidden.Value;
bool IsAllto = this.system_idao.Add_RoleAllotAuthority(str.Split(new char[]
{
','
}), this._key);
if (IsAllto)
{
ShowMsgHelper.ShowScript("back();showTipsMsg('操作成功！','2500','4');");
}
else
{
ShowMsgHelper.Alert_Error("操作失败！");
}
}
public void PageChecking()
{
this.lblRecordCount.Text = this.RecordCount.ToString();
this.lblCurrentPageIndex.Text = this.PageIndex.ToString();
this.lblPageCount.Text = this.TotaPage.ToString();
this.default_pgStartRecord.Text = this.PagestartNumber.ToString();
this.default_pgEndRecord.Text = this.PageendNumber.ToString();
if (this.TotaPage == 0 || this.TotaPage == 1)
{
this.hlkFirst.Enabled = false;
this.hlkPrev.Enabled = false;
this.hlkNext.Enabled = false;
this.hlkLast.Enabled = false;
ShowMsgHelper.ShowScript("Script(1)");
}
else
{
if (this.PageIndex == 1)
{
this.hlkFirst.Enabled = false;
this.hlkPrev.Enabled = false;
this.hlkNext.Enabled = true;
this.hlkLast.Enabled = true;
ShowMsgHelper.ShowScript("Script(2)");
}
else
{
if (this.PageIndex == this.TotaPage)
{
this.hlkFirst.Enabled = true;
this.hlkPrev.Enabled = true;
this.hlkNext.Enabled = false;
this.hlkLast.Enabled = false;
ShowMsgHelper.ShowScript("Script(3)");
}
else
{
this.hlkFirst.Enabled = true;
this.hlkPrev.Enabled = true;
this.hlkNext.Enabled = true;
this.hlkLast.Enabled = true;
ShowMsgHelper.ShowScript("Script(4)");
}
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
SysMenuModel model = new SysMenuModel();
model.ParentID = this.ParentID.Value.Trim();
model.MenuName = this.MenuName.Value.Trim();
model.MenuImg = this.MenuImg.Value.Trim();
model.MenuType = TypeConversion.StringToInt(this.MenuType.Value.Trim());
model.NavigateUrl = this.NavigateUrl.Value.Trim();
model.SortCode = TypeConversion.StringToInt(this.SortCode.Value.Trim());
model.DeleteFlag = 0;
model.CreateDate = new DateTime();
if (model.IsVolid())
{
if (MID == "")
{
model.MenuID = Guid.NewGuid();
int i = SMBll.MenuAction(model, Common.NetEnum.SysEnum.ActionType.ADD);
if (i > 0)
{
ControlAction.CloseWindow(this.Page, "添加成功！", 2500, SysEnum.MsgType.SUCCESS);
}
else
{
ControlAction.CloseWindow(this.Page, "添加失败！", 2500, SysEnum.MsgType.ERROR);
}
}
else
{
model.MenuID = new Guid(MID);
int i = SMBll.MenuAction(model, Common.NetEnum.SysEnum.ActionType.UPDATE);
if (i > 0)
{
ControlAction.CloseWindow(this.Page, "修改成功！", 2500, SysEnum.MsgType.SUCCESS);
}
else
{
ControlAction.CloseWindow(this.Page, "修改失败！", 2500, SysEnum.MsgType.ERROR);
}
}
}
else
{
ShowMsgHelper.ShowScript("showWarningMsg('" + model.ValidateTag.ToString() + "');");
}
}
/// <summary>
/// 保存设置，保存在浏览器Cookie
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
try
{
if (WebHelper.SubmitCheckForm())
{
CookieHelper.WriteCookie("Language_Type", Language_Type.Value, 30);
CookieHelper.WriteCookie("WebUI_Type", WebUI_Type.Value, 30);
CookieHelper.WriteCookie("Menu_Type", Menu_Type.Value, 30);
CookieHelper.WriteCookie("PageIndex", PageIndex.Value, 30);
ShowMsgHelper.ShowScript("MainSwitch()");
}
}
catch
{
ShowMsgHelper.Alert_Error("设置失败！");
}
}
protected void btnrecover_Click(object sender, EventArgs e)
{
string filename = this.Backup_Restore_File.Value;
string FilePath = ConfigHelper.GetAppSettings("BackupsDataPath");
FileHelper.CreateDirectory(FilePath);
bool IsOk = this.system_idao.DataRestore(FilePath + "//" + filename);
if (IsOk)
{
string filesize = FileHelper.GetFileSize(FilePath + "//" + filename);
this.system_idao.Add_Backup_Restore_Log("恢复", filename, filesize, this._UserName, "RM_DB", this.Backup_Restore_Memo.Value);
ShowMsgHelper.ShowScript("showTipsMsg('数据库恢复成功！','2500','4');top.main.windowload();");
}
else
{
ShowMsgHelper.Alert_Error("恢复失败！");
}
}
protected void bntbackups_Click(object sender, EventArgs e)
{
string filename = DateTime.Now.ToString("yyyyMMddhhmmssff") + ".bak";
string FilePath = ConfigHelper.GetAppSettings("BackupsDataPath");
FileHelper.CreateDirectory(FilePath);
bool IsOk = this.system_idao.DataBackups(FilePath + "//" + filename);
if (IsOk)
{
string filesize = FileHelper.GetFileSize(FilePath + "//" + filename);
this.system_idao.Add_Backup_Restore_Log("备份", filename, filesize, this._UserName, "RM_DB", this.Backup_Restore_Memo.Value);
ShowMsgHelper.ShowScript("showTipsMsg('数据库备份成功！','2500','4');top.main.windowload();");
}
else
{
ShowMsgHelper.Alert_Error("备份失败！");
}
}
/// <summary>
/// 确认事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Accept_Click(object sender, EventArgs e)
{
string[] array = new string[0];
if (!string.IsNullOrEmpty(hiddenUserId.Value))
{
array = hiddenUserId.Value.Split('≌');
}
bool IsOk = false;
string CreateUserId = RequestSession.GetSessionUser().UserId;
string CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_userroleibll.BatchAddMember(array, _RoleId, CreateUserId, CreateUserName);
if (IsOk)
{
ShowMsgHelper.ShowScript("showTipsMsg('" + MessageHelper.MSG0007 + "','4000','4');top.$('#' + Current_iframeID())[0].contentWindow.target_right.iframeRoleMember.windowload();OpenClose();");
}
else
{
ShowMsgHelper.Alert_Error(MessageHelper.MSG0022);
}
}
/// <summary>
/// 验证
/// </summary>
public void PageChecking()
{
lblRecordCount.Text = RecordCount.ToString();
lblCurrentPageIndex.Text = PageIndex.ToString();
lblPageCount.Text = TotaPage.ToString();
default_pgStartRecord.Text = PagestartNumber.ToString();
default_pgEndRecord.Text = PageendNumber.ToString();
if (TotaPage == 0 || TotaPage == 1)
{
hlkFirst.Enabled = false;
hlkPrev.Enabled = false;
hlkNext.Enabled = false;
hlkLast.Enabled = false;
ShowMsgHelper.ShowScript("Script(1)");
}
else if (PageIndex == 1)
{
hlkFirst.Enabled = false;
hlkPrev.Enabled = false;
hlkNext.Enabled = true;
hlkLast.Enabled = true;
ShowMsgHelper.ShowScript("Script(2)");
}
else if (PageIndex == TotaPage)
{
hlkFirst.Enabled = true;
hlkPrev.Enabled = true;
hlkNext.Enabled = false;
hlkLast.Enabled = false;
ShowMsgHelper.ShowScript("Script(3)");
}
else
{
hlkFirst.Enabled = true;
hlkPrev.Enabled = true;
hlkNext.Enabled = true;
hlkLast.Enabled = true;
ShowMsgHelper.ShowScript("Script(4)");
}
}
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("退款成功！");
//}
}
}