public bool Edit(Service service)
{
string sql = "update SERVICES set ServiceType=?,NAME=?, URL=?, ContentType=?, Encoding=?, PARAMS=?, REMARKS=?, UserName=?, UserPassword=? where ID=?";
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("ServiceType", OleDbType.VarChar),
new OleDbParameter("NAME", OleDbType.VarChar),
new OleDbParameter("URL", OleDbType.VarChar),
new OleDbParameter("ContentType", OleDbType.VarChar),
new OleDbParameter("Encoding", OleDbType.VarChar),
new OleDbParameter("PARAMS", OleDbType.VarChar),
new OleDbParameter("REMARKS", OleDbType.VarChar),
new OleDbParameter("UserName", OleDbType.VarChar),
new OleDbParameter("UserPassword", OleDbType.VarChar),
new OleDbParameter("ID", OleDbType.VarChar)
};
parms[0].Value = service.ServiceType;
parms[1].Value = service.NAME;
parms[2].Value = service.URL;
parms[3].Value = service.ContentType;
parms[4].Value = service.Encoding;
parms[5].Value = service.PARAMS;
parms[6].Value = service.REMARKS;
parms[7].Value = service.UserName;
parms[8].Value = service.UserPassword;
parms[9].Value = service.ID;
return(AccessHelper.Excute(sql, parms));
}
public bool Add(Service service)
{
string sql = "insert into SERVICES(ID,ServiceType, NAME, URL, ContentType, Encoding, PARAMS, REMARKS, UserName, UserPassword,DELETED)VALUES(?,?,?,?,?,?,?,?,?,?,0)";
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("ID", OleDbType.VarChar),
new OleDbParameter("ServiceType", OleDbType.VarChar),
new OleDbParameter("NAME", OleDbType.VarChar),
new OleDbParameter("URL", OleDbType.VarChar),
new OleDbParameter("ContentType", OleDbType.VarChar),
new OleDbParameter("Encoding", OleDbType.VarChar),
new OleDbParameter("PARAMS", OleDbType.VarChar),
new OleDbParameter("REMARKS", OleDbType.VarChar),
new OleDbParameter("UserName", OleDbType.VarChar),
new OleDbParameter("UserPassword", OleDbType.VarChar)
};
parms[0].Value = service.ID;
parms[1].Value = service.ServiceType;
parms[2].Value = service.NAME;
parms[3].Value = service.URL;
parms[4].Value = service.ContentType;
parms[5].Value = service.Encoding;
parms[6].Value = service.PARAMS;
parms[7].Value = service.REMARKS;
parms[8].Value = service.UserName;
parms[9].Value = service.UserPassword;
return(AccessHelper.Excute(sql, parms));
}
public bool Delete(string id)
{
string sql = "update SERVICES set DELETED=1 where ID=?";
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter("ID", OleDbType.VarChar)
};
parms[0].Value = id;
return(AccessHelper.Excute(sql, parms));
}
