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