public void OnlyLoadCaseCarNoAndStationName(string caseId) { Cgs_AskNote12 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 Cgs_AskNote12 ReadDataOnlyCaseCarNoAndStationName(ComDataReader dr) { Cgs_AskNote12 chufa = new Cgs_AskNote12(); ReadEntity(dr, chufa); return(chufa); }
public Cgs_AskNote12 ReadData(ComDataReader dr) { Cgs_AskNote12 askNote12 = new Cgs_AskNote12(); ReadEntity(dr, askNote12); return(askNote12); }
private static void ReadEntity(ComDataReader dr, Cgs_AskNote12 askNote12) { askNote12.canid = dr["canid"].ToString(); askNote12.CaseId = dr["CaseId"].ToString(); askNote12.cantime1 = dr["cantime1"].ToString(); askNote12.cantime2 = dr["cantime2"].ToString(); askNote12.canAddress = dr["canAddress"].ToString(); askNote12.canaskman = dr["canaskman"].ToString(); askNote12.canaskmanComp = dr["canaskmanComp"].ToString(); askNote12.canaskmanbook1 = dr["canaskmanbook1"].ToString(); askNote12.canaskmanbook2 = dr["canaskmanbook2"].ToString(); askNote12.canrecodman = dr["canrecodman"].ToString(); askNote12.canrecodmanComp = dr["canrecodmanComp"].ToString(); askNote12.canrecodmanbook1 = dr["canrecodmanbook1"].ToString(); askNote12.canrecodmanbook2 = dr["canrecodmanbook2"].ToString(); askNote12.canaskedman = dr["canaskedman"].ToString(); askNote12.canaskedmansex = dr["canaskedmansex"].ToString(); askNote12.canaskedmanold = dr["canaskedmanold"].ToString(); askNote12.canaskedmanrelation = dr["canaskedmanrelation"].ToString(); askNote12.canaskedmancomp = dr["canaskedmancomp"].ToString(); askNote12.canaskedmantele = dr["canaskedmantele"].ToString(); askNote12.canaskedmanhome = dr["canaskedmanhome"].ToString(); askNote12.canaskedmanzip = dr["canaskedmanzip"].ToString(); askNote12.canmycomp = dr["canmycomp"].ToString(); askNote12.canmyname = dr["canmyname"].ToString(); askNote12.canmybook1 = dr["canmybook1"].ToString(); askNote12.canmybook2 = dr["canmybook2"].ToString(); askNote12.canhe = dr["canhe"].ToString(); askNote12.canhename = dr["canhename"].ToString(); askNote12.canhebook1 = dr["canhebook1"].ToString(); askNote12.canhebook2 = dr["canhebook2"].ToString(); askNote12.cananser1 = dr["cananser1"].ToString(); askNote12.canmycarno = dr["canmycarno"].ToString(); askNote12.canmycarkind = dr["canmycarkind"].ToString(); askNote12.canmycarnum = dr["canmycarnum"].ToString(); askNote12.cansign1 = dr["cansign1"].ToString(); askNote12.cansign2 = dr["cansign2"].ToString(); askNote12.cancargoods = dr["cancargoods"].ToString(); askNote12.cancarfrom = dr["cancarfrom"].ToString(); askNote12.cancarto = dr["cancarto"].ToString(); askNote12.cancarlong = dr["cancarlong"].ToString(); askNote12.cancarweight1 = dr["cancarweight1"].ToString(); askNote12.cancarweight2 = dr["cancarweight2"].ToString(); askNote12.cancardesc = dr["cancardesc"].ToString(); askNote12.canreview1 = dr["canreview1"].ToString(); askNote12.canreview2 = dr["canreview2"].ToString(); askNote12.cananser2 = dr["cananser2"].ToString(); askNote12.canyou = dr["canyou"].ToString(); askNote12.cananser3 = dr["cananser3"].ToString(); askNote12.cananser4 = dr["cananser4"].ToString(); askNote12.cananser5 = dr["cananser5"].ToString(); askNote12.candsign1 = dr["candsign1"].ToString(); askNote12.candsign2 = dr["candsign2"].ToString(); askNote12.canasksign = dr["canasksign"].ToString(); askNote12.canrecordsign = dr["canrecordsign"].ToString(); askNote12.canwenshunum = dr["canwenshunum"].ToString(); askNote12.CreateDate1 = dr["CreateDate1"].ToString(); askNote12.CreateUserId1 = dr["CreateUserId1"].ToString(); askNote12.CreateUserName1 = dr["CreateUserName1"].ToString(); askNote12.ModifyDate1 = dr["ModifyDate1"].ToString(); askNote12.ModifyUserId1 = dr["ModifyUserId1"].ToString(); askNote12.ModifyUserName1 = dr["ModifyUserName1"].ToString(); }