/// <summary> /// 获得数据列表 /// </summary> public List<Maticsoft.Model.Tao.SendInvite> DataTableToList(DataTable dt) { List<Maticsoft.Model.Tao.SendInvite> modelList = new List<Maticsoft.Model.Tao.SendInvite>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Maticsoft.Model.Tao.SendInvite model; for (int n = 0; n < rowsCount; n++) { model = new Maticsoft.Model.Tao.SendInvite(); if (dt.Rows[n]["InviteID"] != null && dt.Rows[n]["InviteID"].ToString() != "") { model.InviteID = int.Parse(dt.Rows[n]["InviteID"].ToString()); } if (dt.Rows[n]["ConstitutorID"] != null && dt.Rows[n]["ConstitutorID"].ToString() != "") { model.ConstitutorID = int.Parse(dt.Rows[n]["ConstitutorID"].ToString()); } if (dt.Rows[n]["InviteeID"] != null && dt.Rows[n]["InviteeID"].ToString() != "") { model.InviteeID = int.Parse(dt.Rows[n]["InviteeID"].ToString()); } if (dt.Rows[n]["ModuleID"] != null && dt.Rows[n]["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(dt.Rows[n]["ModuleID"].ToString()); } if (dt.Rows[n]["InviteStatus"] != null && dt.Rows[n]["InviteStatus"].ToString() != "") { model.InviteStatus = int.Parse(dt.Rows[n]["InviteStatus"].ToString()); } if (dt.Rows[n]["InviteDate"] != null && dt.Rows[n]["InviteDate"].ToString() != "") { model.InviteDate = DateTime.Parse(dt.Rows[n]["InviteDate"].ToString()); } if (dt.Rows[n]["DisposeDate"] != null && dt.Rows[n]["DisposeDate"].ToString() != "") { model.DisposeDate = DateTime.Parse(dt.Rows[n]["DisposeDate"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Tao.SendInvite GetModel(int InviteID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 InviteID,ConstitutorID,InviteeID,ModuleID,InviteStatus,InviteDate,DisposeDate from Tao_SendInvite "); strSql.Append(" where InviteID=@InviteID"); SqlParameter[] parameters = { new SqlParameter("@InviteID", SqlDbType.Int,4) }; parameters[0].Value = InviteID; Maticsoft.Model.Tao.SendInvite model = new Maticsoft.Model.Tao.SendInvite(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["InviteID"] != null && ds.Tables[0].Rows[0]["InviteID"].ToString() != "") { model.InviteID = int.Parse(ds.Tables[0].Rows[0]["InviteID"].ToString()); } if (ds.Tables[0].Rows[0]["ConstitutorID"] != null && ds.Tables[0].Rows[0]["ConstitutorID"].ToString() != "") { model.ConstitutorID = int.Parse(ds.Tables[0].Rows[0]["ConstitutorID"].ToString()); } if (ds.Tables[0].Rows[0]["InviteeID"] != null && ds.Tables[0].Rows[0]["InviteeID"].ToString() != "") { model.InviteeID = int.Parse(ds.Tables[0].Rows[0]["InviteeID"].ToString()); } if (ds.Tables[0].Rows[0]["ModuleID"] != null && ds.Tables[0].Rows[0]["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(ds.Tables[0].Rows[0]["ModuleID"].ToString()); } if (ds.Tables[0].Rows[0]["InviteStatus"] != null && ds.Tables[0].Rows[0]["InviteStatus"].ToString() != "") { model.InviteStatus = int.Parse(ds.Tables[0].Rows[0]["InviteStatus"].ToString()); } if (ds.Tables[0].Rows[0]["InviteDate"] != null && ds.Tables[0].Rows[0]["InviteDate"].ToString() != "") { model.InviteDate = DateTime.Parse(ds.Tables[0].Rows[0]["InviteDate"].ToString()); } if (ds.Tables[0].Rows[0]["DisposeDate"] != null && ds.Tables[0].Rows[0]["DisposeDate"].ToString() != "") { model.DisposeDate = DateTime.Parse(ds.Tables[0].Rows[0]["DisposeDate"].ToString()); } return model; } else { return null; } }