/// <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>
/// <returns></returns>
private string SaveCompany()
{
string str = "FAILED";
//Response.Write("comId:" + Request.Form["comId"]);
//Response.Write("comIndustry:" + Request.Form["comName"]);
//Response.Write("comIndustry:" + Request.Form["comIndustry"]);
//Response.Write("comRegion:" + Request.Form["comRegion"]);
//Response.Write("comTurnover:" + Request.Form["comTurnover"]);
//Response.Write("comEmployee:" + Request.Form["comEmployee"]);
//Response.Write("comContact:" + Request.Form["comContact"]);
//Response.End();
if (Request.Form["comId"] != null && Request.Form["comName"] != null && Request.Form["comNature"] != null &&
Request.Form["comIndustry"] != null && Request.Form["comRegion"] != null && Request.Form["comYear"] != null &&
Request.Form["comTurnover"] != null && Request.Form["comEmployee"] != null && Request.Form["comContact"] != null &&
Request.Form["comPhone"] != null)
{
try
{
int id = Convert.ToInt32(Request.Form["comId"]);
if (id <= 0)
{
return str;
}
Company com = new Company();
com.Id = id;
com.ComName = Request.Form["comName"];
com.Nature = Request.Form["comNature"];
com.Industry = Request.Form["comIndustry"];
com.Region = Request.Form["comRegion"];
com.Year = Convert.ToInt16(Request.Form["comYear"]);
com.Turnover = ((IntRange)Company.TurnoverCollection[Convert.ToInt16(Request.Form["comTurnover"])]);
com.Employee = ((IntRange)Company.EmployeeCollection[Convert.ToInt16(Request.Form["comEmployee"])]);
com.Contact = Request.Form["comContact"];
com.Phone = Request.Form["comPhone"];
com.Fax = Request.Form["comFax"] == null ? "" : Request.Form["comFax"];
com.Website = Request.Form["comWebsite"] == null ? "" : Request.Form["comWebsite"];
com.Save();
str = "OK";
}
catch
{
throw;
}
}
return str;
}
/// <summary>
/// ��ȡ��ҵ�û�����
/// </summary>
/// <param name="id">�û���¼��</param>
/// <returns></returns>
public static new Company Get(int id)
{
/* CompanyGet
* @id int
*/
Company obj = null;
SqlParameter[] prams ={
Database.MakeInParam("@id",SqlDbType.Int,id)
};
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "CompanyGet", prams);
if (reader.Read())
{
/* [Id],[Name],Industry,Nature,Region,Contact,ContactPos,Phone,Fax,TurnoverLower,TurnoverUpper,
* EmployeeLower,EmployeeUpper,CreatedYear,Website,BusiType,IsChecked*/
obj = new Company();
obj.Id = reader.GetInt32(0);
obj.ComName = reader.GetString(1);
obj.Industry = reader.GetString(2);
obj.Nature = reader.GetString(3);
obj.Region = reader.GetString(4);
obj.Contact = reader.GetString(5);
obj.ContactPos = reader.GetString(6);
obj.Phone = reader.GetString(7);
obj.Fax = reader.GetString(8);
obj.Turnover = new IntRange(reader.GetInt32(9), reader.GetInt32(10));
obj.Employee = new IntRange(reader.GetInt32(11), reader.GetInt32(12));
obj.Year = reader.GetInt32(13);
obj.Website = reader.GetString(14);
obj.BusiType = (BusinessType)Convert.ToInt16(reader.GetString(15));
obj.IsChecked = reader.GetString(16) == "1" ? true : false;
}
reader.Close();
}
catch
{
//
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return obj;
}
/// <summary>
/// �����û���Ϣ����ҵ���ƺ���ҵ����
/// </summary>
private void setUserInfo()
{
if (!Member.IsLogined)
{
return;
}
string comName = "";
string industry = "";
if (Request.Form["COM_NAME"] != null && Request.Form["INDUS_CODE"] != null)
{
comName = Request.Form["COM_NAME"].Trim();
comName = Server.HtmlEncode(comName);
industry = Request.Form["INDUS_CODE"].Trim();
}
if (comName == "" || industry == "")
{
return;
}
Company com = Company.Get(Member.Instance.Id);
if (com == null)
{
com = new Company(Member.Instance.Id);
}
com.Industry = industry;
com.ComName = comName;
com.Save();
}
