/// <summary> /// 添加一条数据 /// </summary> /// <param name="model">数据实体</param> /// <returns></returns> public int Add(Models.APP.File model) { try { SqlParameter[] para = { new SqlParameter("@id", model.id), new SqlParameter("@pic", model.pic), new SqlParameter("@state", model.state), new SqlParameter("@sort", model.sort), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"INSERT INTO App_File( id ,pic ,state ,sort ,createtime ,modifytime ,userid ,muserid ) VALUES( @id ,@pic ,@state ,@sort ,@createtime ,@modifytime ,@userid ,@muserid )" ); return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para)); } catch (ArgumentNullException ex) { logger.Error("调用方法Add()发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Add()发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Add()发生Exception", ex); } return(-1); }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="_entity"></param> /// <returns></returns> public int Update(Models.APP.File model) { try { SqlParameter[] para = { new SqlParameter("@f_id", model.f_id), new SqlParameter("@id", model.id), new SqlParameter("@pic", model.pic), new SqlParameter("@state", model.state), new SqlParameter("@sort", model.sort), new SqlParameter("@createtime", model.createtime), new SqlParameter("@modifytime", model.modifytime), new SqlParameter("@userid", model.userid), new SqlParameter("@muserid", model.muserid) }; StringBuilder cmdText = new StringBuilder(); cmdText.Append(@"UPDATE [App_File] SET [id]=@id ,[pic]=@pic ,[state]=@state ,[sort]=@sort ,[createtime]=@createtime ,[modifytime]=@modifytime ,[userid]=@userid ,[muserid]=@muserid WHERE [f_id]=@f_id" ); return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para)); } catch (ArgumentNullException ex) { logger.Error("调用方法Update()发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法Update()发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法Update()发生Exception", ex); } return(-1); }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="_entity"></param> /// <returns></returns> public int Update(Models.APP.File model) { return(dal.Update(model)); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="model">数据实体</param> /// <returns></returns> public int Add(Models.APP.File model) { return(dal.Add(model)); }