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