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