public int UpdateClient(Client client)
{
try
{
string sql = string.Format("update LiveSupport_Client set [Name]='{0}',Job='{1}',Unit='{2}',[Phone]='{3}',[Email]='{4}',GrounpId='{5}',Address='{6}',Age={7},Sex={8},QQ='{9}',Remark='{10}' where [Id]='{11}'", client.Name, client.Job, client.Unit, client.Phone, client.Email, client.ClientGrounp.Id, client.Address, client.Age, client.Sex, client.Qq, client.Remark, client.Id);
return DBHelper.ExecuteSql(sql);
}
catch (Exception ex)
{
return 0;
}
}
public int AddClient(Client client)
{
try
{
string sql = string.Format("insert into LiveSupport_Client([Id],[Name],Job,Unit,[Phone],[Email],GrounpId,Address,Age,Sex,QQ,Remark) "
+ "values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},{9},'{10}','{11}')", client.Id, client.Name, client.Job, client.Unit, client.Phone, client.Email, client.ClientGrounp.Id, client.Address, client.Age, client.Sex, client.Qq, client.Remark);
return DBHelper.ExecuteSql(sql);
}
catch (Exception ex)
{
return 0;
}
}