public void GetBibitong()
{
bibitong = Bibitong.Get(id);
}
public static Bibitong Get(int spId)
{
Bibitong bbt = new Bibitong();
bbt.supplierId = spId;
/*
BibitongGet
@spId int
*/
//[GeneralScore],[IndustryCount],[Priority],
//[S_AVG],[R_AVG],[Q_AVG],[V_AVG],[C_AVG],
//[S_A],[S_B],[S_C],[S_D],[S_E],
//[R_A],[R_B],[R_C],[R_D],[R_E],
//[Q_A],[Q_B],[Q_C],[Q_D],[Q_E],
//[V_A],[V_B],[V_C],[V_D],[V_E],
//[C_A],[C_B],[RecommCount],Cert1Count,Cert2Count
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "BibitongGet",
new SqlParameter[] { Database.MakeInParam("@spId", SqlDbType.Int, spId) });
if (reader.Read())
{
bbt.generalScore = Convert.ToSingle(reader.GetValue(0));
bbt.industryCount = reader.GetInt32(1);
bbt.priority = reader.GetInt32(2);
bbt.specialtyAvg = Convert.ToSingle(reader.GetValue(3));
bbt.responsibilityAvg = Convert.ToSingle(reader.GetValue(4));
bbt.qualityAvg = Convert.ToSingle(reader.GetValue(5));
bbt.valuablyAvg = Convert.ToSingle(reader.GetValue(6));
bbt.caseScore =Convert.ToSingle(reader.GetValue(7));
bbt.specialties[0] = reader.GetInt32(8);
bbt.specialties[1] = reader.GetInt32(9);
bbt.specialties[2] = reader.GetInt32(10);
bbt.specialties[3] = reader.GetInt32(11);
bbt.specialties[4] = reader.GetInt32(12);
bbt.responsibilities[0] = reader.GetInt32(13);
bbt.responsibilities[1] = reader.GetInt32(14);
bbt.responsibilities[2] = reader.GetInt32(15);
bbt.responsibilities[3] = reader.GetInt32(16);
bbt.responsibilities[4] = reader.GetInt32(17);
bbt.qualities[0] = reader.GetInt32(18);
bbt.qualities[1] = reader.GetInt32(19);
bbt.qualities[2] = reader.GetInt32(20);
bbt.qualities[3] = reader.GetInt32(21);
bbt.qualities[4] = reader.GetInt32(22);
bbt.valuablies[0] = reader.GetInt32(23);
bbt.valuablies[1] = reader.GetInt32(24);
bbt.valuablies[2] = reader.GetInt32(25);
bbt.valuablies[3] = reader.GetInt32(26);
bbt.valuablies[4] = reader.GetInt32(27);
bbt.goodCaseCount = reader.GetInt32(28);
bbt.badCaseCount = reader.GetInt32(29);
bbt.recommendCount = reader.GetInt32(30);
bbt.cert1Count = reader.GetInt32(31);
bbt.cert2Count = reader.GetInt32(32);
}
reader.Close();
}
catch
{
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return bbt;
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
BBT = Bibitong.Get(SupplierId);
}
