/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Type model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@text", model.text),
new SqlParameter("@Anpic", model.Anpic),
new SqlParameter("@AnIsHomepic", model.AnIsHomepic),
new SqlParameter("@AnHomepic", model.AnHomepic),
new SqlParameter("@AnWhitepic", model.AnWhitepic),
new SqlParameter("@AnOrangepic", model.AnOrangepic),
new SqlParameter("@AnIsAllpic", model.AnIsAllpic),
new SqlParameter("@AnAllpic", model.AnAllpic),
new SqlParameter("@Anpicguanfang", model.Anpicguanfang),
new SqlParameter("@Anpicminjian", model.Anpicminjian),
new SqlParameter("@Iospic", model.Iospic),
new SqlParameter("@IosIsHomepic", model.IosIsHomepic),
new SqlParameter("@IosHomepic", model.IosHomepic),
new SqlParameter("@IosWhitepic", model.IosWhitepic),
new SqlParameter("@IosOrangepic", model.IosOrangepic),
new SqlParameter("@IosIsAllpic", model.IosIsAllpic),
new SqlParameter("@IosAllpic", model.IosAllpic),
new SqlParameter("@Iospicguanfang", model.Iospicguanfang),
new SqlParameter("@Iospicminjian", model.Iospicminjian),
new SqlParameter("@type", model.type),
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),
new SqlParameter("@tdisabled", model.tdisabled)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"INSERT INTO App_Type(
text
,Anpic
,AnIsHomepic
,AnHomepic
,AnWhitepic
,AnOrangepic
,AnIsAllpic
,AnAllpic
,Anpicguanfang
,Anpicminjian
,Iospic
,IosIsHomepic
,IosHomepic
,IosWhitepic
,IosOrangepic
,IosIsAllpic
,IosAllpic
,Iospicguanfang
,Iospicminjian
,type
,sort
,createtime
,modifytime
,userid
,muserid,tdisabled
) VALUES(
@text
,@Anpic
,@AnIsHomepic
,@AnHomepic
,@AnWhitepic
,@AnOrangepic
,@AnIsAllpic
,@AnAllpic
,@Anpicguanfang
,@Anpicminjian
,@Iospic
,@IosIsHomepic
,@IosHomepic
,@IosWhitepic
,@IosOrangepic
,@IosIsAllpic
,@IosAllpic
,@Iospicguanfang
,@Iospicminjian
,@type
,@sort
,@createtime
,@modifytime
,@userid
,@muserid,@tdisabled
)" );
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.Type model)
{
return(dal.Update(model));
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.Type model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@t_id", model.t_id),
new SqlParameter("@text", model.text),
new SqlParameter("@Anpic", model.Anpic),
new SqlParameter("@AnIsHomepic", model.AnIsHomepic),
new SqlParameter("@AnHomepic", model.AnHomepic),
new SqlParameter("@AnWhitepic", model.AnWhitepic),
new SqlParameter("@AnOrangepic", model.AnOrangepic),
new SqlParameter("@AnIsAllpic", model.AnIsAllpic),
new SqlParameter("@AnAllpic", model.AnAllpic),
new SqlParameter("@Anpicguanfang", model.Anpicguanfang),
new SqlParameter("@Anpicminjian", model.Anpicminjian),
new SqlParameter("@Iospic", model.Iospic),
new SqlParameter("@IosIsHomepic", model.IosIsHomepic),
new SqlParameter("@IosHomepic", model.IosHomepic),
new SqlParameter("@IosWhitepic", model.IosWhitepic),
new SqlParameter("@IosOrangepic", model.IosOrangepic),
new SqlParameter("@IosIsAllpic", model.IosIsAllpic),
new SqlParameter("@IosAllpic", model.IosAllpic),
new SqlParameter("@Iospicguanfang", model.Iospicguanfang),
new SqlParameter("@Iospicminjian", model.Iospicminjian),
new SqlParameter("@type", model.type),
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_Type]
SET [text]=@text
,[Anpic]=@Anpic
,[AnIsHomepic]=@AnIsHomepic
,[AnHomepic]=@AnHomepic
,[AnWhitepic]=@AnWhitepic
,[AnOrangepic]=@AnOrangepic
,[AnIsAllpic]=@AnIsAllpic
,[AnAllpic]=@AnAllpic
,[Anpicguanfang]=@Anpicguanfang
,[Anpicminjian]=@Anpicminjian
,[Iospic]=@Iospic
,[IosIsHomepic]=@IosIsHomepic
,[IosHomepic]=@IosHomepic
,[IosWhitepic]=@IosWhitepic
,[IosOrangepic]=@IosOrangepic
,[IosIsAllpic]=@IosIsAllpic
,[IosAllpic]=@IosAllpic
,[Iospicguanfang]=@Iospicguanfang
,[Iospicminjian]=@Iospicminjian
,[type]=@type
,[sort]=@sort
,[createtime]=@createtime
,[modifytime]=@modifytime
,[userid]=@userid
,[muserid]=@muserid
WHERE [t_id]=@t_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.Type model)
{
return(dal.Add(model));
}
