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