/// <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 GetProjectTask_Cust_Brand(QueryProjectTask_Cust_Brand query, string order, int currentPage, int pageSize, out int totalCount) { string where = ""; if (query.PTID != Constant.STRING_INVALID_VALUE) { where += " and ProjectTask_Cust_Brand.PTID ='" + StringHelper.SqlFilter(query.PTID) + "'"; } DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.VarChar, 8000), new SqlParameter("@order", SqlDbType.NVarChar, 100), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@page", 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_PROJECTTASK_CUST_BRAND_SELECT, parameters); totalCount = int.Parse(parameters[4].Value.ToString()); return(ds.Tables[0]); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.ProjectTask_Cust_Brand GetProjectTask_Cust_Brand(string PTID, int BrandID) { QueryProjectTask_Cust_Brand query = new QueryProjectTask_Cust_Brand(); query.PTID = PTID; query.BrandID = BrandID; DataTable dt = new DataTable(); int count = 0; dt = GetProjectTask_Cust_Brand(query, string.Empty, 1, 1, out count); if (count > 0) { return(LoadSingleProjectTask_Cust_Brand(dt.Rows[0])); } else { return(null); } }
public Entities.ProjectTask_Cust GetProjectTask_Cust(string tid) { Entities.ProjectTask_Cust c = Dal.ProjectTask_Cust.Instance.GetProjectTask_Cust(tid); if (c == null) { return(null); } //品牌 int tc; QueryProjectTask_Cust_Brand query = new QueryProjectTask_Cust_Brand(); query.PTID = tid; DataTable dt = BLL.ProjectTask_Cust_Brand.Instance.GetProjectTask_Cust_Brand(query, "", 1, 10000, out tc); foreach (DataRow dr in dt.Rows) { c.BrandIDs.Add(int.Parse(dr["BrandID"].ToString())); c.BrandNames.Add(dr["Name"].ToString()); } return(c); }
/// <summary> /// 按照查询条件查询 分页 /// </summary> /// <param name="queryProjectTask_Cust_Brand">查询值对象,用来存放查询条件</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="order"> </param> /// <param name="totalCount">总行数</param> /// <param name="pageSize">每页记录数</param> /// <returns>销售网络集合</returns> public DataTable GetProjectTask_Cust_Brand(QueryProjectTask_Cust_Brand queryProjectTask_Cust_Brand, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.ProjectTask_Cust_Brand.Instance.GetProjectTask_Cust_Brand(queryProjectTask_Cust_Brand, order, currentPage, pageSize, out totalCount)); }