/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddCrowdInfo(CrowdInfoModel model)
{
const string sql = @"INSERT INTO activity_crow_info
(innerid, title, subtitle, enrollstarttime, enrollendtime, secrettime,uppertotal,uppereach, prize, status, type,flagcode, qrcode, remark, extend, createrid, createdtime, modifierid, modifiedtime)
VALUES
(@innerid, @title, @subtitle, @enrollstarttime, @enrollendtime, @secrettime,@uppertotal,@uppereach, @prize, @status, @type,@flagcode, @qrcode, @remark, @extend, @createrid, @createdtime, @modifierid, @modifiedtime);";
using (var conn = Helper.GetConnection())
{
int result;
try
{
//生成编号
var obj = new
{
p_tablename = "activity_crow_info",
p_columnname = "flagcode",
p_prefix = "A",
p_length = 4,
p_hasdate = 0
};
var args = new DynamicParameters(obj);
args.Add("p_value", dbType: DbType.String, direction: ParameterDirection.Output);
args.Add("p_errmessage", dbType: DbType.String, direction: ParameterDirection.Output);
using (conn.QueryMultiple("sp_automaticnumbering", args, commandType: CommandType.StoredProcedure)) { }
model.Flagcode = args.Get<string>("p_value");
if (string.IsNullOrWhiteSpace(model.Flagcode))
{
var msg = args.Get<string>("p_errmessage");
LoggerFactories.CreateLogger().Write("活动码生成失败：" + msg, TraceEventType.Error);
return -1;
}
result = conn.Execute(sql, model);
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("AddCrowdInfo异常：", TraceEventType.Error, ex);
result = 0;
}
return result;
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateCrowdInfo(CrowdInfoModel model)
{
var sql = new StringBuilder("update activity_crow_info set ");
sql.Append(Helper.CreateField(model).Trim().TrimEnd(','));
sql.Append(" where innerid = @innerid");
int result;
try
{
result = Helper.Execute(sql.ToString(), model);
}
catch (Exception ex)
{
result = 0;
LoggerFactories.CreateLogger().Write("UpdateCrowdInfo异常：", TraceEventType.Error, ex);
}
return result;
}