private void comb_benchSet3_SelectedIndexChanged(object sender, EventArgs e)
{
benchBll = new BenchSetBLL();
BenchSet bSet = benchBll.GetBenchSetByName(comb_benchSet3.SelectedItem.ToString(), _users.Id);
tb_benchName3.Text = bSet.BenchName;
tb_benchRange3.Text = bSet.BenchRange;
tb_benchSerial3.Text = bSet.BenchSerial;
dt_benchExpire3.Value = bSet.Expire;
tb_benchSn3.Text = bSet.BenchSn;
tb_notSure3.Text = bSet.Notsure;
}
public BenchSet GetBenchSetById(int id, int creator)
{
using (SqlDataReader rdr = SqlHelper.ExecuteReader(_connectString, CommandType.StoredProcedure, SQL_SELECT_BENCHSETBYID, new SqlParameter("BENCHID", id)))
{
BenchSet bSet = new BenchSet();
if (rdr.Read())
{
//u.id,u.username,u.roleId,r.rolename,r.roleValue,u.realname
bSet = new BenchSet(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetDateTime(7), rdr.GetInt32(8));
}
return(bSet);
}
}
public IList <BenchSet> GetAllBenchSet(int creator)
{
using (SqlDataReader rdr = SqlHelper.ExecuteReader(_connectString, CommandType.StoredProcedure, SQL_SELECT_ALLBENCHSET, new SqlParameter("CREATOR", creator)))
{
IList <BenchSet> BenchSets = new List <BenchSet>();
while (rdr.Read())
{
//u.id,u.username,u.roleId,r.rolename,r.roleValue,u.realname
BenchSet bSet = new BenchSet(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetDateTime(7), rdr.GetInt32(8));
BenchSets.Add(bSet);
}
return(BenchSets);
}
}
public BenchSet GetBenchSetByName(string name, int creator)
{
SqlParameter[] parms =
{
new SqlParameter("CREATOR", creator),
new SqlParameter("BENCHSET_NAME", name)
};
using (SqlDataReader rdr = SqlHelper.ExecuteReader(_connectString, CommandType.StoredProcedure, SQL_SELECT_BENCHSETBYNAME, parms))
{
BenchSet bSet = new BenchSet();
if (rdr.Read())
{
//u.id,u.username,u.roleId,r.rolename,r.roleValue,u.realname
bSet = new BenchSet(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetDateTime(7), rdr.GetInt32(8));
}
return(bSet);
}
}
