/// <summary> /// ���캯�� /// </summary> /// <param name="id">�����û���¼��</param> public Company(int id) : base() { this.Id = id; this.busiType = BusinessType.None; this.turnover = IntRange.None; this.employee = IntRange.None; }
/// <summary> /// ��ȡ��ҵ�û���¼ /// </summary> /// <param name="indus">��ҵ���</param> /// <param name="name">���ƹؼ���</param> /// <param name="tur">Ӫҵ�Χ</param> /// <param name="emp">Ա������Χ</param> /// <param name="pager">��ҳ</param> /// <returns></returns> private static ArrayList List(string indus, string name,IntRange tur,IntRange emp,int check, Pager pager) { /* CompanyList * @name varchar(100)='', * @indus varchar(6)='', * @check int=-1, * @pageindex int=1, * @pagesize int=20, * @sort int=0 */ ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@name",SqlDbType.VarChar,100,name), Database.MakeInParam("@indus",SqlDbType.Char,6,indus), Database.MakeInParam("@check",SqlDbType.Int,check), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "CompanyList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { /*[Id],[Name],Industry,Nature,Region,Contact,ContactPos,Phone,Fax,TurnoverLower,TurnoverUpper, * EmployeeLower,EmployeeUpper,CreatedYear,Website,BusiType,IsChecked*/ Company obj = new Company(); obj.Id = reader.GetInt32(0); obj.ComName = reader.IsDBNull(1) ? "" : reader.GetString(1); obj.Industry = reader.IsDBNull(2) ? "" : reader.GetString(2); obj.Nature = reader.IsDBNull(3) ? "" : reader.GetString(3); obj.Region = reader.IsDBNull(4) ? "" : reader.GetString(4); obj.Contact = reader.IsDBNull(5) ? "" : reader.GetString(5); obj.ContactPos = reader.IsDBNull(6) ? "" : reader.GetString(6); obj.Phone = reader.IsDBNull(7) ? "" : reader.GetString(7); obj.Fax = reader.IsDBNull(8) ? "" : reader.GetString(8); obj.Turnover = (reader.IsDBNull(9) || reader.IsDBNull(10)) ? IntRange.None : new IntRange(reader.GetInt32(9), reader.GetInt32(10)); obj.Employee = (reader.IsDBNull(11)||reader.IsDBNull(12)) ? IntRange.None : new IntRange(reader.GetInt32(11), reader.GetInt32(12)); obj.Year = reader.IsDBNull(13) ? 1900 : reader.GetInt32(13); obj.Website = reader.IsDBNull(14) ? "" : reader.GetString(14); obj.BusiType = (BusinessType)Convert.ToInt16(reader.GetString(15)); obj.IsChecked=reader.GetString(16)=="1"?true:false; list.Add(obj); } } } reader.Close(); } catch(Exception e) { throw e; } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// ��ȡ��ҵ�û���¼ /// </summary> /// <param name="tur">Ӫҵ�Χ</param> /// <param name="emp">Ա������Χ</param> /// <param name="pager">��ҳ</param> /// <returns></returns> public static ArrayList List(IntRange tur, IntRange emp, Pager pager) { return List("", "", tur, emp,-1, pager); }