public void UpdatePlanItemData(PlanDataItem data) { try { OpenConnection(); SqlCeCommand cmd = new SqlCeCommand(@"UPDATE [PlanData] SET [PlanID] = @PlanID ,[PlanDataName] = @PlanDataName ,[PlanSql] = @PlanSql ,[FailMode] = @FailMode ,[Index] = @Index WHERE [PlanDataID]=@PlanDataID;", con); cmd.Parameters.AddWithValue("PlanDataID", data.PlanDataID); cmd.Parameters.AddWithValue("PlanID", data.PlanID); cmd.Parameters.AddWithValue("PlanDataName", data.PlanDataName); cmd.Parameters.AddWithValue("PlanSql", data.PlanSql); cmd.Parameters.AddWithValue("FailMode", (int)data.FailMode); cmd.Parameters.AddWithValue("Index", data.Index); cmd.ExecuteNonQuery(); } catch (Exception ex) { //Suppress All Exceptions } finally { CloseConnection(); } }
public void AddPlanItemData(PlanDataItem data) { try { OpenConnection(); SqlCeCommand cmd = new SqlCeCommand(@"INSERT INTO [PlanData] ([PlanID],[PlanDataName],[PlanSql],[FailMode],[Index]) VALUES(@PlanID,@PlanDataName,@PlanSql,@FailMode,@Index);", con); cmd.Parameters.AddWithValue("PlanID", data.PlanID); cmd.Parameters.AddWithValue("PlanDataName", data.PlanDataName); cmd.Parameters.AddWithValue("PlanSql", data.PlanSql); cmd.Parameters.AddWithValue("FailMode", (int)data.FailMode); cmd.Parameters.AddWithValue("Index", data.Index); cmd.ExecuteNonQuery(); } catch (Exception ex) { //Suppress All Exceptions } finally { CloseConnection(); } }