/// <summary>
/// 新增卡片
/// </summary>
/// <param name="parameter">卡片參數</param>
/// <returns></returns>
public bool Insert(CardCondition condition)
{
var sql =
@"
INSERT INTO Card
(
[Name]
,[Description]
,[Attack]
,[Health]
,[Cost]
)
VALUES
(
@Name
,@Description
,@Attack
,@Health
,@Cost
);
SELECT @@IDENTITY;
";
using (var conn = new SqlConnection(_connectString))
{
var result = conn.Execute(sql, condition);
return(result > 0);
}
}
/// <summary>
/// 更新卡片
/// </summary>
/// <param name="id">卡片編號</param>
/// <param name="condition"></param>
/// <returns></returns>
public bool Update(int id, CardCondition condition)
{
var sql =
@"
UPDATE Card
SET
[Name] = @Name
,[Description] = @Description
,[Attack] = @Attack
,[Health] = @Health
,[Cost] = @Cost
WHERE
Id = @id
";
var parameters = new DynamicParameters();
parameters.AddDynamicParams(condition);
parameters.Add("Id", id, System.Data.DbType.Int32);
using (var conn = new SqlConnection(_connectString))
{
var result = conn.Execute(sql, parameters);
return(result > 0);
}
}
public void DrawVar(CardCondition gv)
{
EditorGUILayout.LabelField(gv.data.id, GUILayout.MaxWidth(200));
EditorGUILayout.BeginHorizontal();
EditorGUILayout.LabelField("IsTrue", GUILayout.MaxWidth(50));
EditorGUILayout.LabelField("Variable", GUILayout.MaxWidth(150));
EditorGUILayout.LabelField("L_Value", GUILayout.MaxWidth(50));
EditorGUILayout.LabelField("Op", GUILayout.MaxWidth(50));
EditorGUILayout.LabelField("R_Value", GUILayout.MaxWidth(50));
EditorGUILayout.EndHorizontal();
foreach (var e in gv.elements)
{
DrawElement(e);
}
EditorGUILayout.Space();
}
