/// <summary>
/// 生成途虎挪车二维码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddMoveCarQRCode(MoveCarQRCodeModel model)
{
int result = 0;
try
{
using (var conn = ProcessConnection.OpenGungnir)
{
result = dal.AddMoveCarQRCode(conn, model);
}
}
catch (Exception e)
{
Logger.Error($"AddMoveCarQRCode-> {JsonConvert.SerializeObject(model)}", e);
throw;
}
return(result);
}
/// <summary>
/// 生成途虎挪车二维码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddMoveCarQRCode(SqlConnection conn, MoveCarQRCodeModel model)
{
#region SQL
const string sql = @"
INSERT INTO Tuhu_profiles.[dbo].[MoveCarQRCode]
( [QRCodeUrl] ,
[QRCodeID] ,
[QRCodeImageUrl] ,
[IsDownload] ,
[IsBinding] ,
[BatchID] ,
[CreateDatetime] ,
[LastUpdateDateTime] ,
[CreateBy] ,
[LastUpdateBy]
)
VALUES ( @QRCodeUrl ,
@QRCodeID ,
@QRCodeImageUrl ,
@IsDownload ,
@IsBinding ,
@BatchID ,
GETDATE() ,
GETDATE() ,
@CreateBy ,
@LastUpdateBy
);
SELECT SCOPE_IDENTITY();";
#endregion
var parameters = new[]
{
new SqlParameter("@QRCodeUrl", model.QRCodeUrl ?? ""),
new SqlParameter("@QRCodeID", model.QRCodeID),
new SqlParameter("@QRCodeImageUrl", model.QRCodeImageUrl ?? ""),
new SqlParameter("@IsDownload", model.IsDownload),
new SqlParameter("@IsBinding", model.IsBinding),
new SqlParameter("@BatchID", model.BatchID),
new SqlParameter("@CreateBy", model.CreateBy ?? ""),
new SqlParameter("@LastUpdateBy", model.LastUpdateBy ?? "")
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)));
}
