/// <summary> /// 获得数据列表 /// </summary> public List <DSJL.Model.TB_TestInfo> DataTableToList(DataTable dt) { List <DSJL.Model.TB_TestInfo> modelList = new List <DSJL.Model.TB_TestInfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DSJL.Model.TB_TestInfo model; for (int n = 0; n < rowsCount; n++) { model = new DSJL.Model.TB_TestInfo(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["Ath_ID"].ToString() != "") { model.Ath_ID = int.Parse(dt.Rows[n]["Ath_ID"].ToString()); } if (dt.Rows[n]["TestDate"].ToString() != "") { model.TestDate = DateTime.Parse(dt.Rows[n]["TestDate"].ToString()); } if (dt.Rows[n]["TestTime"].ToString() != "") { model.TestTime = DateTime.Parse(dt.Rows[n]["TestTime"].ToString()); } model.Joint_Side = dt.Rows[n]["Joint_Side"].ToString(); model.Test_Mode = dt.Rows[n]["Test_Mode"].ToString(); model.Joint = dt.Rows[n]["Joint"].ToString(); model.Plane = dt.Rows[n]["Plane"].ToString(); model.Motion_Start = dt.Rows[n]["Motion_Start"].ToString(); model.Motion_End = dt.Rows[n]["Motion_End"].ToString(); model.Speed1 = dt.Rows[n]["Speed1"].ToString(); model.Speed2 = dt.Rows[n]["Speed2"].ToString(); model.Acceleration1 = dt.Rows[n]["Acceleration1"].ToString(); model.Acceleration2 = dt.Rows[n]["Acceleration2"].ToString(); model.Break = dt.Rows[n]["Break"].ToString(); model.NOOfSets = dt.Rows[n]["NOOfSets"].ToString(); model.NOOfRepetitions = dt.Rows[n]["NOOfRepetitions"].ToString(); string insuredSide = dt.Rows[n]["InsuredSide"].ToString(); model.InsuredSide = insuredSide.Equals("") ? "2" : insuredSide; string gracomp = dt.Rows[n]["Gravitycomp"].ToString(); model.Gravitycomp = gracomp.Equals("") ? "0" : gracomp; model.Therapist = dt.Rows[n]["Therapist"].ToString(); model.BaseFileName = dt.Rows[n]["BaseFileName"].ToString(); model.DataFileName = dt.Rows[n]["DataFileName"].ToString(); model.Remark = dt.Rows[n]["remark"].ToString(); model.ActionID = dt.Rows[n]["actionid"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// ��������б� /// </summary> public List<DSJL.Model.TB_TestInfo> DataTableToList(DataTable dt) { List<DSJL.Model.TB_TestInfo> modelList = new List<DSJL.Model.TB_TestInfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DSJL.Model.TB_TestInfo model; for (int n = 0; n < rowsCount; n++) { model = new DSJL.Model.TB_TestInfo(); if(dt.Rows[n]["ID"].ToString()!="") { model.ID=int.Parse(dt.Rows[n]["ID"].ToString()); } if(dt.Rows[n]["Ath_ID"].ToString()!="") { model.Ath_ID=int.Parse(dt.Rows[n]["Ath_ID"].ToString()); } if(dt.Rows[n]["TestDate"].ToString()!="") { model.TestDate=DateTime.Parse(dt.Rows[n]["TestDate"].ToString()); } if(dt.Rows[n]["TestTime"].ToString()!="") { model.TestTime=DateTime.Parse(dt.Rows[n]["TestTime"].ToString()); } model.Joint_Side=dt.Rows[n]["Joint_Side"].ToString(); model.Test_Mode=dt.Rows[n]["Test_Mode"].ToString(); model.Joint=dt.Rows[n]["Joint"].ToString(); model.Plane=dt.Rows[n]["Plane"].ToString(); model.Motion_Start=dt.Rows[n]["Motion_Start"].ToString(); model.Motion_End=dt.Rows[n]["Motion_End"].ToString(); model.Speed1=dt.Rows[n]["Speed1"].ToString(); model.Speed2=dt.Rows[n]["Speed2"].ToString(); model.Acceleration1=dt.Rows[n]["Acceleration1"].ToString(); model.Acceleration2=dt.Rows[n]["Acceleration2"].ToString(); model.Break=dt.Rows[n]["Break"].ToString(); model.NOOfSets=dt.Rows[n]["NOOfSets"].ToString(); model.NOOfRepetitions=dt.Rows[n]["NOOfRepetitions"].ToString(); string insuredSide= dt.Rows[n]["InsuredSide"].ToString(); model.InsuredSide = insuredSide.Equals("") ? "2" : insuredSide; string gracomp= dt.Rows[n]["Gravitycomp"].ToString(); model.Gravitycomp = gracomp.Equals("") ? "0" : gracomp; model.Therapist=dt.Rows[n]["Therapist"].ToString(); model.BaseFileName=dt.Rows[n]["BaseFileName"].ToString(); model.DataFileName=dt.Rows[n]["DataFileName"].ToString(); model.Remark = dt.Rows[n]["remark"].ToString(); model.ActionID = dt.Rows[n]["actionid"].ToString(); modelList.Add(model); } } return modelList; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DSJL.Model.TB_TestInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(DSJL.Model.TB_TestInfo model) { dal.Add(model); }