/// <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(); }