/// <summary> /// 根据查询条件获取联系人列表 /// </summary> /// <param name="strWhere">条件</param> /// <returns></returns> public DataTable GetList(string strWhere) { StringBuilder sql = new StringBuilder(); sql.Append("select Contact.Id,Name,Phone,Email,QQ,GroupName from Contact,ContactGroup where Contact.GroupId=ContactGroup.Id "); if (strWhere.Trim() != "") { sql.Append("and " + strWhere); } sql.Append(" order by Contact.Id desc"); return(OleDbHelper.ExecuteDataTable(sql.ToString())); }
/// <summary> /// 根据查询条件获取分组列表 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public DataTable GetList(string strWhere) { StringBuilder sql = new StringBuilder(); sql.Append("select Id,GroupName,[Memo] "); // Memo 为 Access 保留字 sql.Append("from ContactGroup "); if (strWhere.Trim() != "") { sql.Append("where " + strWhere); } return(OleDbHelper.ExecuteDataTable(sql.ToString())); }
public DataTable GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,GroupName,Memo "); strSql.Append(" FROM ContactGroup "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return(OleDbHelper.ExecuteDataTable(strSql.ToString())); }
/// <summary> /// 根据分组编号获取分组信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public Model.ContactGroup GetModel(int Id) { StringBuilder sql = new StringBuilder(); sql.Append("select top 1 Id,GroupName,[Memo] from ContactGroup "); sql.Append("where Id = @id"); OleDbParameter[] para = { new OleDbParameter("@id", OleDbType.Integer, 4) }; para[0].Value = Id; Model.ContactGroup model = new Model.ContactGroup(); DataTable dt = OleDbHelper.ExecuteDataTable(sql.ToString(), para); if (dt.Rows.Count > 0) { if (dt.Rows[0]["Id"] != null && dt.Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[0]["Id"].ToString()); } if (dt.Rows[0]["GroupName"] != null && dt.Rows[0]["GroupName"].ToString() != "") { model.GroupName = dt.Rows[0]["GroupName"].ToString(); } if (dt.Rows[0]["Memo"] != null && dt.Rows[0]["Memo"].ToString() != "") { model.Memo = dt.Rows[0]["Memo"].ToString(); } return(model); } else { return(null); } }
public Model.ContactGroup GetModel(string groupName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,GroupName,Memo from ContactGroup "); strSql.Append(" where GroupName=@GroupName"); OleDbParameter[] parameters = { new OleDbParameter("@GroupName", OleDbType.VarChar, 50) }; parameters[0].Value = groupName; Model.ContactGroup model = new Model.ContactGroup(); DataTable dt = OleDbHelper.ExecuteDataTable(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["Id"] != null && dt.Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[0]["Id"].ToString()); } if (dt.Rows[0]["GroupName"] != null && dt.Rows[0]["GroupName"].ToString() != "") { model.GroupName = dt.Rows[0]["GroupName"].ToString(); } if (dt.Rows[0]["Memo"] != null && dt.Rows[0]["Memo"].ToString() != "") { model.Memo = dt.Rows[0]["Memo"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 根据联系人编号获取联系人信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public Model.Contact GetModel(int Id) { StringBuilder sql = new StringBuilder(); sql.Append("select top 1 Id,Name,Phone,Email,QQ,WorkUnit,OfficePhone,HomeAddress,HomePhone,[Memo],GroupId from Contact "); sql.Append("where Id=@Id"); OleDbParameter[] para = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; para[0].Value = Id; Model.Contact model = new Model.Contact(); DataTable dt = OleDbHelper.ExecuteDataTable(sql.ToString(), para); if (dt.Rows.Count > 0) { if (CheckDataTableCell(dt, 0, "Id")) { model.Id = int.Parse(dt.Rows[0]["Id"].ToString()); } if (CheckDataTableCell(dt, 0, "Name")) { model.Name = dt.Rows[0]["Name"].ToString(); } if (CheckDataTableCell(dt, 0, "Phone")) { model.Phone = dt.Rows[0]["Phone"].ToString(); } if (CheckDataTableCell(dt, 0, "Email")) { model.Email = dt.Rows[0]["Email"].ToString(); } if (CheckDataTableCell(dt, 0, "QQ")) { model.QQ = dt.Rows[0]["QQ"].ToString(); } if (CheckDataTableCell(dt, 0, "WorkUnit")) { model.WorkUnit = dt.Rows[0]["WorkUnit"].ToString(); } if (CheckDataTableCell(dt, 0, "OfficePhone")) { model.OfficePhone = dt.Rows[0]["OfficePhone"].ToString(); } if (CheckDataTableCell(dt, 0, "HomeAddress")) { model.HomeAddress = dt.Rows[0]["HomeAddress"].ToString(); } if (CheckDataTableCell(dt, 0, "HomePhone")) { model.HomePhone = dt.Rows[0]["HomePhone"].ToString(); } if (CheckDataTableCell(dt, 0, "Memo")) { model.Memo = dt.Rows[0]["Memo"].ToString(); } if (CheckDataTableCell(dt, 0, "GroupId")) { model.GroupId = int.Parse(dt.Rows[0]["GroupId"].ToString()); } return(model); } else { return(null); } }