/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MPrintMain model)
{
#region SQL语句
const string sql = @"
INSERT INTO [T_PrintMain] (
[UUID]
,[TemplateName]
,[BackImage]
,[TemplateType]
)
VALUES (
@UUID
,@TemplateName
,@BackImage
,@TemplateType
);";
#endregion
var res = SqlHelper.ExecuteScalar(CommandType.Text, sql,
new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)),
new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)),
new SQLiteParameter("@BackImage", SqlHelper.ToNullDBValue(model.BackImage)),
new SQLiteParameter("@TemplateType", SqlHelper.ToNullDBValue(model.TemplateType))
);
return(res == null ? 0 : Convert.ToInt32(res));
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MPrintMain model)
{
#region SQL语句
const string sql = @"
UPDATE [T_PrintMain]
SET
[UUID] = @UUID
,[TemplateName] = @TemplateName
,[BackImage] = @BackImage
,[TemplateType] = @TemplateType
WHERE [UUID] = @UUID";
#endregion
return(SqlHelper.ExecuteNonQuery(CommandType.Text, sql,
new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)),
new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)),
new SQLiteParameter("@BackImage", SqlHelper.ToNullDBValue(model.BackImage)),
new SQLiteParameter("@TemplateType", SqlHelper.ToNullDBValue(model.TemplateType))
));
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(MPrintMain model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(MPrintMain model)
{
return(_dao.Insert(model));
}
