/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetTemplateCategory(QueryTemplateCategory query, string order, int currentPage, int pageSize, out int totalCount) { string where = string.Empty; if (query.Level != Constant.INT_INVALID_VALUE) { where += " and level=" + query.Level; } if (query.Pid != Constant.INT_INVALID_VALUE) { where += " and pID=" + query.Pid; } if (query.Type != Constant.INT_INVALID_VALUE) { where += " and type=" + query.Type; } if (query.RecID != Constant.INT_INVALID_VALUE) { where += " and RecID=" + query.RecID; } if (query.Status != Constant.INT_INVALID_VALUE) { where += " and Status=" + query.Status; } DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_TEMPLATECATEGORY_SELECT, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
protected void Page_Load(object sender, EventArgs e) { int userID = BLL.Util.GetLoginUserID(); if (!BLL.Util.CheckRight(userID, "SYS024MOD5101")) { Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限")); Response.End(); } Template = BLL.TemplateInfo.Instance.GetTemplateInfo(Convert.ToInt32(Request.QueryString["TemplateID"])); DataTable db = new DataTable(); //Template.TCID; QueryTemplateCategory query = new QueryTemplateCategory(); query.RecID = Convert.ToInt32(Template.TCID); int totle; db = BLL.TemplateCategory.Instance.GetTemplateCategory(query, "RecID", 1, 1, out totle); recID = Template.RecID.ToString(); TcID = Template.TCID.ToString(); type = db.Rows[0]["Type"].ToString(); level = db.Rows[0]["Level"].ToString(); pID = db.Rows[0]["PID"].ToString(); DataTable db_EmailServers = BLL.TemplateInfo.Instance.getEmailServers(Template.RecID); if (db_EmailServers != null && db_EmailServers.Rows.Count > 0) { foreach (DataRow row in db_EmailServers.Rows) { ToUserIDs += row["UserID"].ToString() + ","; //根据UserID获取用户名称 ToUserNames += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(row["UserID"])) + ","; } if (ToUserIDs.Length > 0) { ToUserIDs = "'" + ToUserIDs.Substring(0, ToUserIDs.Length - 1) + "'"; ToUserNames = "'" + ToUserNames.Substring(0, ToUserNames.Length - 1) + "'"; } } else { ToUserIDs = "''"; ToUserNames = "''"; } }
/// <summary> /// 是否存在该记录 /// </summary> public bool IsExistsByRecID(int RecID) { QueryTemplateCategory query = new QueryTemplateCategory(); query.RecID = RecID; DataTable dt = new DataTable(); int count = 0; dt = GetTemplateCategory(query, string.Empty, 1, 1, out count); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.TemplateCategory GetTemplateCategory(int RecID) { QueryTemplateCategory query = new QueryTemplateCategory(); query.RecID = RecID; DataTable dt = new DataTable(); int count = 0; dt = GetTemplateCategory(query, string.Empty, 1, 1, out count); if (count > 0) { return(LoadSingleTemplateCategory(dt.Rows[0])); } else { return(null); } }
public void ProcessRequest(HttpContext context) { BitAuto.YanFa.SysRightManager.Common.UserInfo.Check(); context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); string msg = string.Empty; DataTable dt = new DataTable(); QueryTemplateCategory queryCustInfo = new QueryTemplateCategory(); int _pid; if (int.TryParse(RequestPID, out _pid)) { queryCustInfo.Pid = _pid; } int _type; if (int.TryParse(RequstType, out _type)) { queryCustInfo.Type = _type; } queryCustInfo.Status = 1; int count; dt = BitAuto.ISDC.CC2012.BLL.TemplateCategory.Instance.GetTemplateCategory(queryCustInfo, "", 1, 100, out count); if (dt != null && dt.Rows.Count > 0) { msg += "{root:["; } for (int i = 0; i < dt.Rows.Count; i++) { msg += "{'RecID':'" + dt.Rows[i]["RecID"] + "',"; msg += "'Name':'" + dt.Rows[i]["Name"] + "'},"; } if (dt != null && dt.Rows.Count > 0) { msg = msg.Substring(0, msg.Length - 1); msg += "]}"; } context.Response.Write(msg); }
private void BindData() { int pageIndex; if (Request.QueryString["page"] != null) { pageIndex = Convert.ToInt32(Request.QueryString["page"].Trim()); } else { pageIndex = 1; } int totalCount = 0; QueryTemplateInfo query = new QueryTemplateInfo(); string TcID = ""; int CateTotal = 0; Entities.QueryTemplateCategory CateQuery = new Entities.QueryTemplateCategory(); if (Request.QueryString["type"] != null) { CateQuery.Type = int.Parse(Request.QueryString["type"]); DataTable dt2 = BLL.TemplateCategory.Instance.GetTemplateCategory(CateQuery, "", 1, 100, out CateTotal); foreach (DataRow row in dt2.Rows) { TcID += row["RecID"].ToString() + ","; } } if (Request.QueryString["class1"] != null) { if (Request.QueryString["class1"].ToString() != "-1") { TcID = Request.QueryString["class1"].ToString() + ","; CateQuery.Pid = int.Parse(Request.QueryString["class1"].ToString()); DataTable dt2 = BLL.TemplateCategory.Instance.GetTemplateCategory(CateQuery, "", 1, 100, out CateTotal); foreach (DataRow row in dt2.Rows) { TcID += row["RecID"].ToString() + ","; } } } if (Request.QueryString["class2"] != null) { if (Request.QueryString["class2"].ToString() != "-1") { TcID = Request.QueryString["class2"].ToString() + ","; } } if (TcID.Length > 0) { TcID = TcID.Substring(0, TcID.Length - 1); query.Content = TcID; } DataTable dt = BLL.TemplateInfo.Instance.GetTemplateInfo(query, "TemplateInfo.CreateTime desc", pageIndex, 20, out totalCount); dt.Columns.Add("CreateName"); dt.Columns.Add("EmailServers"); int intVal = 0; foreach (DataRow dr in dt.Rows) { if (int.TryParse(dr["CreateUserIDB"].ToString(), out intVal)) { dr["CreateName"] = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(intVal); } #region 邮件接收人 DataTable dtEmailServers = BLL.TemplateInfo.Instance.getEmailServers(Convert.ToInt32(dr["RecID"])); if (dtEmailServers != null && dt.Rows.Count > 0) { foreach (DataRow drEmailServers in dtEmailServers.Rows) { if (int.TryParse(drEmailServers["UserID"].ToString(), out intVal)) { dr["EmailServers"] += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(intVal) + ","; } } if (dr["EmailServers"].ToString().Length > 0) { dr["EmailServers"] = dr["EmailServers"].ToString().Substring(0, dr["EmailServers"].ToString().Length - 1); } } #endregion #region 分类两级添加 DataTable db = new DataTable(); //Template.TCID; QueryTemplateCategory queryCate = new QueryTemplateCategory(); queryCate.RecID = Convert.ToInt32(dr["TcID"]); int totle; db = BLL.TemplateCategory.Instance.GetTemplateCategory(queryCate, "RecID", 1, 1, out totle); if (db != null && db.Rows.Count > 0) { if (db.Rows[0]["Level"].ToString() == "2") { DataTable dbOri = new DataTable(); //Template.TCID; QueryTemplateCategory queryCatedbOri = new QueryTemplateCategory(); queryCatedbOri.RecID = Convert.ToInt32(db.Rows[0]["PID"]); int totledbOri; dbOri = BLL.TemplateCategory.Instance.GetTemplateCategory(queryCatedbOri, "RecID", 1, 1, out totledbOri); dr["Name"] = dbOri.Rows[0]["Name"].ToString() + "-" + dr["Name"].ToString(); } } #endregion } Rpt_TempList.DataSource = dt; Rpt_TempList.DataBind(); //返回总条数 //litPage.Text = BLL.PageCommon.Instance.LinkString("", 10, totalCount,10); //(totalCount); //分组页容量 每页条数 litPage.Text = BLL.PageCommon.Instance.LinkStringByPost(BLL.Util.GetUrl(), 8, totalCount, 20, BLL.PageCommon.Instance.PageIndex, 1); }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetTemplateCategory(QueryTemplateCategory query, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.TemplateCategory.Instance.GetTemplateCategory(query, order, currentPage, pageSize, out totalCount)); }