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); }