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