/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Code model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@phon", model.phon),
new SqlParameter("@code", model.code),
new SqlParameter("@senddate", model.senddate),
new SqlParameter("@expiretime", model.expiretime),
new SqlParameter("@status", model.status),
new SqlParameter("@type", model.type)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"INSERT INTO App_Code(
phon
,code
,senddate
,expiretime
,status
,type
) VALUES(
@phon
,@code
,@senddate
,@expiretime
,@status
,@type
)" );
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.Code model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@code_id", model.code_id),
new SqlParameter("@phon", model.phon),
new SqlParameter("@code", model.code),
new SqlParameter("@senddate", model.senddate),
new SqlParameter("@expiretime", model.expiretime),
new SqlParameter("@status", model.status)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"UPDATE [App_Code]
SET [phon]=@phon
,[code]=@code
,[senddate]=@senddate
,[expiretime]=@expiretime
,[status]=@status
WHERE [code_id]=@code_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.Code model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Code model)
{
return(dal.Add(model));
}
