/// <summary>
/// 添加营业额分类信息，
/// </summary>
/// <param name="tt"></param>
/// <returns></returns>
public static bool AddTurnOverTypes(TurnOverTypes tt)
{
string cmdline = @"INSERT INTO [dbo].[TurnOverTypes]
([Name]
,[Active]
,[AimType]
,[OwnerId]
,[Comments]
,[CreateTime]
,[LastUpdateTime])
VALUES
(@name, @active, @aimtype, @ownerid, @comments, @createtime, @lastupdatetime)";
SqlParameter[] parameters =
{
new SqlParameter("@name", tt.Name),
new SqlParameter("@active", tt.Active),
new SqlParameter("@aimtype", tt.AimType),
new SqlParameter("@ownerid", tt.OwnerId),
new SqlParameter("@comments", tt.Comments),
new SqlParameter("@createtime", tt.CreateTime),
new SqlParameter("@lastupdatetime", tt.LastUpdateTime)
};
return(SqlHelper.ExecuteNonQuery(cmdline, parameters));
}
public void AddTurnOverType()
{
TurnOverTypes type = new TurnOverTypes();
type.Name = "KOL&招待";
type.OwnerId = Guid.Parse("86ecdaa6-9c84-41a1-aef8-f41e2cedf079");
type.AimType = Aim.Both;
type.Comments = "KOL&招待";
Assert.IsTrue(TurnOverTypesHanlder.AddTurnOverTypes(type));
}
/// <summary>
/// 更新营业额分类信息
/// </summary>
/// <param name="tt"></param>
/// <returns></returns>
public static bool UpdateTurnOverTypes(TurnOverTypes tt)
{
string cmdline = @"UPDATE [dbo].[TurnOverTypes]
SET [Name] = @name
,[AimType] = @aimtype
,[OwnerId] = @ownerid
,[Comments] = @comments
,[LastUpdateTime] = @lastupdatetime
WHERE [Id] = @id";
SqlParameter[] parameters =
{
new SqlParameter("@name", tt.Name),
new SqlParameter("@aimtype", tt.AimType),
new SqlParameter("@ownerid", tt.OwnerId),
new SqlParameter("@comments", tt.Comments),
new SqlParameter("@lastupdatetime", DateTime.Now),
new SqlParameter("@id", tt.Id)
};
return(SqlHelper.ExecuteNonQuery(cmdline, parameters));
}
public bool UpdateTurnOverType([FromBody] TurnOverTypes type)
{
return(TurnOverTypesHanlder.UpdateTurnOverTypes(type));
}
public bool AddTurnOverType([FromBody] TurnOverTypes type)
{
return(TurnOverTypesHanlder.AddTurnOverTypes(type));
}
