protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrEmpty(Request.QueryString["HotelId"]))
{
ShowMsgHelper.OpenClose("操作失败！请先选择酒店...");
return;
}
if (!string.IsNullOrEmpty(Request.QueryString["useredit"]))//首页 用户自己编辑
{
User_Account.Disabled = true;
Credentials_Type.Disabled = true;
ddlUser_Role.Enabled = true;
ddlUser_Role.Attributes.Add("disabled", "disabled");
User_Pwd.Disabled = true;
}
hdUserId.Value = Request.QueryString["UserId"];
hRestore.Value = Request.QueryString["Restore"];
AdminHotelid.Value = RequestSession.GetSessionUser().AdminHotelid.ToString();
HotelId.Value = Request.QueryString["HotelId"];
InitData();
if (!string.IsNullOrEmpty(hdUserId.Value))//编辑
{
EditData();
}
}
}
/// <summary>
/// 编辑按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSumit_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"
SELECT * FROM ReceiptRules
WHERE AdminHotelid =@AdminHotelid
");
SqlParam[] param = new SqlParam[] {
new SqlParam("@AdminHotelid", hdAdminHotelid.Value)
};
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb, param);
if (dt != null && dt.Rows.Count > 0)//更新
{
Hashtable hs = new Hashtable();
hs["RulesContent"] = txtRulesContent.Value;
DataFactory.SqlDataBase().UpdateByHashtable("ReceiptRules", "ID", dt.Rows[0]["ID"].ToString(), hs);
ShowMsgHelper.OpenClose("修改成功！");
}
else
{
Hashtable hs = new Hashtable();
hs["RulesContent"] = txtRulesContent.Value;
hs["Adminhotelid"] = hdAdminHotelid.Value;
DataFactory.SqlDataBase().InsertByHashtableReturnPkVal("ReceiptRules", hs);
ShowMsgHelper.OpenClose("添加成功！");
}
}
/// <summary>
/// 编辑按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
Hashtable hs = new Hashtable();
hs["moneys"] = czje.Text;
if (zsje.Text.Trim() == "")
{
hs["zsmoneys"] = 0;
}
else
{
hs["zsmoneys"] = zsje.Text;
}
if (zsjf.Text.Trim() == "")
{
hs["zsjf"] = 0;
}
else
{
hs["zsjf"] = zsjf.Text;
}
hs["couponid"] = couponids.Value.Trim(','); //yhq.SelectedValue;
hs["HYLXNAME"] = hyjb.SelectedItem.Text;
hs["iszsmoneys"] = iszsmoneys.Value;
hs["iszsjf"] = iszsjf.Value;
hs["ishylxcode"] = ishylxcode.Value;
hs["iscouponid"] = iscouponid.Value;
hs["hylxcode"] = hyjb.SelectedValue;
hs["bz"] = txtInfo.Value;
hs["AdminHotelid"] = RequestSession.GetSessionUser().AdminHotelid.ToString();
hs["HotelId"] = ddlHotel.SelectedValue;
if (Request["id"] != null)
{
int i = DataFactory.SqlDataBase().UpdateByHashtable("CardRecharge", "ID", Request["id"], hs);
if (i > 0)
{
ShowMsgHelper.OpenClose("修改成功！");
}
else
{
ShowMsgHelper.Alert_Error("修改失败！");
}
}
else
{
int i = DataFactory.SqlDataBase().InsertByHashtable("CardRecharge", hs);
if (i > 0)
{
ShowMsgHelper.OpenClose("添加成功！");
}
else
{
ShowMsgHelper.Alert_Error("添加失败！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrEmpty(Request.QueryString["HotelId"]))
{
ShowMsgHelper.OpenClose("操作失败！");
return;
}
hdHotelId.Value = Request.QueryString["HotelId"];
hdAdminHotelId.Value = RequestSession.GetSessionUser().AdminHotelid.ToString();
hdUserId.Value = RequestSession.GetSessionUser().UserId.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrEmpty(Request.QueryString["HotelId"]))
{
ShowMsgHelper.OpenClose("操作失败！请先选择酒店...");
return;
}
hdRoleId.Value = Request.QueryString["roleId"];
HotelAdmin.Value = RequestSession.GetSessionUser().AdminHotelid.ToString();
HotelId.Value = Request.QueryString["HotelId"];
InitData();
if (!string.IsNullOrEmpty(hdRoleId.Value))//编辑
{
EditData();
}
}
}
protected void btnSumit_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
ht["TotalNumber"] = TotalNumber.Value;
ht["MoreNumber"] = MoreNumber.Value;
ht["MoreProportion"] = MoreProportion.Value;
ht["MoreMaintainMoney"] = MaintainMoney.Value;
ht["MoreMaintainProportion"] = MaintainProportion.Value;
int i = DataFactory.SqlDataBase().UpdateByHashtable("MarketingConfigure", "AdminHotelId", hdAdminHotelid.Value, ht);
if (i > 0)
{
ShowMsgHelper.OpenClose("操作成功！");
}
else
{
ShowMsgHelper.Alert_Error("操作失败！");
}
}
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("退款成功！");
//}
}
}
/// <summary>
/// 编辑按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
string filename = "";
if (hfImage.Value != imagepath)
{
filename = fuPicture.FileName;
if (!string.IsNullOrEmpty(filename))
{
string type = (filename.Substring(filename.LastIndexOf(".") + 1)).ToLower(); //得到文件的后缀
if (type == "jpg" || type == "gif" || type == "bmp" || type == "png")
{
string name1 = Guid.NewGuid().ToString();
string name = name1.ToString() + "." + type;
string fpath = HttpContext.Current.Server.MapPath("~\\upload\\image\\") + name;
fuPicture.SaveAs(fpath); //将文件保存到fpath这个路径里面
filename = name;
//原记录中有图片信息。
if (!String.IsNullOrEmpty(imagepath))
{
//删除原来的旧图片。
FileInfo file;
file = new FileInfo(Server.MapPath("..") + "\\..\\upload\\image\\" + imagepath);
file.Delete();
}
}
else
{
ShowMsgHelper.Alert_Error("不支持该格式的图标！支持jpg、gif、bmp、png！");
return;
}
}
}
ht["hylxcode"] = DDLgghy.SelectedValue.Trim();
ht["hylxname"] = hyname.Text;
//ht["zk"] = hykje.Text == "" ? "0" : hykje.Text;
ht["wx_url"] = hfImage.Value;
ht["wx_sm"] = sm.InnerText;
ht["jb"] = hyjb.SelectedValue;
ht["sort"] = hyjb.SelectedValue;
ht["AdminHotelid"] = Request["AdminHotelid"];
if (DDLgghy.SelectedValue == "W")
{
int a = DataFactory.SqlDataBase().InsertByHashtable("hy_hylxbmb", ht);
if (a > 0)
{
Hashtable hts = new Hashtable();
hts["hylxcode"] = DDLgghy.SelectedValue;
hts["hylxname"] = hyname.Text;
hts["mrscm"] = "WXVIP";
hts["AdminHotelid"] = Request["AdminHotelid"];
hts["jb"] = hyjb.SelectedValue;
hts["sort"] = hyjb.SelectedValue;
int b = DataFactory.SqlDataBase(Request["AdminHotelid"]).InsertByHashtable("hy_hylxbmb", hts);
if (b > 0)
{
ShowMsgHelper.OpenClose("添加成功！");
}
else
{
ShowMsgHelper.Alert_Error("同步至国光失败！");
}
}
else
{
ShowMsgHelper.Alert_Error("添加失败！");
}
}
else
{
bool val = DataFactory.SqlDataBase().Submit_AddOrEdit("hy_hylxbmb", "ID", hid.Value, ht);
if (val)
{
Hashtable hts = new Hashtable();
hts["AdminHotelid"] = Request["AdminHotelid"];
hts["jb"] = hyjb.SelectedValue;
hts["sort"] = hyjb.SelectedValue;
bool vals = DataFactory.SqlDataBase(Request["AdminHotelid"]).Submit_AddOrEdit("hy_hylxbmb", "hylxcode", DDLgghy.SelectedValue, hts);
if (vals)
{
ShowMsgHelper.OpenClose("编辑成功！");
}
else
{
ShowMsgHelper.Alert_Error("同步至国光失败！");
}
}
else
{
ShowMsgHelper.Alert_Error("编辑失败！");
}
}
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
{
errorMsg.Visible = true;
errorMsg.InnerHtml = "请您选择要导入的Excel文件！";
return;
}
string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); //System.IO.Path.GetExtension获得文件的扩展名
if (IsXls != ".xls" && IsXls != ".xlsx") //
{
errorMsg.Visible = true;
errorMsg.InnerHtml = "只可以选择Excel文件！";
return;
}
DataTable dt = ExcelDataSource();
if (dt == null || dt.Rows.Count < 1)
{
errorMsg.Visible = true;
errorMsg.InnerHtml = "1.请检测Excel文件是否按照模板指定格式。2.确认工作表名称是否为Sheet1 ！";
return;
}
if (!dt.Columns.Contains("姓名") || !dt.Columns.Contains("性别") || !dt.Columns.Contains("手机号码") || !dt.Columns.Contains("部门") || !dt.Columns.Contains("职位"))
{
errorMsg.Visible = true;
errorMsg.InnerHtml = "请检测Excel文件是否按照模板指定格式！";
return;
}
getRoles();//获取角色
//导入
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i]["姓名"].ToString().Trim();
string sex = dt.Rows[i]["性别"].ToString().Trim();
string phone = dt.Rows[i]["手机号码"].ToString().Trim();
if (name == "" || phone == "")
{
continue;
}
string department = dt.Rows[i]["部门"].ToString().Trim();
string position = dt.Rows[i]["职位"].ToString().Trim();
int iSex = (sex == "女") ? 0 : 1;
StringBuilder sb_user = new StringBuilder();
sb_user.Append("SELECT User_ID,HotelId FROM Base_UserInfo WHERE User_Account= @User_Account AND DeleteMark = 1");
SqlParam[] parm_user = new SqlParam[] {
new SqlParam("@User_Account", phone)
};
DataTable dt_user = DataFactory.SqlDataBase().GetDataTableBySQL(sb_user, parm_user);
string org_id = "";
if (department != "")
{
#region 部门信息
StringBuilder sb_org = new StringBuilder();
sb_org.Append(@"SELECT Organization_ID FROM dbo.Base_Organization WHERE ParentId = '0' AND Organization_Name = @bumen");
SqlParam[] parm_org = new SqlParam[] {
new SqlParam("@bumen", department)
};
DataTable dt_org = DataFactory.SqlDataBase().GetDataTableBySQL(sb_org, parm_org);
if (dt_org != null && dt_org.Rows.Count > 0)
{
org_id = dt_org.Rows[0]["Organization_ID"].ToString();
}
else
{
Hashtable ht_org = new Hashtable();
string oid = CommonHelper.GetGuid;
ht_org["Organization_ID"] = oid;
ht_org["Organization_Name"] = department;
ht_org["ParentId"] = "0";
ht_org["DeleteMark"] = "1";
ht_org["AdminHotelId"] = hdAdminHotelId.Value;
ht_org["HotelId"] = hdHotelId.Value;
ht_org["CreateDate"] = DateTime.Now;
ht_org["CreateUserId"] = hdUserId.Value;
ht_org["CreateUserName"] = RequestSession.GetSessionUser().UserName.ToString();
bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_Organization", "", "", ht_org);
if (IsOk)
{
org_id = oid;
}
}
#endregion
if (position != "")
{
#region 职位信息
sb_org = new StringBuilder();
sb_org.Append(@"
SELECT Organization_ID
FROM dbo.Base_Organization
WHERE Organization_Name = @zhiwei
AND ParentId = @ParentId
");
parm_org = new SqlParam[] {
new SqlParam("@zhiwei", position),
new SqlParam("@ParentId", org_id)
};
dt_org = DataFactory.SqlDataBase().GetDataTableBySQL(sb_org, parm_org);
if (dt_org != null && dt_org.Rows.Count > 0)
{
org_id = dt_org.Rows[0]["Organization_ID"].ToString();
}
else
{
Hashtable ht_org = new Hashtable();
string oid = CommonHelper.GetGuid;
ht_org["Organization_ID"] = oid;
ht_org["Organization_Name"] = position;
ht_org["ParentId"] = org_id;
ht_org["DeleteMark"] = "1";
ht_org["AdminHotelId"] = hdAdminHotelId.Value;
ht_org["HotelId"] = hdHotelId.Value;
ht_org["CreateDate"] = DateTime.Now;
ht_org["CreateUserId"] = hdUserId.Value;
ht_org["CreateUserName"] = RequestSession.GetSessionUser().UserName.ToString();
bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_Organization", "", "", ht_org);
if (IsOk)
{
org_id = oid;
}
}
#endregion
}
}
if (dt_user != null && dt_user.Rows.Count > 0)
{
if (dt_user.Rows[0]["HotelId"].ToString() == hdHotelId.Value)
{
Hashtable ht = new Hashtable();
ht["User_Name"] = name;
ht["User_Sex"] = iSex;
ht["Organization_ID"] = org_id;
string User_ID = dt_user.Rows[0]["User_ID"].ToString();
bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserInfo", "User_ID", User_ID, ht);
}
}
else
{
string guid = CommonHelper.GetGuid;
Hashtable ht = new Hashtable();
ht["IsAdmin"] = 2;
ht["User_Name"] = name;
ht["User_Account"] = phone;
ht["User_Pwd"] = Md5Helper.MD5("123456", 32);
ht["User_Sex"] = iSex;
ht["Email"] = phone;
ht["Title"] = "";
ht["Theme"] = ""; //电子邮箱
ht["User_Remark"] = "导入"; //备注
ht["hotelid"] = hdHotelId.Value;
ht["HotelListId"] = hdHotelId.Value;
ht["AdminHotelid"] = hdAdminHotelId.Value;
ht["User_ID"] = guid;
ht["CreateUserId"] = hdUserId.Value;
ht["CreateUserName"] = RequestSession.GetSessionUser().UserName.ToString();
ht["CreateDate"] = DateTime.Now;
ht["DeleteMark"] = 1;
ht["Organization_ID"] = org_id;
bool IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserInfo", "User_ID", "", ht);
string Roles_ID = jdyg_rid;
if (IsOk && Roles_ID != "")
{
#region ** 角色 **
DataFactory.SqlDataBase().DeleteData("Base_UserRole", "User_ID", guid);//删除角色
Hashtable htRole = new Hashtable();
htRole["UserRole_ID"] = CommonHelper.GetGuid;
htRole["User_ID"] = guid;
htRole["Roles_ID"] = Roles_ID;
DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserRole", "User_ID", "", htRole);//重新添加角色
#endregion
}
}
ShowMsgHelper.OpenClose("操作成功！");
}
}