public static string Empowers(string userlist, string relist) { try { BLL_UserBuyResources bll = new BLL_UserBuyResources(); List <Model_UserBuyResources> listModel = new List <Model_UserBuyResources>(); userlist = userlist.TrimEnd(','); relist = relist.TrimEnd(','); string _dSql = "delete UserBuyResources where BuyType = 'NBSQ' and UserId in ('" + userlist.Replace(",", "','") + "') and book_id in ('" + relist.Replace(",", "','") + "');"; foreach (string item in userlist.Split(',')) { if (!string.IsNullOrEmpty(item)) { foreach (string itemR in relist.Split(',')) { if (!string.IsNullOrEmpty(itemR)) { if (new BLL_UserBuyResources().GetRecordCount("UserId='" + item + "' and Book_id='" + itemR + "'") > 0) { } else { Model_UserBuyResources model = new Model_UserBuyResources(); model.UserBuyResources_ID = Guid.NewGuid().ToString(); model.UserId = item; model.Book_id = itemR; model.BuyType = "NBSQ";//内部授权 model.CreateTime = DateTime.Now; listModel.Add(model); } } } } } if (listModel.Count > 0) { //Rc.Common.DBUtility.DbHelperSQL.Query(_dSql); if (bll.AddUserBuyResources(listModel)) { return("1"); } else { return(""); } } else { return("1"); } } catch (Exception ex) { return("2"); } }
protected void btnBePower_Click(object sender, EventArgs e) { BLL_UserBuyResources bll = new BLL_UserBuyResources(); List <Model_UserBuyResources> listModel = new List <Model_UserBuyResources>(); string _bid = Request["bid"]; string _IDs = hidUserIDs.Value.TrimEnd(','); string _dSql = "delete UserBuyResources where UserId in ('" + _IDs.Replace(",", "','") + "') and book_id ='" + _bid + "';"; int result = 0; foreach (string item in _IDs.Split(',')) { if (!string.IsNullOrEmpty(item)) { Model_UserBuyResources model = new Model_UserBuyResources(); model.UserBuyResources_ID = Guid.NewGuid().ToString(); model.UserId = item; model.Book_id = _bid; model.BuyType = UserOrder_PaytoolEnum.NBSQ.ToString();//内部授权 model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; listModel.Add(model); } } try { Rc.Common.DBUtility.DbHelperSQL.ExecuteSql(_dSql); foreach (var item in listModel) { bool flag = bll.Add(item); if (flag) { new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS(Module_Id, string.Format("给老师授权成功,操作人:{0},资源标识:{1},老师标识:{2}" , loginUser.SysUser_ID, item.Book_id, item.UserId)); } else { new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("给老师授权失败,操作人:{0},资源标识:{1},老师标识:{2}" , loginUser.SysUser_ID, item.Book_id, item.UserId)); } result += flag == true ? 1 : 0; } if (result > 0) { ShowMsg(true, "操作成功!"); } else { ShowMsg(false, "操作失败!"); } } catch (Exception ex) { //记录错误日志 new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("给老师授权失败,操作人:{0},类:{1},方法{2},错误信息:{3}" , loginUser.SysUser_ID , ex.TargetSite.DeclaringType.ToString() , ex.TargetSite.Name.ToString() , ex.Message)); ShowMsg(false, "操作失败!"); return; } }
protected void LaodData() { BLL_UserBuyResources bllubr = new BLL_UserBuyResources(); DataTable dtubr = bllubr.GetList(" Book_id='" + ResourceFolder_ID + "' and UserId='" + FloginUser.UserId + "'").Tables[0]; if (dtubr.Rows.Count > 0) { Vbtn = true; btnBuy.Visible = false; } BLL_Bookshelves bll = new BLL_Bookshelves(); DataTable dt = bll.GetList("ResourceFolder_Id='" + ResourceFolder_ID + "'").Tables[0]; if (dt.Rows.Count > 0) { #region 处理图片显示宽高 int imgHeight = 0; int imgWidth = 0; string imgFilePath = Server.MapPath(dt.Rows[0]["BookImg_Url"].ToString()); if (System.IO.File.Exists(imgFilePath)) { System.Drawing.Image img = System.Drawing.Image.FromFile(imgFilePath); imgHeight = img.Height; imgWidth = img.Width; if (imgHeight / 300.0 > imgWidth / 220.0) { imgWidth = 0; if (imgHeight > 300) { imgHeight = 300; } } else { imgHeight = 0; if (imgWidth > 220) { imgWidth = 220; } } img.Dispose(); } #endregion //ltlImg.Text = string.Format("<img src='{0}' {1} {2} onerror=\"this.src='../images/re_nopic.jpg'\" width='186' height='239' />" // , dt.Rows[0]["BookImg_Url"].ToString() // , imgHeight > 0 ? string.Format("height='{0}'", imgHeight) : "" // , imgWidth > 0 ? string.Format("width='{0}'", imgWidth) : ""); ltlImg.Text = string.Format("<img src='{0}' onerror=\"this.src='../images/re_nopic.jpg'\" width='175' height='240' />" , dt.Rows[0]["BookImg_Url"].ToString()); ltlMaskImg.Text = string.Format("<img class='blur-item-hook' src='{0}' />" , dt.Rows[0]["BookImg_Url"].ToString()); ltlBookName.Text = dt.Rows[0]["Book_Name"].ToString(); btnBuy.Text = "购买 ¥" + dt.Rows[0]["BookPrice"].ToString(); ltlBookBif.Text = dt.Rows[0]["BookBrief"].ToString(); } string strsql = @"select ResourceFolder_Id,ResourceFolder_Name,Resource_Type,Resource_Class,File_Suffix,ResourceFolder_Level,ResourceFolder_ParentId from VW_ResourceAndResourceFolder where Book_ID='" + ResourceFolder_ID + "' order by ResourceFolder_Order"; DataTable dtre = Rc.Common.DBUtility.DbHelperSQL.Query(strsql).Tables[0]; if (dtre.Rows.Count > 0) { DataView dvw = new DataView(); dvw.Table = dtre; litTree.Text = InitNavigationTree("0", dtre.Rows[0]["Resource_Class"].ToString(), dvw, 1).ToString(); } string sql = @" select c.comment_id,c.comment_content,create_time,comment_evaluate,ISNULL(u.TrueName,u.UserName)as Commenter,o.Book_Id from userorder_comment c left join F_User u on u.UserId=c.user_id left join UserOrder o on o.UserOrder_No=c.order_num where o.Book_Id='" + ResourceFolder_ID + "'"; DataTable dtC = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0]; rptcourse_comment.DataSource = dtC; rptcourse_comment.DataBind(); }