public List <IdCard> SelectAll(int kid)
{
List <IdCard> di = new List <IdCard>();
SqlParameter pid = new SqlParameter("@kid", SqlDbType.Int);
pid.Value = kid;
bool f = DBHelper.ExecuteBatchProc("IdCard_S_select", pid);
if (f == true)
{
while (DBHelper.reader.Read())
{
IdCard idc = new IdCard();
idc.Name = DBHelper.reader["name"] + "";
idc.Sex = DBHelper.reader["sex"] + "";
idc.Age = Convert.ToInt32(DBHelper.reader["age"]);
idc.Address = DBHelper.reader["address"] + "";
di.Add(idc);
}
}
DBHelper.con.Close();
DBHelper.reader.Dispose();
DBHelper.cmd.Dispose();
DBHelper.con.Dispose();
return(di);
}
public List <Register> SelectAll()
{
List <Register> lRegi = new List <Register>();
bool f = DBHelper.ExecuteBatchProc("p_retister_select");
if (f == true)
{
while (DBHelper.reader.Read())
{
Register Regi = new Register();
Regi.Rid = DBHelper.reader["Rid"] + "";
Regi.KId = Convert.ToInt32(DBHelper.reader["Kid"]);
Regi.IdType = DBHelper.reader["IdType"] + "";
Regi.GuaDanFei = Convert.ToInt32(DBHelper.reader["GuaDanFei"]);
Regi.OtherFei = Convert.ToInt32(DBHelper.reader["OtherFei"]);
Regi.SectionRoom = DBHelper.reader["SectionRoom"] + "";
Regi.Doctor = DBHelper.reader["Doctor"] + "";
Regi.ReristerTime = DBHelper.reader["ReristerTime"] + "";
Regi.SeeDoctorTime = DBHelper.reader["SeeDoctorTime"] + "";
lRegi.Add(Regi);
}
}
DBHelper.con.Close();
DBHelper.reader.Dispose();
DBHelper.cmd.Dispose();
DBHelper.con.Dispose();
return(lRegi);
}
public List <Drug_insert> SelectAll(string Sname)
{
List <Drug_insert> di = new List <Drug_insert>();
SqlParameter pid = new SqlParameter("@Dname", SqlDbType.VarChar);
pid.Value = Sname;
bool f = DBHelper.ExecuteBatchProc("Drug_SelectName_p", pid);
if (f == true)
{
while (DBHelper.reader.Read())
{
Drug_insert dri = new Drug_insert();
dri.Dname = DBHelper.reader["Dname"] + "";
dri.Dtype = DBHelper.reader["Dtype"] + "";
dri.DcostName = DBHelper.reader["DcostName"] + "";
dri.Dspec = DBHelper.reader["Dspec"] + "";
dri.DjiXing = DBHelper.reader["DjiXing"] + "";
dri.DinsertPrice = Convert.ToInt32(DBHelper.reader["DinsertPrice"]);
dri.DsellPrice = Convert.ToInt32(DBHelper.reader["DsellPrice"]);
dri.Dstock = Convert.ToInt32(DBHelper.reader["Dstock"]);
dri.DstockMax = Convert.ToInt32(DBHelper.reader["DstockMax"]);
dri.DstockMin = Convert.ToInt32(DBHelper.reader["DstockMin"]);
dri.DeffectTime = DBHelper.reader["DeffectTime"] + "";
dri.DproductTime = DBHelper.reader["DproductTime"] + "";
dri.Efficay = DBHelper.reader["Efficay"] + "";
di.Add(dri);
}
}
DBHelper.con.Close();
DBHelper.reader.Dispose();
DBHelper.cmd.Dispose();
DBHelper.con.Dispose();
return(di);
}
