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