protected void Page_Load(object sender, EventArgs e) { B_User.CheckIsLogged(Request.RawUrl); mu = buser.GetLogin(); if (!IsPostBack) { DataRow dr = ExOrder.SelReturnModel(OrderID); if (dr == null) { function.WriteErrMsg("订单不存在"); } if (DataConvert.CLng(dr["xsrid"]) != mu.UserID) { function.WriteErrMsg("你无权访问该订单"); } if (DataConvert.CLng(dr["status_order"]) != 99) { function.WriteErrMsg("订单不允许评价"); } Title_T.Text = DataConvert.CStr(dr["spmc"]); //订单成功,且未完结,且未评论或最近一次的评论超过(7*24*60),则可评 DataTable shareDT = DBCenter.SelTop(1, "ID", "*", "ZL_Order_Share", "ProID=" + dr["nrgid"] + " AND UserID=" + mu.UserID, "ID DESC"); if (shareDT.Rows.Count > 0) { DateTime last = Convert.ToDateTime(shareDT.Rows[0]["CDate"]); if ((DateTime.Now - last).TotalMinutes < (7 * 24 * 60)) { Save_Btn.Visible = false; tip_div.Visible = true; tip_div.InnerHtml = "你最近一次评论时间:" + last.ToString("yyyy年MM月dd日 HH:mm") + ",必须一周后才可再评论"; } } } }
/// <summary> /// 查询指定管理员是否拥有节点的某类操作权限 /// look|modify|addto|comments|columns|state /// </summary> /// <returns>true:有权限</returns> public static bool CheckNodeAuth(M_AdminInfo adminMod, int nid, string auth) { if (adminMod.IsSuperAdmin()) { return(true); } if (nid < 1 || string.IsNullOrEmpty(auth)) { return(false); } string roles = StrHelper.PureIDSForDB(adminMod.RoleList); if (string.IsNullOrEmpty(roles)) { return(false); } //检测权限是否在许可范围之内 string[] allowAuth = "look|modify|addto|comments|columns|state".Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); auth = allowAuth.FirstOrDefault(p => p.Equals(auth)); if (string.IsNullOrEmpty(auth)) { return(false); } //------------ string where = "Nid=" + nid + " AND RID IN (" + roles + ") "; where += " AND " + auth + "=1"; return(DBCenter.SelTop(1, "RN_ID", "*", "ZL_NodeRole", where, "").Rows.Count > 0); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = DBCenter.SelTop(1, "ID", "*", "ZL_Logo_Design", "Zstatus IN(0) AND ZType=1", ""); if (dt.Rows.Count < 1) { function.WriteErrMsg("取到的值为空"); } int id = DataConvert.CLng(dt.Rows[0]["ID"]); string content = DataConvert.CStr(dt.Rows[0]["LogoContent"]); Mid_Hid.Value = dt.Rows[0]["ID"].ToString(); if (string.IsNullOrEmpty(content)) { Ignore_Btn_Click(null, null); } Content_Hid.Value = content; Content_Hid.Value = StrHelper.DecompressString(Content_Hid.Value); string[] domainArr = new string[] { "https://www.raysandsigns.com/", "http://www.raysandsigns.com/", "https://raysandsigns.com/", "http://raysandsigns.com/", "http://win10:164/" }; foreach (string domain in domainArr) { Content_Hid.Value = Content_Hid.Value.Replace(domain, "/"); } } }
/// <summary> /// 获取下一个节点模型,如果不存在,则返回自身 /// </summary> public M_Node GetNextNode(int ParentID, int CurrentID) { int NextID = CurrentID; DataTable dt = DBCenter.SelTop(1, PK, "NodeID", TbName, "ParentID=" + ParentID + " AND OrderID>" + CurrentID, "OrderId"); if (dt.Rows.Count > 0) { NextID = DataConvert.CLng(dt.Rows); } return(this.SelReturnModel(NextID)); }
public ActionResult UserBaseField(int uid, int mode) { //@Html.Partial("Fields/Index_User_AddContent", new VM_FieldModel(Model.ModelID, Model.NodeID, new ModelConfig() { Source = ModelConfig.SType.UserContent }, Model.GeneralID)) DataTable valueDT = DBCenter.SelTop(1, "UserID", "*", "ZL_UserBase", "UserID=" + uid, ""); ModelConfig modcfg = new ModelConfig() { Source = ModelConfig.SType.Admin, ValueDT = valueDT }; modcfg.Mode = (ModelConfig.SMode)mode; VM_FieldModel model = new VM_FieldModel(ubBll.Select_All(), modcfg); return(View("Fields/Index_User_AddContent", model)); }
public ActionResult UserBase() { M_Uinfo basemu = buser.GetUserBaseByuserid(mu.UserID); ViewBag.gpMod = gpBll.SelReturnModel(mu.GroupID); ViewBag.basemu = basemu; DataTable valueDT = DBCenter.SelTop(1, "UserID", "*", "ZL_UserBase", "UserID=" + mu.UserID, ""); ModelConfig modcfg = new ModelConfig() { Source = ModelConfig.SType.Admin, ValueDT = valueDT }; VM_FieldModel model = new VM_FieldModel(ubBll.Select_All(), modcfg); ViewBag.htmlMod = model; return(View(mu)); }
public DataTable Sel() { List <SqlParameter> sp = new List <SqlParameter>(); string where = "ZType=1 "; if (!string.IsNullOrEmpty(SKey)) { sp.Add(new SqlParameter("skey", "%" + SKey + "%")); where += " AND Alias LIKE @skey"; } if (Mid > 0) { where += " AND ID=" + Mid; } return(DBCenter.SelTop(50, "ID", "ID,Alias,PreviewImg", "ZL_Logo_Design", where, "ID DESC", sp)); }
/// <summary> /// 获得前5名问答积分最多的用户 /// </summary> public DataTable GetTopUser() { return(DBCenter.SelTop(5, "UserID", "*", "ZL_User", "", "GuestScore DESC")); }
//---------------------------------------------------------------- //public DataTable SelectAll(int status = -100, string key = "") //{ // List<SqlParameter> sp = new List<SqlParameter>(); // string where = " 1=1 "; // if (status != -100) // { // where += " AND Status=" + status; // } // if (!string.IsNullOrEmpty(key)) // { // where += " AND A.Tittle LIKE @key"; // sp.Add(new SqlParameter("key", "%" + key + "%")); // } // return DBCenter.JoinQuery("A.*,B.GradeName", TbName, "ZL_Grade", "A.BType=B.GradeName", where, "AddTime DESC", sp.ToArray()); //} /// <summary> /// Default Page Used /// </summary> public DataTable SelectSee(int count, string Where, string strOrderby) { return(DBCenter.SelTop(count, PK, "*", TbName, Where, strOrderby)); }
public DataTable SelByGidToDT(int gid) { return(DBCenter.SelTop(1, "ID", "*", TbName, "GeneralID=" + gid, "ID DESC")); }