/// <summary> /// 通过指定条件获取节点,并通过指定条件对节点排序 /// </summary> /// <param name="FiledName">条件字段</param> /// <param name="FiledValue">条件值</param> /// <param name="OrderCondition">排序条件</param> /// <param name="startid">起始ID</param> /// <param name="endid">结束ID</param> /// <returns></returns> public DataTable GetNodeByCondition(ArrayList FiledName, ArrayList FiledValue, string OrderCondition,int startid,int endid) { string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); //string cmdtxt = "select * from (select NodeId,NodeName,NodeIdentifier,ParentID,NodePath,NodeMemo,NodePic,SortID,IsRecom,IsHtml,HtmlPath,NodeTemplate,Meta_Description,Meta_KeyWords ,row_number() over ( order by " + OrderCondition + ") as rowno from T_NodeList " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by " + OrderCondition; //System.Web.HttpContext.Current.Response.Write(sbCondition); string seltext =string.Empty; if (OrderCondition.ToString().Trim() == "") { seltext = "select * from (select NodeId,NodeName,NodeIdentifier,ParentID,NodePath,NodeMemo,NodePic,a.SortID,IsRecom,IsHtml,HtmlPath,NodeTemplate,Meta_Description,Meta_KeyWords,Adder ,row_number() over ( order by a.SortID asc,NodeID desc ) as rowno,Admin_RealName from T_NodeList a left join T_Admin b on a.Adder=b.Admin_ID where 1=1 " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by SortID asc,NodeID desc"; } else { seltext = "select * from (select NodeId,NodeName,NodeIdentifier,ParentID,NodePath,NodeMemo,NodePic,a.SortID,IsRecom,IsHtml,HtmlPath,NodeTemplate,Meta_Description,Meta_KeyWords,Adder ,row_number() over ( order by a.SortID asc,NodeID desc ) as rowno,Admin_RealName from T_NodeList a left join T_Admin b on a.Adder=b.Admin_ID where 1=1 " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by SortID asc,NodeID desc"; } dh.Open(); DataTable dt = dh.GetDataTable(CommandType.Text, seltext, null); dh.Close(); return dt; }
public int GetShopNumByCondition(ArrayList FiledName, ArrayList FiledValue) { int recordcount = 0; string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); string seltxt = "Select count(*) from T_Shop where 1=1 " + sbCondition; Object thisLock = new Object(); lock (thisLock) { dh.Open(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, seltxt, null)) { if (dr.HasRows) { dr.Read(); Int32.TryParse(dr[0].ToString(), out recordcount); } else { recordcount = 0; } } dh.Close(); } return(recordcount); }
protected void Page_Load(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); int pid = 0; string SelectVal = string.Empty; Int32.TryParse(CommOperate.GetStrFromRequestForm("uid"), out pid); SelectVal = CommOperate.GetStrFromRequestForm("sv"); TBLL.NodeBLL nbl = new NodeBLL(); DataTable childlist = nbl.GetChildNode(pid); if (childlist.Rows.Count > 0) { sb.Append("<option value='-1'>请选择...</option>"); for (int i = 0; i < childlist.Rows.Count; i++) { sb.Append("<option value='" + childlist.Rows[i]["NodeId"].ToString().Trim() + "'>" + childlist.Rows[i]["NodeName"].ToString().Trim() + "</opion>"); } } else { sb.Append("0"); } Response.Write(sb.ToString()); Response.End(); }
/// <summary> ///根据nodeid 和条件列表,获取所有新闻,includechild为0则不包括子节点的信息,不为0时则包括所有子节点信息(影响性能) /// </summary> /// <param name="NodeID"></param> /// <param name="FiledName"></param> /// <param name="FiledValue"></param> /// <param name="includechild"></param> /// <returns></returns> public int GetInfoNumByNode(int NodeID, ArrayList FiledName, ArrayList FiledValue, int includechild) { int recordcount = 0; string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); string cmdtxt = string.Empty; if (NodeID == 0) { cmdtxt = "Select count(*) from T_InfoList where 1=1 and IsDelete=0 " + sbCondition.ToString(); } else { if (includechild != 0) //包含子节点 { NodeOperate nop = new NodeOperate(); ArrayList childlist = nop.GetAllChildNode(NodeID); string childstring = string.Empty;//子节点列表 for (int i = 0; i < childlist.Count; i++) { childstring += childlist[i].ToString() + ","; } childstring = childstring.Substring(0, childstring.Length - 1);//截取最后一个"," ,组成类似1,2,3形式 cmdtxt = "Select count(*) from T_InfoList where IsDelete=0 and InfoCateID in(" + childstring.Trim() + ") " + sbCondition.ToString(); } else { cmdtxt = "Select count(*) from T_InfoList where IsDelete=0 and InfoCateID= " + NodeID + " " + sbCondition.ToString(); } } // System.Web.HttpContext.Current.Response.Write(cmdtxt); //System.Web.HttpContext.Current.Response.End(); dh.Open(); dh.BeginTrans(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, cmdtxt, null)) { if (dr.HasRows) { dr.Read(); Int32.TryParse(dr[0].ToString(), out recordcount); } else { recordcount = 0; } } dh.CommitTrans(); dh.Close(); return(recordcount); }
public DataTable GetInfoByNode(int NodeID, ArrayList FiledName, ArrayList FiledValues, int includechild, string OrderCondition, int startid, int endid) { string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValues); string cmdtxt = string.Empty; string orderbystring = string.Empty;//排序字符串 if (OrderCondition == "") { orderbystring = " order by a.SortID desc,InfoID desc "; } else { orderbystring = " order by " + OrderCondition + " "; } if (NodeID == 0) { cmdtxt = "select * from (select InfoID,InfoTitle,InfoSubMemo,InfoMemo,InfoPic, InfoType,a.SortID,IsRecom,InfoCateID,InfoAdder,InfoAddTime,IsCheck,row_number() over (" + orderbystring + ") as rowno,Admin_RealName from T_InfoList a left join T_Admin b on a.InfoAdder=b.Admin_ID where 1=1 and a.IsDelete=0 " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by SortID desc,InfoID desc "; } else { if (includechild != 0)//包含子节点 { NodeOperate nop = new NodeOperate(); ArrayList childlist = nop.GetAllChildNode(NodeID); string childstring = string.Empty;//子节点列表 for (int i = 0; i < childlist.Count; i++) { childstring += childlist[i].ToString() + ","; } childstring = childstring.Substring(0, childstring.Length - 1); cmdtxt = "select * from (select InfoID,InfoTitle,InfoSubMemo,InfoMemo,InfoPic, InfoType,a.SortID,IsRecom,InfoCateID,InfoAdder,InfoAddTime,IsCheck,row_number() over (" + orderbystring + ") as rowno ,Admin_RealName from T_InfoList a left join T_Admin b on a.InfoAdder=b.Admin_ID where 1=1 and a.IsDelete=0 and InfoCateID in (" + childstring + ") " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by SortID desc,InfoID desc "; } else { cmdtxt = "select * from (select InfoID,InfoTitle,InfoSubMemo,InfoMemo,InfoPic, InfoType,a.SortID,IsRecom,InfoCateID,InfoAdder,InfoAddTime,IsCheck,row_number() over (" + orderbystring + ") as rowno,Admin_RealName from T_InfoList a left join T_Admin b on a.InfoAdder=b.Admin_ID where 1=1 and a.IsDelete=0 and InfoCateID = " + NodeID.ToString() + " " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + " order by SortID asc,InfoID desc "; } } DataTable dt; dh.Open(); dh.BeginTrans(); dt = dh.GetDataTable(CommandType.Text, cmdtxt, null); dh.CommitTrans(); dh.Close(); return(dt); }
/// <summary> /// 获取管理员的datatable /// </summary> /// <param name="FiledName"></param> /// <param name="FiledValue"></param> /// <param name="startid"></param> /// <param name="endid"></param> /// <returns></returns> public DataTable GetAdminByCondition(ArrayList FiledName, ArrayList FiledValue, int startid, int endid) { string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); string cmdtxt = string.Empty; string orderbystring = " order by SortID asc,Admin_ID desc ";//排序字符串 cmdtxt = "select * from (select Admin_ID,Admin_UID,Admin_Stat,Admin_RealName,Admin_RegTime,Admin_LogTimes,Admin_Flag,SortID,row_number() over (" + orderbystring + ") as rowno from T_Admin where 1=1 and IsDelete=0 " + sbCondition + " ) as row where rowno between " + startid + " and " + endid.ToString() + orderbystring; dh.Open(); dh.BeginTrans(); DataTable dt = dh.GetDataTable(CommandType.Text, cmdtxt, null); dh.CommitTrans(); dh.Close(); return(dt); }
protected void Button1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string filetype1 = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf(".") + 1); if (FileType.ToLower().IndexOf(filetype1.ToLower()) > 0) { if (FileUpload1.PostedFile.ContentLength > MaxSize) { RunJs.AlertAndBack("文件大小超过限制"); } else { string filename = System.Guid.NewGuid().ToString() + "." + filetype1;//设置文件名 if (!Directory.Exists(Server.MapPath("/") + "/" + filePath + "/" + CommOperate.GetFolder())) { Directory.CreateDirectory(Server.MapPath("/") + "/" + filePath + "/" + CommOperate.GetFolder()); } string filepath = filePath + CommOperate.GetFolder() + filename; FileUpload1.SaveAs(Server.MapPath("/") + "/" + filePath + "/" + CommOperate.GetFolder() + filename); //保存文件 Response.Write("<html><body style='margin:0px;padding:0px;'>"); Response.Write("<script type=\"text/javascript\" src=\"/Scripts/Library/jquery-1.7.1.min.js\"></script>"); Response.Write("<script>window.parent.document.getElementById(\"" + Content + "\").value='" + filepath + "';"); // Response.Write("var ObjSelect = document.parentWindow.parent.document.getElementById('CatePic');"); //Response.Write("ObjSelect.options[ObjSelect.options.selectedIndex].value='"+filepath+"'; "); Response.Write("$(window.parent.document).find('#CatePic').append(\"<option value='" + filepath + "' selected='selected'>" + filepath + "</option>\");"); Response.Write("</script>"); // Response.Write(filepath + " "); Response.Write("<a href=\"?FileType=" + FileType + "&MaxSize=" + MaxSize + "&SavePath=" + filePath + "&UpInput=" + Content + "\" target=\"_self\" style=\"font-size:12px;\">重新上传</a>"); Response.Write("</body></html>"); Response.End(); } } else { RunJs.AlertAndBack("上传的文件类型不正确,只支持" + FileType + "类型文件"); } } else { RunJs.AlertAndBack("请选择要上传的文件"); } }
/// <summary> /// 根据条件获取记录数 /// </summary> /// <param name="FiledName">字段</param> /// <param name="FiledValue">值</param> /// <returns></returns> public int GetNodeNumByCondition(ArrayList FiledName, ArrayList FiledValue) { int recordcount = 0; string sbCondition = string.Empty; // sbCondition = SelectCondition(FiledName, FiledValue); sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); string seltxt = "Select count(*) from T_NodeList where 1=1 " + sbCondition; dh.Open(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, seltxt, null)) { if (dr.HasRows) { dr.Read(); Int32.TryParse(dr[0].ToString(), out recordcount); } else { recordcount = 0; } } dh.Close(); return recordcount; }
/// <summary> ///获取管理员数量 /// </summary> /// <param name="FiledName"></param> /// <param name="FiledValue"></param> /// <returns></returns> public int GetAdminNumByCondition(ArrayList FiledName, ArrayList FiledValue) { int recordcount = 0; string sbCondition = string.Empty; sbCondition = CommOperate.SelectCondition(FiledName, FiledValue); string cmdtxt = "Select count(*) from T_Admin where 1=1 " + sbCondition.ToString(); dh.Open(); dh.BeginTrans(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, cmdtxt, null)) { if (dr.HasRows) { dr.Read(); Int32.TryParse(dr[0].ToString(), out recordcount); } } dh.CommitTrans(); dh.Close(); return(recordcount); }