public bool Update(Model.Contact model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Contact set ");
strSql.Append("Name=@Name,");
strSql.Append("Phone=@Phone,");
strSql.Append("Email=@Email,");
strSql.Append("QQ=@QQ,");
strSql.Append("WorkUnit=@WorkUnit,");
strSql.Append("OfficePhone=@OfficePhone,");
strSql.Append("HomeAddress=@HomeAddress,");
strSql.Append("HomePhone=@HomePhone,");
strSql.Append("[Memo]=@Memo,");
strSql.Append("GroupId=@GroupId");
strSql.Append(" where Id=@Id");
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", OleDbType.VarChar, 50),
new OleDbParameter("@Phone", OleDbType.VarChar, 11),
new OleDbParameter("@Email", OleDbType.VarChar, 50),
new OleDbParameter("@QQ", OleDbType.VarChar, 20),
new OleDbParameter("@WorkUnit", OleDbType.VarChar, 200),
new OleDbParameter("@OfficePhone", OleDbType.VarChar, 20),
new OleDbParameter("@HomeAddress", OleDbType.VarChar, 200),
new OleDbParameter("@HomePhone", OleDbType.VarChar, 20),
new OleDbParameter("@Memo", OleDbType.VarChar, 200),
new OleDbParameter("@GroupId", OleDbType.Integer, 4),
new OleDbParameter("@Id", OleDbType.Integer, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Phone;
parameters[2].Value = model.Email;
parameters[3].Value = model.QQ;
parameters[4].Value = model.WorkUnit;
parameters[5].Value = model.OfficePhone;
parameters[6].Value = model.HomeAddress;
parameters[7].Value = model.HomePhone;
parameters[8].Value = model.Memo;
parameters[9].Value = model.GroupId;
parameters[10].Value = model.Id;
int rows = OleDbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.Contact model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into Contact( ");
sql.Append("Name,Phone,Email,QQ,WorkUnit,OfficePhone,HomeAddress,HomePhone,[Memo],GroupId) ");
sql.Append("values(@Name,@Phone,@Email,@QQ,@WorkUnit,@OfficePhone,@HomeAddress,@HomePhone,@Memo,@GroupId)");
OleDbParameter[] para =
{
new OleDbParameter("@Name", OleDbType.VarChar, 50),
new OleDbParameter("@Phone", OleDbType.VarChar, 11),
new OleDbParameter("@Email", OleDbType.VarChar, 50),
new OleDbParameter("@QQ", OleDbType.VarChar, 20),
new OleDbParameter("@WorkUnit", OleDbType.VarChar, 200),
new OleDbParameter("@OfficePhone", OleDbType.VarChar, 20),
new OleDbParameter("@HomeAddress", OleDbType.VarChar, 200),
new OleDbParameter("@HomePhone", OleDbType.VarChar, 20),
new OleDbParameter("@Memo", OleDbType.VarChar, 200),
new OleDbParameter("@GroupId", OleDbType.Integer, 4)
};
para[0].Value = model.Name;
para[1].Value = model.Phone;
para[2].Value = model.Email;
para[3].Value = model.QQ;
para[4].Value = model.WorkUnit;
para[5].Value = model.OfficePhone;
para[6].Value = model.HomeAddress;
para[7].Value = model.HomePhone;
para[8].Value = model.Memo;
para[9].Value = model.GroupId;
int n = OleDbHelper.ExecuteNonQuery(sql.ToString(), para);
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除分组
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public bool Delete(int Id)
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from ContactGroup ");
sql.Append("where Id=@Id");
OleDbParameter[] para =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
para[0].Value = Id;
int n = OleDbHelper.ExecuteNonQuery(sql.ToString(), para);
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Delete(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Contact ");
strSql.Append(" where Id=@Id");
OleDbParameter[] parameters =
{
new OleDbParameter("@Id", OleDbType.Integer, 4)
};
parameters[0].Value = Id;
int rows = OleDbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
