public void OnlyLoadCaseCarNoAndStationName(string caseId)
{
chufashu01 chufa = null;
Param param = new Param();
string strSQL = " select top 1 * from TBCase where CaseId=@caseId ";
param.Add("@caseId", caseId);
try
{
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
chufa = ReadDataOnlyCaseCarNoAndStationName(dr);
}
WebJson.ToJson(context, chufa);
}
catch (Exception)
{
throw;
}
finally
{
db.Close();
}
// string str = db.DataGridTemp(strSQL, param);
}
public chufashu01 ReadData(ComDataReader dr)
{
chufashu01 chufa = new chufashu01();
chufa.addman = dr["addman"].ToString();
chufa.addtime = dr["addtime"].ToString();
chufa.CaseCarNo = dr["CaseCarNo"].ToString();
chufa.CaseId = dr["CaseId"].ToString();
chufa.chufazi = dr["chufazi"].ToString();
chufa.dangshiren = dr["dangshiren"].ToString();
chufa.dangshirenyu = dr["dangshirenyu"].ToString();
chufa.dihao = dr["dihao"].ToString();
chufa.dizhi = dr["dizhi"].ToString();
chufa.fakuan = dr["fakuan"].ToString();
chufa.firststr = dr["firststr"].ToString();
chufa.gongli = dr["gongli"].ToString();
chufa.guiding = dr["guiding"].ToString();
chufa.infodate = dr["infodate"].ToString();
chufa.jdid = dr["jdid"].ToString();
chufa.jiance = dr["jiance"].ToString();
chufa.jiaona = dr["jiaona"].ToString();
chufa.shenpiren = dr["shenpiren"].ToString();
chufa.shenpishijian = dr["shenpishijian"].ToString();
chufa.StationName = dr["StationName"].ToString();
return(chufa);
}
public chufashu01 ReadDataOnlyCaseCarNoAndStationName(ComDataReader dr)
{
chufashu01 chufa = new chufashu01();
chufa.CaseId = dr["CaseId"].ToString();
chufa.CaseCarNo = dr["CaseCarNo"].ToString();
chufa.StationName = dr["StationName"].ToString();
return(chufa);
}