public static string UrlDecrypt(string Text)
{
return(RequestSession.GetSessionUser() == null ? Text : DESEncrypt.Decrypt(Text, RequestSession.GetSessionUser().DESKey.ToString()));
}
/// <summary>
/// 初始化
/// </summary>
private void InitData()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT id,name FROM Hotel_Admin WHERE AdminHotelid='{0}'", RequestSession.GetSessionUser().AdminHotelid);
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb);
if (dt != null && dt.Rows.Count > 0)
{
hotelName.InnerHtml = PageTitle = dt.Rows[0]["name"].ToString();
}
string Rolesname = RequestSession.GetSessionUser().RoleName.ToString();
string un = RequestSession.GetSessionUser().UserName.ToString() + " [" + Rolesname + "]";
this.MenuTitle.InnerHtml = this.spTopUserName.InnerHtml = un;
try
{
DataFactory.ClearConnString(RequestSession.GetSessionUser().AdminHotelid.ToString(), Convert.ToInt32(RequestSession.GetSessionUser().Hotelid));
//数据库连接状态
if (DataFactory.CheckSqlIsOpen(RequestSession.GetSessionUser().AdminHotelid.ToString(), Convert.ToInt32(RequestSession.GetSessionUser().Hotelid)))
{
zt.Attributes.Add("class", "ljqk zc");
ljzt.InnerText = "连接正常";
//ljzt.Style.Add("color", "#5FE390");
tk.InnerHtml = "";
}
else
{
zt.Attributes.Add("class", "ljqk yc");
ljzt.InnerText = "连接异常";
HCheckSqlIsOpen.Value = "1";
//ljzt.Style.Add("color", "#FA6F72");
}
}
catch { }
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
string guid = CommonHelper.GetGuid;
Hashtable ht = new Hashtable();
Hashtable ht_Notice = new Hashtable();
ht["IsAdmin"] = 2;
ht["User_Name"] = User_Name.Value;
ht["User_Account"] = User_Account.Value; //登录账号
ht["User_Phone"] = User_Account.Value; //手机号码
if (User_Pwd.Value != "*************")
{
if (User_Pwd.Value == "")
{
User_Pwd.Value = "123456";
}
ht["User_Pwd"] = Md5Helper.MD5(User_Pwd.Value, 32);
}
ht["User_Sex"] = 1;
ht["Email"] = ""; // 电子邮箱
ht["Title"] = "";
ht["Theme"] = ""; //
ht["User_Remark"] = ""; //备注
ht["ygh"] = ygh.Value; //国光工号
ht["hotelid"] = HotelId.Value;
ht["HotelListId"] = HotelId.Value;
ht["AdminHotelid"] = AdminHotelid.Value;
ht["Credentials_Type"] = Credentials_Type.Value;
ht["Credentials_Number"] = Credentials_Number.Value;
ht["RoomState"] = hdRoomState.Value;
ht["HotelData"] = hdHotelData.Value;
ht["Organization_ID"] = hdOrgId.Value;
ht["PublicShow"] = hdPublicShow.Value;
ht["ReserveMoney"] = hdReserveMoney.Value;
if (!string.IsNullOrEmpty(hdUserId.Value) && string.IsNullOrEmpty(hRestore.Value))
{
guid = hdUserId.Value;
ht["ModifyDate"] = DateTime.Now;
ht["ModifyUserId"] = RequestSession.GetSessionUser().UserId;
ht["ModifyUserName"] = RequestSession.GetSessionUser().UserName;
StringBuilder sbPR = new StringBuilder();
sbPR.Append("SELECT User_Account FROM Base_UserInfo WHERE User_Account= @User_Account and User_ID <> @User_ID and DeleteMark = 1");
SqlParam[] parmAdd = new SqlParam[] {
new SqlParam("@User_Account", User_Account.Value),
new SqlParam("@User_ID", hdUserId.Value)
};
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sbPR, parmAdd);
if (dt != null && dt.Rows.Count > 0)
{
ShowMsgHelper.Alert_Error("操作失败！该员工手机号已存在");
return;
}
}
else
{
StringBuilder sbPR = new StringBuilder();
sbPR.Append("SELECT User_Account FROM Base_UserInfo WHERE User_Account= @User_Account and (DeleteMark = 1 OR hotelid = @hotelid) and IsAdmin = 2");
SqlParam[] parmAdd = new SqlParam[] {
new SqlParam("@User_Account", User_Account.Value),
new SqlParam("@hotelid", HotelId.Value)
};
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sbPR, parmAdd);
if (dt != null && dt.Rows.Count > 0)
{
ShowMsgHelper.Alert_Error("操作失败！该员工手机号已存在");
return;
}
ht["User_ID"] = guid;
ht["CreateUserId"] = RequestSession.GetSessionUser().UserId;
ht["CreateUserName"] = RequestSession.GetSessionUser().UserName;
ht["CreateDate"] = DateTime.Now;
}
ht["ModifyDate"] = DateTime.Now;
ht["DeleteMark"] = 1;
bool IsOk;
if (!string.IsNullOrEmpty(hRestore.Value))
{
ht["User_Pwd"] = Md5Helper.MD5("123456", 32);
IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserInfo", "User_ID", "", ht);
}
else
{
IsOk = DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserInfo", "User_ID", hdUserId.Value, ht);
}
if (IsOk)
{
#region ** 角色 **
if (ddlUser_Role.SelectedValue != "-1")
{
DataFactory.SqlDataBase().DeleteData("Base_UserRole", "User_ID", guid);//删除角色
Hashtable htRole = new Hashtable();
htRole["UserRole_ID"] = CommonHelper.GetGuid;
htRole["User_ID"] = guid;
htRole["Roles_ID"] = ddlUser_Role.SelectedValue;
DataFactory.SqlDataBase().Submit_AddOrEdit("Base_UserRole", "User_ID", "", htRole);//重新添加角色
}
#endregion
// IsOk = this.add_ItemForm(checkbox_value.Value.Split(','), guid);
}
if (IsOk)
{
ht_Notice["HotelData"] = hdHotelData.Value;
DataFactory.SqlDataBase().Submit_AddOrEdit("Notice", "UserId", hdUserId.Value, ht_Notice);
ShowMsgHelper.AlertReloadClose("操作成功！", "ListGrid(false)");
}
else
{
ShowMsgHelper.Alert_Error("操作失败！");
}
}
public void gethtmls(HttpContext context)
{
string TbHtml = "";
#region ***** 加载表格 *****
DataTable dt = CommonMethod.GetVip(RequestSession.GetSessionUser().AdminHotelid.ToString());
if (dt != null && dt.Rows.Count > 0)
{
//头部标题
TbHtml += "<tr>";
TbHtml += "<th width='40'>启用</th><th width='130'>方式</th>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<th class='hylxnames' jb='" + dt.Rows[j]["code"].ToString() + "'>";
TbHtml += dt.Rows[j]["LevelName"].ToString();
TbHtml += "</th>";
}
TbHtml += "</tr>";
//累计积分升级
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>累计积分升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
if (j == 0)
{
TbHtml += "<input type='text' disabled='disabled' value='0' class='jfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>分</i>";
}
else
{
TbHtml += "<input type='text' class='jfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>分</i>";
}
TbHtml += "</td>";
}
TbHtml += "</tr>";
//累计消费升级高于
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>累计消费升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
if (j == 0)
{
TbHtml += "<input type='text' disabled='disabled' value='0' class='xfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
else
{
TbHtml += "<input type='text' class='xfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
TbHtml += "</td>";
}
TbHtml += "</tr>";
//单次消费升级高于
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>单次消费升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
if (j == 0)
{
TbHtml += "<input type='text' disabled='disabled' value='0' class='dcxfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
else
{
TbHtml += "<input type='text' class='dcxfsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
TbHtml += "</td>";
}
TbHtml += "</tr>";
//充值升级高于
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>累计充值升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
if (j == 0)
{
TbHtml += "<input type='text' disabled='disabled' value='0' class='czsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
else
{
TbHtml += "<input type='text' class='czsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
TbHtml += "</td>";
}
TbHtml += "</tr>";
//单次充值升级高于
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>单次充值升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
if (j == 0)
{
TbHtml += "<input type='text' disabled='disabled' value='0' class='dcczsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
else
{
TbHtml += "<input type='text' class='dcczsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
}
TbHtml += "</td>";
}
TbHtml += "</tr>";
//购买升级高于
TbHtml += "<tr><td><i class='icon-radio6'></i></td><td>购买升级</td>";
for (int j = 0; j < dt.Rows.Count; j++)
{
TbHtml += "<td>";
TbHtml += "<input type='text' class='gmsjgy' jb='" + dt.Rows[j]["code"].ToString() + "' /><i class='dw'>元</i>";
TbHtml += "</td>";
}
// TbHtml += "<td>";
// TbHtml += @"<div class='radio' id='gnlx'>
// <label class='checked'>原价购买</label>
// <label >差价购买</label>
// </div>";
// TbHtml += "</td>";
TbHtml += "</tr>";
}
#endregion
context.Response.Write(TbHtml);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public int Delete(string KeyValue)
{
#region 获取旧值
var oldEntity = this.GetEntity(KeyValue);
#endregion
int IsOk = DataFactory.DbUtils().Delete("BPMS_Items", "ItemsId", KeyValue);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.DeleteTaskLog <BPMS_Items>(oldEntity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <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()");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_Items entity)
{
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_Items>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
adminhotelid.Value = RequestSession.GetSessionUser().AdminHotelid.ToString();
StringBuilder sqlss = new StringBuilder();
sqlss.Append("select * from PreferentialType where IsElectronics=0");
DataTable dts = DataFactory.SqlDataBase().GetDataTableBySQL(sqlss);
if (dts.Rows.Count > 0)
{
DDLmode.Items.Insert(0, new ListItem("请选择", "0"));
for (int i = 0; i < dts.Rows.Count; i++)
{
DDLmode.Items.Insert(i + 1, new ListItem(dts.Rows[i]["TypeName"].ToString(), dts.Rows[i]["id"].ToString()));
}
}
Com.SetChildren(0, 0, 0, DDLmode, 0);
StringBuilder sqlsss = new StringBuilder();
sqlsss.Append("select * from CouponType ");
DataTable dtss = DataFactory.SqlDataBase().GetDataTableBySQL(sqlsss);
if (dtss.Rows.Count > 0)
{
ddltype.Items.Insert(0, new ListItem("请选择", "0"));
for (int i = 0; i < dtss.Rows.Count; i++)
{
ddltype.Items.Insert(i + 1, new ListItem(dtss.Rows[i]["name"].ToString(), dtss.Rows[i]["id"].ToString()));
}
}
Com.SetChildren(0, 0, 0, ddltype, 0);
if (Request["ID"] != null)
{
string sql = string.Format(@"select * from coupon where id='{0}'", Request["id"]);
DataTable ds = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sql));
if (ds != null && ds.Rows.Count > 0)
{
B_sj.Value = ds.Rows[0]["BiginTime"].ToString().Split(' ')[0];
E_sj.Value = ds.Rows[0]["EndinTime"].ToString().Split(' ')[0];
txtName.Value = ds.Rows[0]["CouponName"].ToString();
txtPar.Value = ds.Rows[0]["Par"].ToString();
txtUsedMin.Value = ds.Rows[0]["UsedMin"].ToString();
txtInstructions.Value = ds.Rows[0]["ProductRange"].ToString();
_sumhotel = sumhotel.Value = ds.Rows[0]["ServiceRange"].ToString();
DDLmode.SelectedValue = ds.Rows[0]["Mode"].ToString();
ddltype.SelectedValue = ds.Rows[0]["TypeID"].ToString();
//指定赠送
if (ds.Rows[0]["MembergradeType"] != null && ds.Rows[0]["MembergradeType"].ToString() != "")
{
_zdzs = hfzdzs.Value = ds.Rows[0]["MembergradeType"].ToString();
}
if (ds.Rows[0]["FirstMoney"] != null && ds.Rows[0]["FirstMoney"].ToString() != "")
{
txtFirstMoney.Value = ds.Rows[0]["FirstMoney"].ToString();
}
if (ds.Rows[0]["SecondMoney"] != null && ds.Rows[0]["SecondMoney"].ToString() != "")
{
txtcz.Value = ds.Rows[0]["SecondMoney"].ToString();
}
if (ds.Rows[0]["IsEnable"] != null && ds.Rows[0]["IsEnable"].ToString() != "")
{
hfsfqy.Value = _sfqy = ds.Rows[0]["IsEnable"].ToString();
}
if (ds.Rows[0]["Is_Day_ok"] != null && ds.Rows[0]["Is_Day_ok"].ToString() != "")
{
hfIs_Day_ok.Value = _Is_Day_ok = ds.Rows[0]["Is_Day_ok"].ToString();
}
if (ds.Rows[0]["hytype"] != null && ds.Rows[0]["hytype"].ToString() != "")
{
hhytype.Value = _hytype = ds.Rows[0]["hytype"].ToString();
}
if (ds.Rows[0]["Isgiving"] != null && ds.Rows[0]["Isgiving"].ToString() != "")
{
hfsfzs.Value = _sfzs = ds.Rows[0]["Isgiving"].ToString();
}
if (ds.Rows[0]["ConsumptionType"] != null && ds.Rows[0]["ConsumptionType"].ToString() != "")
{
HConsumptionType.Value = _ConsumptionType = ds.Rows[0]["ConsumptionType"].ToString();
}
txtNum.Value = ds.Rows[0]["count"].ToString();
txtTotal.Value = ds.Rows[0]["Total"].ToString();
if (ds.Rows[0]["Mode"].ToString() == "2")//消费赠送
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "none");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "");
zssm.Style.Add("display", "none");
sfzs.Style.Add("display", "none");
}
else if (ds.Rows[0]["Mode"].ToString() == "10")//指定赠送
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "none");
sfzs.Style.Add("display", "none");
if (ds.Rows[0]["MembergradeType"].ToString() == "1")
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "");
sfzs.Style.Add("display", "");
}
else if (ds.Rows[0]["MembergradeType"].ToString() == "2")
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "");
hydj.Style.Add("display", "");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "");
sfzs.Style.Add("display", "");
}
else if (ds.Rows[0]["MembergradeType"].ToString() == "3")
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "");
hyxx.Style.Add("display", "");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "");
sfzs.Style.Add("display", "");
}
}
else if (ds.Rows[0]["Mode"].ToString() == "15") //生日赠送
{
hdSendType.Value = ds.Rows[0]["BirthdaySendType"].ToString();
srzs.Style.Add("display", "");
zdzs.Style.Add("display", "none");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "none");
sfzs.Style.Add("display", "none");
}
else//其他类型不可见
{
srzs.Style.Add("display", "none");
zdzs.Style.Add("display", "none");
hydj.Style.Add("display", "none");
hykh.Style.Add("display", "none");
hyxx.Style.Add("display", "none");
xfje.Style.Add("display", "none");
zssm.Style.Add("display", "none");
sfzs.Style.Add("display", "none");
}
//有效期类型
if (ds.Rows[0]["EffectiveType"] != null && ds.Rows[0]["EffectiveType"].ToString() != "")
{
hfEffectiveType.Value = _Effective = ds.Rows[0]["EffectiveType"].ToString();
}
//有效天数
if (ds.Rows[0]["EffectiveDay"] != null && ds.Rows[0]["EffectiveDay"].ToString() != "")
{
txtDay.Value = ds.Rows[0]["EffectiveDay"].ToString();
}
hfdID.Value = Request["id"];
IsMembergrade(ds.Rows[0]["Membergrade"].ToString());
IsyxMembergrade(ds.Rows[0]["ishy"].ToString());
Isjjr(ds.Rows[0]["jjr"].ToString());
IsOpen_Hotel(ds.Rows[0]["Open_Hotel"].ToString());
//hjjr.Value = ds.Rows[0]["jjr"].ToString();
hyxrq.Value = ds.Rows[0]["yxrq"].ToString();
}
}
else
{
IsMembergrade("0");
IsyxMembergrade("0");
Isjjr("0");
IsOpen_Hotel("0");
}
}
}
public void Gift(int id)
{
if (DDLmode.Items[DDLmode.SelectedIndex].Text == "指定赠送")
{
try
{
string URI = "http://www.zidinn.com/SysSetBase/coupons/GetCouponList.ashx";
//string URI = "http://localhost:520/SysSetBase/coupons/GetCouponList.ashx";
string myParameters = "id=" + id + "&Menu=GiftCoupons&AdminHotelid=" + RequestSession.GetSessionUser().AdminHotelid.ToString();
//实例化
WebClient client = new WebClient();
// client.UseDefaultCredentials = true;
client.Headers[HttpRequestHeader.ContentType] = "application/x-www-form-urlencoded";
client.Encoding = Encoding.UTF8;
client.UploadString(URI, myParameters);
}
catch (Exception ex)
{
Log.Error("指定赠送错误", ex.Message);
}
}
}
public void Isjjr(string jjr)
{
StringBuilder html = new StringBuilder();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT year,COUNT(year) count FROM Festival WHERE AdminHotelid='{0}' GROUP BY year ", RequestSession.GetSessionUser().AdminHotelid.ToString());
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html.AppendFormat("<li class='clearfix'>");
html.AppendFormat("<span'>{0}年</span>", dt.Rows[i][0].ToString());
html.AppendFormat("<p class='checkbox cb2' style='display: block;'>");
if (CommonHelper.GetInt(dt.Rows[i][1]) > 0)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT * FROM dbo.Festival WHERE year={0} and AdminHotelid='{1}' ORDER BY year ASC", dt.Rows[i][0].ToString(), RequestSession.GetSessionUser().AdminHotelid.ToString());
DataTable dtjr = DataFactory.SqlDataBase().GetDataTableBySQL(sb);
if (dtjr != null && dtjr.Rows.Count > 0)
{
for (int j = 0; j < dtjr.Rows.Count; j++)
{
html.AppendFormat("<label val='{0}' class='{2}' >{1}</label>", dtjr.Rows[j]["id"].ToString(), dtjr.Rows[j]["name"].ToString(), loadjjr(dtjr.Rows[j]["id"].ToString(), jjr));
}
}
}
html.AppendFormat("</p></li>");
}
}
_jjr = html.ToString();
}
public void IsOpen_Hotel(string Open_Hotel)
{
StringBuilder sb = new StringBuilder();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("SELECT ID,name FROM dbo.Hotel WHERE type=1 AND DeleteMark=1 AND AdminHotelid='{0}'", RequestSession.GetSessionUser().AdminHotelid.ToString());
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append(string.Format("<label class='{0}' val='{2}'>{1}</label>", loadOpen_Hotel(dt.Rows[i]["ID"].ToString(), Open_Hotel.ToString()), dt.Rows[i]["name"].ToString(), dt.Rows[i]["ID"].ToString()));
}
}
_Open_Hotel = sb.ToString();
}
public string Index(HttpContext context)
{
string result = "";
string sql;
try
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("Name");
dt.Columns.Add("Data");
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
sql = "select * from Company_51sole where companyId=" + user.CompanyId;
int sole = db.Database.SqlQuery <Company_51sole>(sql).Count();
if (sole > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "51Sole";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "51Sole";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_99inf where companyId=" + user.CompanyId;
int inf = db.Database.SqlQuery <Company_99inf>(sql).Count();
if (inf > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "久久信息";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "久久信息";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_atobo where companyId=" + user.CompanyId;
int atobo = db.Database.SqlQuery <Company_atobo>(sql).Count();
if (atobo > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "阿土伯";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "阿土伯";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_b2b168 where companyNo=" + user.CompanyId;
int b2b = db.Database.SqlQuery <Company_b2b168>(sql).Count();
if (b2b > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "八方资源";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "八方资源";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_gtobal where companyNo=" + user.CompanyId;
int gtobal = db.Database.SqlQuery <Company_gtobal>(sql).Count();
if (gtobal > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "际通宝";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "际通宝";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_jqw where companyId=" + user.CompanyId;
int jqw = db.Database.SqlQuery <Company_jqw>(sql).Count();
if (jqw > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "金泉网";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "金泉网";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
}
}
result = "{\"code\":0,\"msg\":\"\",\"count\":6,\"data\":" + JsonConvert.SerializeObject(dt) + "}";
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
bool result = false;
int returnType = 0;
Hashtable ht = depositManager.GetDataByID(_key);
string depositMoney = SiteHelper.GetHashTableValueByKey(ht, "DepositMoney");
string depositPayWay = SiteHelper.GetHashTableValueByKey(ht, "DepositPayWay");
string depositTradeNo = SiteHelper.GetHashTableValueByKey(ht, "DepositTradeNo");
string realName = SiteHelper.GetHashTableValueByKey(ht, "RealName");
string bindPhone = SiteHelper.GetHashTableValueByKey(ht, "BindPhone");
decimal refundMoney = 0.00m;
refundMoney = decimal.Parse(depositMoney);
if (State.Value == "2")
{
string errmsg = "";
string code = "";
if (depositPayWay == "1")
{
//支付宝退款
AlipayRefund alipay = new AlipayRefund();
result = alipay.Refund2(depositTradeNo, refundMoney, out errmsg, out code);
Logger.Warn(string.Format("{0},{1}支付宝退款:{2}", realName, bindPhone, errmsg));
if (!result && "40004".Equals(code))
{
//ShowMsgHelper.Alert_Error("支付宝退款失败:" + errmsg + "！");
//return;
//判断是否保存了buyer_id
string buyer_id = SiteHelper.GetHashTableValueByKey(ht, "buyer_id");
if (string.IsNullOrEmpty(buyer_id))
{
//buyer_id为空需要查询订单
AlipayOrderQuery orderQuery = new AlipayOrderQuery();
OrderQueryResult queryResult = orderQuery.QueryByTradeNO(depositTradeNo);
buyer_id = queryResult.buyer_user_id;
}
if (!string.IsNullOrEmpty(buyer_id))
{
//执行单笔转账到支付宝账户
result = alipay.Transfer(depositTradeNo, buyer_id, refundMoney, out errmsg);
Logger.Warn(string.Format("{0},{1}支付宝转账退款:{2}", realName, bindPhone, errmsg));
returnType = 1;
if (!result)
{
ShowMsgHelper.Alert_Error("支付宝转账退款失败:" + errmsg + "！");
return;
}
}
}
}
else if (depositPayWay == "2")
{
//微信退款
WxRefund wxpay = new WxRefund();
result = wxpay.refund2(depositTradeNo, refundMoney, out errmsg);
if (!result)
{
ShowMsgHelper.Alert_Error("微信退款失败:" + errmsg + "！");
return;
}
}
else if (depositPayWay == "5")
{
//微信公众号退款
api.weapp.pay.wxpay.WxRefund wxpay = new api.weapp.pay.wxpay.WxRefund();
result = wxpay.refund2(depositTradeNo, refundMoney, out errmsg);
if (!result)
{
ShowMsgHelper.Alert_Error("微信公众号退款失败:" + errmsg + "！");
return;
}
}
}
else
{
result = true;
}
if (result)
{
result = depositManager.HandleReturnDeposit(_key, State.Value, Remark.Text.Trim(), RequestSession.GetSessionUser().UserName.ToString(), returnType);
if (result)
{
ShowMsgHelper.AlertMsgNoFresh("操作成功！");
}
else
{
ShowMsgHelper.Alert_Error("操作失败！");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request["User_ID"] != null)
{
hdHotelId.Value = Request["HotelId"].ToString();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT User_ID,User_Account,User_Name,WX_Nickname,Roles_Name,CreateDate FROM V_Base_UserInfoRole WHERE AdminHotelid = '" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' and hotelid = '" + hdHotelId.Value + "' and User_ID='" + Request["User_ID"].ToString() + "' ");
DataTable ds = DataFactory.SqlDataBase().GetDataTableBySQL(sb);
if (ds != null && ds.Rows.Count > 0)
{
hdUser_ID.Value = ds.Rows[0]["User_ID"].ToString();
lblPhone.Text = ds.Rows[0]["User_Account"].ToString();
lblName.Text = ds.Rows[0]["User_Name"].ToString();
lblWXName.Text = ds.Rows[0]["WX_Nickname"].ToString();
lblRolse.Text = ds.Rows[0]["Roles_Name"].ToString();
lblAddTime.Text = Convert.ToDateTime(ds.Rows[0]["CreateDate"].ToString()).ToString("yyyy-MM-dd hh:mm");
Hashtable hs = new Hashtable();
hs["UserId"] = ds.Rows[0]["User_ID"].ToString();
hs["Phone"] = ds.Rows[0]["User_Account"].ToString();
DataTable ds_Sales = DataFactory.SqlDataBase().GetDataTableProc("P_Sales_record", hs);
if (ds_Sales != null && ds_Sales.Rows.Count > 0)
{
//销量金额 @Sales_Total
lblSales_Total.Text = ds_Sales.Rows[0]["Sales_Total"].ToString();
//累计奖金 @Bonus_Total
lblBonus_Total.Text = ds_Sales.Rows[0]["Bonus_Total"].ToString();
//提现奖金 @WithdrawCash
lblWithdrawCash.Text = ds_Sales.Rows[0]["WithdrawCash"].ToString();
//剩余奖金 @ExtractableMoney
lblExtractableMoney.Text = ds_Sales.Rows[0]["ExtractableMoney"].ToString();
//带来客户 @Register_Total
lblRegister_Total.Text = ds_Sales.Rows[0]["Register_Total"].ToString();
//入住客户 @CheckIn_Total
lblCheckIn_Total.Text = ds_Sales.Rows[0]["CheckIn_Total"].ToString();
}
}
}
//树形菜单
Hdhoteladmin.Value = RequestSession.GetSessionUser().AdminHotelid.ToString();
bool blHotelTree = false; //是否有多分店权限 多店显示酒店树
string HotelId = ""; //如果只有一家店 默认的酒店ID
if (RequestSession.GetSessionUser().Hotelid.ToString() == "0")
{
hotelTreeHtml = HotelTreeHelper.HotelTree(Hdhoteladmin.Value, 1, out blHotelTree, out HotelId);
}
else
{
blHotelTree = false;
HotelId = RequestSession.GetSessionUser().Hotelid.ToString();
}
HotelTree.Visible = blHotelTree;
htHotelTree.Value = blHotelTree.ToString();
hdHotelId.Value = HotelId;
}
}
public void getinfo(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "sort";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "HotelName")
{
sb.Append(" and (HotelName like '%" + nv[1] + "%' or hylxname like '%" + nv[1] + "%' or bz like '%" + nv[1] + "%' )");
}
else if (nv[0] == "HotelId")
{
if (nv[1].ToString() != "-1")
{
sb.Append(" and HotelId = '" + nv[1] + "' ");
}
}
else
{
sb.Append(" and " + nv[0] + " = '" + nv[1] + "' ");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("v_CardRecharges", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
IList <SqlParam> IList_param = new List <SqlParam>();
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
protected void Page_Load(object sender, EventArgs e)
{
this._UserPwd = RequestSession.GetSessionUser().UserPwd.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Update(BPMS_Items entity)
{
#region 获取旧值
var oldEntity = this.GetEntity(BPMS_SysLogDAL.Instance.GetKeyFieldValue <BPMS_Items>(entity).ToString());
#endregion
int IsOk = DataFactory.DbUtils().Update(entity, "ItemsId");
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.UpdateTaskLog <BPMS_Items>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 确认事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Accept_Click(object sender, EventArgs e)
{
bool IsOk = false;
bpms_organization = ControlBindHelper.GetWebControls <BPMS_Organization>(this.Page);
bpms_organization.Enabled = Enabled.Checked ? 1 : 0;
bpms_organization.IsInnerOrganize = IsInnerOrganize.Checked ? 1 : 0;
if (!string.IsNullOrEmpty(_key))//判断是否编辑
{
bpms_organization.OrganizationId = _key;
bpms_organization.ModifyDate = DateTime.Now;
bpms_organization.ModifyUserId = RequestSession.GetSessionUser().UserId;
bpms_organization.ModifyUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_organizationibll.Update(bpms_organization);
if (IsOk)
{
//保存成功后将数据同步到微信企业号
if (!myCommFun.UpdateDepartment(Convert.ToInt32(bpms_organization.Code), bpms_organization.FullName, toQYParentId(bpms_organization.ParentId), Convert.ToInt32(bpms_organization.SortCode)))
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0032);
}
ShowMsgHelper.AlertCallback(MessageHelper.MSG0006);
}
}
else
{
bpms_organization.OrganizationId = CommonHelper.GetGuid;
bpms_organization.ModifyUserId = RequestSession.GetSessionUser().UserId;
bpms_organization.ModifyUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_organizationibll.Insert(bpms_organization);
if (IsOk)
{
//保存成功后将数据同步到微信企业号
if (!myCommFun.CreateDepartment(Convert.ToInt32(bpms_organization.Code), bpms_organization.FullName, toQYParentId(bpms_organization.ParentId), Convert.ToInt32(bpms_organization.SortCode)))
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0032);
}
bpms_datapermissionibll.AddItemDefault(RequestSession.GetSessionUser().RoleId, "Organization", bpms_organization.OrganizationId, RequestSession.GetSessionUser().UserId);
ShowMsgHelper.AlertCallback(MessageHelper.MSG0005);
}
}
if (!IsOk)
{
ShowMsgHelper.Alert_Error(MessageHelper.MSG0022);
}
}
protected void Page_Load(object sender, EventArgs e)
{
userName.InnerText = RequestSession.GetSessionUser().UserName;
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_Roles entity)
{
entity.SortCode = CommonHelper.GetInt(this.GetMaxCode());
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_Roles>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// GridView数据导入方法
/// </summary>
private void LoadData()
{
List <MMS_PurchaseIndentContent> infoList = new List <MMS_PurchaseIndentContent>();
//调用业务层方法取采购计划单列表
infoList = PurchaseIndentService.Instance.GetAllInfo();
RM.Busines.DAL.RM_UserInfo_Dal daluser = new Busines.DAL.RM_UserInfo_Dal();
//取所有的字典信息
List <Base_DictionaryInfo> dictList = DictionaryInfoService.Instance.GetAllInfo();
var query = from info in infoList
// where (info.PayMode == "1" && info.Provider == RequestSession.GetSessionUser().UserAccount.ToString().Trim())
where ((info.AuditFlag == null || info.AuditFlag == false) && info.PayMode == "2" && info.PurchaseMan.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim())) || ((info.PayMode == "1" || info.PayMode == null) && info.Provider.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim()))
select new
{
id = info.ID,
info.PurchaseBillCode,
info.PurchaseMan,
info.PurchaseDate,
info.InvoiceCode,
info.DeptName,
info.AuditFlag,
info.PayMode,
Operator = daluser.GetUserInfo(info.Operator).Rows[0]["User_Name"].ToString().Trim()
};
DataTable dt = DataTableHelper.CopyToDataTable(query);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
//dgvInfo.DataKeyNames = new[] {"ID"}; //设置GridView数据主键
//dgvInfo.DataSource = query.ToList(); //设置GridView数据源
//dgvInfo.DataBind();
}
public void getinfo(HttpContext context)
{
string hotelid = context.Request["hotelid"].Trim();
StringBuilder sql = new StringBuilder();
sql.AppendFormat("select * from Full_house where hotelid='{0}' and AdminHotelid='{1}' order by ID desc", hotelid, RequestSession.GetSessionUser().AdminHotelid.ToString());
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql);
string dtName = "Full_house";
string json = JsonHelper.DataTableToJson(dt, dtName);
context.Response.Write(json);
}
/// <summary>
/// 批量新增用户权限
/// </summary>
/// <param name="item_value">对象主键</param>
/// <param name="user_id">用户主键</param>
/// <returns></returns>
public bool add_ItemForm(string[] item_value, string user_id)
{
try
{
int index = 0;
StringBuilder[] sqls = new StringBuilder[(item_value.Length + 2)];
object[] objs = new object[(item_value.Length + 2)];
StringBuilder groupDelete_Right = new StringBuilder();
groupDelete_Right.Append("Delete From Base_UserMenuGroup Where User_ID = @User_ID");
SqlParam[] group_Right = new SqlParam[] { new SqlParam("@User_ID", user_id) };
sqls[0] = groupDelete_Right;
objs[0] = group_Right;
StringBuilder sbDelete_Right = new StringBuilder();
sbDelete_Right.Append("Delete From Base_UserRight Where User_ID =@User_ID");
SqlParam[] parm_Right = new SqlParam[] { new SqlParam("@User_ID", user_id) };
sqls[1] = sbDelete_Right;
objs[1] = parm_Right;
index = 2;
foreach (var item in item_value)
{
if (item.Length > 0)
{
//菜单组
StringBuilder sb_group = new StringBuilder();
sb_group.Append("Insert into Base_UserMenuGroup(");
sb_group.Append("User_ID,MenuGroup_ID,CreateUserId,CreateUserName");
sb_group.Append(")Values(");
sb_group.Append("@User_ID,@MenuGroup_ID,@CreateUserId,@CreateUserName)");
SqlParam[] parm_group = new SqlParam[] {
new SqlParam("@User_ID", user_id),
new SqlParam("@MenuGroup_ID", item),
new SqlParam("@CreateUserId", RequestSession.GetSessionUser().UserId),
new SqlParam("@CreateUserName", RequestSession.GetSessionUser().UserName)
};
sqls[index] = sb_group;
objs[index] = parm_group;
index++;
////用户权限
//StringBuilder sbadd = new StringBuilder();
//sbadd.Append("Insert into Base_UserRight(");
//sbadd.Append("UserRight_ID,User_ID,Menu_Id,CreateUserId,CreateUserName");
//sbadd.Append(") SELECT LOWER(NEWID()),'" + user_id + "',Menu_Id,'" + RequestSession.GetSessionUser().UserId + "','" + RequestSession.GetSessionUser().UserName + "' FROM Base_MenuGroupRight WHERE MenuGroup_ID = @MenuGroup_ID ");
//SqlParam[] parmAdd = new SqlParam[] {
// new SqlParam("@MenuGroup_ID", item)};
//sqls[index] = sbadd;
//objs[index] = parmAdd;
//index++;
}
}
return(DataFactory.SqlDataBase().BatchExecuteBySql(sqls, objs) >= 0 ? true : false);
}
catch
{
return(false);
}
}
private void InitBindData()
{
DataTable dt = this.sys_idao.GetHomeShortcut_List(RequestSession.GetSessionUser().UserId.ToString());
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
public void updates(HttpContext context)
{
//&values=5,1,0,17:00,17:00,17:00,17:00|B,2,0,18:00,18:00,18:00,18:00|A,3,1,20:00,20:00,20:00,20:00&jfbs=1&rzmyj=1&dhyjblsj=1&wwyjblsj=0&zfyjblsj=0&ystfsj=0
StringBuilder sql = new StringBuilder();
sql.Append("delete Set_Upgrade WHERE AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid + "' ");
DataFactory.SqlDataBase().ExecuteBySql(sql);
string value = context.Request["values"].Trim();
string jfsjgy = context.Request["jfsjgy"].Trim();
//string jfsjdy = context.Request["jfsjdy"].Trim();
string xfsjgy = context.Request["xfsjgy"].Trim();
string czsjgy = context.Request["czsjgy"].Trim();
string dcxfsjgy = context.Request["dcxfsjgy"].Trim();
string dcczsjgy = context.Request["dcczsjgy"].Trim();
string gmsjgy = context.Request["gmsjgy"].Trim();
string gmlx = context.Request["gmlx"].Trim();
int x = 0;
string[] values = value.Split('|');
for (int i = 0; i < values.Length; i++)
{
Hashtable ht = new Hashtable();
ht["jb"] = values[i].Split(',')[0];
ht["jfsjgy"] = values[i].Split(',')[1];
//ht["jfsjdy"] = values[i].Split(',')[2];
ht["xfsjgy"] = values[i].Split(',')[2];
ht["dcxfsjgy"] = values[i].Split(',')[3];
ht["czsjgy"] = values[i].Split(',')[4];
ht["dcczsjgy"] = values[i].Split(',')[5];
ht["gmsjgy"] = values[i].Split(',')[6];
ht["sm"] = values[i].Split(',')[7];
ht["isjfsjgy"] = jfsjgy;
//ht["isjfsjdy"] = jfsjdy;
ht["isxfsjgy"] = xfsjgy;
ht["isczsjgy"] = czsjgy;
ht["isdcxfsjgy"] = dcxfsjgy;
ht["isdcczsjgy"] = dcczsjgy;
ht["isgmsjgy"] = gmsjgy;
ht["gmlx"] = gmlx;
ht["AdminHotelid"] = RequestSession.GetSessionUser().AdminHotelid.ToString();
x += DataFactory.SqlDataBase().InsertByHashtable("Set_Upgrade", ht);
string sqls = string.Format(@"Update hy_hylxbmb Set zk=@zk Where hylxcode=@hylxcode");
SqlParam[] parmAdd2 = new SqlParam[] {
new SqlParam("@zk", ht["gmsjgy"]),
new SqlParam("@hylxcode", ht["jb"])
};
DataFactory.SqlDataBase(RequestSession.GetSessionUser().AdminHotelid.ToString()).ExecuteBySql(new StringBuilder(sqls), parmAdd2);
if (i == 0)
{
int gmzc = 0;
if (gmsjgy == "1")
{
if (values[i].Split(',')[6].Trim() != "0")
{
gmzc = 1;
}
}
StringBuilder sqlup = new StringBuilder();
sqlup.AppendFormat("UPDATE Hotel_Admin SET RegCharge={0} ,RegMoney={1} WHERE AdminHotelid='{2}' ", gmzc.ToString(), values[i].Split(',')[6], RequestSession.GetSessionUser().AdminHotelid.ToString());
DataFactory.SqlDataBase().ExecuteBySql(sqlup);
}
}
context.Response.Write(x);
}
/// <summary>
/// 删除一条数据
/// </summary>
/// <param name="KeyValue">主键</param>
/// <param name="UserId">用户主键</param>
/// <returns></returns>
public int Delete(string KeyValue, string UserId)
{
#region 获取旧值
var oldEntity = this.GetEntity(KeyValue);
#endregion
StringBuilder strSql = new StringBuilder();
strSql.Append(@"DELETE FROM BPMS_Shortcut WHERE 1=1");
strSql.Append(" AND MenuId = @MenuId");
strSql.Append(" AND UserId = @UserId");
SqlParam[] param =
{
new SqlParam("@MenuId", KeyValue),
new SqlParam("@UserId", UserId)
};
int IsOk = DataFactory.SqlHelper().ExecuteBySql(strSql, param);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.DeleteTaskLog <BPMS_Shortcut>(oldEntity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}