public static ArrayList List(int actionId,string leadIdOrGuid,string category,string area, int spId,int buyerId,short mailed,short viewed,short evaled,Pager pager) { /* MatchedLeadList @actionId int=0, --ָ������ID @leadId varchar(32)='', --ָ��Lead @cate varchar(30)='', --ָ������ @area varchar(6)='', --ָ��ij������ @spId int=0, --ָ����Ӧ�� @buyerId int=0, --ָ��Buyer @mailed smallint=-1, --����-1ʱָ���ʼ�״̬ @viewed smallint=-1, --����-1ʱָ���鿴״̬ @evaled smallint=-1, --����-1ʱָ������״̬ @pageIndex int=1, --ָ����ҳҳ�� @pageSize int=20, --ָ����ҳ��С @sort int=0 --ָ������ */ ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@actionId",SqlDbType.Int,actionId), Database.MakeInParam("@leadId",SqlDbType.VarChar,32,leadIdOrGuid), Database.MakeInParam("@cate",SqlDbType.VarChar,30,category), Database.MakeInParam("@area",SqlDbType.VarChar,6,area), Database.MakeInParam("@spId",SqlDbType.Int,spId), Database.MakeInParam("@buyerId",SqlDbType.Int,buyerId), Database.MakeInParam("@mailed",SqlDbType.SmallInt,mailed), Database.MakeInParam("@viewed",SqlDbType.SmallInt,viewed), Database.MakeInParam("@evaled",SqlDbType.SmallInt,evaled), 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, "MatchedLeadList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { //0-7:[Id], LeadId, LeadGuid, Category, Area, IndustryRequired, Nature, [Datetime], //8-13:ActionId, SupplierId,SupplierName, BuyerId,BuyerName, MatchedDatetime, //14-17:Mailed, Viewed, Evaluated MatchedLeads mlead = new MatchedLeads(); mlead.id = reader.GetInt32(0); mlead.actionId = reader.GetInt32(8); mlead.datetime = reader.GetDateTime(13); mlead.mailed = reader.GetBoolean(14); mlead.viewed = reader.GetBoolean(15); mlead.evaluated = reader.GetBoolean(16); mlead.lead = new Lead(reader.GetInt32(1),reader.GetString(2),reader.GetDateTime(7)); mlead.lead.Category = reader.GetString(3); mlead.lead.Area = reader.GetString(4); mlead.lead.IndustryRequire = reader.GetBoolean(5); mlead.lead.NatrueRequire = reader.GetInt16(6); mlead.supplierId = reader.GetInt32(9); mlead.supplierName = reader.GetString(10); mlead.buyerId = reader.GetInt32(11); mlead.buyerName = reader.GetString(12); list.Add(mlead); } } } reader.Close(); } catch { throw; } finally { if (reader != null) { reader.Close(); } } return list; }
public static MatchedLeads Get(int id,int comId) { /* MatchedLeadGet @id int, @comId int=0 */ MatchedLeads mlead = null; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "MatchedLeadGet", new SqlParameter[] { Database.MakeInParam("@id",SqlDbType.Int,id), Database.MakeInParam("@comId",SqlDbType.Int,comId) }); if (reader.Read()) { //0-7:[Id], LeadId, LeadGuid, Category, Area, IndustryRequired, Nature, [Datetime], //8-13:ActionId, SupplierId,SupplierName, BuyerId,BuyerName, MatchedDatetime, //14-17:Mailed, Viewed, Evaluated, MatchStatus mlead = new MatchedLeads(); mlead.id = reader.GetInt32(0); mlead.actionId = reader.GetInt32(8); mlead.datetime = reader.GetDateTime(13); mlead.mailed = reader.GetBoolean(14); mlead.viewed = reader.GetBoolean(15); mlead.evaluated = reader.GetBoolean(16); mlead.lead = new Lead(reader.GetInt32(1), reader.GetString(2), reader.GetDateTime(7)); mlead.lead.Category = reader.GetString(3); mlead.lead.Area = reader.GetString(4); mlead.lead.IndustryRequire = reader.GetBoolean(5); mlead.lead.NatrueRequire = reader.GetInt16(6); mlead.supplierId = reader.GetInt32(9); mlead.supplierName = reader.GetString(10); mlead.buyerId = reader.GetInt32(11); mlead.buyerName = reader.GetString(12); } reader.Close(); } catch { // } finally { if (reader != null) { reader.Close(); } } return mlead; }