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