/// <summary>
/// 插入记录
/// </summary>
public static int Insert(ModelDiyWebUrl model)
{
string sql = string.Format("Insert Into S_DiyWebUrl(SelfId,Name,Url,UrlEncode,UrlParams,CreateTime)Values({0},'{1}','{2}','{3}','{4}','{5}')",
model.SelfId,
model.Name,
model.Url,
model.UrlEncode,
model.UrlParams,
model.CreateTime);
return(DbHelper.Execute(CommonHelper.SQLiteConnectionString, sql, null));
}
/// <summary>
/// 更新记录
/// </summary>
public static int Update(ModelDiyWebUrl model, int Id)
{
string sql = string.Format("Update S_DiyWebUrl Set SelfId={0}, Name='{1}',Url='{2}',UrlEncode='{3}',UrlParams='{4}' Where Id={5}",
model.SelfId,
model.Name,
model.Url,
model.UrlEncode,
model.UrlParams,
Id
);
return(DbHelper.Execute(CommonHelper.SQLiteConnectionString, sql, null));
}
