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