/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.About model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@title", model.title),
new SqlParameter("@context", model.context),
new SqlParameter("@tp_id", model.tp_id),
new SqlParameter("@begintime", model.begintime),
new SqlParameter("@contact", model.contact),
new SqlParameter("@phone", model.phone),
new SqlParameter("@praise", model.praise),
new SqlParameter("@number", model.number),
new SqlParameter("@numberlimit", model.numberlimit),
new SqlParameter("@age", model.age),
new SqlParameter("@sex", model.sex),
new SqlParameter("@address", model.address),
new SqlParameter("@province", model.province),
new SqlParameter("@city", model.city),
new SqlParameter("@district", model.district),
new SqlParameter("@state", model.state),
new SqlParameter("@specifictime", model.specifictime),
new SqlParameter("@createtime", model.createtime),
new SqlParameter("@modifytime", model.modifytime),
new SqlParameter("@userid", model.userid),
new SqlParameter("@muserid", model.muserid),
new SqlParameter("@pic", model.pic),
new SqlParameter("@other", model.other)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"INSERT INTO App_About(
title
,context
,tp_id
,begintime
,contact
,phone
,praise
,number
,numberlimit
,age
,sex
,address
,province
,city
,district
,state
,specifictime
,createtime
,modifytime
,userid
,muserid
,pic
,other
) VALUES(
@title
,@context
,@tp_id
,@begintime
,@contact
,@phone
,@praise
,@number
,@numberlimit
,@age
,@sex
,@address
,@province
,@city
,@district
,@state
,@specifictime
,@createtime
,@modifytime
,@userid
,@muserid
,@pic
,@other
)" );
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.About model)
{
return(dal.Update(model));
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.About model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@ab_id", model.ab_id),
new SqlParameter("@title", model.title),
new SqlParameter("@context", model.context),
new SqlParameter("@tp_id", model.tp_id),
new SqlParameter("@begintime", model.begintime),
new SqlParameter("@contact", model.contact),
new SqlParameter("@phone", model.phone),
new SqlParameter("@praise", model.praise),
new SqlParameter("@number", model.number),
new SqlParameter("@numberlimit", model.numberlimit),
new SqlParameter("@age", model.age),
new SqlParameter("@sex", model.sex),
new SqlParameter("@address", model.address),
new SqlParameter("@province", model.province),
new SqlParameter("@city", model.city),
new SqlParameter("@district", model.district),
new SqlParameter("@state", model.state),
new SqlParameter("@specifictime", model.specifictime),
new SqlParameter("@createtime", model.createtime),
new SqlParameter("@modifytime", model.modifytime),
new SqlParameter("@userid", model.userid),
new SqlParameter("@muserid", model.muserid),
new SqlParameter("@pic", model.pic),
new SqlParameter("@other", model.other)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"UPDATE [App_About]
SET [title]=@title
,[context]=@context
,[tp_id]=@tp_id
,[begintime]=@begintime
,[contact]=@contact
,[phone]=@phone
,[praise]=@praise
,[number]=@number
,[numberlimit]=@numberlimit
,[age]=@age
,[sex]=@sex
,[address]=@address
,[province]=@province
,[city]=@city
,[district]=@district
,[state]=@state
,[specifictime]=@specifictime
,[createtime]=@createtime
,[modifytime]=@modifytime
,[userid]=@userid
,[muserid]=@muserid
,[pic]=@pic
,[other]=@other
WHERE [ab_id]=@ab_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="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.About model)
{
return(dal.Add(model));
}
