/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.Activaty model)
{
return(dal.Update(model));
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.Activaty model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@a_id", model.a_id),
new SqlParameter("@tp_id", model.tp_id),
new SqlParameter("@title", model.title),
new SqlParameter("@context", model.context),
new SqlParameter("@type", model.type),
new SqlParameter("@bytime", model.bytime),
new SqlParameter("@begintime", model.begintime),
new SqlParameter("@endtime", model.endtime),
new SqlParameter("@organizers", model.organizers),
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("@money", model.money),
new SqlParameter("@ptype", model.ptype),
new SqlParameter("@state", model.state),
new SqlParameter("@address", model.address),
new SqlParameter("@isactivaty", model.isactivaty),
new SqlParameter("@city", model.city),
new SqlParameter("@district", model.district),
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("@specifictime", model.specifictime),
new SqlParameter("@endspecifictime", model.endspecifictime),
new SqlParameter("@other", model.other),
new SqlParameter("@longitude", model.longitude),
new SqlParameter("@latitude", model.latitude),
new SqlParameter("@mypic", model.mypic)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"UPDATE [App_Activaty]
SET [tp_id]=@tp_id
,[title]=@title
,[context]=@context
,[type]=@type
,[bytime]=@bytime
,[begintime]=@begintime
,[endtime]=@endtime
,[organizers]=@organizers
,[contact]=@contact
,[phone]=@phone
,[praise]=@praise
,[number]=@number
,[numberlimit]=@numberlimit
,[money]=@money
,[ptype]=@ptype
,[state]=@state
,[address]=@address
,[isactivaty]=@isactivaty
,[city]=@city
,[district]=@district
,[createtime]=@createtime
,[modifytime]=@modifytime
,[userid]=@userid
,[muserid]=@muserid
,[pic]=@pic
,[specifictime]=@specifictime
,[endspecifictime]=@endspecifictime
,[other]=@other
,[longitude]=@longitude
,[latitude]=@latitude
,[mypic]=@mypic
WHERE [a_id]=@a_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.Activaty model)
{
return(dal.Add(model));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Activaty model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@tp_id", model.tp_id),
new SqlParameter("@title", model.title),
new SqlParameter("@context", model.context),
new SqlParameter("@type", model.type),
new SqlParameter("@bytime", model.bytime),
new SqlParameter("@begintime", model.begintime),
new SqlParameter("@endtime", model.endtime),
new SqlParameter("@organizers", model.organizers),
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("@money", model.money),
new SqlParameter("@ptype", model.ptype),
new SqlParameter("@state", model.state),
new SqlParameter("@address", model.address),
new SqlParameter("@isactivaty", model.isactivaty),
new SqlParameter("@city", model.city),
new SqlParameter("@district", model.district),
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("@specifictime", model.specifictime),
new SqlParameter("@endspecifictime", model.endspecifictime),
new SqlParameter("@other", model.other),
new SqlParameter("@longitude", model.longitude),
new SqlParameter("@latitude", model.latitude),
new SqlParameter("@mypic", model.mypic),
new SqlParameter("@duserid", model.duserid)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"INSERT INTO App_Activaty(
tp_id
,title
,context
,type
,bytime
,begintime
,endtime
,organizers
,contact
,phone
,praise
,number
,numberlimit
,money
,ptype
,state
,address
,isactivaty
,city
,district
,createtime
,modifytime
,userid
,muserid
,pic
,specifictime
,endspecifictime
,other
,longitude
,latitude
,mypic
,duserid
) VALUES(
@tp_id
,@title
,@context
,@type
,@bytime
,@begintime
,@endtime
,@organizers
,@contact
,@phone
,@praise
,@number
,@numberlimit
,@money
,@ptype
,@state
,@address
,@isactivaty
,@city
,@district
,@createtime
,@modifytime
,@userid
,@muserid
,@pic
,@specifictime
,@endspecifictime
,@other
,@longitude
,@latitude
,@mypic
,@duserid
);SELECT @@Identity" );
return(Convert.ToInt32(SqlHelper.ExecuteScalar(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);
}
